5

I've been developing some web maps in ESRI's JSAPI. Currently I'm storing the following layers in SQL Server:

1,000,000 points

30,000 polygons

1,000 polyons

These need to be displayed on top of one another. I also need to be able to do somewhat advanced querying, and identifying of features.

I've built some tools so far, but I'm curious if there are better options. I've looked at CartoDB, but currently it doesn't support multiple layers. It seems you can use CartoDB and the Google Maps API, but I feel like that's adding extra complexity. I've read some about leaflet, mapbox, opengeo, and others.

So what it boils down to is what is a decent alternative to SQL Server/ArcGIS Server/ESRI JSAPI?

Thanks, Evan

Community
  • 1
  • 1
mapexpert
  • 69
  • 1
  • 2
  • It would be good if you specified what exactly you mean by _"better options"_. Faster? Cheaper? Easier to setup? -- (Btw. you might also want to visit [gis.stackexchange.com](http://gis.stackexchange.com/).) – stakx - no longer contributing Oct 19 '12 at 20:01
  • Btw., add [MapServer](http://mapserver.org/) to your list of possible alternatives. – stakx - no longer contributing Oct 19 '12 at 20:03
  • 1
    can't you just use SQL Server natively without all the extra ArcGIS stuff? – Aaron Kempf Oct 19 '12 at 20:04
  • I know this question is closed, but you might consider [bluespatial](http://www.bluespatial.com). It supports all the advanced querying capability over REST for vector data that Esri does and it's compatible with the Esri JS API. – madannes Aug 22 '17 at 23:54

2 Answers2

6

An equivalent open source stack would be PostGIS/PostgreSQL + GeoServer + OpenLayers. Store your data in the database, render via GeoServer, interface with OpenLayers. If you're building a more complicated built-to-purpose app, build interface with GeoExt/ExtJS.

As a commenter notes, you might be able to serve a lot of your queries directly out of the spatial database, by building simple spatial SQL queries and passing them to the backend. For rendering 1M points you'll probably end up needing the rendering engine though. Look at the GeoServer SQL layers as a potential route for dynamic rendering of complex query layers.

The components I mention are downloadable separately (postgis.org, geoserver.org, openlayers.org) or as an integrated chunk via the OpenGeo Suite (opengeo.org).

Paul Ramsey
  • 839
  • 6
  • 8
1

You might want to take a look at MapDotNet, especially if you intend to keep your data in SQL Server. I don't have any direct experience with them but from what I have read and heard it sounds like a good product. They have an HTML5/JS API/solution called touchgeo as well.

And as @stakx noted above, you might want to check out MapServer.

Dave Marley
  • 705
  • 6
  • 10