2,981 reputation
517
bio website
location Ardmore, PA
age
visits member for 2 years, 10 months
seen 7 hours ago
stats profile views 229

Mar
9
awarded  Enlightened
Mar
9
awarded  Nice Answer
Feb
9
comment Why does DC belong to Maryland in OpenStreetMap/Nominatim?
It's definitely incorrect to consider it a part of Maryland. As others point out, this probably isn't the best forum to address it. File a bug report with OpenStreetMap.
Dec
31
comment ST_Touches function in Spatialite
Was your version compiled with GEOS support?
Dec
6
comment How to remove shapefile from PostGIS
Since he didn't specify version and DropGeometryTable is still in 2.0, I figured this was the cleaned way.
Nov
25
comment Why all WFS and WPS are CGI based?
rashad: Are you sure you understand what CGI is? It's a way for a web-server to pass requests on to other applications. It can be slower in some cases but it has nothing to do with HTML5Canvas or SVG. PHP can be used as a CGI. There are CGI for C++ and Java. CGI has its uses when you want a web server in front of your application.
Nov
22
answered How to remove shapefile from PostGIS
Oct
17
answered 1990 US Census Block Boundary File?
Oct
10
comment Is Spatialite Really Slow?
Welcome to gis.stackexchange.com! The format for this site implies that answers posted should be answers to the original question. When responding to an answer or comment it is best to make it a comment.
Sep
1
answered What's the best way to implement routing through areas such as parking lots?
Aug
11
comment Acquiring ArcGIS-like speed in Postgis
It's a common idiom in PostGIS to add a bounding box intersection check to speed things up. Try adding 'AND a.geom && b.geom' to your WHERE clause and see how much of a difference it makes.
Aug
6
revised Some data Loss when Import PGDB Table from Excel
added 5 characters in body
Aug
6
answered Some data Loss when Import PGDB Table from Excel
Aug
5
comment Solutions for fast operations on large GIS datasets
I'll agree with others that the solution is probably solved by optimizing your query/indexes and that distributed computing might not be necessary. For point-in-polygon, why do you use st_intersects and not st_contains? Are your points individual geometries or are some stored as multipoint?
Jul
22
awarded  Yearling
Jul
18
comment How to record tracks finer than 10-30cm resolution (possibly using an iPhone)?
If you want to find out specific capabilities of an iPhone unrelated to GPS, the Apple Stack Exchange might be a better place for your question. c.f. apple.stackexchange.com/questions/10722/…
Jul
18
answered How to convert Landsat L1G raster to Geotiff?
Jul
18
comment merging block group data that uses 2000 geography with 2010 geography
You should specify the dataset you're talking about. If it's 2010 Decennial data, it's in 2010 geography. If it's 2010 American Community Survey data, it's 2000 geography.
Jul
18
answered merging block group data that uses 2000 geography with 2010 geography
Jul
18
comment US unemployment data by zip (or aggregating data up to county level)
As mhoran_psprep points out, ZIP codes don't relate to county boundaries at all so trying to use county data to give ZIP code rates is inherently inaccurate.