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 14527 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added geography(util.geocoord...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
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.

14520 08/19/2014 02:25 PM Aaron Marcuse-Kubitza

exports/native_status_resolver.csv.run: upload_(): documented runtime (2.5 min)

14519 08/19/2014 02:18 PM Aaron Marcuse-Kubitza

bugfix: exports/native_status_resolver.csv.run: upload_(): $live must be exported

14518 08/19/2014 02:15 PM Aaron Marcuse-Kubitza

exports/native_status_resolver.csv.run: upload_(): use `live=1` instead for consistency with other invocations of put

View all revisions | View revisions

Also available in: Atom