All,
You probably want to add in lines as well, for doing buffered searches from
along Railraod routes for example.
bobb
>>> Michal Kubenka wrote:
Actually what we need is some hierarchical base for relationship between
countries, cities, regions, etc. Main goal of the application wil
I didn't read into the solution he provided, so I don't know the background of
the parameters he's using, but I would suspect that are intended for "R" to use
as some sort of smoothing config. Unless I'm mis reading your reply.
I've never used "R" myself, but I have looked at it's capabilitie
If the aim is to actually smooth lines, this was posted recently to the list:
http://postgis.refractions.net/pipermail/postgis-users/2010-October/030264.html
it uses R to accomplish the task. The links at the bottom are still active as
well for the sample output that was created.
bobb
All,
Seemling simple, but eluding me (at the moment).
I've found how to generate a Line string from a set of points, even how to bust
one up into separate segments. But what I need is a way to generate separate 2
point line segments from a string of points. I need to apply a time/distance
Gery,
here is a hint: INSERT INTO (select . . . )
or something close to that . . .
bobb
>>> "Gery ." wrote:
I'm really amazed by such basic question, sorry for this but I don't find the
answer, this is, I simplified a table like this:
select transform(simplify(transform(rawgeom,
try adding another to the "nclheights" line.
nclheights AS foobar.
Also I don't think that semicolon after the last paren is valid (Before your
existing AS . . .)
bobb
>>> JamesH wrote:
Ok I'm trying OpenJump as I need to get going with this for my dissertation.
Now I'm connected to
Is there a way to set the output pane in the query builder to automatically
resize for the output width wise?
thanks
bobb
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgi
serial or bigserial, it will create an int or bigint
respectively and create the sequence.
more below ...
On 3/15/2012 3:19 PM, Bob Basques wrote:
> All,
>
>
> I have this sequence:
>
>
> CREATE SEQUENCE cmdstpinfo_cmdrecid_seq
>
> INCREMENT 1
>
> MINVALUE 1
>
&g
All,
I have this sequence:
CREATE SEQUENCE cmdstpinfo_cmdrecid_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 132894
CACHE 1;
ALTER TABLE cmdstpinfo_cmdrecid_seq
OWNER TO gismo;
and I'm trying to create this table:
CREATE TABLE cmdstpinfo
(
cmdrecid bi
All,
Interesting thread here, working with this myself right now.
I can see how it could easily become daunting though. I started from scratch
in the cloud, and set up Ubuntu and Postgres. Been working with it for a month
now, and all seems to be working nicely. Sort of in the performance
That's my PERL heritage sneaking in, sorry.
bobb
>>> Stephen Woodbridge wrote:
This makes indexing somewhat problematic. And if you try this in SQL
'&&' is NOT the same as 'AND', it is a spatial comparison.
-Steve
On 3/7/2012 12:36 PM, Bob B
wagon that this is not so with POSTGIS. I don't have
a 21 million record dataset to test with however. :c)
bobb
>>> "Mr. Puneet Kishor" wrote:
On Mar 7, 2012, at 11:36 AM, Bob Basques wrote:
> if (x > minx && x < max && y > miny &
If the polygons are always going to be level (as indicated below) and
non-rotated, you might be better off just using a regular Tabular select (and
non-spatial geom) and use the minx,miny,max,may numbers directly.
if (x > minx && x < max && y > miny && y < maxy) then true. . . .
Maybe build
stalled by:
SELECT * FROM POSTGIS_FULL_VERSION();
If PROJ4 is installed, it should appear in that string.
George
On Tue, Mar 6, 2012 at 3:48 PM, Mike Toews wrote:
On 7 March 2012 06:10, Bob Basques wrote:
> ...
> ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric,
> part4:
split_part(cmd, ',', 4) as part4,
split_part(cmd, ',', 5) as part5,
split_part(cmd, ',', 6) as part6,
split_part(cmd, ',', 7) as part7
from
cmdstpinfo
se, right??). The result of the ST_SetSRID
seems to be the correct type of object to pass to ST_Transform based on what I
found in my searches. Maybe I'm not supposed to try the transform in this
manner.
bobb
>>> Mike Toews wrote:
On 7 March 2012 06:10, Bob B
Yeah, that was my latest fix, I don't have user rights (yet) to run against the
Spatial_ref_sys table, so waiting for someone else to run it.
bobb
>>> Mike Toews wrote:
On 7 March 2012 06:10, Bob Basques wrote:
> ...
>ST_AsText(ST_Transform(ST_SetSRI
Ok, it looks like I may not have PROJ support compiled in, but wouldn't the
existence of the SPATIAL_REF_SYS mean that PROJ is installed??
bobb
>>> "Bob Basques" wrote:
All,
made nice progress from Simon's suggestions, but . . .
Ok, I'm probably
All,
made nice progress from Simon's suggestions, but . . .
Ok, I'm probably trying to push this harder than I need to, but, I'm trying to
ST_Transform the data from 4326 to 200068 (Our private projection) in the
construction of the view, but I keep hitting permission errors.
NOTE: we us
That was the next question . . . . :c)
Out for the day, I'll be back at this tomorrow though . . .
Thanks for the help too.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/post
Ha, success!!!
Coll, Thanks Simon (A LOT !!)
select rxtime,
ltrim(split_part(part1, ':', 1), '>') as cmd_type,
split_part(part1, ':', 2) as esn,
part2 as time_idx,
part3 as lat,
part4 as lon,
ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeri
Hi, Simon,
Cool, almost there, I swear I tried something similar to that this afternoon .
. .
Ok, this is good, that got it further, now I need to change the data type, from
TEXT to NUMERIC, . . . .
ERROR: column "lon" does not exist
LINE 7:ST_SetSRID(ST_MakePoint(lon::numeric,
All,
First posting, been looking for a while now, maybe not possible, or I'm not
asking/searching with correct vocabulary.
I have a table with records like this that are fed from a Vendor source:
ID STAT RXTIME CMD
165 12012-03-05 08:14:09.095626 >Plot:11072940,201
23 matches
Mail list logo
