units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and ACRES = "2.007"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11038 | 11038 | 11037 | {"type": "Polygon", "coordinates": [[[-121.41952, 38.50592], [-121.41951, 38.5072], [-121.41886, 38.5072], [-121.41886, 38.50592], [-121.41952, 38.50592]]]} | Open Access 1 | 21214 | Camellia Park | 16757 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.007 | Camellia Park | 0 | Local Park 2 | 4 | |
13246 | 13246 | 13245 | {"type": "Polygon", "coordinates": [[[-119.17722, 34.26059], [-119.17718, 34.26059], [-119.1769, 34.26038], [-119.17675, 34.26011], [-119.17642, 34.26014], [-119.17633, 34.26019], [-119.17607, 34.26025], [-119.17606, 34.26031], [-119.17581, 34.26047], [-119.17576, 34.26057], [-119.17563, 34.26054], [-119.17562, 34.26057], [-119.17457, 34.26054], [-119.17433, 34.26059], [-119.17373, 34.26086], [-119.17364, 34.26092], [-119.17348, 34.26107], [-119.1734, 34.26125], [-119.17333, 34.26123], [-119.1731, 34.26128], [-119.17327, 34.26119], [-119.17314, 34.26103], [-119.1732, 34.26095], [-119.17334, 34.26091], [-119.17346, 34.26078], [-119.17379, 34.26074], [-119.17388, 34.26062], [-119.17398, 34.26054], [-119.17407, 34.26054], [-119.17415, 34.26045], [-119.17425, 34.26039], [-119.17435, 34.26037], [-119.17453, 34.26046], [-119.17481, 34.26044], [-119.17483, 34.26029], [-119.17491, 34.26023], [-119.17511, 34.26028], [-119.17528, 34.26021], [-119.17545, 34.26027], [-119.17545, 34.26046], [-119.17563, 34.26049], [-119.17587, 34.26021], [-119.17616, 34.26002], [-119.17644, 34.25999], [-119.17658, 34.26003], [-119.17678, 34.25991], [-119.17703, 34.26039], [-119.1772, 34.26049], [-119.17722, 34.26059]]]} | Open Access 1 | 35291 | Ventura holding 95 | 26979 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.007 | Ventura holding 95 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);