superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 23, MNG_AG_TYP = 3 and PARK_NAME = "Garland Ranch Regional Park"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15080 | 15080 | 15079 | {"type": "MultiPolygon", "coordinates": [[[[-121.72109, 36.49067], [-121.72044, 36.49119], [-121.72042, 36.49117], [-121.72107, 36.49065], [-121.72109, 36.49067]]], [[[-121.72883, 36.47453], [-121.72871, 36.47454], [-121.72855, 36.47436], [-121.72855, 36.47425], [-121.72883, 36.47453]]], [[[-121.73601, 36.4765], [-121.73588, 36.47648], [-121.73573, 36.47649], [-121.73524, 36.47665], [-121.73509, 36.47668], [-121.73497, 36.47668], [-121.73488, 36.47667], [-121.73493, 36.47654], [-121.73492, 36.47653], [-121.73462, 36.47648], [-121.7341, 36.47648], [-121.73393, 36.47633], [-121.73366, 36.476], [-121.73328, 36.47561], [-121.73308, 36.47549], [-121.73283, 36.4754], [-121.73253, 36.47547], [-121.73226, 36.47545], [-121.73306, 36.47396], [-121.73378, 36.47533], [-121.73601, 36.4765]]], [[[-121.76813, 36.50991], [-121.76779, 36.51032], [-121.7668, 36.51017], [-121.76648, 36.51027], [-121.76642, 36.51027], [-121.7662, 36.51023], [-121.76592, 36.51013], [-121.76578, 36.51003], [-121.76561, 36.50977], [-121.7651, 36.50951], [-121.76474, 36.50961], [-121.76444, 36.50934], [-121.76414, 36.50899], [-121.76416, 36.50882], [-121.76393, 36.50863], [-121.76369, 36.508], [-121.76361, 36.50791], [-121.7635, 36.50763], [-121.76345, 36.50736], [-121.7633, 36.50706], [-121.76313, 36.50656], [-121.76286, 36.50603], [-121.76273, 36.50588], [-121.76248, 36.50537], [-121.76294, 36.5059], [-121.76314, 36.50586], [-121.76317, 36.50601], [-121.76334, 36.506], [-121.7634, 36.50639], [-121.76352, 36.50685], [-121.76366, 36.50723], [-121.76385, 36.5076], [-121.76412, 36.50802], [-121.76439, 36.50835], [-121.76469, 36.50866], [-121.76503, 36.50894], [-121.76532, 36.50916], [-121.76566, 36.50937], [-121.76813, 36.50991]]]]} | Open Access 1 | Garland Ranch Regional Park | 19222 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 15.288 | Garland Ranch RP |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);