Reputation
310
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 13
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 21 votes cast
Aug
9
awarded  Notable Question
Jul
27
revised CartoDB (PostGIS) near function (distance) points to polygons
added both projected comments
Jul
27
comment CartoDB (PostGIS) near function (distance) points to polygons
Like this (also above)? --- SELECT *, ST_Distance(the_geom::geography, (SELECT the_geom::geography FROM polygon_near)) as distance_to_polygon from points_near
Jul
23
revised CartoDB (PostGIS) near function (distance) points to polygons
added 596 characters in body
Jul
23
answered CartoDB (PostGIS) near function (distance) points to polygons
Jul
23
revised CartoDB (PostGIS) near function (distance) points to polygons
added map w/ link
Jul
23
asked CartoDB (PostGIS) near function (distance) points to polygons
Jul
9
awarded  Yearling
Jun
21
awarded  Popular Question
Jun
17
revised csvsql SQLite --insert causes ID to change
found a workaround
Jun
16
asked csvsql SQLite --insert causes ID to change
Jun
7
awarded  Popular Question
Apr
23
comment Join a CSV file to shapefile using gdal/ogr?
What's weird is the join occurs correctly on geoid but the output has the geoid with -2147184982 instead of what went into it.
Apr
23
comment Join a CSV file to shapefile using gdal/ogr?
Thanks! Working great. One more question, hopefully quick. The first line, I have a field geoid that keeps getting weirdly converted to negative floats. It's a census id that I want to treat as string, I've tried wrapping the string with quotes and that didn't work. Is there a command like: csvsql --db sqlite:///myjoindb.db --insert myjoincsv.csv geoid.map(str) or something?
Apr
17
comment Join a CSV file to shapefile using gdal/ogr?
Hey Eric, I'm getting an error that myjoindb.db already exists. Is that secondline db supposed to be named same as first?
Mar
10
accepted CartoDB table join error: Column reference is ambiguous
Mar
10
asked CartoDB table join error: Column reference is ambiguous
Mar
5
accepted CartoDB detecting user location - putting dot on the map
Mar
5
answered Converting File Geodatabase feature classes to shapefiles in ArcGIS for Desktop?
Mar
5
asked CartoDB detecting user location - putting dot on the map