Thanks Baren and strk - that was the problem, the file was in decimal degrees.<br>
<br>
Can these files be used in Postgis ? is it just a matter of finding another SRID, or do I have to convert them sowehow?<br>
<br>
Cheers<br>
Johan Wehtje<br><br><div><span class="gmail_quote">On 11/14/05, <b class="gmail_sendername">Barend Köbben</b> <<a href="mailto:kobben@itc.nl">kobben@itc.nl</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
In
ArcGIS/ArcView the original projection of the data can be
different from the projection of the View (or data frame in ArcGIS).
EG. you data could be in decimal degrees, 0,0 being the convergence of
the equator with the Greenwich meridian, while it could be projected to
meters in UTM where 0,0 could be quite another place on earth. In
ArcGIS you can see the projections of the data layer and the data frame
by looking at the propoerties of these two things (right clicking
them). In ArcView I think (don't have it here) you sholdl be able to
see that data too of respectively the layer and the View. The easiest
wai in PostGIS is just lloking at the numbers of the coordinates: if you<br>
select AsText(geom) from your table and see coordinates like
2.93883558758 10.227323263, you're looking at decimal degrees
latitude-longitude, if you see coords like 2125353.32 12263535.33 it's
meter coordinates in some cartesian system...<br><br><br>___________________________<br><br>Barend Köbben<br>International Institute for Geo-information<br>Sciences and Earth Observation (ITC)<br>PO Box 6, 7500AA Enschede (The Netherlands)
<br>ph: +31 (0)53 4874253; fax: +31 (0)53 4874335<br><br><br><br><br>> -----Original Message-----<br>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a><br>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On<br>> Behalf Of Johan Wehtje<br>> Sent: 14 November 2005 11:34<br>> To: PostGIS Users Discussion
<br>> Subject: Re: [postgis-users] Area and scale completely wrong<br>><br>> How would I check this.<br>><br>><br>> On 11/14/05, <a href="mailto:strk@refractions.net">strk@refractions.net</a> <<a href="mailto:strk@refractions.net">
strk@refractions.net</a> > wrote:<br>><br>> None of the measurement functions in postgis take<br>> projection into<br>> account. Computations are purely cartesian. Can it be that the<br>> input (shapefile) is really in decimal degrees and it
<br>> is transformed<br>> (reprojected) to GDA94/MGA84 during ARC load ?<br>><br>> --strk;<br>><br>> On Mon, Nov 14, 2005 at 08:25:54PM +1100, Johan Wehtje wrote:<br>> > isvalid returns true, envelope gives results that
<br>> make no sense outside of<br>> > the world of Lilliput.<br>> ><br>> > I had some of the same maps but with MGA 84 zone 56<br>> datum, and they have<br>> > loaded no problem, I therefore think that the
<br>> definition for the GDA94<br>> > spatial refernces must be out of whack, because the<br>> shape files have no<br>> > problem when loaded in arc view in either GDA 94 or MGA 84.<br>> >
<br>> > The GDA 94 shapes have attached xml files, and the<br>> pojection string in these<br>> > does look the same as the proj4 text in the Spatial<br>> Refsys table, so I don't<br>> > know what is going wrong.
<br>> ><br>> > Cheers<br>> > (and thanks your help)<br>> > Johan Wehtje<br>> ><br>> > On 11/14/05, <a href="mailto:strk@refractions.net">strk@refractions.net
</a> <<br>> <a href="mailto:strk@refractions.net">strk@refractions.net</a> <mailto:<a href="mailto:strk@refractions.net">strk@refractions.net</a>> > wrote:<br>> > ><br>> > > Does the area computation give acceptable value for
<br>> the geometry's<br>> > > envelope ? [ select area(envelope(the_geom)) ] ?<br>> > > Is the geometry valid ? [ select isvalid(the_geom) ] ?<br>> > ><br>> > > --strk;
<br>> > ><br>> > > On Mon, Nov 14, 2005 at 07:50:10PM +1100, Johan<br>> Wehtje wrote:<br>> > > > I am using Postgis 1.0.4 on Win XP with Postgresql 8.1.<br>> > > >
<br>> > > > I had some Shape files that have Land Parcels ,<br>> they use GDA94 Zone 56 (<br>> > > > srid 28356) , and I used shp2pgsql to load them<br>> into my DB.<br>> > > >
<br>> > > > But when I an area calculation I get results that<br>> are completely wrong ,<br>> > > and<br>> > > > when i add a Postgis layer using QGIS the scale<br>> would have me beleive
<br>> > > that<br>> > > > the entire shire (which about 80 km accross) is<br>> about 2 cm.<br>> > > ><br>> > > > I have tried this about twenty times, on 2
<br>> different machines - and the<br>> > > > results are the same. i have verified the<br>> original shape files in<br>> > > Arcview,<br>> > > > and when they are laoded the scale and area are
<br>> all what they should be.<br>> > > ><br>> > > > What am I doing wrong?<br>> > > ><br>> > > > Johan Wehtje<br>> > ><br>> > > > _______________________________________________
<br>> > > > postgis-users mailing list<br>> > > > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> > > ><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> > ><br>> > ><br>> > > --<br>> > ><br>> > > /"\ ASCII Ribbon Campaign<br>
> > > \ / Respect for open standards<br>> > > X No HTML/RTF in email<br>> > > / \ No M$ Word docs in email<br>> > ><br>> > > _______________________________________________
<br>> > > postgis-users mailing list<br>> > > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> > ><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> > ><br>><br>> > _______________________________________________<br>> > postgis-users mailing list<br>> >
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>><br>><br>> --<br>><br>> /"\ ASCII Ribbon Campaign<br>> \ / Respect for open standards<br>> X No HTML/RTF in email<br>> / \ No M$ Word docs in email
<br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br>><br>><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>