On Wed, May 08, 2024 at 05:53:48PM -0400, Regina Obe wrote:
> On Wed, May 08, 2024 at 03:01:47PM -0500, Daryl Herzmann wrote:
> >
> > I stumbled into this issue today. The lack of 9311 in spatial_ref_sys. Is
> > a fix
> > for this coming or is the spatial_ref_sys just known to be stale and not
"Regina Obe" writes:
> Paul and Sandro,
>
> Any thoughts on this. I know we went back and forth with "Why don't
> we just populate spatial_ref_sys using postgis_srs_all or some other
> such thing or why don't we just change spatial_ref_sys to a view that
> relegates to reading these from
> "Regina Obe" writes:
>
> > Paul and Sandro,
> >
> > Any thoughts on this. I know we went back and forth with "Why don't
> > we just populate spatial_ref_sys using postgis_srs_all or some other
> > such thing or why don't we just change spatial_ref_sys to a view that
> > relegates to reading
> > Which I can't find in our spatial_ref_sys table (guess our table needs
> > an update), but you can add with the below as long as you are using
> > PostGIS 2.5 or higher and PROJ 7 or higher, it's going to relegate all the
> details to PROJ anyway So the other columns will not be needed except
On Thu, Mar 28, 2024 at 9:05 AM Regina Obe wrote:
>
> > Depends where you got the data, but generally if they give you longitude
> > latitude Columns, then 4326 is a safe assumption and looks like you created
> > the geometry right too.
> >
> > To Gary's point, 4326 is degree based, so no wonder
On Thu, 28 Mar 2024, Regina Obe wrote:
Depends where you got the data, but generally if they give you longitude
latitude Columns, then 4326 is a safe assumption and looks like you created
the geometry right too.
To Gary's point, 4326 is degree based, so no wonder you aren't getting any
> Depends where you got the data, but generally if they give you longitude
> latitude Columns, then 4326 is a safe assumption and looks like you created
> the geometry right too.
>
> To Gary's point, 4326 is degree based, so no wonder you aren't getting any
> meaningful answers since 1000 would
> On Thu, 28 Mar 2024, Gary Turner wrote:
>
> >
> > On 28/03/2024 12:32 pm, Max Pyziur wrote:
> >> On Wed, 27 Mar 2024, Regina Obe wrote:
> >>
> >>> That's the function I would have suggested.
> >>>
> >>> What query are you trying to run and what is the spatial reference
> >>> system id for your
Gary Turner writes:
>> I then issue these two commands:
>> ALTER TABLE shapefiles.atp_filling_stations ADD COLUMN geom
>> geometry(Point, 4326);
>>
>> UPDATE shapefiles.atp_filling_stations SET geom =
>> ST_SetSRID(ST_MakePoint(longitude, latitude), 4326);
>>
>> So the SRS is 4326, right?
>
>
offers something that seems useful.
Thank you,
Max
-Original Message-
From: Max Pyziur
Sent: Wednesday, March 27, 2024 5:33 PM
To: postgis-users@lists.osgeo.org
Subject: Running clustering queries
Greetings,
I have a dataset of filling stations with point geometries (about
80k U.S
: Wednesday, March 27, 2024 5:33 PM
To: postgis-users@lists.osgeo.org
Subject: Running clustering queries
Greetings,
I have a dataset of filling stations with point geometries (about 80k
U.S.
filling
stations)
I'm trying to find/make clusters of this data (with a criteria like say
minimum
' know if there are any foot
based spatial reference systems.
Neither offers something that seems useful.
Thank you,
Max
-Original Message-
From: Max Pyziur
Sent: Wednesday, March 27, 2024 5:33 PM
To: postgis-users@lists.osgeo.org
Subject: Running clustering queries
Greetings,
I
clustering queries
Greetings,
I have a dataset of filling stations with point geometries (about 80k U.S.
filling
stations)
I'm trying to find/make clusters of this data (with a criteria like say
minimum
of 3 stations w/in 500 feet of each other.
I've found these webpages; but as yet I can't
.
> -Original Message-
> From: Max Pyziur
> Sent: Wednesday, March 27, 2024 5:33 PM
> To: postgis-users@lists.osgeo.org
> Subject: Running clustering queries
>
>
> Greetings,
>
> I have a dataset of filling stations with point geometries (about 80k U.S.
filling
>
Greetings,
I have a dataset of filling stations with point geometries (about 80k
U.S. filling stations)
I'm trying to find/make clusters of this data (with a criteria like say
minimum of 3 stations w/in 500 feet of each other.
I've found these webpages; but as yet I can't produce any
15 matches
Mail list logo