An unexpected Read-Only message is common when attempting a Geoserver WFS-T request via the Demo page. This is also true ...
Read More

Geoserver ships with a good list of helpful Demo requests — however, the authenticated requests fail if you do not ...
Read More

This technique is useful for georeferencing an image that you could be getting from a WMS server. To get an ...
Read More

Previously I discussed setting up a Vagrant EC2 VM for web application deployment. In this post, I will walk through ...
Read More

Vagrant on AWS with Windows Required installations: – AWS CLI – VirtualBox – Vagrant – an existing EC2 instance with ...
Read More

I’m back from my cross country bike ride! On a completely different topic, my book with Packt Publishing, is finished ...
Read More

I’m on a cross country bike ride! My progress as of 8/4/15: Photos ...
Read More

When I build interfaces on top of a pre-established database schema, I usually can’t change schema properties. That’s a problem ...
Read More

To my knowledge, there’s no way to “autopopulate” a form created through cakephp’s bake/scaffold utility. Populating of the forms are ...
Read More

For various reasons, I had found I needed to be root to install ArcGIS Server on Centos. I ran into ...
Read More

When our cluster was upgraded, I somehow lost the ability to run ArcGIS Server. No problem, I said, I’ll just ...
Read More

As noted here: http://gis.stackexchange.com/questions/18280/batch-convert-geotiffs-to-kmz-files, an undocumented method for conversion to KML exists in GDAL’s gdal_translate as format KMLSUPEROVERLAY. To do ...
Read More

On running sqlite CREATE and INSERT queries, I was getting some mysterious errors, like “Error: disk I/O error”, despite having ...
Read More

Initially I was getting error: The requested URL returned error: 403 Forbidden while accessing https://github.com/.. on $ git push origin ...
Read More

To keep symbology of a shapefile or geodatabase feature class, save a layer as a “layer file” (.lyr). If you ...
Read More

Here are some notes and thoughts I gathered during the 3-day Responsive Design Summit, which concluded today. Link to the ...
Read More

We recently up put out a new LearnIT Express Webinar A Brief Introduction To Story Maps, with Jim Casey, Teaching ...
Read More

As I had mentioned in previous email Esri has retired it’s public-facing geocoding and routing services. These services are now ...
Read More

So you have some data that includes latitude and longitude, you add it to the map … and it doesn’t ...
Read More

As I noted in my last post, UD has an ArcGIS Online subscription. As part of that service we have ...
Read More

You’ll be glad to hear that the ArcGIS Online Subscription is included as part of our campus site license. We’ve ...
Read More

Uploading existing datasets of any significant size (“bulk imports”) to OpenStreetMap involves serious consideration, above that of ordinary updates and ...
Read More

best webinar I’ve ever seen on public satellite imagery, though it’s by Exelis so expect lots of ENVI examples https://www3.gotomeeting.com/register/697671558 ...
Read More

I’ve posted a public branch of code from the Lima Bean project to github as csv2gft. This might be very ...
Read More

Working from a Google example I wrote some PHP that outputs KML from Postgres data, using region and lod to ...
Read More

