For my school assignment, I must compose an SQL statement which retrieves data from a database in .mdb format. I have no problem developing the SQL statement. It is a requirement that we have an actual .sql file included in the submission of the assignment. The thing that I am unsure about is how to go from this SQL file to a point shapefile.
I'll give a little bit of context that may help answering this question. The point of the assignment is creating a web map in the end. Because the performance of web mapping increases when there is less data, certain data (the data to be displayed online) must be extracted from the database. So I get the whole web mapping concept, where before I can start, I need an actual map (.mxd) document. In order to complete the map document, I need this point shapefile, which must be derived from an SQL statement. Going from SQL file to point shapefile is where I'm lost.
أكثر...
I'll give a little bit of context that may help answering this question. The point of the assignment is creating a web map in the end. Because the performance of web mapping increases when there is less data, certain data (the data to be displayed online) must be extracted from the database. So I get the whole web mapping concept, where before I can start, I need an actual map (.mxd) document. In order to complete the map document, I need this point shapefile, which must be derived from an SQL statement. Going from SQL file to point shapefile is where I'm lost.
أكثر...