superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 432, MNG_AG_TYP = 2 and YR_EST = 1969
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-122.28216, 37.48306], [-122.28213, 37.48341], [-122.28125, 37.48399], [-122.28098, 37.48407], [-122.28012, 37.48408], [-122.27956, 37.48417], [-122.27897, 37.48435], [-122.27847, 37.48457], [-122.27684, 37.48566], [-122.27673, 37.48548], [-122.27626, 37.48571], [-122.27552, 37.48575], [-122.27487, 37.48656], [-122.27458, 37.4865], [-122.2745, 37.48663], [-122.27439, 37.48677], [-122.27428, 37.48687], [-122.27401, 37.48704], [-122.27265, 37.4858], [-122.27186, 37.48639], [-122.27102, 37.48642], [-122.27109, 37.48583], [-122.27075, 37.48584], [-122.27014, 37.48553], [-122.26998, 37.48542], [-122.26985, 37.48526], [-122.26982, 37.48512], [-122.26986, 37.48499], [-122.26994, 37.4849], [-122.26999, 37.48503], [-122.27023, 37.48497], [-122.27018, 37.48461], [-122.27027, 37.48455], [-122.2703, 37.4845], [-122.2703, 37.48445], [-122.27027, 37.4844], [-122.27022, 37.48435], [-122.27009, 37.48433], [-122.26975, 37.48379], [-122.26969, 37.48369], [-122.26984, 37.48362], [-122.26984, 37.48351], [-122.26959, 37.48313], [-122.26957, 37.48306], [-122.26952, 37.48301], [-122.26946, 37.48298], [-122.26937, 37.48297], [-122.2693, 37.48298], [-122.26907, 37.48253], [-122.2691, 37.48232], [-122.27137, 37.48247], [-122.27265, 37.48204], [-122.27293, 37.48224], [-122.27387, 37.48258], [-122.27414, 37.48276], [-122.27434, 37.48286], [-122.27428, 37.48296], [-122.27457, 37.4833], [-122.27501, 37.48346], [-122.27515, 37.48338], [-122.27538, 37.48358], [-122.27536, 37.48394], [-122.27546, 37.48419], [-122.2757, 37.48438], [-122.27653, 37.4849], [-122.27736, 37.48388], [-122.27793, 37.48391], [-122.27875, 37.48321], [-122.27959, 37.48341], [-122.28, 37.48339], [-122.28018, 37.48301], [-122.28045, 37.483], [-122.2806, 37.48301], [-122.28093, 37.4831], [-122.28086, 37.48332], [-122.28119, 37.48355], [-122.28182, 37.48346], [-122.28207, 37.48326], [-122.28209, 37.48307], [-122.28216, 37.48306]]]} | Open Access 1 | Eaton Park | 18411 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 65.363 | Eaton Park | 1969 |
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]);