<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks for the reply Oliver. With your help I'm getting closer!<br>
<br>
On Fri10/2910 Fri Oct 29 1:35 AM, Olivier Courtin wrote:
<blockquote
cite="mid:64BC27E0-7BB2-4B62-8FAB-357F425AD25E@gmail.com"
type="cite">
<pre wrap="">shp2pgsql -s 31467 -W LATIN1 -I gruenflaechen.shp frida | psql -U
postgres -d tinyows
</pre>
</blockquote>
<br>
This allowed me to successfully load the frida data. After taking a
closer look at my javascript and config.xml, I got the Transactional
example to work locally!<br>
<br>
<blockquote
cite="mid:64BC27E0-7BB2-4B62-8FAB-357F425AD25E@gmail.com"
type="cite">
<pre wrap="">Not sure to understand the question,
You mean an empty table/layer ?
</pre>
</blockquote>
<br>
Yes, that is what I mean. After examining the SQL used to generate
the frida table I think I've managed to create an empty layer.
Here's the output from tinyows --check:<br>
<br>
Available layers:<br>
- public.frida -> 31467 RW<br>
- public.connectome -> 4326 RW<br>
<br>
Unfortunately, problems persist.<br>
<br>
I'm trying to use OpenLayers to display a large image and allow
users to add annotations to them.<br>
To accomplish this, I'm using OpenLayers.Layer.TMS. If I tell my
custom map to use the Frida layer I get the following error upon
saving an annotation:<br>
<pre role="list"><code class="wrappedText focusRow" role="listitem">ERROR: new row for relation "frida" violates check constraint "enforce_srid_the_geom"</code></pre>
On the other hand, when I attempt to use my new, empty layer, I get
the same old "xml isn't valid" errors. I guess my main question at
this point is, what SRID should I be using in this situation?<br>
<br>
In order to help you help me, I've uploaded my javascript and config
file:<br>
<a class="moz-txt-link-freetext" href="http://melanarchy.info/tmp/config.xml">http://melanarchy.info/tmp/config.xml</a><br>
<a class="moz-txt-link-freetext" href="http://melanarchy.info/tmp/connectome.js">http://melanarchy.info/tmp/connectome.js</a><br>
<br>
I appreciate any additional help you can offer me.<br>
-Zack<br>
</body>
</html>