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 13825 over 10 years Aaron Marcuse-Kubitza exports/2014-6-12.Jeff_Ott.climatic_range_deter...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
13825 06/19/2014 11:13 AM Aaron Marcuse-Kubitza

exports/2014-6-12.Jeff_Ott.climatic_range_determinants.csv.run: updated export_() runtime (35 min) and rowcount (23 million)

13824 06/19/2014 02:33 AM Aaron Marcuse-Kubitza

fix: /README.TXT: Full database import: disk space: removed instructions to rerun the import if the disk space gets used up, because this is actually a bug and is not generally "fixed just by rerunning the import"

13823 06/19/2014 02:27 AM Aaron Marcuse-Kubitza

schemas/util.sql: lat_long_in_new_world(): use function rather than operator+search_path to allow inlining, which enables util.new_world() to only be evaluated once

13822 06/19/2014 02:24 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: operator @(postgis.geography, postgis.geography): must use wrapper function because st_coveredby() needs postgis to be in the search_path

13821 06/19/2014 01:57 AM Aaron Marcuse-Kubitza

fix: lib/runscripts/extract.run: export_(): explicitly prevent files from becoming web-accessible, to protect against an incorrect umask in the calling process

13820 06/19/2014 01:45 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: point(): hide benign "Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY" notices

13819 06/18/2014 08:56 PM Aaron Marcuse-Kubitza

schemas/public_.sql: 2014-6-12.Jeff_Ott.climatic_range_determinants: also include New World occurrences by coordinates, using new lat_long_in_new_world(). this modification (as requested by Jeff) will help reduce the false negatives filtered out by including only data with placenames.

13818 06/18/2014 08:52 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added lat_long_in_new_world() wrapper around util.lat_long_in_new_world()

13817 06/18/2014 08:49 PM Aaron Marcuse-Kubitza

schemas/util.sql: lat_long_in_new_world(): documented that this includes false positives above and below the New World bounding box, as described in util.bounding_box()

13816 06/18/2014 08:44 PM Aaron Marcuse-Kubitza

schemas/util.sql: bounding_box(): documented that the geography type stores all edges as arcs of great circles, resulting in the latitude lines bulging outward from the true bounding box. this will create false positives above and below the bounding box.

View all revisions | View revisions

Also available in: Atom