In my opinion you can’t beat UMN Mapserver or Mapnik for making gorgeous online maps. Mapserver has installed and run for me flawlessly every time I’ve tried it — without days of arguing with it. Mapnik has taken me nearly a week to get running sometimes. But, just like you wouldn’t want to shovel snow…
You are currently browsing the post archives for July 2008.
Good review of Mapnik for generating online maps
Comment on Good review of Mapnik for generating online maps
History of Rasters in PostGIS and a glimpse into the mechanics of an Open Source Project
I love this post thread so much I’m going to stick it into my blog. First because if you read into it and follow the links you can see the history of raster support in PostGIS (or reasons for lack thereof) for the PostGIS newbie readers. You can also see Paul’s encouragement and explanation of…
Comment on History of Rasters in PostGIS and a glimpse into the mechanics of an Open Source Project
GWT Charting Kit
Here is a nice GWT-based charting kit. It looks like it might be a reasonable replacement for a lot of we normally use JfreeChart for.
http://code.google.com/p/gchart/
Open Source County – Impressive Geospatial Portal
I keep having to fish around for this URL so I’m just going to blog into this online note space that I maintain. One stop shopping.
http://maps.co.mecklenburg.nc.us/gp/
This is the Mecklenburg County GIS data portal to both environmental and cadastral-type information. I ran across it some time ago as an avid reader of Tobin Bradley’s excellent blog…
Comment on Open Source County - Impressive Geospatial Portal
Putting your own content into a website with Google Maps
So I’m doing a little research tonight on some requirements for a client:
1. Embed a map in the client’s home page (non-database driven ASP.Net which is essentially HTML) that depicts the county’s watersheds and some number of additional layers2. Let users click each watershed polygon to trigger an event that leads to them learning more about…
Comment on Putting your own content into a website with Google Maps
Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6
http://www.bostongis.com/PrinterFriendly.aspx?content_name =sqlserver2008_postgis_mysql_compare
From the PostGIS Listserv comes a very useful comparison table that has been partially vetted by the members of the list. I just wish they included Oracle Spatial and Oracle Locator.
Paragon wrote: /> As part of our due diligence work, we are formulating a comparison of the /> spatial functionality offered by SQL Server…
Comment on Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6
Google Earth/ ArcExplorer Killer?
“TITAN takes spatial data sharing, viewing, and publishing to a new level. It seems to magically ingest almost any spatial data format, read it, use it, and publish it back out in any format — and do so quickly. It does for spatial data what the Babel fish did for language and speech. A universal…
Comment on Google Earth/ ArcExplorer Killer?
Gotta love interop
I love it when the big boys actually play nice together and support standards. Autodesk and Bentley team up on AEC Interoperability.
The GIS industry demonstrates this harmony so much better than main stream IT businesses. But even they are learning.
Changing a light bulb
Bought one of these Bulb Changer Kit/Pole tonight after months of dragging my feet about hauling the ladder up stairs to change the ceiling bulb in the bathroom. Totally worth money. If you have tall ceilings with light bulbs that hang down. Get one of these things. Period.
Comment on Changing a light bulb
Optimize all tables in a database, Part 2
Ok, not being satisfied with my first exploration of a global “do something” mysql script I asked the community for help.
The result is posted below, and here are the links that got me here.
http://www.linuxquestions.org/questions/showthread.php?p=2668261#post2668261
http://www.linuxforums.org/forum/linux-programming-scripting/85836-loop-within-loop-mysql-ops.html#post445403
Here is the final example script that optimizes (or replace optimize
with your favorite command like backup, alter table to InnoDB, etc.)
all tables…
Comment on Optimize all tables in a database, Part 2