Re^2: DBI placeholders for spatial data


Pathologically Eclectic Rubbish Lister
	PerlMonks

Re^2: DBI placeholders for spatial data

by Bod (Parson)

on Jun 26, 2021 at 10:37 UTC ( [id://11134323]=note: print w/replies, xml )

Need Help??

in reply to Re: DBI placeholders for spatial data
in thread DBI placeholders for spatial data

Is there another constructor for your POINT objects that accepts coordinates separately?

There is ST_PointFromText but it looks like it is just a synonym for ST_GeomFromText.

Comment on Re^2: DBI placeholders for spatial data Download Code

Replies are listed 'Best First'.
Re^3: DBI placeholders for spatial data by Anonymous Monk on Jun 26, 2021 at 10:45 UTC
I think that the `Site::Point` class will benefit from an `as_wkt` method (or similar) returning strings that you could feed to `ST_GeomFromText` via placeholders like `select ST_GeomFromText(?, ?)`.	[reply] [d/l] [select]
Re^4: DBI placeholders for spatial data by Bod (Parson) on Jun 30, 2021 at 20:35 UTC
I think that the `Site::Point` class will benefit from... Agreed. The `sql` method now returns just the `POINT` code instead of the complete `ST_GeomFromText` string. This allows me to do something like this: `my $point = Site::Point->new('SO 1230 4560'); $dbh->do("INSERT INTO Test SET start = ST_GeomFromText( ? , 4326)", un +def, $point->sql);` [download] As 4326 is a constant (as long as I am only dealing with this planet!) it doesn't need a placeholder.	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom

Log In^?

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://11134323]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others musing on the Monastery: (3)

As of 2024-04-20 01:37 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found