[postgis-users] Having problemas to convert SHP to PGSQL

[George Silva]

Thanks Gregory, i will look into it tomorrow. (im not at the office)

So your master makes you say things?

Thanks again everyone.

On Thu, May 15, 2008 at 12:13 AM, Gregory Williamson <
Gregory.Williamson at digitalglobe.com> wrote:

>
> Sanity ?
>
>   ;-)
>
> Empty fields or misformed SQL, missing data or misformed data. Depending on
> how you are setting the output, you can try running sample statements in the
> "psql" tool (or pgAdmin):
>   BEGIN;
>    <your sql here>;
>   ROLLBACK; -- assuming you don't want partial changes
>
> Post back the first few lines and maybe the last few, but do eyeball it
> first and see if anything jumps out at you.
>
> Sorry for top-posting with such a slug o'text below but, as they say, "ours
> is not to reason why, but to invert and multiply."
>
> Greg Williamson
> Senior DBA
> DigitalGlobe
>
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information and must be protected in accordance with those
> provisions. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the sender
> by reply e-mail and destroy all copies of the original message.
>
> (My corporate masters made me say this.)
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net on behalf of George
> Silva
> Sent: Wed 5/14/2008 8:03 PM
> To: PostGIS Users Discussion
>  Subject: Re: [postgis-users] Having problemas to convert SHP to PGSQL
>
> Thanks Robert. Will try that.
>
> What should i look for?
>
> George
>
>
> On Wed, May 14, 2008 at 3:45 PM, Burgholzer,Robert <
> rwburgholzer at deq.virginia.gov> wrote:
>
>
>         BTW - I always dump the output of shp2pgsql to a text file, so that
> I can look at the SQL insert statements if there is a problem.
>
>
>         Robert W. Burgholzer
>         Surface Water Modeler
>         Office of Water Supply and Planning
>         Virginia Department of Environmental Quality
>         rwburgholzer at deq.virginia.gov
>         804-698-4405
>         Open Source Modeling Tools:
>         http://sourceforge.net/projects/npsource/
>
>         -----Original Message-----
>
>         From: postgis-users-bounces at postgis.refractions.net [
> mailto:postgis-users-bounces at postgis.refractions.net<postgis-users-bounces at postgis.refractions.net>]
> On Behalf Of Burgholzer,Robert
>         Sent: Wednesday, May 14, 2008 2:36 PM
>         To: PostGIS Users Discussion
>
>         Subject: RE: [postgis-users] Having problemas to convert SHP to
> PGSQL
>
>         Syntax for command please ...
>
>         Robert W. Burgholzer
>         Surface Water Modeler
>         Office of Water Supply and Planning
>         Virginia Department of Environmental Quality
>         rwburgholzer at deq.virginia.gov
>         804-698-4405
>         Open Source Modeling Tools:
>         http://sourceforge.net/projects/npsource/
>
>         -----Original Message-----
>         From: postgis-users-bounces at postgis.refractions.net [
> mailto:postgis-users-bounces at postgis.refractions.net<postgis-users-bounces at postgis.refractions.net>]
> On Behalf Of George R. C. Silva
>         Sent: Wednesday, May 14, 2008 2:27 PM
>         To: PostGIS Users Discussion
>         Subject: [postgis-users] Having problemas to convert SHP to PGSQL
>
>         hello all!
>
>         Once again i come with a issue for you the experts :P
>
>         I´m having trouble converting a shapefile to postgis schema, and
> nothing
>         will make it work.
>
>         the shp2pgsql actually runs, but at the end, no table is added or
>         populated. I even tried converting using QGIS 10
>
>         I will attach a zip of the shpfile. SRID is 29182.
>
>         Ive checked within ArcGIS is the shp is valid, or has problems, and
> nothing.
>
>         My postgresql is 8.3 and latest pgis.
>
>         _______________________________________________
>         postgis-users mailing list
>         postgis-users at postgis.refractions.net
>         http://postgis.refractions.net/mailman/listinfo/postgis-users
>         _______________________________________________
>         postgis-users mailing list
>         postgis-users at postgis.refractions.net
>         http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080515/be29c327/attachment.html>