<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [postgis-users] PostGIS and ADO.NET</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1589" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007>If we were using WFS, we'd be using MapServer to serve
it, so it looks like WFS-T is out.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007>So far, we've been doing everything web-based. A
desktop editor would be a nice fit for some problems, but it's not a
must-have.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007>If we can put and get WKT from the database using the
PostGress drivers that may be our solution.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN
class=251542418-26042007>Thanks for the help.</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Obe, Regina<BR><B>Sent:</B> Thursday, April 26, 2007 12:38
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> RE:
[postgis-users] PostGIS and ADO.NET<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=553421716-26042007><FONT face=Arial
color=#0000ff size=2>I believe that WFS-T spec which I think GeoServer
supports is designed for transactional editing via WFS. Mapserver
unfortunately does not support WFS-T to my knowledge. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=553421716-26042007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=553421716-26042007><FONT face=Arial
color=#0000ff size=2>I haven't played around with WFS-T so don't know much
about it and am not too familar with many client apps that can use
it directly except for uDig (which can edit PostGIS directly anyway I
think but is a Java app) and OpenLayers which seems to support WFS-T but can't
comment on how good that support is. </FONT></SPAN></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=553421716-26042007></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>T<SPAN class=553421716-26042007>he PostGreSQL
ADO.NET drivers can manipulate the attribute data easily. I do that all
the time.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007>Are you looking for a web-based editor or a desktop
editor?</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007>If you are looking to have your users edit data from
an ASP.NET page and have the ASP.NET page update the database, then one
thought that comes to mind is to use the WKT driver in OpenLayers (don't know
how robust it is, but looks like its designed to both read and edit WKT
data)</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007><A
href="http://trac.openlayers.org/browser/sandbox/tschaub/wkt/lib/OpenLayers/Format/WKT.js?rev=2902">http://trac.openlayers.org/browser/sandbox/tschaub/wkt/lib/OpenLayers/Format/WKT.js?rev=2902</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007><A
href="http://trac.openlayers.org/browser/sandbox/tschaub/wkt/examples/wkt.html?rev=2902">http://trac.openlayers.org/browser/sandbox/tschaub/wkt/examples/wkt.html?rev=2902</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007>Then you can use the AsText() function and
GeomFromText() functions built into PostGIS to dish out WKT data and consume
the WKT data. With that you can get by with just the npgsql ADO.NET
driver for editing and dishing out selected regions, your mapserver/KaMap for
heavy map rendering, and openLayers for bridging the
gaps.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007>Hope that helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=553421716-26042007>Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV><STRONG></STRONG> </DIV></BLOCKQUOTE></BODY></HTML>