Ac Geospatial Data

Storing and querying data that lives on a map: coordinate reference systems and the disaster of mixing them, spatial indexes from R-tree to geohash and what each is for, nearest-neighbour and radius queries, bounding boxes as the cheap filter and where they mislead, distance computation over a sphere, polygons and containment, and the written geospatial record. It explains how spatial storage and queries behave; it never recommends a spatial database and never promises a query time. Use when asking "spatial index", "geohash", "R-tree", "nearest neighbour query", "radius search", "bounding box", "coordinate system", "WGS 84", "latitude longitude storage", "point in polygon", "haversine", "postgis", "why is my distance query slow", "GeoJSON". Not for general database indexing and partitioning (ac-query-and-index-design, ac-database-engine-internals), not for general analytical data modelling and dimensions (ac-analytical-data-modeling), not for map rendering and visual design (ac-dataviz).

jiayaoqijia Updated 81 repo stars

File contents

jiayaoqijia/cryptoskill commit 4ea928e459

Frequently asked questions

npx get-skill add jiayaoqijia/ac-geospatial-data