If I have a table that has some spatial fields in it (i.e. a list of points geometries), is there anyway using ISQL to do something like SELECT * from address_table ; OUTPUT TO c:\testit\address_table.sh FORMAT SHAPEFILE ; I know it's real easy to LOAD in spatial data but what are the options for creating a shapefile in the way out? Is this something better done with ESRI API tools etc? Thanks! |
Do you need the output to be a shapefile, or would other spatial data file formats do, as well? ESRI shapefiles seem to be the only data format not supported to export to.