3,953 reputation
734
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 2 years, 9 months
seen 1 hour ago

Spatial Information Manager / Sr. GIS Analyst at Denver Public Schools


May
22
comment How to count points once with overlappying polygons?
I had to get this into PostGIS to get a better handle on the problem, but your solution worked best - thank you and very sorry for the delay, but the problem just re-surfaced and I've finally got it working!!!
May
22
accepted How to count points once with overlappying polygons?
May
21
comment How do you set the extent of a CartoDB 'embed' map?
Ok I see that's in there - would be nice to have it exposed in the embed window as this isn't really intuitive (embedding being the most basic form of using a cartodb map...) Thanks!!!
May
21
accepted How do you set the extent of a CartoDB 'embed' map?
May
21
asked How do you set the extent of a CartoDB 'embed' map?
May
21
comment Directly querying a raster
A arcgis mosaic dataset can store images OUTSIDE the dataset itself - ie. on the other server - then it can be accessed by arcgis tools locally as per the answers below...
May
21
comment How to use STUnion with GroupBy
that's a bummer!
May
20
comment Directly querying a raster
so you're not using SQL server really you're using ArcSDE to store the raster?
May
20
comment Directly querying a raster
The guys down in BI did this for me but it was the first time I've heard of rasters in SQL server - they are stored as BLOB's I believe, but not georeferenced and thus not 'data'... so... this might not be an option in SQL Server.
May
20
comment Directly querying a raster
We have stored raster 'images' in SQL server but not raster 'data'. We can query the images as records in a table, but we can't do pixel-level overlays, queries, etc. I can find out how it was done if you'd like...
May
20
answered How to use STUnion with GroupBy
May
20
answered Create a reference number (id) based on x coordinate in QGIS
May
18
comment Researching into the nuts and bolts of displaying ESRI Grids in QGIS
You're talking about an ArcGIS data format - not an 'open' format - so the best way would be to export the GRIDs as geoTIFF's or another georeferenced raster layer... I think...?
May
15
comment Creating spatial database with many categories that have same set of values?
@RyanM what locational information is in the CSV, that is, is the data by X,Y for crop locations, or are they each given a County name?
May
14
comment Creating spatial database with many categories that have same set of values?
how many input datasets are you going to be working with? And do you have any idea of the types of analysis you'll be doing?
May
13
answered Source for wind energy potential for India in GIS format
May
6
asked How to update the OSM data in a PGRouting Database built with osm2pgrouting?
May
6
comment Advanced Digitizing Tools Crashing in QGIS 2.8.1 x64 on Ubuntu 14.04
nice - did you submit to the QGIS bug trackers?
May
6
comment Printing (or exporting) Imagery from a Image Service using pre-defined map layout templates within an JavaScript based ArcGIS web app
Check out the so-called 'clip, zip, and ship' examples: resources.arcgis.com/en/help/main/10.1/index.html#//…
May
6
comment If Geographic Coordinates are unprojected coordinates, how can GIS softwares display such unprojected data on a plane?
They're projected to X/Y on the earths surface - as a globe - They're just not projected to a 2D plane... the software knows how to plot LAT/LON onto a projected coordinate system... but if your question is how is THAT done... well... I'll defer to the programmers...