195 reputation
13
bio website nygeog.com
location New York, United States
age
visits member for 2 years, 10 months
seen Jun 25 at 3:46

A NYC Geographer/GIS Analyst at CU; Data Science Cert. student at IDSE - python, stata, geoprocessing, music, effects pedals, & data, SUNYGeneseo/Buffalo alum


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
Dec
11
comment Is there a python option to “join attributes by location”?
Think I got it - see here gis.stackexchange.com/questions/125043/…
Dec
11
answered Finding an ogr2ogr equivalent of SelectLayerByLocation
Dec
11
comment Is there a python option to “join attributes by location”?
Would it be possible to have the neighborhoods as the output? I'm trying to do something where I want to use points to select polygons gis.stackexchange.com/questions/125043/… not using ArcGIS. I tried switching the input and the output shapefiles in this code without luck.
Dec
11
comment Finding an ogr2ogr equivalent of SelectLayerByLocation
Yeah, I'm going to have to do this in something that is not arcpy - just tested out modified code using Spatial Join and any and all arcpy attempts are going to take weeks to process. I need something on the order of day/days.
Dec
11
revised Finding an ogr2ogr equivalent of SelectLayerByLocation
added an attempt at the ogr2ogr code
Dec
10
comment Finding an ogr2ogr equivalent of SelectLayerByLocation
This is a similar processing function - saying to use Spatial Join - gis.stackexchange.com/questions/12448/…
Dec
10
comment Finding an ogr2ogr equivalent of SelectLayerByLocation
That's an interesting approach. I have some stuff processing so I'll try and do some tests on that approach. I'm down this rabbit hole sort of b/c I know it works. Can MakeFeatureLayer_management and SelectLayerByLocation_management be improved using in_memory?
Dec
10
comment Finding an ogr2ogr equivalent of SelectLayerByLocation
The Esri processing is taking way too long (weeks vs. ogr2ogr hours/days). I have 5 buffer sizes for 80,000+ grid points and I need to select only the exploded buffer features that can be selected by the grid point (buffer centroid).