Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14530 over 10 years Aaron Marcuse-Kubitza /README.TXT: Full database import: converted da...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14530 08/20/2014 11:28 AM Aaron Marcuse-Kubitza

/README.TXT: Full database import: converted database commands to command-line commands to make them easier to run

14529 08/20/2014 10:55 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: added instructions for how to enable automatic restart on power loss for the UPS (which isn't accessible in the GUI)

14528 08/19/2014 05:13 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: contained_within_approx(point geocoord, region postgis.geography): use util.geography() instead of implicit cast to suppress "Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY" NOTICEs

14527 08/19/2014 05:10 PM Aaron Marcuse-Kubitza

schemas/util.sql: added geography(util.geocoord), which suppresses "Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY" NOTICEs

14526 08/19/2014 04:48 PM Aaron Marcuse-Kubitza

exports/native_status_resolver.csv.run: updated export_() runtime (5 min, now that we're using the narrower New World criterion)

14525 08/19/2014 04:39 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: don't include rows with New World coordinates that don't also have New World country names, since the NSR only uses the country name

14524 08/19/2014 04:26 PM Aaron Marcuse-Kubitza

schemas/public_.sql: native_status_resolver: removed rows with is_geovalid NULL, at Brad's request. note that this removes valid rows with standardized country names.

14523 08/19/2014 04:01 PM Aaron Marcuse-Kubitza

exports/native_status_resolver.csv.run: updated export_() runtime (30 min)

14522 08/19/2014 03:28 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: added country IS NOT NULL filter requested by Brad

14521 08/19/2014 02:35 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: remove the id because this prevents SELECT DISTINCT from having the desired effect. instead, the results will be joined back using the other columns.

View all revisions | View revisions

Also available in: Atom