ArcGIS Online (ArcGIS.com) does a nice job of providing front ends for your web mapping services (particularly of the ArcGIS ...
Read More

There are many use cases for running GDAL and arcpy in the same python instance. GDAL is the most popular ...
Read More

Running maptiler on Mac is no easy task, as I’ve found out. While there are a few stumbling blocks when ...
Read More

Maptiler is a good option for creating image overlays (such as historical maps) on Google Maps. There are some snags ...
Read More

Google’s Geocoding API limits results to 2,500/day. So what are your options when you hit a geocoding wall with a ...
Read More

I had previously written about a strange projection in the NOAA/CLIMAPS data, and am now following that up with a ...
Read More

As I’m currently working with two digital humanities groups on web projects, I have been thinking about easy/free ways to ...
Read More

With the plethora of cloud services being offered these days for hosting and analyzing geospatial data, it is important to ...
Read More

In addition to doing scheduled backups from Postgres, we’ve also needed to load nightly dumps sent via scp to our ...
Read More

National Climatic Data Center’s Climate Maps of the United States database offers polygon data for many popular climate variables. We ...
Read More

I’ve seen a few folks who’ve had trouble installing ArcGIS 10 because they’ve been unable to uninstall ArcReader (usually version ...
Read More

The Delaware 2012 GIS conference was held yesterday. It was a great opportunity to meet and learn from our colleagues ...
Read More

I took a trip to the UD Lewes Wind Turbine on Thurdsday … I posted a few paragraphs and a ...
Read More

I occasionally answer questions on ENVI/IDL and ArcGIS/Python integration. ENVI functions are available as “tools” through the ArcGIS GUI toolbox: ...
Read More

I followed this page to install/configure svn on my server … it’s written for Windows-based Apache install, so I’ve summarized ...
Read More

ArcGIS Online allows a user to upload CSVs, but as we found out, this feature provides less extensive sharing capabilities ...
Read More

Q: How to get max latitude for each given longitude in a time period subset of points as a GIS ...
Read More

Now that we have our new community cluster running at UD it’s time to learn how I can optimize GIS ...
Read More

Very cool dynamic cartograms for visualizing economic complexity: atlas.media.mit.edu ...
Read More

I am consulting on a research project involving bridge decay. For this project we needed to locate a number of ...
Read More

NetCDF is a format well suited for environmental research given the inherent multi-dimensionality of the environment and environmental research topics ...
Read More

I needed to take four steps to import an Oracle binary dump into PostgreSQL Open Oracle dump with something like ...
Read More

Client was getting error 999999 (generic) error when running weighted overlay analysis. Fixed this by changing Windows environment variable for ...
Read More

Issues I’ve run into while caching imagery on Geoserver/GWC Out of Memory Errors (java.lang.OutOfMemoryError: PermGen space): Solved this (as suggested ...
Read More

Is your each iterator not working on an Array? Try constructing the array as an object instead. Jquery v1.3.2 ...
Read More

To set an environment variable for ENVI/IDL on a pre-Lion MacOS System, I would recommend using the environment.plist file. This ...
Read More

Now that Geowebcache is integrated with Geoserver and WMS (among other OGC service types), map tile-caching is supposed to be ...
Read More

Today I was looking for a way to get the last character of a pattern so that I could replace ...
Read More

Cancer is a big deal, and the potential environmental factors make mapping incidence very appealing. This has made maps a ...
Read More

“ERROR: ESRI: error getting spatial references for srid = ” … uses public.sde_spatial_references instead of sde.sde_coordinate_systems, so cannot use standard ...
Read More

It seems like there is an out of the box error in ArcSDE which causes geodatabase operations like Import Feature ...
Read More

select max(to_number(substring(COLUMNNAME from ‘([0-9].*)’),’99999′)) from TABLENAME removes letters from a mixed column … can be used for generating a new ...
Read More

There is a bug in ArcGIS with the intersect tool (I noticed it when intesecting lines as polylines) that causes ...
Read More

Problem: NIC/NSIDC Antarctica data was appearing flipped 180 dg, without coordinate system or projection defined. When other polar data, thought ...
Read More

“I had become increasingly unhappy with L. L. Thurstone’s principle of so-called simple structure and his widely accepted idea that ...
Read More

While copy over a newline special character will show up in the “find” field of the “find & replace” dialog ...
Read More

I recently had a chance to test out ArcGIS Editor for OpenStreetMap (1.1 Beta3), an open source toolbox for interacting ...
Read More

fixed this issue by giving css position:relative on parent container further up the tree (in this case was the tabs ...
Read More

I gave a presentation to the U. of Delaware WebDev group and IT-CS&S (RDMS) on the topic of using data ...
Read More

It turned out that this task was much easier than I’d expected. Here are the steps I took: Edit the ...
Read More

NULL values trip up the WHERE NOT IN condition in Postgres. To fix this behavior, use a conditional (not null) ...
Read More

I noticed a couple places where we have two polygons on top of each other (particularly for parking polygons) in ...
Read More

Zooming to the maximum extent of all features in a vector layer does not work unless all features have been ...
Read More

I met with a gentleman today who needed to select random streets in Wilmington in order to do a field ...
Read More

Google MyMaps allows you to export KML by using the “Export to Google Earth” feature. If you copy/paste the URL ...
Read More

Wierd Geoserver Behavior (bug): font changed from Arial to some kind of serif font for no apparent reason. I fixed ...
Read More

The Animal Movement Extension was written in Avenue, and development stopped many years ago. Therefore, Animal Movement Extension is not ...
Read More

Fix: had specified larger tile size for earlier debugging. Switch tilesize back to 256 to fix label repeat on polygons ...
Read More

I’ve been having an extremely frustrating problem over the last month … in one word: labeling. My latest labeling challenge, ...
Read More

I was ultimately not able to deal with cutoff labels in Mapnik (or labels not being placed because of tile/overlap ...
Read More

I’ve been spending a lot of time dealing with mapnik labels/shields being cut off. Here are some strategies: change the ...
Read More

I'm still not sure what exactly causes this error: "ImportError: No module named mapnik" .. clearly Python is not finding ...
Read More

Was getting the following error on zipfile.py (actually while attempting to run a cascadenik script): newdata = self.dc.decompress(newdata) MemoryError I ...
Read More

I recently figured out that a web service class I was dealing with (WFS in OpenLayers) would only accept requests ...
Read More

So it seems like there’s no automated way to go from mxd to file/folder based (rather than web service) tile ...
Read More

I was getting the following error when trying to cache a map service in ArcGIS Server/ArcCatalog: 000569: Failed to generate ...
Read More

Was getting the following error: “You are missing some Flash content that should appear here! Perhaps your browser cannot display ...
Read More

To add a tiled basemap to a gmap created with views (and the gmaps) module: 1. First make sure that ...
Read More

1. Install Apache (2.2.x, to c:Apache2.2, in my case) and Tomcat (6.0.x, to c:Tomcat6.0, in my case) make sure each ...
Read More

For some reason you need to run the result of pg_fetch_array through a loop and store in another array to ...
Read More

Here’s how I imported, rendered, and served OSM data through mapnik, locally: 1. Do all downloads/installs … python (2.5 worked ...
Read More

After getting mapnik installed and running I realized: 1. generate_tiles/generate_xml (and the rest of the render utilities) are really necessaryfor ...
Read More

Now that I’ve decided to locally render OSM data for the campus, I need to get the OSM data for ...
Read More

Update: Success! Was able to convert to OSM with Export_to_OSM.py, all was needed was to change some paths in the ...
Read More

Installing QGIS with a standalone installer is definitely the way to go for someone with little time, no need for ...
Read More

A new idea: use custom service/renderer within a given extent and cloud service outside of that extent … tag campus ...
Read More

So I am returning in the new year with a major task at hand: finish work on UD campus maps ...
Read More

Is there a bug with the “table to table” tool in ArcGIS when using it to export a DBF from ...
Read More

I wanted to use openstreetmaps as the base data layer for the new UD Campus Maps, but am running into ...
Read More

Occasionally, the number of rows in a table* is not really the number of rows in the table. Sometimes this ...
Read More

was getting an error like “license server down or not responding -96,7” when trying to get ArcGIS to run on ...
Read More

try using the noscale option and enlarging the dimensions exported … you can use negative margins on the html output ...
Read More

In notepad++ you can easily find a carriage return by copying a section of texxt with a carriage return in ...
Read More

Connecting to my new SDE was exceedingly difficult. I’m not sure if it’s because it was built on postgres, but ...
Read More

when setting percent height property in AS3 was getting the following erro”1084: Syntax error: expecting identifier before semicolon” … was ...
Read More

I’m not sure if ENVI documentation is lousy or just not searchable, but I could not find any good information ...
Read More

“select * into” is not allowed in mysql. Here is an example to get around this limitation: CREATE TABLE newtable ...
Read More

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’); from: http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/ ...
Read More

Problem: Classify dialog does not open when hitting button “Classify …” under Spatial Analyst “Reclassify” tool Solution: Was trying to ...
Read More

EveryDWG is a utility provided by the Open Design Alliance, a consortium of firms mostly organized around DWG and other ...
Read More

finally found a suitable (and open source!) make executable for windows 64x, dmake. I posted it on a serve I ...
Read More

Blocks not displaying in their regions? Delete the block and then create it again and add again to the appropriate ...
Read More

mysql> create database db2; ! /usr/local/mysql/bin/mysqldump -u root –password=pass db1 | /usr/local/mysql/bin/mysql -u root –password=pass db2 originally seen on: http://mywheel.net/blog/index.php/2006/01/05/mysql-duplicate-database-quick-tip/ ...
Read More

The general wildcard regex for notepad (simliar to % in sql) is (.*). So to match both of these lines: ...
Read More

Problem: getting a syntax error whenever making any change to a py (python) file Solution: stop editing py file in ...
Read More

LOAD DATA LOCAL INFILE ‘[path to your csv]’INTO TABLE [table to import into, must be created before running with proper ...
Read More

on importing a csv to mysql I saw these little black square characters, which were carriage return symbols of course ...
Read More

if you get the error just run the following command to override the error: mstsc -v:0.0.0.0 /f -console (substitute ip ...
Read More

having trouble displaying a DISTINCT user list with views? This problem often arises because you need to choose the ‘user’ ...
Read More

Having difficulty accessing the $fields array under your Drupal Views template? Are you sure you have named your template correctly ...
Read More

Occasionally it is important to work on a local development machine. For this task I often use the xampp package, ...
Read More

the $fields array is very important for accessing field content when doing custom theming. Unfortunately field names are not well ...
Read More

Having trouble with no “active” class being generated for menu’s or primary/secondary links in Drupal 6.x?   It has been documented that ...
Read More

with the php domdocument class was getting the following error: Warning: main() [function.main]: unterminated entity reference 64-bit this error was ...
Read More

I leverage the domdocument php class to create elegant, dynamic html documents via the dom tree. However, I was finding ...
Read More

there are so many options with pear’s db library for php, I sometimes forget the optimal code for getting a ...
Read More

When defining projection from ArcCatalog (shapefile properties) I get an error message “Failed to Alter the Spatial Reference”. If I ...
Read More

There are multiple caching levels to be mindful of with a typical ArcGIS Server environment. This factor often makes debugging ...
Read More

To do a non-boolean conditional insert in SQL Server (the “where exists” clause is best for boolean), use the “where ...
Read More

I was getting the (generic and fairly common) “a is not defined” (on line 287 of main.js I believe) javascript ...
Read More

Thematic groups created in ArcMap and enhanced with Adobe Illustrator (AI), were saved as separate AI files (by region) and ...
Read More

I just created a small tool for calculating decimal degree map extents : you can access it here ...
Read More

when adding a service to a remote arcgis server you cannot browse to the actual location of the mxd or ...
Read More

this is a nice pear db query which returns an associative array $data = $sqlconnectionobject ->getAssoc(‘sql statement here’,true, array(), DB_FETCHMODE_ASSOC, ...
Read More

Setting up a Setting up a Tiling/Caching Google Maps/ArcGIS Server Solution has gotten much easier with the advent of ArcGIS ...
Read More

In trying to make an ArcGIS server (9.3) caching service I was initially not seeing any option for the required ...
Read More

Was getting the following error when trying to geocode, though I suspect it might come up whenever a feature class ...
Read More

export as .xls (with no formatting option) open w/ excel 2003 or earlier. press ctrl + A twice, do column ...
Read More

postgres to mysql workflow 1. Export database from postgres to plain text sql. You should do this with the pgAdmin ...
Read More

I recently was having trouble importing CSV to postgres. The trouble was with empty trailing columns (the first row had ...
Read More

was getting the following error after installing php 5.2.6 on IIS with IIS CGI configuration: PHP Warning: PHP Startup: Unable ...
Read More

are you getting field value with with the leading zeros excluded, but are joining to a field with the zeros ...
Read More

I was getting the following error on my web browser: “The directory name is invalid.” I assumed this was a ...
Read More

having problems with your pear install on a drive other than c (d?) on iis? you must run the pear ...
Read More

a common task I come across is the need to create a table of “distinct” records based upon “uniqueness” of ...
Read More

I had earlier shown how to do an update query based on a field from another table in MS Access ...
Read More

using xxamp for a lamp (linux,mysql, php) environment to do development on php? perhaps you are already running an iis ...
Read More

alright, there is actually a way to do this built into excel! good, it is as it should be! format ...
Read More

I often get tripped up doing an update of one table from fields in other table in access sql. i’m ...
Read More

Gone are my days of crawling ftp uploads. Now I just upload zip archives and expand with this nifty little ...
Read More

The WMS Manager library for openlayers is a great tool for allowing users to dynamically select layers from one or ...
Read More

another embarrassingly simple fix which took me a little while to figure out: While passing a hierarchical list to sajax ...
Read More

Was getting the following error when running a “join/select into” query in MS Access “Cannot open database ”. It may ...
Read More

this workflow assumes you are using the WP-DB-Backup plugin (I highly recommend) to backups of your mysql/wordpress db. Also am ...
Read More

I’ve begun adding a 3rd sidebar to my theme as a first step towards figuring out how to add widgets ...
Read More

Are Flash (SWF) maps worthwhile, or just a gimmick? Many sites have been putting up some pretty slick SWF maps ...
Read More

Though OpenLayers does define an opacity property for the layer object, I haven’t been able to get it working. Therefore, ...
Read More

If you want a descriptive associative array with Pear DB, this is probably what you should use: $data=& $dbh->getAssoc('select * ...
Read More