Re: [postgis-users] ESRI Shape to Postgres
pgrouting http://pgrouting.postlbs.org/ Khurram Niaz Sheikh wrote: Thanks a lot, I managed to view the map through geoserver openlayers, how about routing and navigation, is there any utility/plug in to support such feature? Best Regards, Khuram -Original Message- From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] Sent: Wednesday, February 24, 2010 10:57 PM To: PostGIS Users Discussion Cc: Khurram Niaz Sheikh Subject: Re: [postgis-users] ESRI Shape to Postgres Hi, The typical approach is via OGC web services (WFS/WMS) You set up a server (eg: geoserver, UMN mapserver) then you can use a web client to render maps (eg: OpenLayers, GeoMoose) mapserver is a cgi which comes in a ms4w package which may be simpler for you, Geoserver is a java/tomcay application. mapserver can provide WMS/WFS services & also has a java (& php, etc) mapscript capability if you want to craft your own client interface instead of using something like OpenLayers. HTH, Brent Wood --- On Thu, 2/25/10, Khurram Niaz Sheikh wrote: From: Khurram Niaz Sheikh Subject: Re: [postgis-users] ESRI Shape to Postgres To: "PostGIS Users Discussion" Date: Thursday, February 25, 2010, 2:21 AM Thanks Leo, That was very helpful I managed to import the shape file as a table. Is there any place where I can find javascript apis to plot that data on a web platform? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon Corporation Sent: Wednesday, February 24, 2010 4:39 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] ESRI Shape to Postgres Khuram, We have a quick tutorial here targeted for windows users. Please take a look at it and see if it solves your questions. It also covers the loader Regarding your create new database. You need to use template_postgis as the template when creating a new database. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Leo -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Khurram Niaz Sheikh Sent: Wednesday, February 24, 2010 5:51 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Hi, I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: Wednesday, February 24, 2010 3:50 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Khurram Niaz Sheikh wrote: Thanks Mark, Can anyone plz me on this, I have tried to create a new database as well but still get the same error. Regards, Khuram Hi Khurram, You'll have to show us all of the commands you typed from creating the database to loading the shapefile in order for us to help you. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Regards, Chris Hermansen·mailto:chris.herman...@timberline.ca tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625 Timberline Natural Resource Group · http://www.timberline.ca 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Thanks a lot, I managed to view the map through geoserver openlayers, how about routing and navigation, is there any utility/plug in to support such feature? Best Regards, Khuram -Original Message- From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] Sent: Wednesday, February 24, 2010 10:57 PM To: PostGIS Users Discussion Cc: Khurram Niaz Sheikh Subject: Re: [postgis-users] ESRI Shape to Postgres Hi, The typical approach is via OGC web services (WFS/WMS) You set up a server (eg: geoserver, UMN mapserver) then you can use a web client to render maps (eg: OpenLayers, GeoMoose) mapserver is a cgi which comes in a ms4w package which may be simpler for you, Geoserver is a java/tomcay application. mapserver can provide WMS/WFS services & also has a java (& php, etc) mapscript capability if you want to craft your own client interface instead of using something like OpenLayers. HTH, Brent Wood --- On Thu, 2/25/10, Khurram Niaz Sheikh wrote: > From: Khurram Niaz Sheikh > Subject: Re: [postgis-users] ESRI Shape to Postgres > To: "PostGIS Users Discussion" > Date: Thursday, February 25, 2010, 2:21 AM > Thanks Leo, > > That was very helpful I managed to import the shape file as > a table. Is there any place where I can find javascript apis > to plot that data on a web platform? > > Regards, > Khuram > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Paragon Corporation > Sent: Wednesday, February 24, 2010 4:39 PM > To: 'PostGIS Users Discussion' > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Khuram, > > We have a quick tutorial here targeted for windows > users. Please take a > look at it and see if it solves your questions. It > also covers the loader > > Regarding your create new database. You need to use > template_postgis as the > template when creating a new database. > > http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 > > Leo > > > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Khurram > Niaz Sheikh > Sent: Wednesday, February 24, 2010 5:51 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Hi, > > I created the database using admin console, I mean > rigtclick and create a > new database, do I have to create the database using > command line, plz > advise? > > Regards, > Khuram > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Mark > Cave-Ayland > Sent: Wednesday, February 24, 2010 3:50 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Khurram Niaz Sheikh wrote: > > > Thanks Mark, > > > > Can anyone plz me on this, I have tried to create a > new database as well > but still get the same error. > > > > Regards, > > Khuram > > Hi Khurram, > > You'll have to show us all of the commands you typed from > creating the > database to loading the shapefile in order for us to help > you. > > > ATB, > > Mark. > > -- > Mark Cave-Ayland - Senior Technical Architect > PostgreSQL - PostGIS > Sirius Corporation plc - control through freedom > http://www.siriusit.co.uk > t: +44 870 608 0063 > > Sirius Labs: http://www.siriusit.co.uk/labs > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Hi, The typical approach is via OGC web services (WFS/WMS) You set up a server (eg: geoserver, UMN mapserver) then you can use a web client to render maps (eg: OpenLayers, GeoMoose) mapserver is a cgi which comes in a ms4w package which may be simpler for you, Geoserver is a java/tomcay application. mapserver can provide WMS/WFS services & also has a java (& php, etc) mapscript capability if you want to craft your own client interface instead of using something like OpenLayers. HTH, Brent Wood --- On Thu, 2/25/10, Khurram Niaz Sheikh wrote: > From: Khurram Niaz Sheikh > Subject: Re: [postgis-users] ESRI Shape to Postgres > To: "PostGIS Users Discussion" > Date: Thursday, February 25, 2010, 2:21 AM > Thanks Leo, > > That was very helpful I managed to import the shape file as > a table. Is there any place where I can find javascript apis > to plot that data on a web platform? > > Regards, > Khuram > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Paragon Corporation > Sent: Wednesday, February 24, 2010 4:39 PM > To: 'PostGIS Users Discussion' > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Khuram, > > We have a quick tutorial here targeted for windows > users. Please take a > look at it and see if it solves your questions. It > also covers the loader > > Regarding your create new database. You need to use > template_postgis as the > template when creating a new database. > > http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 > > Leo > > > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Khurram > Niaz Sheikh > Sent: Wednesday, February 24, 2010 5:51 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Hi, > > I created the database using admin console, I mean > rigtclick and create a > new database, do I have to create the database using > command line, plz > advise? > > Regards, > Khuram > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] > On Behalf Of Mark > Cave-Ayland > Sent: Wednesday, February 24, 2010 3:50 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ESRI Shape to Postgres > > Khurram Niaz Sheikh wrote: > > > Thanks Mark, > > > > Can anyone plz me on this, I have tried to create a > new database as well > but still get the same error. > > > > Regards, > > Khuram > > Hi Khurram, > > You'll have to show us all of the commands you typed from > creating the > database to loading the shapefile in order for us to help > you. > > > ATB, > > Mark. > > -- > Mark Cave-Ayland - Senior Technical Architect > PostgreSQL - PostGIS > Sirius Corporation plc - control through freedom > http://www.siriusit.co.uk > t: +44 870 608 0063 > > Sirius Labs: http://www.siriusit.co.uk/labs > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Thanks Leo, That was very helpful I managed to import the shape file as a table. Is there any place where I can find javascript apis to plot that data on a web platform? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon Corporation Sent: Wednesday, February 24, 2010 4:39 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] ESRI Shape to Postgres Khuram, We have a quick tutorial here targeted for windows users. Please take a look at it and see if it solves your questions. It also covers the loader Regarding your create new database. You need to use template_postgis as the template when creating a new database. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Leo -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Khurram Niaz Sheikh Sent: Wednesday, February 24, 2010 5:51 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Hi, I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: Wednesday, February 24, 2010 3:50 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Khurram Niaz Sheikh wrote: > Thanks Mark, > > Can anyone plz me on this, I have tried to create a new database as well but still get the same error. > > Regards, > Khuram Hi Khurram, You'll have to show us all of the commands you typed from creating the database to loading the shapefile in order for us to help you. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Khuram, We have a quick tutorial here targeted for windows users. Please take a look at it and see if it solves your questions. It also covers the loader Regarding your create new database. You need to use template_postgis as the template when creating a new database. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Leo -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Khurram Niaz Sheikh Sent: Wednesday, February 24, 2010 5:51 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Hi, I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: Wednesday, February 24, 2010 3:50 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Khurram Niaz Sheikh wrote: > Thanks Mark, > > Can anyone plz me on this, I have tried to create a new database as well but still get the same error. > > Regards, > Khuram Hi Khurram, You'll have to show us all of the commands you typed from creating the database to loading the shapefile in order for us to help you. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Khurram Niaz Sheikh wrote: Hi, I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise? Regards, Khuram Hi Khuram, You need to load the postgis.sql and spatial_ref_sys.sql files into your database in order to spatially enable it, as per http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Hi, I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise? Regards, Khuram -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: Wednesday, February 24, 2010 3:50 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI Shape to Postgres Khurram Niaz Sheikh wrote: > Thanks Mark, > > Can anyone plz me on this, I have tried to create a new database as well but > still get the same error. > > Regards, > Khuram Hi Khurram, You'll have to show us all of the commands you typed from creating the database to loading the shapefile in order for us to help you. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Khurram Niaz Sheikh wrote: Thanks Mark, Can anyone plz me on this, I have tried to create a new database as well but still get the same error. Regards, Khuram Hi Khurram, You'll have to show us all of the commands you typed from creating the database to loading the shapefile in order for us to help you. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Thanks Mark,
Can anyone plz me on this, I have tried to create a new database as well but
still get the same error.
Regards,
Khuram
-Original Message-
From: Mark Cave-Ayland [mailto:mark.cave-ayl...@siriusit.co.uk]
Sent: Wednesday, February 24, 2010 3:02 PM
To: Khurram Niaz Sheikh; PostGIS Users Discussion
Subject: Re: ESRI Shape to Postgres
Khurram Niaz Sheikh wrote:
[CC-d to postgis-users list]
> Hi Mark,
>
> Can u plz help me on this, I have just installed to evaluate postgres, I
> have the data in shape format and wish to convert to postgres format,
> when I try to do it using shp to postgres importer it gives me error
>
> Connecting: user=postgres password=** port=5432 host=localhost
> dbname=postgres
>
> Connection succeeded.
>
> Connection: user=postgres password=** port=5432 host=localhost
> dbname=postgres
>
> Destination: public.postgrestest
>
> Source File: D:\My Documents\Data\postgres\postgrestest
>
> Shapefile type: Arc
>
> Postgis type: MULTILINESTRING[2]
>
> Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
>
> SET STANDARD_CONFORMING_STRINGS TO ON;
>
> BEGIN;
>
> CREATE TABLE "public"."postgrestest" (gid serial PRIMARY KEY,
>
> "road_id" int4,
>
> "priority" int2,
>
> "name" varchar(250),
>
> "geography" varchar(50));
>
> SELECT AddGeometryColumn('public','po"
>
> Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown,
> unknown, unknown, unknown, unknown, integer) does not exist
>
> LINE 9: SELECT AddGeometryColumn('public','postgrestest','the_geom',...
>
>^
>
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
> Shapefile import failed.
>
> Can uplz give me solution of this issue.
Hi Khurram,
Please email the list directly in future since it is much more likely
that someone will be able to help you.
Note that the in-built postgres database is for
maintenance/administration only - you need to create yourself a new
database and load postgis.sql into it, as per the manual here:
http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ESRI Shape to Postgres
Khurram Niaz Sheikh wrote:
[CC-d to postgis-users list]
Hi Mark,
Can u plz help me on this, I have just installed to evaluate postgres, I
have the data in shape format and wish to convert to postgres format,
when I try to do it using shp to postgres importer it gives me error
Connecting: user=postgres password=** port=5432 host=localhost
dbname=postgres
Connection succeeded.
Connection: user=postgres password=** port=5432 host=localhost
dbname=postgres
Destination: public.postgrestest
Source File: D:\My Documents\Data\postgres\postgrestest
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."postgrestest" (gid serial PRIMARY KEY,
"road_id" int4,
"priority" int2,
"name" varchar(250),
"geography" varchar(50));
SELECT AddGeometryColumn('public','po"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown,
unknown, unknown, unknown, unknown, integer) does not exist
LINE 9: SELECT AddGeometryColumn('public','postgrestest','the_geom',...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Shapefile import failed.
Can uplz give me solution of this issue.
Hi Khurram,
Please email the list directly in future since it is much more likely
that someone will be able to help you.
Note that the in-built postgres database is for
maintenance/administration only - you need to create yourself a new
database and load postgis.sql into it, as per the manual here:
http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
