Sparkblog

Viewing posts for the category postgis

PostGIS, CartoDB Bounding Box Trick

Posted by: Will Cadell in mapping cartodb web development postgis google maps leaflet 2 years, 5 months ago

When pulling out CartoDB or PostGIS data into a web mapping environment like LeaftletJS or Google Maps, it is handy to know the bounding box of the data in question. The bounding box is a convenient way to ensure your data is fully visible to the user, no matter what platform they are using or how responsive the viewport is.

read more / Comments

UPDATE With CartoDB Via PostGIS

Posted by: Will Cadell in postgis cartodb mapping cartocss web development 2 years, 5 months ago

I had made the assumption that CartoDB was all about data delivery. Much like the deprecated Google Maps Engine, I had assumed CartoDB's value was really in fast data rendering and distribution.

read more / Comments

More to maps than markers

Posted by: Will Cadell in esri user experience mapping web development code gdal postgis GIS open source tools google maps consulting leaflet 2 years, 9 months ago

Google Maps have been with us since February 2005, virtually a decade ago as I write this (expect a party on Feb 8th 2015). From their acquisitions of Where 2 Technologies and Keyhole, Google ignited a cartographic web revolution. Yes, of course there were maps on the internet pre-Google Maps, but Google brought the web map to the consumer, and has driven the expectation of location intelligence in web and mobile apps ever since.

read more / Comments

Making the US Census Database Show Up On A Google Map

Posted by: Will Cadell in web development postgis Open Source Tools google maps node mapnik 4 years, 4 months ago

I wrote up how to build a US Census Tract database earlier. However, we all know that data without a way of showing it on a map, is a little sad. So I wrote up the process I used to make it all available on a Google Map. The process involves the use of PostGIS, Mapnik, Node.js and just a smidge of magic. Its a longer post, so i lumped it in with my tutorials. You can go check it out here.

read more / Comments

Building a US Census Tracts PostGIS Database

Posted by: Will Cadell in postgis technology open source tools ogr2ogr 4 years, 5 months ago

This article shows how you (yes, you!) can build your very own US Census Tracts PostGIS database. I had looked over the interwebs for some time under the false assumption that someone, somewhere would have already done this, but it seems not. So this article documents my process. I am running a mac, so some things could be done faster / smarter using other technology refinements, but I have tried to keep things pretty generic for 'nix users. Windows people; you will find this process is pretty simple, I am sure you can replicate it using what you have available.

read more / Comments

Recent Posts

Archive

2017
2016
2015
2014
2013
2012

Categories

Tags

Authors

Feeds

RSS / Atom