superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 398 and YR_EST = 1975
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9880 | 9880 | 9879 | {"type": "MultiPolygon", "coordinates": [[[[-122.39528, 37.59394], [-122.3894, 37.59734], [-122.38915, 37.59707], [-122.39089, 37.59607], [-122.3911, 37.59626], [-122.39164, 37.59597], [-122.39165, 37.59595], [-122.39145, 37.59575], [-122.39305, 37.59482], [-122.39471, 37.59366], [-122.39481, 37.59358], [-122.39494, 37.59351], [-122.39528, 37.59394]]], [[[-122.40184, 37.59691], [-122.40145, 37.59714], [-122.40141, 37.59713], [-122.40108, 37.59693], [-122.40089, 37.59671], [-122.40092, 37.59664], [-122.40068, 37.59652], [-122.40054, 37.59642], [-122.4005, 37.59644], [-122.40022, 37.5962], [-122.39966, 37.59584], [-122.39922, 37.59541], [-122.39908, 37.59509], [-122.39951, 37.59487], [-122.40018, 37.59558], [-122.40069, 37.59603], [-122.40076, 37.59601], [-122.40079, 37.59603], [-122.40093, 37.59596], [-122.40184, 37.59691]]], [[[-122.40762, 37.59812], [-122.40671, 37.59864], [-122.40508, 37.59828], [-122.40481, 37.59844], [-122.40388, 37.59818], [-122.4032, 37.59794], [-122.4025, 37.59763], [-122.40167, 37.59719], [-122.40196, 37.59703], [-122.40249, 37.59715], [-122.40298, 37.59737], [-122.40346, 37.59757], [-122.40377, 37.59739], [-122.4038, 37.59741], [-122.40347, 37.5976], [-122.40347, 37.59762], [-122.40434, 37.59789], [-122.40487, 37.59743], [-122.40752, 37.598], [-122.40762, 37.59812]]]]} | Open Access 1 | Spur Trail Park | 25755 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 18.139 | Spur Trail Park | 1975 |
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]);