[GeoJSON] Best way to serve GeoJSON from Windows IIS
mpriour at kestrelcomputer.com
Sat Jul 21 19:51:53 PDT 2007
Thanks for the advice Chris & Howard,
I got Feature Server easily installed on my test server and used it to serve
out some GeoJSON from shapefiles. I'll let you know how the OGC connection
to MySQL goes.
I'll be using the data to do dynamically themed thematic polygons in VE.
I'll share the GeoJSON to VE map objects code when I complete it.
----- Original Message -----
From: "Christopher Schmidt" <crschmidt at metacarta.com>
To: "Matt Priour" <mpriour at kestrelcomputer.com>
Cc: <geojson at lists.geojson.org>
Sent: Friday, July 20, 2007 4:40 PM
Subject: Re: [GeoJSON] Best way to serve GeoJSON from Windows IIS
On Fri, Jul 20, 2007 at 03:15:28PM -0500, Matt Priour wrote:
> I thought y'all might be able to help me figure out the best way to serve
> GeoJSON out from a Windows 2K Server on IIS.
> I have a MySQL db with WKT geometries in a geometry column. I want to
> query the db and respond with GeoJSON.
> What's the best way to do this?
FeatureServer can talk to anything that OGR can talk to. I've only
tested it with GML, shapefiles and PostGIS, but it sounds (from howard's
previous post) like it should be possible to use FeatureServer's OGR
datasource for this.
Requirements are only that you have the OGR Python bindings installed --
everything else is pure python and easy to install.
If it turns out not to work, I'll be glad to help you with it on the
FeatureServer mailing list.
> Would the answer change if I was able to convince the client to move the
> data to a PostgresSQL db with PostGIS?
>From the point of view of FeatureServer, I have more experience with
serving data from PostGIS than from OGR. The requirements still include
ogr Python bindings (since the data is loaded from WKB using OGR), and
also tack on the psycopg modules. From my point of view, this type of
usage is the best supported by FeatureServer currently.
If there are any problems setting up FeatureServer, I'd be glad to help
out with them, and the latest FeatureServer includes support for
exporting GeoJSON per the current spec.
More information about the Geojson