Hi Zia,
As Michael said, the postgresql COPY command is a standard way from
PostgreSQL to import CSV data. You can specify the columns, delimiter,
NULL values, quotes and other parameters and it will stop and report
errors if a line does not fit the data-types of the defined tables.
Often, l
Hi Regina,
I am pretty sure it is a restriction by Geoserver, but I am not a
Geoserver user, so I may be wrong. I am using updateable views with
Postgis and QGIS and it works fine, as long as it finds a primary key
(integer and unique). Did you make sure that you have a "primary key" in
you
Dear List,
does anyone has experience or references on how to store river
network segments of a watershed in Postgis database?
bestregards,
surya
___
indomail - Your everyday mail - http://indomail.indo.net.id
Stephen,
Could be. I think I had similar issues with my triggers where the actual
bounding box of the geometry was different from the stored one.
I forgot about that since it hasn't been an issue recently and I have
upgraded since.
Thanks,
Regina
-Original Message-
From: postgis-users
I have finally resolved this issue by upgrading to 8.3.6 and then dropping and
recreating the relevant GIST geometry index.
Could this be a manifestation of the GIST bug fixed in 8.3.6?
Cheers,
Stephen
On Saturday 14 February 2009 13:55:08 Stephen Davies wrote:
> Further to my earlier question.
Simon Greener wrote:
How do I load csv file in database? If some know please help me .
ogr2ogr is a really neat tool for this.
That's neat! I've used the csv driver for some lightweight stuff, but
not for importing into the DB. Very clever.
--
Gregor Mosheh / Greg AllensworthBS, A+, Net
Zia,
> How do I load csv file in database? If some know please help me .
ogr2ogr is a really neat tool for this.
Look at: http://www.gdal.org/ogr/drv_csv.html
regards
Simon
--
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Assoc
You might want to check out the COPY command:
http://www.postgresql.org/docs/8.2/static/sql-copy.html
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Zia
Ahmed
Sent: Tuesday, February 17, 2009 4:35 P
Zia Ahmed wrote:
How do I load csv file in database? If some know please help me .
Write a program in Perl or something, to separate the commas and
generate SQL. Depends on your language of choice.
--
Gregor Mosheh / Greg AllensworthBS, A+, Network+, Security+, Server+
System Administrat
How do I load csv file in database? If some know please help me .
Thanks
Zia
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
I'm not sure if this is the best list to try, but hoping someone may have a
solution to this and since I'm not on the geoserver list, figured I would
try this one first.
In one of the projects we have, we have a PostgreSQL view with update,
insert, select rules on it. I am told that geoserver se
By saying @nadgrids=null you are implicitly saying "please don't try
to do spheroid conversions for me". In cases where you are already in
WGS84, this is good. In other cases, it isn't. The @nadgrids hack was
invented by folks in North America, where their data is usually
already in NAD83, which i
> You can download a zip-file containing the GPL'd source for the Win32
> installer from here:
> http://pgfoundry.org/frs/?group_id=1000256&release_id=1274. This should
> then answer all your questions :)
Some results. First, I tried commenting out the sections on checking
the existence of te
> > MessageBox MB_YESNO "Install PostgreSQL 8.3.5?" /SD IDYES IDNO endPG835
> > File "..\postgresql\postgresql-8.3-int.msi"
> > ExecWait '"msiexec" /i "postgresql-8.3-int.msi" /qr INTERNALLAUNCH=1
> > SERVICEACCOUNT="postgres" \
> > SERVICEPASSWORD="xyz" CREATESERVICEUSER=1 SUPERUSER
Hi,
I am using PostGIS on Vista with UAC enabled, and have not observed this
problem at all. I did have to Run as Administrator when installing
PostgreSQL and PostGIS though, but that was the only issue I encountered
related to Vista.
Cheers
John
Ravivundavalli wrote:
>
> Hi,
> having some pro
I've applied the following script to my database to install support for the
Google Spherical Mercator projection, plus to fix the well known datum
missing for SRID 27700:
INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text)
values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DAT
I have a problem with the display of the marker layer, because the
coordinates do not match
this is my code:
function init()
{
options={
projection: new OpenLayers.Projection("EPSG:900913"),
displayProjection: new OpenLayers.Projection("EPSG:4326"),
17 matches
Mail list logo
