units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Washington Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
989 | 989 | 988 | {"type": "Polygon", "coordinates": [[[-118.137, 34.16884], [-118.13546, 34.16885], [-118.13545, 34.16768], [-118.13551, 34.16767], [-118.13552, 34.16743], [-118.13551, 34.16742], [-118.13551, 34.16733], [-118.13616, 34.16732], [-118.13617, 34.16735], [-118.13649, 34.16735], [-118.1365, 34.16767], [-118.13699, 34.16767], [-118.137, 34.16884]]]} | Open Access 1 | 6718 | Washington Park | 27276 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Washington_Park/ | Los Angeles 6 | 5.43 | Washington Park | 0 | Local Park 2 | 4 |
3064 | 3064 | 3063 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | 21127 | Washington Park | 27279 | 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.583 | Washington Park | 0 | Local Park 2 | 4 | |
3626 | 3626 | 3625 | {"type": "Polygon", "coordinates": [[[-122.3468, 37.58139], [-122.34466, 37.58278], [-122.34314, 37.58149], [-122.34459, 37.58052], [-122.34494, 37.58081], [-122.34519, 37.58063], [-122.3468, 37.58139]]]} | Open Access 1 | 13520 | Washington Park | 27273 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 10.223 | Washington Park | 1935 | Local Park 2 | 4 | |
6001 | 6001 | 6000 | {"type": "Polygon", "coordinates": [[[-117.0646, 33.13353], [-117.06399, 33.13352], [-117.06374, 33.13349], [-117.0637, 33.13339], [-117.06346, 33.13339], [-117.06325, 33.1334], [-117.063, 33.13347], [-117.06278, 33.13357], [-117.06261, 33.13369], [-117.06193, 33.13449], [-117.06258, 33.13619], [-117.06094, 33.13717], [-117.06087, 33.13699], [-117.06045, 33.13543], [-117.06028, 33.13504], [-117.0605, 33.13496], [-117.06093, 33.13475], [-117.06131, 33.1345], [-117.06178, 33.13412], [-117.06178, 33.13408], [-117.0623, 33.13348], [-117.0626, 33.13322], [-117.06264, 33.13326], [-117.06278, 33.13319], [-117.06292, 33.13314], [-117.06325, 33.13308], [-117.06358, 33.13309], [-117.06359, 33.13306], [-117.06426, 33.13311], [-117.0646, 33.13353]]]} | Open Access 1 | 648 | Washington Park | 27275 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/washington-park.aspx | San Diego 4 | 12.694 | Washington Park | 0 | Local Park 2 | 4 |
6439 | 6439 | 6438 | {"type": "Polygon", "coordinates": [[[-122.41087, 37.80109], [-122.40947, 37.80126], [-122.40931, 37.80052], [-122.41014, 37.80042], [-122.41084, 37.8009], [-122.41087, 37.80109]]]} | Open Access 1 | 1965 | Washington Park | 27280 | 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 | 2.193 | Washington Park | 0 | Local Park 2 | 4 | |
6440 | 6440 | 6439 | {"type": "Polygon", "coordinates": [[[-122.04258, 37.37722], [-122.04247, 37.3776], [-122.04219, 37.37841], [-122.03848, 37.37762], [-122.0389, 37.37638], [-122.03953, 37.37651], [-122.03959, 37.37659], [-122.04258, 37.37722]]]} | Open Access 1 | 1970 | Washington Park | 27282 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 11.552 | Washington Park | 1945 | Local Park 2 | 4 | |
6473 | 6473 | 6472 | {"type": "Polygon", "coordinates": [[[-117.08763, 33.62003], [-117.08747, 33.62042], [-117.08731, 33.62075], [-117.08708, 33.62114], [-117.08686, 33.62144], [-117.08672, 33.62146], [-117.08613, 33.6211], [-117.08582, 33.62084], [-117.08558, 33.62059], [-117.08556, 33.62054], [-117.08589, 33.62021], [-117.08615, 33.62004], [-117.08763, 33.62003]]]} | Open Access 1 | 48393 | Washington Park | 32957 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/washington-park | Riverside 10 | 4.752 | Washington Park | 0 | Local Park 2 | 4 |
6929 | 6929 | 6928 | {"type": "Polygon", "coordinates": [[[-117.74092, 34.04896], [-117.74039, 34.04898], [-117.74042, 34.04989], [-117.74003, 34.0499], [-117.74004, 34.05021], [-117.74002, 34.05029], [-117.73897, 34.05028], [-117.73847, 34.05044], [-117.73793, 34.05046], [-117.73785, 34.05051], [-117.73787, 34.05087], [-117.73694, 34.05089], [-117.73685, 34.04829], [-117.74089, 34.04819], [-117.74092, 34.04896]]]} | Open Access 1 | 5825 | Washington Park | 27277 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 20.529 | Washington Park | 0 | Local Park 2 | 4 | |
6930 | 6930 | 6929 | {"type": "Polygon", "coordinates": [[[-117.38678, 33.93378], [-117.38579, 33.93434], [-117.38492, 33.93328], [-117.38591, 33.93272], [-117.38678, 33.93378]]]} | Open Access 1 | 5826 | Washington Park | 27271 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.904 | Washington Park | 0 | Local Park 2 | 4 | |
7102 | 7102 | 7101 | {"type": "Polygon", "coordinates": [[[-118.39889, 33.92695], [-118.39844, 33.92695], [-118.39843, 33.92606], [-118.39815, 33.92605], [-118.39815, 33.92515], [-118.39889, 33.92515], [-118.39889, 33.92695]]]} | Open Access 1 | 6154 | Washington Park | 27274 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 2.736 | Washington Park | 0 | Local Park 2 | 4 | |
8000 | 8000 | 7999 | {"type": "Polygon", "coordinates": [[[-122.25116, 38.10705], [-122.25116, 38.10747], [-122.25136, 38.10748], [-122.25138, 38.10749], [-122.25137, 38.10784], [-122.25135, 38.10787], [-122.24993, 38.10786], [-122.24988, 38.10784], [-122.2499, 38.10707], [-122.24991, 38.10704], [-122.24995, 38.10703], [-122.25116, 38.10705]]]} | Open Access 1 | 11608 | Washington Park | 27283 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Washington_Park | Solano 26 | 2.71 | Washington Park | 0 | Local Park 2 | 4 |
8421 | 8421 | 8420 | {"type": "Polygon", "coordinates": [[[-122.27505, 37.77022], [-122.27504, 37.7714], [-122.27278, 37.77133], [-122.27288, 37.76913], [-122.27286, 37.76884], [-122.2728, 37.76866], [-122.27259, 37.76834], [-122.27239, 37.7681], [-122.27215, 37.7679], [-122.27199, 37.76774], [-122.27475, 37.76891], [-122.27478, 37.76995], [-122.27505, 37.77022]]]} | Open Access 1 | 13144 | Washington Park | 27272 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 14.726 | Washington Park | 0 | Local Park 2 | 4 | |
8429 | 8429 | 8428 | {"type": "Polygon", "coordinates": [[[-122.38492, 37.9234], [-122.38437, 37.9249], [-122.38339, 37.92526], [-122.38222, 37.92515], [-122.38222, 37.92391], [-122.38373, 37.92472], [-122.38393, 37.92439], [-122.38439, 37.92452], [-122.38464, 37.92397], [-122.38429, 37.92384], [-122.38458, 37.9233], [-122.38492, 37.9234]]]} | Open Access 1 | 13074 | Washington Park | 27278 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 4.842 | Washington Park | 0 | Local Park 2 | 4 | |
8731 | 8731 | 8730 | {"type": "Polygon", "coordinates": [[[-121.9452, 37.34354], [-121.94488, 37.34366], [-121.94502, 37.34393], [-121.94417, 37.34424], [-121.94331, 37.3427], [-121.94323, 37.34272], [-121.94313, 37.34255], [-121.94184, 37.34301], [-121.94165, 37.34264], [-121.94178, 37.34259], [-121.94179, 37.34258], [-121.94115, 37.34143], [-121.94312, 37.34098], [-121.94385, 37.34228], [-121.94439, 37.34209], [-121.9452, 37.34354]]]} | Open Access 1 | 14176 | Washington Park | 27281 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 13.555 | Washington Park | 0 | Local Park 2 | 4 | |
15321 | 15321 | 15320 | {"type": "Polygon", "coordinates": [[[-117.84213, 34.00669], [-117.84211, 34.00671], [-117.84182, 34.00685], [-117.84177, 34.0068], [-117.8416, 34.00669], [-117.84174, 34.00646], [-117.84201, 34.00646], [-117.84205, 34.00643], [-117.84207, 34.00653], [-117.84213, 34.00669]]]} | Open Access 1 | 46484 | Washington Park | 29763 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 0.353 | Washington 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]);