Commit Graph

  • d766f08b03 calculate area normalization of a polygon by square kilometer, not square meter. fixes #158 John Krauss 2016-07-22 15:18:43 +0000
  • 8f345fd508 in this function, its "measure_id" not "numer_id" John Krauss 2016-07-21 15:35:09 -0400
  • 383c3eb6ec Merge pull request #155 from CartoDB/148-move-glossary-and-license-files csobier 2016-07-19 11:58:59 -0400
  • 798c0a73a1 added absolutel urls for doc links as weird redirects are happening for relative links csobier 2016-07-19 11:57:40 -0400
  • bfa57f4971 Use 6432 for connections from server Carla 2016-07-19 17:54:08 +0200
  • e7a16f4b4d Merge pull request #153 from CartoDB/148-move-glossary-and-license-files csobier 2016-07-19 11:43:23 -0400
  • 540ff68a90 fixing hyperlinks to live docs csobier 2016-07-19 11:42:19 -0400
  • 6a1df2abd1 Merge pull request #149 from CartoDB/148-move-glossary-and-license-files csobier 2016-07-19 11:32:25 -0400
  • dc9ed2de33 fixes issue 148 csobier 2016-07-19 11:30:09 -0400
  • acaa434118 Merge pull request #152 from CartoDB/obs_fdw_dependency Carla 2016-07-19 15:58:05 +0200
  • 173d7c0aec Add postgres_fdw as a dependency of observatory Carla 2016-07-19 15:56:25 +0200
  • 970d5d2119 Merge pull request #151 from CartoDB/add-docs-url Belén Achaerandio 2016-07-19 15:06:32 +0200
  • a3681062cb second-fix Belén Achaerandio 2016-07-19 12:28:57 +0200
  • a179a46b86 Update measures_functions.md Belén Achaerandio 2016-07-19 12:15:58 +0200
  • 4c434ffb8d Release 1.0.2 artifact 1.0.2 Mario de Frutos 2016-07-15 15:52:38 +0200
  • b041821fc0 Merge pull request #150 from CartoDB/develop Mario de Frutos 2016-07-15 15:49:03 +0200
  • 876515f9aa Merge pull request #127 from CartoDB/table_level_functions Mario de Frutos 2016-07-15 15:47:02 +0200
  • 25570e5b11 Merge pull request #147 from CartoDB/develop Mario de Frutos 2016-07-15 15:28:52 +0200
  • 1054443117 removed glossary and license files, updated any hyperlinks to these files csobier 2016-07-15 09:05:49 -0400
  • d93752efa3 move addr_host as a parameter Carla 2016-07-15 11:34:42 +0200
  • 588cda3262 Merge pull request #146 from CartoDB/release-v-1.0.2 Mario de Frutos 2016-07-14 17:12:33 +0200
  • e43d0ca4cf Merge pull request #144 from CartoDB/getmeasure-using-obsmeta john krauss 2016-07-14 09:24:51 -0400
  • 987c4c5b76 Merge pull request #145 from CartoDB/obsmeta-end-to-end john krauss 2016-07-14 09:22:57 -0400
  • 51ce13f8b9 update NEWS with additional improvements John Krauss 2016-07-14 09:21:16 -0400
  • 25f4dbc416 use obs_meta for tests John Krauss 2016-07-14 09:11:02 -0400
  • c09e0b6e83 can eliminate getrelatedcolumn John Krauss 2016-07-13 18:42:25 -0400
  • 748428ace1 Merge branch 'release-v-1.0.2' into getmeasure-using-obsmeta John Krauss 2016-07-13 18:41:04 -0400
  • 10a0dc9b26 Merge pull request #141 from CartoDB/fix-hardcoded-getcategory-geom john krauss 2016-07-13 18:39:31 -0400
  • 9245de84b0 Merge pull request #142 from CartoDB/comment-notices john krauss 2016-07-13 18:38:59 -0400
  • 514e1e4c5b Merge pull request #138 from CartoDB/mx-tests john krauss 2016-07-13 18:38:46 -0400
  • 7bb1bbd804 handle predenomination of points properly John Krauss 2016-07-13 18:37:17 -0400
  • 1d008ccbe9 should not try to use area normalization for zhvi John Krauss 2016-07-13 18:33:53 -0400
  • f581278b8a default is now NULL John Krauss 2016-07-13 18:24:45 -0400
  • cbf1c5e67d fix default normalizations John Krauss 2016-07-13 18:16:53 -0400
  • adc663b563 default to area normalization for point, no normalization for polygon getmeasures John Krauss 2016-07-13 18:14:09 -0400
  • 3a37b98b72 we still needt hese for getdemographicsnapshot John Krauss 2016-07-13 17:54:19 -0400
  • a4a20e9c1d prevent internal join for denominated getmeasure by polygon John Krauss 2016-07-13 17:41:05 -0400
  • f485426085 fix syntax error John Krauss 2016-07-13 17:38:54 -0400
  • 75e765f256 explicit type casts for = ANY John Krauss 2016-07-13 17:38:05 -0400
  • b690478aff use IN ANY to avoid joins elsewhere, and filter by nonzero overlap for all getmeasure polygon queries John Krauss 2016-07-13 17:36:27 -0400
  • 6fa9d5c96a add missing array_agg John Krauss 2016-07-13 17:27:03 -0400
  • fc6317161f avoid joins John Krauss 2016-07-13 17:26:01 -0400
  • c07d9f6833 add missing params John Krauss 2016-07-13 17:13:45 -0400
  • ff173a0152 filter so theres some overlap John Krauss 2016-07-13 17:12:16 -0400
  • a7de1f2228 intersects, not overlaps John Krauss 2016-07-13 16:57:27 -0400
  • 86529ada5a use st_overlaps instead of && John Krauss 2016-07-13 16:53:50 -0400
  • 80cdc5e8ca fix predicate John Krauss 2016-07-13 16:48:06 -0400
  • 7c8c5cca0a fix params John Krauss 2016-07-13 16:42:02 -0400
  • a946ab9d03 fix params in denominated polygon getmeasure John Krauss 2016-07-13 16:28:50 -0400
  • da127baa3c implementation for polygon/multipolygon weighted getmeasure John Krauss 2016-07-13 16:24:33 -0400
  • e89a88aa83 use subselects as joins are horrifically slow over FDW John Krauss 2016-07-13 15:59:27 -0400
  • af2259bb0a fix wrong number of variables INTO John Krauss 2016-07-13 13:39:33 -0400
  • fb083f4b9e fix typo John Krauss 2016-07-13 13:30:05 -0400
  • 976e119abb fix typo John Krauss 2016-07-13 12:21:53 -0400
  • bbc6f9ef36 getmeasure bypassing several older functions, areas not yet implemented John Krauss 2016-07-13 12:20:01 -0400
  • 5229279ee9 Merge branch 'comment-notices' into release-v-1.0.2-preview John Krauss 2016-07-13 11:14:00 -0400
  • 0090e537fc add comment-notices branch merge to NEWS.md John Krauss 2016-07-13 11:07:06 -0400
  • e4052ed565 better feedback in autotest John Krauss 2016-07-13 10:59:25 -0400
  • 2107796f07 updates to NEWS.md and observatory.control John Krauss 2016-07-12 17:49:34 -0400
  • 2463623658 Merge pull request #136 from CartoDB/obs-meta-internal john krauss 2016-07-12 17:33:43 -0400
  • 91797918c1 Merge branch 'fix-hardcoded-getcategory-geom' into release-v-1.0.2-preview John Krauss 2016-07-12 16:10:19 -0400
  • 6a39bedee7 fix ambiguous colname for categories in points too John Krauss 2016-07-12 16:10:00 -0400
  • 6ce0e5a8d9 Merge branch 'fix-hardcoded-getcategory-geom' into release-v-1.0.2-preview John Krauss 2016-07-12 16:08:05 -0400
  • 81176d1df2 fix possible ambiguity in category colname John Krauss 2016-07-12 16:06:19 -0400
  • f22854b4e9 Merge branch 'fix-hardcoded-getcategory-geom' into release-v-1.0.2-preview John Krauss 2016-07-12 15:58:02 -0400
  • 54701d595a Merge branch 'obs-meta-internal' into release-v-1.0.2-preview John Krauss 2016-07-12 15:57:44 -0400
  • 4b26eeda65 fix to correct segment for testarea area John Krauss 2016-07-12 15:33:26 -0400
  • 4fc02f99e2 choose largest segment in the polygon John Krauss 2016-07-12 14:37:43 -0400
  • 5bb4285528 fix typo John Krauss 2016-07-12 14:16:28 -0400
  • 1e9c3fb860 fix typo John Krauss 2016-07-12 14:15:00 -0400
  • 62a2c259a7 fix typo John Krauss 2016-07-12 14:13:09 -0400
  • 61854a070d fix wrong quoting John Krauss 2016-07-12 14:11:02 -0400
  • 8654c22c87 handle area categories properly John Krauss 2016-07-12 14:06:43 -0400
  • 62c08864af remove bad "target_table" notice John Krauss 2016-07-12 12:37:30 -0400
  • af39a37b43 fix missing comma John Krauss 2016-07-12 12:34:32 -0400
  • 26b61a6ddb minor formatting John Krauss 2016-07-12 12:26:10 -0400
  • 965fb94704 fix bugs in obs_getcategory implementation John Krauss 2016-07-12 12:22:06 -0400
  • 84dec8bdf4 simplify obs_getcategory and use obs_meta John Krauss 2016-07-12 12:09:42 -0400
  • 568996930b test location for MX John Krauss 2016-07-12 12:02:49 -0400
  • ebc27dbbb7 faster obs_meta generation, use better formatting and handle NULL boundary_id John Krauss 2016-07-12 11:52:56 -0400
  • 56fa19118b adjust expectations John Krauss 2016-07-12 11:25:50 -0400
  • 4f3baac10a adjust expectations and make sure echo is none John Krauss 2016-07-12 11:21:42 -0400
  • b512985b46 drop/create less, better indexes John Krauss 2016-07-12 11:15:08 -0400
  • 329b4dbca3 do not imitate foreign keys John Krauss 2016-07-12 10:46:53 -0400
  • 897cf38d42 faster generation of obs-meta via indexes John Krauss 2016-07-12 10:42:00 -0400
  • fe6343c73f should use coaelesce, not nullif John Krauss 2016-07-11 13:57:29 -0400
  • 26ee8aedb1 solve null identifier issue John Krauss 2016-07-11 13:53:22 -0400
  • 66e2c6be54 create obs_meta out of dump band John Krauss 2016-07-11 13:40:42 -0400
  • 6b41994a87 add missing formatstring args John Krauss 2016-07-11 12:17:36 -0400
  • d3d5cbdbbd use obs_meta in obs_getmeasurebyid John Krauss 2016-07-11 12:15:36 -0400
  • 4d51ecc12e comment out notices John Krauss 2016-07-11 11:46:04 -0400
  • c0030acb0c Merge pull request #131 from CartoDB/docs-781 Carlos Matallín 2016-07-07 18:57:47 +0200
  • e938ee0c7b Merge branch 'develop' into docs-781 Carlos Matallín 2016-07-07 18:57:26 +0200
  • 8fa2d642bf Update release dir with make release 1.0.1 Rafa de la Torre 2016-07-01 19:00:05 +0200
  • 926435a908 Update NEWS and control file for v1.0.1 Rafa de la Torre 2016-07-01 18:55:07 +0200
  • 80073aa213 Merge remote-tracking branch 'origin/develop' Rafa de la Torre 2016-07-01 18:53:11 +0200
  • 3f78797e14 Merge pull request #130 from CartoDB/preemptive-setsrid Rafa de la Torre 2016-07-01 18:49:57 +0200
  • 11dbb860ab preemptively set_srid for obs_getavailableboundaries John Krauss 2016-07-01 09:51:20 -0400
  • 9ade6588e2 Add augment functions, add mocks for data retrieval, create own fdw functions to avoid cartodb dependency Carla 2016-06-22 18:58:37 +0200
  • 5ef1427bc3 Merge pull request #126 from CartoDB/develop Andy Eschbacher 2016-06-28 13:11:00 -0400