I've been working around one minor issue and it occurred to me that
someone here might be able to explain the rationale for its design.
I start with a shapefile of US states, which to me appears to be a set
of multipolygons, one for each state. So, for example, Hawaii is a
single multipolyg
hi all!
How should i use AsKML() function to create KML files (w try show
postgis data in google maps nad google earth)
It is posible?
--
regards,
Maciej Skórczewski
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://post
Hi,
On 9/14/07, Maciej Skorczewski <[EMAIL PROTECTED]> wrote:
> How should i use AsKML() function to create KML files (w try show
> postgis data in google maps nad google earth)
The AsKML() function gives you the geometry in XML format (reprojected
to WGS84, if that's needed). You need to add the
Hi Jose !
how sql should looks like?
I use PHP. so i want to use it whit PostgreSql...
is there any doc. about this function?
Question about Python class...i am not python programer can you
describe my how i can use it?
thx :)
Hi,
On 9/14/07, Maciej Skorczewski <[EMAIL PROTECTED]> wrot
Hi Maciej,
I sent you an e-mail, but your spam protection system wouldn't allow
the message to go through. If you have another address, I'll resend
it to you :)
On 9/14/07, Maciej Skorczewski <[EMAIL PROTECTED]> wrote:
> how sql should looks like?
Simply (and this is already quite advanced: you
as_kml()?! there's another askml() in line with asgml(). why this
alias/name change/confusion?
anyway how does it really work? getting a "Must contain
'geometry_column from table_name' or 'geom from (subselect) as foo'
(couldnt find ' from ')". what do i do after passing bbox=... and
type=kml to e
On Friday 14 September 2007, John Smith wrote:
> as_kml()?! there's another askml() in line with asgml(). why this
> alias/name change/confusion?
>
> anyway how does it really work? getting a "Must contain
> 'geometry_column from table_name' or 'geom from (subselect) as foo'
> (couldnt find ' from
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet
I use ogr2ogr for doing that.. however sometimes its best to write the KML
using your own structure, descriptions, and element names.
http://www.gdal.org/ogr/drv_kml.html will describe the options that let you
name the KML
Absolutely.
See attached, a simple plpgsql function that adds header info around the
current askml function.
I do this in psql:
-- Set output to unaligned
\a
-- Show only tuples
\t
-- Dump query to a file
\o my_kml_file.kml
-- Run your query
SELECT askml('my_line', 'description', 'SRID=3005
Thats so cool it hurts.. I love offloading processing to the big bad server
while the little wimpy sql clients request the data. Good find!
On 9/14/07, Kevin Neufeld <[EMAIL PROTECTED]> wrote:
>
> Absolutely.
>
> See attached, a simple plpgsql function that adds header info around the
> current a
Hold it, stop, take a look at this first!
This post was sent on the mapserver list last friday, please check if
this will your demands!
http://www.itopen.it/soluzioni/kml-map-server/
Dylan Beaudette schreef:
On Friday 14 September 2007, John Smith wrote:
as_kml()?! there's another ask
thx Kevin for replay!
great help.
:)
maciek
Kevin Neufeld pisze:
Absolutely.
See attached, a simple plpgsql function that adds header info around the
current askml function.
I do this in psql:
-- Set output to unaligned
\a
-- Show only tuples
\t
-- Dump query to a file
\o my_kml_file.
12 matches
Mail list logo
