-
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
-