units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1 and ACRES = "0.23"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
DES_TP 5
MNG_AG_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
505 | 505 | 504 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 2045 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.23 | 30th Street MP | 0 | Local Park 2 | 4 | |
3976 | 3976 | 3975 | {"type": "Polygon", "coordinates": [[[-116.94659, 33.76477], [-116.94658, 33.76514], [-116.94648, 33.76514], [-116.94647, 33.76484], [-116.94577, 33.76473], [-116.9458, 33.76466], [-116.94623, 33.76474], [-116.94659, 33.76477]]]} | Open Access 1 | 48843 | Rsi Park | 33563 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | https://www.sanjacintoca.gov/community/parks_facilities/parks/r_s_i_park | Riverside 10 | 0.23 | Rsi Park | 0 | Local Park 2 | 4 |
4022 | 4022 | 4021 | {"type": "Polygon", "coordinates": [[[-118.29141, 33.96539], [-118.29091, 33.96539], [-118.29091, 33.96521], [-118.29141, 33.96521], [-118.29141, 33.96539]]]} | Open Access 1 | 46884 | Vermont Miracle Park | 32598 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 0.23 | Vermont Miracle Park | 0 | Private Recreation or Education 65 | 4 | |
4639 | 4639 | 4638 | {"type": "Polygon", "coordinates": [[[-122.59352, 38.58594], [-122.59328, 38.58619], [-122.59306, 38.58597], [-122.59325, 38.58577], [-122.59352, 38.58594]]]} | Open Access 1 | 36378 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 0.23 | 0 | Local Other or Unknown 14 | 4 | ||
6936 | 6936 | 6935 | {"type": "Polygon", "coordinates": [[[-122.44577, 37.76325], [-122.44561, 37.76349], [-122.44531, 37.76336], [-122.44547, 37.76312], [-122.44577, 37.76325]]]} | Open Access 1 | 5832 | Mt Olympus (upper Terrace) | 22574 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.23 | Mt Olympus (upper Terrace) | None 566 | |||
13363 | 13363 | 13362 | {"type": "Polygon", "coordinates": [[[-119.10553, 36.42313], [-119.10552, 36.42333], [-119.10507, 36.42332], [-119.10506, 36.42313], [-119.10553, 36.42313]]]} | Open Access 1 | 35447 | Woodlake holding 2 | 27715 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | Tulare 29 | 0.23 | Woodlake holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | 36553 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.23 | Aromas Community Park | 0 | Local Park 2 | 4 | |
16802 | 16802 | 16801 | {"type": "Polygon", "coordinates": [[[-119.86959, 34.41191], [-119.86959, 34.41246], [-119.86943, 34.41245], [-119.86943, 34.4119], [-119.86959, 34.41191]]]} | Open Access 1 | 13882 | Isla Vista Recreation and Park District | 20280 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.23 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 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]);