Thanks Paul and Jochem
Thats the answer I was hoping for. We have a hosted server running
PostgreSQL/PostGIS/Mapserver running at www.gis.bush.org.nz hosting by
limelyte. But no inhouse experience with even installing PostgreSQL.
We use MSDE2 inhouse but it has a 2GB limit. Being able to integrate CF with
mapserver would be fantastic.
Paul - are you querying ArcSDE with CF directly. ESRI have donated ArcSDE so
....
where is the boundary between CF and mapserver and flash
Mike
NZERN
---------- Original Message ----------------------------------
From: Paul Hastings <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 29 Nov 2004 20:42:05 +0700
Jochem van Dieten wrote:
> PostgreSQL should be able to handle this without a problem on
> suitable hardware. Don't forget to check out the PostGIS project,
> it plugs GIS features right into PostgreSQL.
yeah, it's pretty slick. i've been a long-long time user of commercial
GIS database products (mainly arcSDE) and to be able to use cf to run
spatial queries is pretty freaking fantastic:
<!--- find the province this point lies within --->
<cfquery name="findProvince" datasource="postGIS">
SELECT provinceName
FROM provinces
WHERE CONTAINS(the_geom, GeometryFromText('POINT(100.65 13.85)')
</cfquery>
and to top it off it can output results as SVG.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185584
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
