<!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">
Hello Murali!<br>
<br>
I am doing exactly the same at this moment! In our case, the shape
files are zip files in the MS SQL database (do these blobs come from
MapObjects? then you are probably in the same situation.)<br>
<br>
<big><big><font color="#ff0000"><i><b>The Byte is probably a ZIP, not a
shape..</b></i></font></big></big><br>
<br>
<br>
What we do:<br>
- Extract the blobs with a php-script -> store them as <b>ZIP</b><br>
- <b>Unzip</b> with the php_zip_lib (or something like that, I am not
behind the development machine right now) into a <i>temp directory</i><br>
- start a shell from the php-script that activates ogr2ogr -> ESRI
shape to PostGIS for the shape file in the temp directory into a
temporary table in PostGIS<br>
- Copy the temp table content in PostGIS to a production table with an
INSERT statement<br>
- loop this sequence<br>
<br>
Our proces is 80% under control, we are now generating the insert into
production (with a little help here on the PostGIS forums, thanks again
Kevin)<br>
<br>
<br>
Let me know if you want to know more. ....<br>
<br>
Kind regards,<br>
Milo van der Linden<br>
<a class="moz-txt-link-freetext" href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
<br>
<br>
Murali Maddali schreef:
<blockquote
cite="mid:76758090F8686C47A44B6FF52514A1D308C9C544@hermes.uai.int"
type="cite">
<pre wrap="">This is a ESRI shape file record, untranslated. Can you suggest me how to
translate this.
I am reading the blob from SQL Server 2000 using C# which return a Byte[]
and convert this Byte[] to bytea and pass this to Npgsql command object as a
parameter.
Thank you,
Murali K. Maddali
256-705-5191
<a class="moz-txt-link-abbreviated" href="mailto:murali.maddali@uai.com">murali.maddali@uai.com</a>
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Paul
Ramsey
Sent: Friday, July 20, 2007 6:10 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] geometry(bytea)
What is the format of your bytea? If it's the ESRI shape file record,
untranslated, you're out of luck. If it's a WKB byte array, then use
GeomFromWKB.
P
On 20-Jul-07, at 8:17 AM, Murali Maddali wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello All,
Can any one tell what I am doing wrong with the following select.
select geometry('\\005\\000\\000\\000\\010\\247\\033\\113\\056\\263\
\053\\101\\213\\236\\223\\165\\164\\062\\046\\101\\006\\377\\131\
\025\\172\\266\\053\\101\\350\\300\\323\\152\\241\\067\\046\\101\
\001\\000\\000\\000\\006\\000\\000\\000\\000\\000\\000\\000\\010\
\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\\234\\067\
\046\\101\\205\\364\\147\\256\\134\\266\\053\\101\\350\\300\\323\
\152\\241\\067\\046\\101\\006\\377\\131\\025\\172\\266\\053\\101\
\230\\025\\330\\025\\171\\062\\046\\101\\034\\227\\351\\330\\331\
\263\\053\\101\\366\\105\\154\\104\\165\\062\\046\\101\\136\\376\
\167\\260\\113\\263\\053\\101\\213\\236\\223\\165\\164\\062\\046\
\101\\010\\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\
\234\\067\\046\\101\\000'::bytea);
I am trying to convert a ESRI shape which is stored as a blob in SQL
Server 2000 to postgis. I am using Npgsql to connect to postgis. This
is the out I got from Npgsql. I know this is a valid shape and when I
imported the data using shp2pgsql from the shape file it imported
fine.
Thank you,
Regards,
Murali K. Maddali
UAI, Inc.
(256) 705-5191 (W)
<a class="moz-txt-link-abbreviated" href="mailto:murali.maddali@uai.com">murali.maddali@uai.com</a>
"Always bear in mind that your own resolution to succeed is more
important than any one thing." - Abraham Lincoln
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender. This message contains confidential information and is
intended only for the individual named. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail.
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteerd mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bijbehorende voorwaarden.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>