I'm looking for software recommendations for custom mapping for a nonprofit organization that works with many other loosely affiliated organizations to register and display info for ecology-related points-of-interest.
The way it works very roughly is that a city that wants to be involved will apply and submit their info along with points-of-interest. Then when approved, the main organization will add a web page for this city on their website and will add their points to their big dataset. Their points will now appear on the big map with all points from all cities. This Google Map takes 20+ seconds to load for me whether it shows the wide map of the country or whether it starts out zoomed to just one city's area.
Points can be added, and new cities added. But this is not a daily occurrence and it would be manageable for one volunteer to update things on a daily basis.
Google My Maps Limitations
Google My Maps has the following limitations:
- max of 10 datasets in one map
- max of 2,000 rows in each dataset
I don't know how many points there are currently, but I would say it's not impossible for it to grow past 20,000 someday.
Additional Functionality I'm Looking For
Google Maps has good embedding functionality, and I'd like to retain that ability so there is flexibility for the different organizations to display their own individual maps.
But I'm hoping to find something that also allows for:
- separate datasets for each city (lots more than 10)
- mapping of all points in one map
- mapping of only one dataset's points
- adding a new point in only one place will effectively update both that city's map and the big map of all cities (periodic manual map updating is fine as long as it's easy and the same process each time)
There might be different ways to maintain the datasets. It could be based on one Excel spreadsheet for each dataset, and all are added for the big map. It could be a single table in a database that has one column denoting which city the point belongs to, and it would allow SELECTing only points from one city (for a map), or points from all.
But this will be done by someone who may be tech-savvy but is not a programmer or database admin. And we'd like to keep this person's workload minimized.
- It would be interesting if work to add/update points for a particular city's database could be done by a delegated responsible party from that city so that those updates would appear in that city's map, and would also either immediately be reflected in the big map or would be reflected after a manual update to pull in current points over all datasets.
- It would be great if a tiny bit of text info could be displayed about each point of interest, and perhaps a photo, like Google My Maps allows.
I've done some searching around but haven't found much yet. And I'm not sure what I'm looking for because it's not straightforward to search for these features. I figured asking the question here may be more productive.
Regarding costs... I am sure some costs would be accepted for much improved functionality and to meet the needs. However Google My Maps is free, and all this is done by nonprofits and volunteers. Any budget comes from donors or public sources. So cost is definitely a huge point.
I appreciate any input! And hey it's great to see there is a StackExchange site that actually accepts questions about software recommendations as that seems to be shut down everywhere else.