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…
Putting your own content into a website with Google Maps
Putting your own content into a website with Google Maps - continue reading
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…
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…
Comment on Optimize all tables in a database, Part 2
The all powerful find command
find <starting point> <search criteria> <action> The starting point is the name of the directory where find should start looking for files. The find command examines all files in this directory (and any subdirectories) to see if they meet the specified search criteria. If any do, find performs the specified action on each found file.…
Comment on The all powerful find command
Another Linux Web MySQL Backup Script
I found this on on the nixcraft craft. Looks pretty good to me. Similar in functionality to my other script posted here. I’m going to poach some concepts from here to make a script that will auto-optimize all tables in all databases on the mysql server. #!/bin/sh ################## ## jcz 17-feb-2007 ## copied from http://www.cyberciti.biz/tips/…
Comment on Another Linux Web MySQL Backup Script
gzip all directories in a directory
I don’t know why I keep having to do this, but I do. I always to create separate archives of all the directories in a directory. So, here is script from David (aka Matir aka EmptyCinema) from linuxquestions.org http://www.linuxquestions.org/questions/showthread.php?s=&postid=1839513#post1839513 to do just that (along with a sample sessions using it). #!/bin/bash for dir in */…
Comment on gzip all directories in a directory
Postgis data loader from shapefile bash shell script
Run this script in a directory of shp files to create STDOUT that will load them all into postgis —————————————————— #!/bin/sh # jcz aug 24, 2005 # clip off the “.shp” file extensions before use # drops existing shapes if they are the same name for z in `ls *.shp do echo “shp2pgsql $z $z…
Comment on Postgis data loader from shapefile bash shell script
