Add capabilities for retrieving GPS coordinates from the leaflet map in the interest point uploader view. As it stands, the database can only manage a latitude and longitude, and cannot manage the list of coordinates that result from a polygon or polyline. This issue deserves some thought. A couple possible implementations:
GPS coordinates are stored in different columns depending on the feature type. A new 'feature_type' column should be added to the interest_points table. To create a GeoJSON feature collection from the features, the script will determine the feature type of an interest point and query the db for the corresponding coordinates column.
GPS coordinate column holds a list containing an arbitrary number of coordinates. A new 'feature_type' column should be added to the interest_points table. To create a GeoJSON feature collection from the features, the script will determine the feature type of an interest point and process the coordinates accordingly.
Add capabilities for retrieving GPS coordinates from the leaflet map in the interest point uploader view. As it stands, the database can only manage a latitude and longitude, and cannot manage the list of coordinates that result from a polygon or polyline. This issue deserves some thought. A couple possible implementations: