units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1 and ACRES = "1.212"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, DES_TP
MNG_AGENCY 5
MNG_AG_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3428 | 3428 | 3427 | {"type": "Polygon", "coordinates": [[[-120.92638, 38.66545], [-120.92512, 38.66575], [-120.92479, 38.66594], [-120.92458, 38.66569], [-120.92491, 38.6655], [-120.92627, 38.66518], [-120.92638, 38.66545]]]} | Open Access 1 | 25182 | Bradford Park | 16323 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.212 | Bradford Park | 0 | Local Park 2 | 4 | |
5133 | 5133 | 5132 | {"type": "Polygon", "coordinates": [[[-121.45225, 38.61393], [-121.45152, 38.61433], [-121.45093, 38.61471], [-121.45092, 38.61393], [-121.45225, 38.61393]]]} | Open Access 1 | 21098 | Triangle Park | 26532 | 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 | 1.212 | Triangle Park | 0 | Local Park 2 | 4 | |
10840 | 10840 | 10839 | {"type": "Polygon", "coordinates": [[[-118.14282, 33.92088], [-118.1425, 33.92129], [-118.1422, 33.92159], [-118.14159, 33.92126], [-118.14183, 33.92094], [-118.14219, 33.92113], [-118.14251, 33.92071], [-118.14282, 33.92088]]]} | Open Access 1 | 20616 | Brookshire Childrens Park | 16430 | 1088 | Downey, City of 82 | City 2 | City Agency 2 | http://www.downeyca.org/services/cs/default.asp | City 2 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 1.212 | Brookshire Childrens Park | 0 | Local Park 2 | 4 | |
12549 | 12549 | 12548 | {"type": "Polygon", "coordinates": [[[-117.27771, 33.05534], [-117.27694, 33.05549], [-117.27667, 33.05524], [-117.27649, 33.05488], [-117.27664, 33.05484], [-117.27689, 33.05484], [-117.27712, 33.0549], [-117.27729, 33.05498], [-117.27753, 33.05517], [-117.27771, 33.05526], [-117.27771, 33.05534]]]} | Open Access 1 | 36585 | Las Verdes Park | 28588 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.212 | Las Verdes Park | 0 | Local Park 2 | 4 |
12552 | 12552 | 12551 | {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} | Open Access 1 | 29055 | Fales Park | 18830 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.212 | Fales Park | 0 | Local Park 2 | 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]);