every once in a while I get asked for topics such as
- how to calculate a meaningful (convex?) polygon that contains a set of coordinates (e.g. my customers)?
- how to determine the post code area that contains a given point?
- how to determine whether two areas intersect
Depending on the runtime you use (Java, .NET, JavaScript, ... ) you can use third party / open source libraries that offer geometry functions such as
- POLYGON intersection (POLYGON, POLYGON)
- BOOLEAN point in polygon(POLYGON, POINT)
- POLYGON convexhull(POINTS[])
- BOOLEAN intersects(POLYGON,POLYGON)
- Java : Java Topology Suite : https://github.com/locationtech/jts
- .NET : Net Topology Suite : https://github.com/nettopologysuite/nettopologysuite
- JavaScript : http://geoscript.org/js/api/geom/geometry.html
https://docs.microsoft.com/en-us/sql/re ... sql-server
Of course sometimes you also need geometry data such as ZIPCODE areas or COUNTRY borders but that is a question of data broking which can be provided by PTV's Digital Data Services (http://www.ddsgeo.de/)
Best regards,
Bernd