Category Archives: Technology

“Doing more with SQL” talk at MAC URISA

Last week, I gave a 30 minute talk on “Doing More with SQL” at MAC URISA 2014. The slides from the talk are available below:

Posted in Conferences, PostgreSQL, Technology | Tagged , , , , , , , | 3 Comments

Insignificant Spaces

Yesterday, I mentioned that I discovered ArcGIS’s inconsistent handling of spaces within text fields. Today, I tested to see how ArcGIS handles NULLs, Empty Strings and Spaces within its native file formats.

Posted in Data, PostgreSQL, Technology, Tools and Scripts | Comments Off on Insignificant Spaces

Mitch Hedberg and GIS

So, a recent post on Reddit highlighted a Mitch Hedberg joke. “La Quinta” is Spanish for “next to Denny’s.” Thinking about this, I realized we could use GIS to find the number of La Quintas that are next to Denny’s. … Continue reading

Posted in Data, Google Maps, In the News, Teaching, Technology, Tools and Scripts, Web Mapping | 4 Comments

Bizarre GeoServer WMS rendering possibly due to ArcGIS handling of PostGIS data

I just submitted a problem to the OpenGeo support forum regarding an unusual bug I’ve discovered in GeoServer. Multipart polygon geometries are producing “unintentional art” when rendered through GeoServer. Several GIS data sets that have been brought into PostGIS using … Continue reading

Posted in Data, Technology, Visualization, Web Mapping | Tagged , , , , , | 1 Comment

Beach erosion in Ocean City

While not as hard hit as the towns near Seaside Heights, Ocean City felt the effects of Sandy and is still in the process of cleanup. Back in July, I took a Gigapan photo of the Ocean City beach from … Continue reading

Posted in In the News, Technology, Visualization | Tagged , , , | Comments Off on Beach erosion in Ocean City

Hurricane Sandy live data resources

As Hurricane Sandy is about to make landfall somewhere in NJ or DE, keep safe and dry. Move to a safe location and stay there. Don’t attempt to travel after dusk due to reduced visibility and the intensifying storm. Once … Continue reading

Posted in Data, Events, In the News, Technology | Comments Off on Hurricane Sandy live data resources

Pulling data from OSM using XAPI, bringing it to ArcGIS

I was recently asked by a friend if I knew of an ArcGIS-friendly data set representing the highway interchanges within New Jersey. I knew the information was already available in OpenStreetMap, but how could I quickly pull just the highway … Continue reading

Posted in OpenStreetMap, Technology, Tools and Scripts | Tagged , , , , , | 1 Comment

New Jersey Bike Map public meeting

This Thursday, May 10th, I will be attending the final public meeting to discuss the draft New Jersey Statewide Bicycle Map and Resource Guide. I attended the first meeting at Cumberland County College, but will be again providing comments at … Continue reading

Posted in Cycling, Data, Government, OpenStreetMap, OPRA, Planning, Technology, Transportation | Comments Off on New Jersey Bike Map public meeting

RULost? I hope not.

Fellow Rutgers grad Jim Barry shared with me a link to a press release on the RULost iPhone app. While I was initially excited to see Rutgers come out with an app to aid students in navigating the huge New … Continue reading

Posted in Data, Mass Transit, Technology, Transportation, Web Mapping | Tagged , , , | 1 Comment

Statewide 1974 aerial imagery available via WMS

OIT has made the 1974 statewide aerial photography available via their WMS service. WMS: http://njwebmap.state.nj.us/njimagery Civil Solutions was the contractor that assembled the source imagery and prepared the seamless dataset for OIT. What I find amazing about the data is … Continue reading

Posted in Aerial Photography, Data, Government, Technology | Tagged , , , | 1 Comment