I am trying to map data by querying a table called xyz. I need to show the the_geom data on the map.
I have below query in my mapserver .map file:
DATA "the_geom from xyz using unique id using SRID=xxxx"I need to generate a shape file in order to get the data. I have
SHAREPATH "../data" defined in my .map file.
But I am not sure command I should write for generating shape file for above query, I tried doing
/usr/local/pgsql/bin/pgsql2shp -f /home/name/public_html/proj/data/xyz -h xxx.xxx.xx.xx -u username -P passwrd dbname "select the_geom from xyz"This generated some files which I have it in by data folder. But I see blank page on my webpage.
Please correct me!
أكثر...
I have below query in my mapserver .map file:
DATA "the_geom from xyz using unique id using SRID=xxxx"I need to generate a shape file in order to get the data. I have
SHAREPATH "../data" defined in my .map file.
But I am not sure command I should write for generating shape file for above query, I tried doing
/usr/local/pgsql/bin/pgsql2shp -f /home/name/public_html/proj/data/xyz -h xxx.xxx.xx.xx -u username -P passwrd dbname "select the_geom from xyz"This generated some files which I have it in by data folder. But I see blank page on my webpage.
Please correct me!
أكثر...