I put together a small Geotools based jar that Coldfusion can use to copy data from Oracle Spatial directly into PostGIS. Previously, we had needed to export the data as a shapefile, and use shp2pgsql to load the data into PostGIS. That method had an E… more »

An issue came up on the Geoserver users mailing list the other day, which I myself had had in the past. It goes like this: Lets say you have a table a and table b that you want to publish through Geoserver. a belongs to schema GIS1 and b belongs to sch… more »

It was a showdown between the three different methods to compare geometry in Oracle today. I had a left outer join to a table with a geometry attribute  in it. If there was no matching record in the table I was joining to, it would return null for the… more »

I was scratching my head for about two hours the other day trying to figure out why a query wouldn't work. The query involves a left outer join and a simple inner join. I kept getting Oracle error ORA-00904: "ME"."ENTRY_ID": invalid identifier. Here's th… more »