[Fwd: Re: [Community] PCL/Primagis postgis back end.]

[Michael Fecht]

Hi Jean,

BALTUS Jean wrote:
> Hi Michael,
> 
> Do you think that it would be possible to use your trick for MS SQL Server or are you using features from postgis?
I don't have any experience with MS SQL Server, and I don't know how to 
get your data into zope using something like Zpsycopg. Is there a 
product for MS SQL Server?

Nether the less I think it should work anyway. The only thing that is 
different is the way you have to prepare your data before adding them to 
the memoryfeaturesource. Somewhere I saw a example using csv to feed a 
memoryfeaturestore.
> 
> I have a table with 4 columns:
> ID | INFORMATION | LATITUDE | LONGITUDE
the geoemetry shoul look like :
  POINT(x y)

e.g.
Fid  	Fname  	                Geom
71 	Outlet at km 3.2 	POINT(503259.108177138 632385.95115673)
72 	Outlet at km 4.3 	POINT(502175.286238616 632155.406244628)
74 	Outlet at km 5.8 	POINT(500907.550872611 631450.17956161)
75 	Outlet at km 6.85 	POINT(500494.011269451 630512.401477663)
76 	Outlet at km 7.1 	POINT(500492.930452996 630257.45342032)
78 	Outlet at km 8.05 	POINT(499939.02357808 630213.327897371)
79 	Outlet at km 8.35 	POINT(499638.14867548 630264.380206155)


The example I have written was to display polygons so you have to 
replace polygon to point in the bounds, datastore and datatype script.

I hope it helps.
Cheers
Michael

> 
> And would like to display that information as a layer of points in primagis.
> 
> -- Jean
> 
> -----Original Message-----
> From: community-bounces at lists.gispython.org [mailto:community-bounces at lists.gispython.org] On Behalf Of Michael Fecht
> Sent: 10 February 2006 10:24
> To: co >> "gispython.org community"
> Subject: [Fwd: Re: [Community] PCL/Primagis postgis back end.]
> 
> 
> 
> -------- Original Message --------
> Subject: Re: [Community] PCL/Primagis postgis back end.
> Date: Fri, 10 Feb 2006 10:21:12 +0100
> From: Michael Fecht <fecht at grid-it.at>
> To: Jason C. Leach <jason.leach at gmail.com>
> References: <602f2f2b0602091306n3aa7f1dbq262158719db75e32 at mail.gmail.com>
> 
> Hi Jason,
> 
> we are using PostGIS via MemoryFeatureStore. I just added a section in
> the wiki on that:
> 
> http://trac.gispython.org/projects/zope/wiki/UsingPostGISviaMemoryFeatureStore
> 
> Maybe it helps!
> Cheers
> Michael
> 
> Jason C. Leach wrote:
> 
>>hi,
>>
>>Does anyone know of a site or docs on how to setup a PostGIS back end
>>for PCL?  I have the demo (Primagis) working just fine with the shape
>>file, now on to postgis.
>>
>>Thanks,
>>Jason.
>>
>>
>>
>>--
>>........................................
>>.... Jason C. Leach
>>.... PGP Key: 0x62DDDF75
>>.... Keyserver: gpg.mit.edu
>>_______________________________________________
>>Community mailing list
>>Community at lists.gispython.org
>>http://lists.gispython.org/mailman/listinfo/community
> 
> 


-- 
---------------------
Michael Fecht
Freisingstraße 2
A6020 Innsbruck
+43 (0)650 8131923
---------------------