All,
This is probably a generic postgres question, but . .
I’m trying to generate a line segment data table from a (parcel) polygon
dataset. I need to bind the polygon (ParcelId) to each segment as well as
maintain the sequence of the line strings that make up the source polygon, so I
need to
a segment
id for each polygon.
(to adapt in case of multipg):
with tmp as (
select 1::int as id, 'POLYGON((0 0, 1 0, 1 1, 0 0))'::geometry(polygon) as
geom
), tmp1 as (
SELECT id, st_dumppoints(geom) as d
FROM tmp
), tmp2 as (
select t1.id<http://t1.id/>, (t1.d).path[2
All,
I tried DXF (although there were some settings I didn’t try) and that didn’t
seem to work, the arcs came in, but no attribute (extended) data applied to any
of the features. Even GeoJSON doesn’t seem to support circles/arcs (right)?
Am I going to need to write my own importer for CSV, or?
(assoc -1 (entget (entlast) (ade_odaddrecord newf "CSEGMENTS")
(ade_odsetfield newf "CSEGMENTS" "row_number" 0 1) (ade_odsetfield newf
"CSEGMENTS" "parcelid" 0 "C98") (ade_odsetfield newf "CSEGMENTS" "length" 0
173.14976794376) &q
I’m trying to remove all duplicated parcel edges from an exploded parcel
dataset. I have a set of 2 point line segments and I’ve been able to find the
geom duplicates ok witha window partition, but the number was really low. Upon
examining the data more closely, I figured out that the majoirty
e docs: "Returns true if the given geometries represent the same
geometry. Directionality is ignored."
Best,
Tom
On Fri, May 19, 2017 at 7:55 PM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
I’m trying to remove all duplicated parcel edges from an explod
JK,
I don’t know what you end goal is with this (completely) but I’ve been working
on something similar. And I founf that you needed to isolate the circular
strings into separate features, in other words, “explode” the parcel edges into
separate features, and work the process against both feat
Hi Regina,
Sorry about the all over the place character of my list, but we use PostGIS
quite a bit.
City of Saint Paul, Public Works:
* Local caching of offsite Geo-data from other gov gencies (About 60 layers
in all).
* Other Municipalities
* Counties
* States
*
Oops, some of my example links in the previous message got duplicated, sorry
about that, here it is again:
—
Hi Regina,
Sorry about the all over the place character of my list, but we use PostGIS
quite a bit.
City of Saint Paul, Public Works:
* Local caching of offsite Geo-data
All (trying PostGIS users first),
I have a need to call it by another name, but also to leave it named as is for
legacy stuff.
Anyone know of a way to do this?
Thanks
bobb
Those who believe in telekinetics, raise my hand.
—Kurt Vonnegut
___
pos
de 21/05/19, Basques, Bob (CI-StPaul) escreveu:
All (trying PostGIS users first),
I have a need to call it by another name, but also to leave it named as
is for legacy stuff.
Anyone know of a way to do this?
Thanks
bobb
Those who believe in telekinetics, raise my hand.
—Kurt Vo
worked quite well. It is stable.
Good luck,
Jorge
Às 16:00 de 22/05/19, Basques, Bob (CI-StPaul) escreveu:
Hi Jorge,
I found the info on the pg_service.conf file, and it works as described
for a local connection. I need to connect from a remote location. Also
looked at pgBouncer, but not su
All,
One biggie, is that the ESRI side does not like connecting to the “postgres”
named database, claiming it’s a System database (whatever that means). This is
not readily available as a limitation either when looking for reasons why it
won’t connect. We’ve been using the “postgres” database
, Shaozhong SHI
mailto:shishaozh...@gmail.com>> wrote:
Think Before You Click: This email originated outside our organization.
Why do you think loading is a heavy duty?
On Tuesday, 20 August 2019, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
All,
One biggie,
ooking forward to have more insight into this matter.
Regards,
Shao
On Tue, 20 Aug 2019 at 17:08, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
All,
One biggie, is that the ESRI side does not like connecting to the “postgres”
named database, claiming it’s a Sys
email originated outside our organization.
Hi, Bobb,
I am confused with this.
The idea is to use ArcGIS desktops to read data from PostGIS/PostgreSQL.
How best to configure and make them happy to talk to each other?
Regards,
Shao
On Wed, 21 Aug 2019 at 15:01, Basques, Bob (CI-StPaul)
mailto:bo
r Arc to use.
— Andy
On Aug 21, 2019, at 12:23 PM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
That’s what I’m talking about. when I first tried to connect to Posters (and
the “postgres” named database, I kept getting an error from ArcGIS saying the
the “po
, etc. Don’t touch. Set up another
database for Arc to use.
— Andy
On Aug 21, 2019, at 12:23 PM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
That’s what I’m talking about. when I first tried to connect to Posters (and
the “postgres” named database, I kept getting an err
a data structure. Many tables can be created by
using this data structure.
Am I right?
Regards,
Shao
On Thu, 22 Aug 2019 at 17:25, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Shao,
I’ve always thought of a schema as a sub-grouping inside of a database, as in a
creates a table, the table is defined. Namely, a schema is created and defined.
Am I right?
Can we define a schema so that all other applications including ArcGIS, MapInfo
and QGIS can read?
Regards,
Shao
On Fri, 23 Aug 2019 at 14:29, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stp
I know, bad to cross post on more than one list. . . .
But . . .
Anyone ever tried to load a (custom) projection into QGIS from a PostGIS query?
I’m not even sure what that might look like from the QGIS side. Just looking
for ideas to automate this.
We use Postgres/PostGIS quite a bit and c
Paul,
Not eactly what you were asking for, but this service will output a
standardized declination Arrow based on the location in LAT/LON and a DATE of
capture for magnetic north (It keeps moving) :
https://mdd.sharedgeo.org/mdd-gen?date=2016.5&lat=44.95&lon=-93.1&zone=15
It’s intended for aut
All,
I almost jumped over this thread from the beginning because I wasn’t
understanding the original question very well, mostly based on my own labels
for these types of services/datasets. I reference things like this as
“derived” data. The actual source data doesn’t exist (unless it gets cac
ry team, who are SQL specialists?
Ruven Brooks
On 9/25/2020 10:47 AM, Basques, Bob (CI-StPaul) wrote:
All,
I almost jumped over this thread from the beginning because I wasn’t
understanding the original question very well, mostly based on my own labels
for these types of services/datasets. I r
Brian,
Very interesting observations. I was actually wondering about this same type
of scenario recently, A lot of the limits applied on the ESRI side end up
being some sort of default setting that can be handled in some form, the
biggest piece is finding the setting(s), the next is having c
Brian,
Also, forgot this little tidbit that we (I?) discovered a while back, don’t
even know if it’s a limitation anymore, but ESRI won’t allow much of anything
edit-wise against the default database name (postgres) stating that it thinks
this is a System database. Have you tried using a diff
All,
Ok, this is sort of a weird one (to me).
I have a feature dataset of MutliLineStrings, all with no Z value, but with a
Elevation attribute on each end. I need to prorate the elevation for each
vertex along the line based on the distance for either/or each of the ends.
I was planning on
grab the interpolated elevations with something like this:
SELECT ST_Z(ST_PointN(geom, generate_series(1, ST_NPoints(geom) - 1))) AS
elevation
Simon
On Jan 5, 2022, at 9:03 AM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
All,
Ok, this is sort of a weird one (to m
I'm working on something similar, and wondering about what your current
performance values are? We (I) went with a more abstracted method of storing
the data and went with a point per record strategy.
We gain about 1 million records per month from a GPS fleet of 300 (or so)
assets and have yet
Mark,
I've have been at this problem for a number of years. Early on I was more
interested in making All AutoCAD versions work the same which was my primary
focus on things, but over time we made the data stores available to other
clients like the internet and ARC users.
The solution I went w
Subject says it all. Possible ?
Thanks
Bobb
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
gt;>
>> See also
>> http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Conn
>> ection_Pooling#Replication
>> for alternative, not builtin, replication.
>>
>> Andreas
>>
>> Am 09.01.2013 19:49, schrieb Basques, Bob (CI-StPaul):
>>
Frank,
You may need to convert the 3dfaces to triangles.each 3dface (in AutoCAD
anyway) is actually two triangle polygon definitions. These can be stored in a
POSTGIS database just fine.
Bobb
>> -Original Message-
>> From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-
>>
Steve,
Could this process of inherited tables be used to roll up GPS data by time
increments for example? Maybe roll up the data by day, week or month? I need
to figure out a way to handle queries potentially against millions of records
for reporting purposes.
Bobb
>> -Original Messa
our systems complement each other?
Bobb
From: pcr...@pcreso.com [mailto:pcr...@pcreso.com]
Sent: Friday, March 01, 2013 6:06 PM
To: PostGIS Users Discussion
Cc: Basques, Bob (CI-StPaul)
Subject: Re: [postgis-users] design problem
Hi Bob,
This may be of interest.
We do exactly this with
Hi all,
Juat watched Paul Ramseys video on point cloud storage and it made me think of
a few questions to ask.
Quesitions:
* Sort of a DB processing question, probably not thought about yet,
but can the pointcloud be colorized based on a raster/vector of view passed in?
As in aerial
All,
Anyone know if POSTGIS queries will work against SDE (ARCGIS10.1) data in
Postgres? For example, can I set up MapServer to query PostGIS for the data
entered into Postgres from SDE?
Thanks
Bobb
___
postgis-users mailing list
postgis-users@li
Sorry, I guess I should have looked just a little more before posting the
question . . . .
http://support.esri.com/en/knowledgebase/techarticles/detail/40553
bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Basques, Bob
(CI-StPaul
64 bit build available: it'll work
> fine.
>
> P.
>
>
>
>
>
> On Sat, Oct 26, 2013 at 6:18 PM, BladeOfLight16
> wrote:
> > On Fri, Oct 25, 2013 at 11:27 AM, Basques, Bob (CI-StPaul)
> > wrote:
> >>
> >>
Gerry,
Seems like the biggest hangup would be in adding the data to the DB fast
enough. How many points, per revolution, and what is the frequency of a
revolution (stationary Radar, correct, although as I think about it, it could
be mobile if needed, just need to add in the radar location to e
n the horizon is Phased Array Radar. When
that happens, more data, more resolution, and faster updates.
gerry
On Tue, Dec 10, 2013 at 11:05 AM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Gerry,
Seems like the biggest hangup would be in adding the data to t
ising.
Another application? Lidar. Pointed at the sky, not at the ground (we use 'em
to determine cloud layers [ceiling] and sky cover at airports for aviation
data...).
Thanks, all!
gerry
On Tue, Dec 10, 2013 at 1:49 PM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>>
data base !
We did the same but our solution is far from perfect.
Bob, is you rporject public/open source, have you any paper/doc about it ?
Cheers,
Rémi-C
2013/12/11 Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>>
Hmm,
I’m working with the Minneapolis International Airpor
sites' data. OR, if you were to place a grid of these things out on
a test site, to look at tomographs of the lower atmosphere ("Boundary Layer").
gerry
On Wed, Dec 11, 2013 at 8:49 AM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Hmm,
I'm wor
evel II data from the FAA's Terminal Doppler
Weather Radar. Test data, for sure, but it might help in getting them to free
up the TDWR Level II... Never know.
gerry
On Wed, Dec 11, 2013 at 11:26 AM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Gerry,
Any time
ormats and interfaces (CAD, X3D)?
Point clouds in PostGIS (also import of).
Is there a 3D PostGIS interest-group?
If not, should one established?
Frank
Am 11.12.2013 17:44, schrieb Basques, Bob (CI-StPaul):
All,
Nothing that far along. Did a couple of proofs of concept so far, I’ve
done a coup
here a 3D PostGIS interest-group?
If not, should one established?
Frank
Am 11.12.2013 17:44, schrieb Basques, Bob (CI-StPaul):
> All,
>
> Nothing that far along. Did a couple of proofs of concept so far,
> I've done a couple of presentations on the Visualizer approach. We
> t
Geoserver
I think Baalbek is too large (too many triangles) and therefore possibly leads
to crash. Palatin and W3DS should work.
The 3D window is a standard WebGL window based on X3DOM. So it should run right
stable.
Once again my question:
Is there an interest in a PostGIS 3D group?
Frank
Am
age 100's of billions of points
> and retrieve quickly those of interest.
>
> Now most of the usage requiere severe downsampling, which isn't a part
> of anything yet but may come (I'm working on adding this to pointcloud).
> .
>
> Cheers,
>
> Rémi-C
>
From: Basques, Bob (CI-StPaul)
Sent: Wednesday, December 18, 2013 11:04 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Old question resurfacing
Rémi,
I’ve already played around with Cloud Compare, found it a few weeks ago during
another research cycle.
I think the
Nothing particularly Spatial about this one, but I think it's worth mentioning
(and I like it) . . .
http://xkcd.com/1205/
bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Gerry Creager -
NOAA Affiliate
Sent: Thursday, February 27,
On Behalf Of Josh Jordan
Sent: Thursday, February 27, 2014 11:49 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] xkcd
This looks like it could be a page out of a project management textbook. I'm
missing the joke!
On Thu, Feb 27, 2014 at 12:29 PM, Basques, Bob (CI-StPaul)
it could be a page out of a project management textbook. I'm
missing the joke!
On Thu, Feb 27, 2014 at 12:29 PM, Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Nothing particularly Spatial about this one, but I think it's worth mentioning
(and I like
select
*
from
tab1, tab2
Where
tab1.hk_id = tab2.hk_id -- Assuming you have a ID column in
both tables . . .
AND
tab2.y_max < tab1.h_max
AND
tab2.y_max > tab1.h_min
order by
tab2.height
Bobb
From: p
A hint to get you started . .
INSERT INTOVALUES (SELECT FROM . . . . )
Bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Daniel GIL
Sent: Thursday, April 02, 2015 9:53 AM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users]
All,
Oh, geez, I just realized I wrote my answer using syntax from two different
functions.
It should have been more like what Dylan responded with . . . sorry to
introduce confusion . . .
Bobb
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Be
Can you use ST_Buffer??
bobb
> On Jun 9, 2015, at 4:34 PM, Andy Colson wrote:
>
> Hi all.
>
> I have buffer selection problem. My site can drop a point, then find all the
> parcels within 100 feet of that point. No problem.
>
> One client however would like to select a parcel (maybe its
I’ve done this with a SQL statement in the past. (it’s been a few years now.)
It was dependent on the lines actually intersecting each other (diagrammatic
lifework) vs physical representations. We had to manually end the line work at
the intersections, and in some instances divide lines that n
Hi Steve,
I think you almost need to check every point from at least one linestring
against the other linestring.
You could check just one end, but they could still be the same but the other
end different. Also you could have line strings with the same end points, but
different intermediate p
59 matches
Mail list logo