772 reputation
117
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 1 year, 7 months
seen 19 hours ago

Spatial Information Manager at Denver Public Schools.
Community Technologist at OpeningOfDetroit.org


Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
thanks so much for your help, it has been valuable just to dig into these other methods!
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
Still no luck. Order of inputs is how you have specified, expression is as you specified but is not being taken by the tool, result still over 4,000,000...
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
weird issue with this tool: I got it to work by putting both the schools shapefile and the incidents table into a FGDB... when I run the tool - in most combination of parameters I can determine might work - the result point query layer balloons to over 4,000,000 records! The input school points have 196 features, and there are 20,000 incidents in the table...
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
@ian not at all... the goal is to do time-series analysis / animations.
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
@ian a new shapefile / feature class is what i'm after.
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
Much appreciate your response. It is not necessary to keep the excel file in its current format. I will try this just the same! Thanks again!
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
I did import the excel file into a FGDB, but the issue seems to be with adding the school points SDE feature class (also tried as shapefile) that it didn't like... will try again to make sure its the workspaces that aren't causing me troubles.
Apr
11
comment How to assign geometry to records in a table that contain an ID of a geometry point?
See edit. I'd like to basically have a point shapefile or other.
Apr
10
comment How to assign geometry to records in a table that contain an ID of a geometry point?
I can't seem to get the tool to accept the point file as either SDE or SHP... reading the doc you linked to and the tool help that it only takes TABLES rather than feature classes / geometry...?
Apr
10
comment How to assign geometry to records in a table that contain an ID of a geometry point?
@BradHards schools are points, so yes, trying to locate / assign to that school point based on SCHOOLNUM
Apr
10
comment How to assign geometry to records in a table that contain an ID of a geometry point?
see comment above... straight up joins in either direction do not work in ArcMap to solve this problem.
Apr
10
comment How to assign geometry to records in a table that contain an ID of a geometry point?
@the_skua performing that type of join in ArcMap, for example, doesn't work in either direction.
Apr
10
comment How to assign geometry to records in a table that contain an ID of a geometry point?
@PolyGeo edited with (I hope) enough info...
Mar
27
comment Why aren't the info windows showing up on my cartodb layers?
@Amanda I will leave this in javisantana's capable hands...
Mar
26
comment Why aren't the info windows showing up on my cartodb layers?
If you're using a custom filter, I take that to mean you're using a custom SQL expression, and I've run into the issue described here gis.stackexchange.com/questions/88265/… in which you also need to select tableName.the_geom_webmercator in order for the features to display.
Mar
24
comment How to convert a PNG tile set into the Mbtiles format
Are they PNG's from an ArcGIS tileset?
Mar
24
comment Can I automate State Plane to Lat/Lon conversion in CartoDB?
Here's a great tutorial on reprojecting data in QGIS, check section 1.3: manual.linfiniti.com/en/vector_analysis/…
Mar
22
comment Dot Density Maps in QGIS?
great tool, thanks Anita!
Mar
21
comment Why are map scales not used instead of Zoom-levels in web mapping clients such as OSM or Google Maps?
I'd say that google maps and open street map are NOT meant for people who care about scale numbers... that is, client applications built on Google or OSM are meant for simple audiences who don't care what zoom level (1-23) or scale (1:234,000) they are at... they just care about what they can see on the map! If you're building something for a more concerned/specific audience, I'd say there should be a way to specify in an API what zoom level you'd like to display in the slider...
Mar
21
comment sql server spatial index performance
I was just going through something similar dba.stackexchange.com/questions/61289/… the other day... I wasn't generating a polygon from text, but was intersecting points and polygons... I specified to use the spatial index on the point, which had great speed results. I then tried using the spatial index on the polygon, and had very poor performance...which seems like the exact opposite of your problem!