Fred,
On 18/05/2010, at 22:38 , Fred Lehodey wrote:
> I have no success trying the function probe_geometry_columns() with Postgis
> 1.5.0
>
> 1) Not sure but comparing the SQL with Postgis 1.3.3:
> the clause (in the INSERT step and not the count of probed)
> "sridcheck.consrc LIKE '(srid('||
Guillermo,
MapServer is the proper list for this question, but you haven't given much
information on what is a complex issue... and I can't help you directly with it
I'm sorry, but it might help if you gave a bit more information.
Are you getting a map? Is the data correctly displayed? You coul
Martin,
Assuming you wanted feedback - from an epidemiologists perspective, I like the
first one - Complete Spatial Randomness is an important concept to avoid
engendering a perception of order or clustering, and I'm thinking as long as
the relative 'dot-density' is correct for each polygon, th
I have used an R function before (using maptools package) to do something
similar, but I can't remember the details, so I would be considering looking at
PL/R.
cheers
Ben
On 06/05/2010, at 15:40 , strk wrote:
> On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote:
>> One of the thin
I think you need to ask this on the MapServer List - MapServer doesn't use the
postgis spatial_ref_sys table for it's projections, but the proj epsg library
files, so you need to put the definition in there - I googled " MapServer
Spherical Mercator Projection 900913 " to find out how to do this
Julian,
I have been trying to modify the function to take a tablename when it is
called, and although I can't see why it wouldn't work, it doesn't.
This is the one that does work - pretty similar I think to the one online.
I normally create a function to find the nearest geography of interest,
G'day all,
I am trying to sort out a routing problem over much of South-East Asia, and
trying to fill gaps using a number of different data sources.
I have a plpgsql function which works - with a static table name etc. When I
tried to change it to a dynamic name using the execute 'query' using
-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ben Madin
> Sent: Thursday, 1 April 2010 4:42 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] ST_Buffer questions
>
> G'day Li,
>
> I can't help with Q2, but
>
&g
Nicholas,
On 12/04/2010, at 12:33 , Nicholas Bower wrote:
> On Mon, Apr 12, 2010 at 12:21 PM, Ben Madin
> wrote:
> OK
>
> On 12/04/2010, at 10:03 , Nicholas Bower wrote:
>
> > 2. Dump just this separate data schema using pg_dump -Fc -N
>
> I think here you mea
OK
On 12/04/2010, at 10:03 , Nicholas Bower wrote:
> 2. Dump just this separate data schema using pg_dump -Fc -N
I think here you mean -n?, but it's six of one and half a dozen of the other. I
routinely use different schema's for different aspects of the database, hence
easier to just exclude
Nicholas,
I can't answer 'What's the right way?', as I'm sure I don't have it yet, but I
have found the biggest issue is in getting postgis to transfer, so I do it in
steps:
1. always install postgis into it's own schema (either create the schema - gis
- and set the search-path before \i postg
/2010, at 22:33 , P Kishor wrote:
> I asked this question yesterday, and received a very helpful pointer
> from Ben Madin re. TABLESPACES. As noted in my reply in that thread, I
> am also investigating the possibility of splitting a single table
> across multiple disks.
>
> Howe
G'day Puneet,
I'm no expert, but we have just started looking at using tablespaces to spread
a database across multiple drives. You may already be across this.
http://www.postgresql.org/docs/8.4/interactive/manage-ag-tablespaces.html
I haven't yet worked out if you can spread one table across m
G'day Li,
I can't help with Q2, but
On 01/04/2010, at 12:28 , Chen, Li [Contractor] wrote:
> Q1.
> ST_Buffer(g1, range) is able to return a geometry within the range of g1.
>
> So, I define two point using lon/lat (SRID=4326) and range 10km. I want to
> see whether they cross each other by us
ep -v BEGIN | grep -v COMMIT | psql australia
cheers
Ben
On 15/03/2010, at 4:35 , strk wrote:
> On Sun, Mar 14, 2010 at 04:58:02PM +0700, Ben Madin wrote:
>
>> in the event I can't work out the encoding, is there any way to turn off the
>> transaction behaviour,
G'day all,
I'm using shp2pgsql to import a road network, of which the fine detail is not
so important.
Mac OS X 10.6.2 POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23
September 2009" USE_STATS (thanks William K)
$ shp2pgsql -s 28350 /Users/owner/Spatial/country/AUS/WA/MRWA/mrwa
Ravi,
On 03/03/2010, at 14:45 , Ravi wrote:
> no error is given from the browser, but it just displays
>
> $db_handle = pg_connect(”host = localhost port = 5432 dbname = postgis user =
> postgres password = GrassJump”); $query = “SELECT * FROM rjybound”; $result =
> pgexec($dbhandle, $query);
Ravi,
A little bit more information about what is happening would help?
Do you have some output from the apache/php error log?
Does the User / Password combination have access to the tables normally?
cheers
Ben
On 03/03/2010, at 11:01 , Ravi wrote:
> Hi,
> am using OSGeo4W bundle and the a
gt; error messages may not always correspond to the coordinate system of the
> input geometries.
>
> Ben Madin wrote:
>> G'day all,
>>
>> I have a topology exception with a file I clean up with GRASS and exported
>> back into PostGIS, which I discovered whe
gt; strk wrote:
>> On Mon, Feb 15, 2010 at 03:51:40PM +0800, Ben Madin wrote:
>>> NOTICE: TopologyException: found non-noded intersection between LINESTRING
>>> (-0.204257 0.999226, -0.204257 0.99858) and LINESTRING (-0.204257 0.995743,
>>> -0.204257 0.99922
G'day all,
I have a topology exception with a file I clean up with GRASS and exported back
into PostGIS, which I discovered when I tried to merge provinces into countries:
CREATE TABLE new_country AS
SELECT country::varchar(3), st_union(the_geom) as the_geom
FROM new_prov
I had a similar issue with postgis, and I think what you need is a
topologically aware GIS, so you could try v.clean in GRASS. This will prevent
gaps forming, although if you have them to start you need to look at the rmarea
option to get rid of them, or v.digit.
It took me a bit of trial and e
Mark,
On 08/02/2010, at 17:10 , Mark Cave-Ayland wrote:
> Paragon Corporation wrote:
>
>> It should be noted that for this table
>> the_geom is the first field in the table and addr_num_tlid comes right after
>> and is a varchar
>> I can select any integer or bigint field fine, but selecting any
Kevin,
I suspect this is mainly an artefact of floating-point numbers, and the
conversion to and storage of these points in binary format.
As an aside I also notice that your shp2pgsql command didn't include a -s flag
- so you haven't defined a spatial reference system for your data. This may b
G'day all,
In chasing a list of administrative areas, and the number of reports of disease
from within each of them (based on point coordinates) I am using a left outer
join from the admin polygon table to the outbreaks table, and st_covers
SELECT n.ccode, n.admin1, count(a5.id) AS "2009"
FROM
G'day all,
Is there any way to simplify adjacent boundaries so that they remain congruent?
By way of explanation, I have finally obtained / cleaned up a data layer for
administrative boundaries in mainland South-East Asia, and I am very happy with
the result - all the topology etc is correct. I
Shreerang,
Here is a quick example of how it looks for me:
minmin:~ $ shp2pgsql -s 4326 -I /Users/minmin/Spatial/country/AUS/australia.shp
public.australia > australia.sql
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
minmin:~ $ psql australiapsql (8.4.2)
Type "help" for help.
australia
You can also read in SQL commands into psql using the \i command, for instance :
testdb=# \i
~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm/tl_2008_06001_arealm.sql
should read it in...
At least this should get you around the authentication issues...
cheers
Ben
On 29/01/2010, at 12:
I used the bended knee approach with some success, as in "Please sir, can I
have this in shapefiles"
Along the way I think I lost some attribute data, but the geometry was my
primary concern (roads for livestock transport and associated disease risks).
I was begging for a research project, but
G'day Puneet,
On 24/01/2010, at 21:04 , P Kishor wrote:
> On Sat, Jan 23, 2010 at 10:25 PM, Ben Madin
> wrote:
>> It's probably bad practice to log in as the postgres user - log in to psql,
>> and create a new user (without a password for now), with their own datab
It's probably bad practice to log in as the postgres user - log in to psql, and
create a new user (without a password for now), with their own database. If
your computer is secure, or you don't care, create the new user as a superuser.
Try the following:
http://www.postgresql.org/docs/8.4/inter
with different SRIDs
>
> Regards,
> Oscar
>
> On Sat, Jan 16, 2010 at 10:48 PM, Ben Madin
> wrote:
> Oscar,
>
> you have a couple of options as I see it. In Postgres you could just update
> the geometries first.
>
> > UPDATE mytable SET the_geom = ST
Oscar,
you have a couple of options as I see it. In Postgres you could just update the
geometries first.
> UPDATE mytable SET the_geom = ST_SetSRID(the_geom,4326);
And for next time, assuming your data originally had some sort of coordinate
system (and it must have if it was spatial data), yo
G'day all,
I just tried the upgrade script (from 1.4.0 to 1.4.1), but I seem to get a
number of fatal errors, and if I work around them by manually dropping the
types, other notices.
In a nutshell, if I go through this process, the upgrade COMMITS. If I run it
again, it fails at exactly the sa
G'day Ben,
On 11/01/2010, at 4:26 , Ben Harper wrote:
> Wouldn't it be the right thing to have spatial_ref_sys.srid be an auto
> increment field?
I would guess it should be unique (and possibly even a primary key?), but I
don't think auto-increment makes sense - better to have a system where p
G'day all,
I have a problem with some administrative boundary data I have failing validity
checks.
As an example, I had a polygon which kept reporting self-intersections. When I
tried :
select st_exteriorring((st_dump(the_geom)).geom) as the_geom from tmp_admin
where gid = 91;
So the one pol
able.
update tmp_admin set the_geom = r.the_geom from (select the_geom from rubbish
where gid = (select max(gid) from rubbish)) as r where gid = 91
So not a great outcome so far, but a small step in the right direction.
cheers
Ben
On 05/01/2010, at 17:31 , Ben Madin wrote:
> G'day all,
>
Arrgh! it was so likely to happen that Murphy would be proud,
On 26/11/2009, at 12:14 , Ben Madin wrote:
> create schema postgis;
>
> set search_path postgis, other schemas;
>
> \i postgis.sql -- or you could set the search_path in the postgis_sql file -
> there used to be
he database
> level is better I think
>
> ALTER DATABASE mydb SET search_path = public, shared
>
>
> The above will have it set for good, except if you restore a db, you need to
> remember to rerun the above command.
>
> Leo
>
>
>
.
Finally, I believe that you would want (or need) to specify SERIAL
UNIQUE now to ensure primary key is unique.
--
Ben Madin
AusVet Animal Health Services
P.O. Box 5467
Broome WA 6725
Australia
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
e : b...@ausvet.com.au
AusVet's we
a dbf file I had tried
to convert to utf-8 using openoffice, it worked perfectly on the
original file. Brilliant, thank you again.
I'm off to try it with the Chinese ones as well!
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
B
he columns with the Thai encoding and then type them all back
in!? Is there another way?
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
other reason I have missed?
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
[mailto:postgis-
users-boun...@postgis.refractions.net] On Behalf Of Ben Madin
Sent: Sunday, September 13, 2009 6:21 PM
To: PostGIS Users Discussion
Subject: [postgis-users] PostGIS upgrade 1.3 to 1.4
G'day all,
since I'm following the manual, when I tried the soft upgrade, it
seem
r you need a dump/reload
(HARD UPGRADE) to upgrade.
but in the Release Notes appendix I can't find anywhere any guidance
on whether I need a hard or soft upgrade.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome
r? (I'd almost be confident to guess that the last two messages
refer to the DROP AGGREGATE that follows the message?)
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA
251994328,AUTHORITY["EPSG","9122"]],AUTHORITY
["EPSG","3819"]]','+proj=longlat +ellps=bessel
+towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs ');
so there is no table definition in the spatial_ref_sys.sql file.
I would wonder
rt my ESRI shapefiles and
attribute
tables into PostGIS.
I have been trying to use the shp2pgsql function but its either i am
not
using it correctly or its just not working for me.
Please can someone out there help me. I am very new to PostGIS
application.
--
Ben Madin
REMOTE INFORMATI
berline.ca
tel+1.604.714.2878 · fax+1.604.733.0631 ·
mob+1.778.840.4625
Timberline Natural Resource Group · www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada
· V5Z 1E5
-Original Message-
From: pcr...@pcreso.com
Date: Thu, 3 Sep 2009 00:20:02
To: Ben Madin
Cc:
Subject: Re: [p
fractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 044
T_Point(-118.29926,
34.00846),ST_Point(-118.1907, 34.09855)),4269)
LIMIT 250
Query time: 4 seconds
The latitude and longitude columns are indexed. The geom column uses
a GIST index. We’re using Postgres v 8.1. Is there something we’re
doing wrong? Please let me know if you need more in
ns.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
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 545
-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
--
Ben Ma
rec
return some_result;
-Steve W
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
But I'm not sure if there is a function to select the 'nth' string in
a multi and add that as another layer
any ideas or help much appreciated.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 88
But I'm not sure if there is a function to select the 'nth' string in
a multi and add that as another layer
any ideas or help much appreciated.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 88
eople like you.
Check out Yahoo! Buzz. http://in.buzz.yahoo.com/
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m
Go Gophers!
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA
s@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
O
all professional systems use lat, lon
instead.
2009/7/10 Pavel Iacovlev
Yes they are in "reverse order", there is no standard for lat or lon
should be first (as I know), blame wkb/wkt :)
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
B
s.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
(nodes,edges)
from a road shapefile ?
--
Thanks
Regards
Sandeep Kumar Jakkaraju
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61
the version they are using so we have a
sense of
percentages for futrue versions.
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pay
the streets.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
know
om this. I would guess you will need to either upgrade
one machine or downgrade the other to be able to expect absolute
concurrence.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
27;,-1,'POLYGON',2);
CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek
USING gist (geometria);
I hope this is correct and not unhelpful.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broo
istinfo/postgis-users
_______
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 88
ally, this might not be a very good solution at all, but has
helped for now!
cheers
Ben
On 14/05/2009, at 4:26 AM, Juan Pedro Pérez Alcántara wrote:
Sure, you right. I'm refering versioning in it's first meaning, that
is,
history tracking.
--
Ben Madin
REMOTE INFORMATION
t
got any idea?
Thank You in advance.
Regards,
Rahul Pachaghare
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
know
ble precision))
Filter: (n.the_geom &&
st_expand(a.c_geom, 2::double precision))
-> Index Scan using mrwa_net_pkey on mrwa_net
(cost=0.00..5.71 rows=1 width=4) (actual time=0.005..0.006 rows=1
loops=154)
Index C
e.com.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.c
http://www.carto.net/neumann/
http://www.svgopen.org/
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 919
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/
d millions of records, so I guess I'm just checking.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
runk and requires GEOS 3.1.0.
Unfortunately
this does not exist in PostGIS 1.3 and also requires GEOS 3.1 and
above.
Hope that helps,
Regin
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
responding."
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, i
n export the data in a
different format (I don't want to stretch a favour here - they say
they only provide the data in their own format)
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome
e text
data to ensure it is valid?
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
know...
__
y googling I also saw references to PGRaster, but it looks like
that's still under consideration for development in postgis?
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
ql -d dbname -f /usr/local/pgsql/share/lwpostgis.sql
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out he
lumn containing 'seg' objects (see
./contrib/seg) with the end values derived from unix timestamps.
Paul
On Wed, Feb 18, 2009 at 4:24 PM, Ben Madin > wrote:
I hope no one minds this, but I have to deal with some changes to
my data,
and thought it might be a good opportunity to ask
en trying to
pg_dump everything except PostGIS ... now that's would be a pain.
Cheers,
Kevin
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
the GIS component, this would be attractive... but
are there implications for speed? Indexing? any good reasons not to do
this?
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 67
I better to calculate it on the fly
using postgis functions?
(area for some data)
ultimately, would keeping them be helpful, or would discarding them be
prudent to shrink the table, and the information that they provide can
be calculated if / when I need it?
cheers
Ben
--
Ben Madin
RE
occur over the transition is beyond me so far!)
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it
d seem like a large amount
of overhead.
I am trying to pull about the output from explain, but as the query
appears to never complete, it's a bit hard to figure when it isn't
finishing.
I would welcome any suggestions... any!!
cheers
Ben
--
Be
try on the gist index
# CLUSTER gis_roads USING gis_roads_gist;
CLUSTER
# select count(*) from gis_roads;
count
---
0
(1 row)
whoops!
Is this something I missed? Is this a PostgreSQL bug... surely the
cluster command shouldn't be allowed to destroy a whole table.
cheers
B
index it as a linestring and remove the
additional handling required to extract the linestring from the
multilinestring for processing and rendering. Has to be a little bit
faster.
OK - thanks again - it is only a small table by the standards of some
(9 rows)
cheers
Ben
--
Ben
bviate the need for
such a thing.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pay
In the event they are not the same, I have a few questions :
1. Is there any reason I shouldn't use the GEOMETRY type for my
aggregate table? (There must be or there wouldn't be any other types)
2. is ST_Multi() the best function to use to import them?
3. Is there any reason I wouldn&
and easier to repeat) using postgis.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out he
G'day all,A quick cross posting - I reply to myself - (thanks to Venkat for the suggestion, albeit not successful)I am having generally excellent results with MapServer 5.2, but I am having a problem with a postgis line layer not displaying, and no suggestion that it shouldn't from the logs.This wa
101 - 192 of 192 matches
Mail list logo
