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 shapefile in order to get the data. I have
SHAPEPATH "../data" defined in my .map file.
But I am not sure command I should write for generating shapefile 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!