We require a web based custom mapping tool for two separate purposes but with common sql table based icon set which will be used to draw lines, polygons etc from the database as discussed in the current process below.
We have developed a dot net based application for Emergency Services Agencies, the back end is Microsoft SQL Server 2008, (drawing data in table in zip) we currently have developed our own integration with Google Maps to display location of resources, tasks etc on a map live from the database in different views depending upon the incident
A sample of the code for the above (resources and groups) mapping is in the attached zip as
[url removed, login to view]
The sample symbology required to be in the toolbox for drawing is in the attached zip as a SQL 2008 backup format [url removed, login to view] the table name (only one in db is tblSymbology) note that different themes are in the table and will be used by different users so a theme drop down is required.
[url removed, login to view] Symbology set based on user selected theme
2.a) select point graphics from the db table and place on map and
b) using data from table in db to draw lines, polygons, etc change shape of polygon and fill polygons with color , chnage line thickness , direction, label name etc
See example site of this at [url removed, login to view]
sample code is included on this site for you to use
[url removed, login to view] the drawing data on a map layer named by user (can be local file)
[url removed, login to view] to reload and modify above file at any time plus Save as capability