After googlin' around I get an answer myself..
This is the string I use to load a dxf file to postgis without any Layer
that begin with "X":
ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config DXF_MERGE_BLOCK_GEOMETRIES
FALSE -f "PostgreSQL" PG:"host=localhost user=postgres dbname=mydb
password=myP
Hi Paolo, thanks.
Running the script for each layer assume that I know every layer inside each
dxf.
That's not possible because the content of a dxf depend on its location.
A dxf locate in mountain has different layers of a dxf representing a
seaside city..
But I know all layers that I don't wa
Hi
you'd better do asking to gdal-dev list, as it is a GDAL question. Anyway:
On Fri, Oct 12, 2012 at 2:21 PM, Pieri70 wrote:
> Hello
> I'm trying to load a thousand dxf files to postgis using ogr2ogr (windows xp
> postgres9/postgis2).
> the syntax I use is:
> ogr2ogr --config DXF_INLINE_BLOCKS F
Hello
I'm trying to load a thousand dxf files to postgis using ogr2ogr (windows xp
postgres9/postgis2).
the syntax I use is:
ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config DXF_MERGE_BLOCK_GEOMETRIES
FALSE -f "PostgreSQL" PG:"host=localhost user=postgres dbname=mydbname
password=mypassword" mydxf
Well, that was simple enough! Thanks! (as Eric rolls his eyes at himself)
On Mon, Jul 30, 2012 at 3:13 PM, David William Bitner wrote:
> You have geocoded declared as a type record. ST_Within needs that to be of
> type geometry.
>
> On Mon, Jul 30, 2012 at 1:32 PM, Eric Aspengren wrote:
>
>> So,
You have geocoded declared as a type record. ST_Within needs that to be of
type geometry.
On Mon, Jul 30, 2012 at 1:32 PM, Eric Aspengren wrote:
> So, I've got this PL/PGSQL script that doesn't want to work. I've got the
> TIGER geocoder up and running and I can get whatever I want from that.
>
If you're sure you're in a database based on the PostGIS template, I'd
try putting the schema name in front of the function name, i.e.
"public.ST_Within(...", see if that's the issue.
-Greg Kramida
On 7/30/2012 2:32 PM, Eric Aspengren wrote:
So, I've got this PL/PGSQL script that doesn't want
So, I've got this PL/PGSQL script that doesn't want to work. I've got the
TIGER geocoder up and running and I can get whatever I want from that.
However, when I try and combine ST_Within with the output from GEOCODE I
get an error. I assume there's a simple syntax error here, but I can't
figure it
t;
>To: PostGIS Users Discussion
>Sent: Monday, April 23, 2012 8:08 PM
>Subject: [postgis-users] help wanted with performance/GIST index question
>
>
>I'm doing some left outer spatial joins using the && operator, which should be
>relatively quick.
>
&g
Try setting:
set enable_seqscan=false;
and then try your explain again. I have run into this before with other
queries and this solved the problem, but I'm sure there is a better way
of dealing with this and I'm not sure what causes it.
-Steve
On 4/23/2012 11:08 PM, pcr...@pcreso.com wrote:
I'm doing some left outer spatial joins using the && operator, which should be
relatively quick.
When I join across 5 tables, the result is fast enough, & explain shows index
scans are being applied to the spatial tables. When I add another table,
explain shows a seq scan is used, despite the
> I tried retrieving a raster img using the gdal_translate.
> The problem now is that the retrieve works fine when I export only one of the
> bands, but
> gives a seg err. when no such option is given.
You will have to report this to the GDAL mailing list.
> Secondly I wish to publish the raster
got me correctly. The msi installation is a breeze.
I tried retrieving a raster img using the gdal_translate.
The problem now is that the retrieve works fine when I export only one of
the bands, but
gives a seg err. when no such option is given.
Secondly I wish to publish the raster data as a W
On Thu, Apr 19, 2012 at 02:42:11PM +0530, milon bhattacharya wrote:
> I recently installed PostGIS 2.0 . Using tool rastertopgsql converted a
> geotiff into sql. While executing the SQL using psql tool I am getting an
> error
> "type raster does not exists", please help.
It looks like you didn't
I recently installed PostGIS 2.0 . Using tool rastertopgsql converted a
geotiff into sql. While executing the SQL using psql tool I am getting an
error
"type raster does not exists", please help.
___
postgis-users mailing list
postgis-users@postgis.refra
Thanks Ben for your answer, I see the problem now... so, let me understand
this well, I have two tables, one table of points (as the one I posted
before) and the table of lines, which was made from the table of points. I
think in my case it'd be better to smooth just the table of lines, so I have
t
Gery,
You have created two loess functions, one which accepts two arrays of doubles,
and one which accepts a geometry and a double precision number.
You have two error messages :
On 10/04/2012, at 1:31 AM, Gery . wrote:
> CREATE FUNCTION
> psql:smoothingtest.sql:51: ERROR: function loess(doub
>I think it means some of your rasters have different pixel size.
>
>It's just a warning... But you should fix this.
>
>Pierre
ok, I try to resolve, my raster set should be all with the same pixel size.
More generally.
Not always is possible to have the same pixel size for a set of raster.
Inst
peri2...@gmail.com]
Sent: Saturday, March 03, 2012 11:52 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Help on warning from raster2pgsql
Hi,
I'm study-ing and try-ing to use the postgis 2.0 raster capability in beta2.
I launch raster2pgsql on a set of 730 files raster TIFF4 CCITT
Hi,
I'm study-ing and try-ing to use the postgis 2.0 raster capability in beta2.
I launch raster2pgsql on a set of 730 files raster TIFF4 CCITT FAX
black/white with tfw world-file.
The postgis raster is a new feature for me.
So I try use this settings:
raster2pgsql -s 3003 -I -C -M rst10k_flat
tgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] *On Behalf Of
*Birgit Laggner
*Sent:* Thursday, November 24, 2011 4:12 PM
*To:* postgis-users@postgis.refractions.net
*Subject:* Re: [postgis-users] Help me.
Hi Atul,
with the st_union function, yo
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Birgit
Laggner
Sent: Thursday, November 24, 2011 4:12 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] Help me.
Hi Atul,
with the st_union function, you aggregate all geometries dissolving all inner
boundaries
users@postgis.refractions.net
*Subject:* Re: [postgis-users] Help me.
Hi Atul,
are you really sure, you want to union all geometries of the three
tables into one big multipolygon? It seems to me that this might be a
little bit too complex and big...
But, if you really want to union all these geometries (and I a
t: Re: [postgis-users] Help me.
Hi Atul,
are you really sure, you want to union all geometries of the three tables into
one big multipolygon? It seems to me that this might be a little bit too
complex and big...
But, if you really want to union all these geometries (and I am not sure, if
this
users@postgis.refractions.net
*Subject:* Re: [postgis-users] Help me.
Hallo Atul,
perhaps, I would split the query in two queries, because otherwise I
think it might be difficult to use a spatial index on the second
intersection. The queries could be like this:
--create a spatial index on each input
, TEMP_OUTPUTTREE_5 t3
Thanks
Atul
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Birgit
Laggner
Sent: Wednesday, November 23, 2011 6:07 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] Help me.
Hallo
Hallo Atul,
perhaps, I would split the query in two queries, because otherwise I
think it might be difficult to use a spatial index on the second
intersection. The queries could be like this:
--create a spatial index on each input table:
create index temp_outputtree_2_gist_geometry on temp_ou
Hi All,
I am trying to intersection multiple sets of geographical data using
ST_intersection function. But query execution time is long.
My Query is :
select st_intersection (st_intersection (t1.geometry, t2.geometry),
t3.geometry) geometry from TEMP_OUTPUTTREE_2 t1,TEMP_OUTPUTTREE2_4 t2,
TEM
On Tue, Oct 04, 2011 at 09:50:41PM +0530, rajeev singhal wrote:
> Dear All,
>
> We are working on a project where we have a requirement to calculate the
> miles driven by a vehicle statewise. Driver can
> drive the vehicles in multiple states of the country and we have to show
> miles driven in ea
Dear All,
We are working on a project where we have a requirement to calculate the
miles driven by a vehicle statewise. Driver can
drive the vehicles in multiple states of the country and we have to show
miles driven in each state of the country.
We are getting GPS Coordinates of the vehicle ever
maybe you could first reduce the problem
create a view of all fields of your table except the geom columns
try to pg_dump it, this don't need postgis so could go
create a second view of the geom columns specifying AsText(geom) and a
field reference
copy this view to a text file with \g option
ever when you
> restore if you want.
>
> ** **
>
> Hope that helps,
>
> Leo and Regina
>
> http://www.postgis.us
>
> ** **
> --
>
> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
>
s
Gat
Sent: Tuesday, August 16, 2011 6:29 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Help dumping data from an old database
Hello,
I've recently been tasked with reviving an older database that hasn't been
touch in a while. Both postgres and postgis were used
Chris,
This is probably a bad suggestion, but iff you are desparate and iff you can
build a more recent postgis, then to dump it out you may find that creating a
simlink from a more recent liblwgeom.so with the name of the missing one might
work. the COPY command won't actually take anything ot
Chris, just use the postgres copy command to copy out the data you need, and
then copy into your new DB then. It can take an arbitrary sql expression so if
needed do a query that grabs the columns you care about and ignores the
location ones.
hth
charles
On Aug 16, 2011, at 6:28 PM, Chris Gat
Hello,
I've recently been tasked with reviving an older database that hasn't been
touch in a while. Both postgres and postgis were used to create this
database. My ultimate goal at this point is to be able to dump the database
from the linux server where it currently resides, to a mac workstation.
PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] help with backing up and restoring a
postgisdatabase (Raster comments)
Vishal,
P.S. - your raster notes are a good start. Haven't had a chance to read thru to
see if I can help with your questions at the end.
I wou
> P.S. - your raster notes are a good start. Haven't had a chance to read thru
> to
> see if I can help with your questions at the end.
Just added some comments in the page...
Pierre
___
postgis-users mailing list
postgis-users@postgis.refractions.net
stgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Friday, August 05, 2011 2:08 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] help with backing up and restoring apostgis
database
V
ractions.net] On Behalf Of Vishal
Mehta
Sent: Thursday, August 04, 2011 8:11 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] help with backing up and restoring a
postgisdatabase
Hi all,
I am working with windows7/ postgres9.0.4/postgis2.0 which I recently
installed and
scussion
Subject: Re: [postgis-users] help with backing up and restoring apostgis
database
Hi all,
I can provide a specific workflow describing my problems with backing up and
restoring a postgis2.0 database.
Information:
- Database I want to restore is called 'bangalore
net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Vishal Mehta
Sent: Thursday, August 04, 2011 5:11 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] help with backing up and restoring a postgis database
Hi all,
I am working with windows7/ postgres9.0.4/
Hi all,
I am working with windows7/ postgres9.0.4/postgis2.0 which I recently installed
and started testing like so:
http://algoesalgo.wordpress.com/tag/postgis2-0/
my previous experience has been with postgres8.3/postgis1.5, and I have never
before now tried to backup and restore a postgres/po
;
Or create a new table with these aggregated data & query from that directly.
HTH,
Brent Wood
--- On Tue, 6/14/11, Josh Jordan wrote:
From: Josh Jordan
Subject: [postgis-users] help with spatial query
To: postgis-users@postgis.refractions.net
Date: Tuesday, June 14, 2011, 2:03 AM
I am trying to return a map of the USA with the top 100 cities (point data)
labeled.
SELECT * FROM cities ORDER BY pop_1990 DESC LIMIT 100;
The problem is it returns clusters of cities, for instance 7 dots on Chicago
and 8 dots on Manhattan. Is there a way to return the top 100 cities
omitting o
On 16/05/2011 13:50, René Riech wrote:
On Mon, 16 May 2011 19:23:15 +0200, truongxuan quang
wrote:
Dear list
I face with some problem in installation PostgreSQL 8.3 on winXP ,
long time
before I use PostgreSQL and PostGIS for managing shape file data.
Last week I
tried to install Postgre
On Mon, 16 May 2011 19:23:15 +0200, truongxuan quang
wrote:
Dear list
I face with some problem in installation PostgreSQL 8.3 on winXP , long
time
before I use PostgreSQL and PostGIS for managing shape file data. Last
week I
tried to install PostgreSQL 8.4, after that I remove PostgreSQL
Dear list
I face with some problem in installation PostgreSQL 8.3 on winXP , long time
before I use PostgreSQL and PostGIS for managing shape file data. Last week I
tried to install PostgreSQL 8.4, after that I remove PostgreSQL 8.3 (I only
uninstalled inside windows control panel/add and then
I should ignori it, but I had to correct a typo, the last query I think
should be:
Select st_collectionextract(st_collect(whole_table.the_geom), 3)
from
(Select (st_dump(the_geom)).geom as the_geom,(st_dump(the_geom)).path as
the_path, id from myTable) as whole_table
left join
(SELECT a.the_path
Oops, I saw your ignore note too late :-)
/Nicklas
On Thu, 2011-01-20 at 09:20 +, Ross Lawley wrote:
> Hi,
>
>
> Please ignore my post, must have been tired last night because on
> reflection it doesn't make sense on its own and I would need more
> logic to determine which polygons if any t
As I understand it you want to find (and remove) parts of multipolygons
that has no neighbour multi part within a certain distance.
First, in your code you are usin the geometry instead of the double
value as teh last parameter in ST_DWithin
to get a list of all polygons in a multipolygon you use
Hi,
Please ignore my post, must have been tired last night because on reflection
it doesn't make sense on its own and I would need more logic to determine
which polygons if any to remove.
Ross
___
postgis-users mailing list
postgis-users@postgis.refract
I want to clean up some multipolygons and remove any polygons over a certain
distance by using a postgis function.
This is the closest I've come:
CREATE OR REPLACE FUNCTION filter_polygons_within(geometry, double
precision)
RETURNS geometry AS
$BODY$
SELECT ST_Multi(ST_Collect(f
On Mon, Nov 08, 2010 at 01:10:00PM -0500, Sam Snellings wrote:
> I didn't check the log, do you still need that to diagnose or did your
> second reply mean it's not necessary?
Until you figure out what it is I'd recommend looking at it.
> *(database geog_three, tutorial data) select
> GeomFromEW
I didn't check the log, do you still need that to diagnose or did your
second reply mean it's not necessary?
*(database geog_three, tutorial data) select
GeomFromEWKB(asEWKB(geog::geometry)) from airports;*
010120E61075029A081B9A5DC0F085C954C1F84040
010120E6106DC5FEB27B72044045477
On Sat, Nov 06, 2010 at 05:31:55PM -0400, Sam Snellings wrote:
> *(database geog_three, tutorial data) select
> asEWKB(setSRID(geog::geometry,-1), 'XDR') from airports;*
> *
> *
> asewkb
> *\001c05d9a1b089a02754040f8c154c985f0*
> \0014004727bb2fec56d4048810ff9724745
> \001c0
On Sun, Nov 07, 2010 at 09:58:02AM +0100, strk wrote:
> On Sat, Nov 06, 2010 at 05:31:55PM -0400, Sam Snellings wrote:
> > *(database geog_three, tutorial data) select
> > asEWKB(setSRID(geog::geometry,-1), 'XDR') from airports;*
> > *
> > *
> > asewkb
> > *\001c05d9a1b089a02754040f8c154c98
*(database geog_three, tutorial data) select
asEWKB(setSRID(geog::geometry,-1), 'XDR') from airports;*
*
*
asewkb
*\001c05d9a1b089a02754040f8c154c985f0*
\0014004727bb2fec56d4048810ff9724745
\001c035dce075f6fd224050083afb7e9100
3 row(s)
On Sat, Nov 6, 2010 at 4:56 PM, str
On Sat, Nov 06, 2010 at 01:44:12PM -0400, Sam Snellings wrote:
> Thanks for the ::geometry tip.
>
> (database geog_test, my data) *select count(asEWKB(location::geometry)) from
> global_points;*
>
> count: 1
>
> (database geog_three, tutorial data) *select count(asEWKB(geog::geometry))
> from ai
Thanks for the ::geometry tip.
(database geog_test, my data) *select count(asEWKB(location::geometry)) from
global_points;*
count: 1
(database geog_three, tutorial data) *select count(asEWKB(geog::geometry))
from airports;*
count: 3
Both of those counts are correct. global_points contains a
On Fri, Nov 05, 2010 at 09:43:14PM -0400, Sam Snellings wrote:
> select count(asEWKB(the_geom)) from global_points;
>
> Returns the following error:
>
> ERROR: function asewkb(geography) does not exist
Try asewkb(the_geom::geometry)
> asEWKB(), ST_isValid() and ST_isValidReason() don't work wit
select count(asEWKB(the_geom)) from global_points;
Returns the following error:
ERROR: function asewkb(geography) does not exist
Perhaps I don't understand your use of the term 'invalid geometry,' but I'm
using a geography datatype in both tables (airports and global_points) - so
there shouldn'
On Fri, Nov 05, 2010 at 04:43:54PM -0400, Sam Snellings wrote:
> The output of postgis_full_version() is:
>
> POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009"
> LIBXML="2.6.26" USE_STATS
Uhm. Maybe we need more fixes then.
See if this query gives you the ERROR:
selec
The output of postgis_full_version() is:
POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009"
LIBXML="2.6.26" USE_STATS
On Fri, Nov 5, 2010 at 4:27 PM, strk wrote:
> On Fri, Nov 05, 2010 at 12:25:43PM -0400, Sam Snellings wrote:
> > Hi,
> >
> > I ran into an error whi
On Fri, Nov 05, 2010 at 12:25:43PM -0400, Sam Snellings wrote:
> Hi,
>
> I ran into an error while trying to use pgsql2shp to export a table of
> geography LINESTRING() objects:
>
> [XXX~]$ [XXX]/pgsql2shp -f testfile -p 58456 geo_test global_points
> Initializing... Done (postgis major version:
Hi,
I ran into an error while trying to use pgsql2shp to export a table of
geography LINESTRING() objects:
[XXX~]$ [XXX]/pgsql2shp -f testfile -p 58456 geo_test global_points
Initializing... Done (postgis major version: 1).
Output shape: PolyLine
*Dumping: XERROR: parse error - invalid geometry*
That worked; sublimely simple.
Thank you!
On Mon, Sep 27, 2010 at 3:43 PM, Richard Greenwood
wrote:
> I think this should do the trick:
>
> SELECT EXTENT(the_geom)
> FROM parcels_public
> WHERE gid > 27611 AND gid < 28000;
>
>
> Rich
>
>
>
>
> On Mon, Sep 27, 2010 at 9:05 AM, John Poole
I think this should do the trick:
SELECT EXTENT(the_geom)
FROM parcels_public
WHERE gid > 27611 AND gid < 28000;
Rich
On Mon, Sep 27, 2010 at 9:05 AM, John Poole wrote:
> I've been grappling with the following concept and reviewing the
> PostGIS 1.5.1 Manual and cannot seem to com
I've been grappling with the following concept and reviewing the
PostGIS 1.5.1 Manual and cannot seem to come up with a working
solution to achieve this simple goal:
GOAL: I want to collect various polygons and then determine the
bounding box or extent of the collection in order to display an
appr
Your table is setup to accept only MULTIPOLYGONs. Either adjust your table
constraint to allow regular polygons or convert your polygon to a
MULTIPOLYGON.
--
Nathan Gerber
On Mon, Sep 13, 2010 at 6:56 AM, Nicholas I wrote:
> Hi,
>
> I want to create a polygon from the given points and clip the
Hi,
I want to create a polygon from the given points and clip the area's within
the polygon.
I just tried with the below one to create a polygon,
\d test_polygon;
Table "public.test_polygon"
Column | Type |
Modifiers
--+
On 17 August 2010 17:11, Jan Saalbach wrote:
> Nicolas, thank you for your help. I have imported a set of points using a
> python to psql script which filled a GeometryColumn using the ST_MakePoint()
> function.
>
> Now I would like to visualize the points using uDig. Since the set imported
> is c
Nicolas, thank you for your help. I have imported a set of points
using a python to psql script which filled a GeometryColumn using the
ST_MakePoint() function.
Now I would like to visualize the points using uDig. Since the set
imported is comprised of around 10 million points, drawing each
Nicolas,
you made my day. Absolutely amazing how fast and precise your help is.
Thank you very much.
Guess I will be using ST_AsEWKT() instead of the AsText function for now.
Thank you again.
Jan
Zitat von Nicolas Ribot :
Hello
st_astext is an OGC function supporting only 2D geometries.
> Hello
> st_astext is an OGC function supporting only 2D geometries.
> To get the textual representation of the real object, use st_asewkt
> (extended version of WKT, supporting more dimensions and SRID):
>
Hmm, I'm not very clear:
st_astext drops third and fourth dimensions when outputing its re
> thank you for your help. And yet I have another question. When I try to
> insert my 3d points into a previously created, empty column it seems only a
> 2d point is stored. Here is what I did via psql:
>
> -
> postgisdb=# INSERT INTO punkte (jan) VALUES (ST_makePoint(1.1,2.2,3.3));
> INSERT 0
thank you for your help. And yet I have another question. When I try
to insert my 3d points into a previously created, empty column it
seems only a 2d point is stored. Here is what I did via psql:
-
postgisdb=# INSERT INTO punkte (jan) VALUES (ST_makePoint(1.1,2.2,3.3));
INSERT 0 1
postgi
> Thank you Edward. It worked.
>
> Which now leads me to another question. I have datasets of the form "x y z".
> Which are location x,location y and elevation z to describe different
> bathymetries . What is the smartes way to store them so they can be easily
> worked with?
>
> Regards,
> Jan
>
H
gis/postgis.sql
HTH
Edward
Date: Mon, 9 Aug 2010 13:43:16 +0200
From: f...@dubmosphere.de
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] help setting up postgis
Dear all,
I am running into some troubles trying to install postgis 1.5.1. After
installation I followed the m
Date: Mon, 9 Aug 2010 13:43:16 +0200
> From: f...@dubmosphere.de
> To: postgis-users@postgis.refractions.net
> Subject: [postgis-users] help setting up postgis
>
> Dear all,
> I am running into some troubles trying to install postgis 1.5.1. After
> installation I followed
Dear all,
I am running into some troubles trying to install postgis 1.5.1. After
installation I followed the manual on which first steps to take. I
created a postgresql db and did the createlang part.
Now, when I enter "psql -d postgisdb -f postgis.sql" I get a
"postgis.sql: No such file o
For what it's worth: I cannot speak about FOSS in general, but for
raster servers I dare to take position.
Open-source rasdaman repeatedly has been reported to have a performance
way superior to ArcSDE.
Some more voices (look at the Oracle one!):
“world leading technology." -- Aerovista France (
Hi all,
one thing you may want to point out to the Indian Authorities is also that
the phrase "A highly scalable system may therefore be confronted with high
license costs" should be be understood according to what geoinformation is.
A large system has a large number of potential external users, m
Gee, somebody is desperate.
S
On Mon, 02 Aug 2010 20:07:55 +1000, Mark Cave-Ayland
wrote:
Ravi wrote:
Some so called SDI experts feel that FOSS SDI cannot perform at-par with
Proprietary SDI.
Please provide examples to fight a case from an Indian state which
swears by Free and Open Source So
Ravi wrote:
Some so called SDI experts feel that FOSS SDI cannot perform at-par with
Proprietary SDI.
Please provide examples to fight a case from an Indian state which
swears by Free and Open Source Software. We can never expect a better
level playing field.
Kerala - India
Here are some ex
ctions.net
Subject: [postgis-users] Help in Defending FOSS SDI
Some so called SDI experts feel that FOSS SDI cannot perform at-par with
Proprietary SDI.
Please
provide examples to fight a case from an Indian state which swears by
Free and Open Source Software. We can never expect a better level
pla
Some so called SDI experts feel that FOSS SDI cannot perform at-par with
Proprietary SDI.
Please
provide examples to fight a case from an Indian state which swears by
Free and Open Source Software. We can never expect a better level
playing field.
Kerala - India
Here are some excerpts from a
> Hey guys
> i am having trouble connecting postgis to mapser, could anyone please give
> me directions on the same. what version of mapsever do i need? i am working
> with postgresql 8.4 thanks
>
Any recent Pgis version is supported by MapServer
good hints here: http://mapserver.org/input/vector/
Hey guys
i am having trouble connecting postgis to mapser, could anyone please give
me directions on the same. what version of mapsever do i need? i am working
with postgresql 8.4 thanks
--
With regards,
Linnet Kwamboka
+254733229041
site: geekmates.ning.com
blog: one-kenya.blogspot.com
facebook
http://postgis.org/documentation/manual-1.5/ST_NumPoints.html
On Fri, May 21, 2010 at 10:15 AM, Bolivar wrote:
>
> Which postgis function is used to return the amount of vertexes (in an
> array)
> I got in my geometry?
>
>
> Thanks.
> --
> View this message in context:
> http://old.nabble.com/HE
Which postgis function is used to return the amount of vertexes (in an array)
I got in my geometry?
Thanks.
--
View this message in context:
http://old.nabble.com/HELP-WITH-A-POSTGIS-FUNCTION-tp28635185p28635185.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
> Hello,
>
>
>
> I have a table of parcels and the projection is epsg 102728
> (NAD_1983_StatePlane_Pennsylvania_North_FIPS_3701_Feet). I am trying to
> select certain parcels that are within 1 mile of the host parcel. I select
> the centriod of the host parcels as follows:
>
>
>
> SELECT ST_AsTex
Hello,
I have a table of parcels and the projection is epsg 102728
(NAD_1983_StatePlane_Pennsylvania_North_FIPS_3701_Feet). I am trying to select
certain parcels that are within 1 mile of the host parcel. I select the
centriod of the host parcels as follows:
SELECT ST_AsText(ST_Centroid(th
.
kind regards,
surya
From: Simon Greener
To: PostGIS Users Discussion
Sent: Mon, October 19, 2009 10:17:34 AM
Subject: Re: [postgis-users] Help determining position
Surya,
> with help of the list I am able to determine minimum width of a river using
&g
Surya,
with help of the list I am able to determine minimum width of a river using SQL
below. Especially thanks to Mr. Simon Greener.. I still need to determine
position (in meter and also latlon) of this point from the river mounth. Can
anybody give me suggestion what Postgis function I shou
Dear list,
with help of the list I am able to determine minimum width of a river using SQL
below. Especially thanks to Mr. Simon Greener.. I still need to determine
position (in meter and also latlon) of this point from the river mounth. Can
anybody give me suggestion what Postgis function I sho
a name of a road)
>> 4) way(geometry)
>>
>> Thanks
>> Rickus
>>
>> -Original Message-
>> From: postgis-users-boun...@postgis.refractions.net
>> [mailto:postgis-users-boun...@postgis.refractions.net]on Behalf Of Brian
>> Modra
>>
>
> Thanks
> Rickus
>
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.refractions.net]on Behalf Of Brian
> Modra
> Sent: Sunday, September 27, 2009 12:33 AM
> To: PostGIS Users Discussion
ry)
Thanks
Rickus
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net]on Behalf Of Brian
Modra
Sent: Sunday, September 27, 2009 12:33 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Help: Reverse Geocoding wit
Oops thats what happens when I post too quickly.
Ignore my mention of the "id" column, and replace "id" with "name" in
the example...
2009/9/27 Brian Modra :
> 2009/9/26 Rickus :
>> Hi
>> I hope someone can put me on the right track. I'm new to this list and new
>> to PostGis and to Spatial Databa
1 - 100 of 235 matches
Mail list logo