units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and UNIT_NAME = "Liberty Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
381 | 381 | 380 | {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} | Open Access 1 | 1141 | Liberty Park | 21210 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 16.086 | Liberty Park | 0 | Local Park 2 | 4 | ||
1265 | 1265 | 1264 | {"type": "Polygon", "coordinates": [[[-117.69604, 34.03892], [-117.69495, 34.03892], [-117.69494, 34.03807], [-117.69396, 34.03808], [-117.69395, 34.03717], [-117.69597, 34.03716], [-117.69598, 34.03795], [-117.69595, 34.03817], [-117.69597, 34.03824], [-117.69603, 34.0383], [-117.69604, 34.03892]]]} | Open Access 1 | 5685 | Liberty Park | 21209 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/liberty-park | San Bernardino 22 | 6.96 | Liberty Park | 0 | Local Park 2 | 4 |
1266 | 1266 | 1265 | {"type": "Polygon", "coordinates": [[[-117.3665, 34.48853], [-117.36511, 34.48853], [-117.36513, 34.48797], [-117.36445, 34.48797], [-117.36445, 34.48672], [-117.3665, 34.48672], [-117.3665, 34.48853]]]} | Open Access 1 | 5686 | Liberty Park | 21212 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 8.444 | Liberty Park | 0 | Local Park 2 | 4 | |
5367 | 5367 | 5366 | {"type": "Polygon", "coordinates": [[[-117.98542, 33.76027], [-117.98532, 33.76028], [-117.98534, 33.76166], [-117.9837, 33.76167], [-117.98369, 33.76028], [-117.98492, 33.76027], [-117.98493, 33.76004], [-117.98542, 33.76004], [-117.98542, 33.76027]]]} | Open Access 1 | 5689 | Liberty Park | 21213 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 6.085 | Liberty Park | 0 | Local Park 2 | 4 | |
6602 | 6602 | 6601 | {"type": "MultiPolygon", "coordinates": [[[[-118.10099, 33.85324], [-118.10009, 33.85325], [-118.10007, 33.85322], [-118.09975, 33.85322], [-118.0997, 33.85318], [-118.09967, 33.8513], [-118.09969, 33.85], [-118.09967, 33.84962], [-118.10001, 33.84962], [-118.10099, 33.85324]]], [[[-118.10233, 33.85814], [-118.102, 33.85814], [-118.10201, 33.85819], [-118.10123, 33.8582], [-118.10122, 33.85753], [-118.09975, 33.85754], [-118.0997, 33.85333], [-118.10102, 33.85333], [-118.10175, 33.85601], [-118.10175, 33.85692], [-118.102, 33.85693], [-118.10233, 33.85814]], [[-118.10131, 33.85762], [-118.10132, 33.85755], [-118.10124, 33.85755], [-118.10124, 33.85761], [-118.10131, 33.85762]]]]} | Open Access 1 | 4119 | Liberty Park | 21208 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 28.855 | Liberty Park | 0 | Local Park 2 | 4 | |
11978 | 11978 | 11977 | {"type": "Polygon", "coordinates": [[[-117.6015, 33.46911], [-117.60151, 33.46918], [-117.60125, 33.46963], [-117.60124, 33.46967], [-117.6012, 33.46971], [-117.60119, 33.46982], [-117.60113, 33.46995], [-117.60112, 33.47013], [-117.60109, 33.47021], [-117.60098, 33.47034], [-117.60062, 33.4706], [-117.60062, 33.47063], [-117.60057, 33.47068], [-117.60028, 33.47082], [-117.60016, 33.47084], [-117.60001, 33.47092], [-117.59979, 33.47098], [-117.59972, 33.47104], [-117.59965, 33.47111], [-117.59951, 33.47137], [-117.59933, 33.47157], [-117.59921, 33.47177], [-117.59917, 33.47189], [-117.59916, 33.47224], [-117.59912, 33.47239], [-117.59904, 33.4725], [-117.59906, 33.47253], [-117.59892, 33.47263], [-117.59884, 33.47278], [-117.59871, 33.47274], [-117.59876, 33.47262], [-117.59897, 33.4724], [-117.59901, 33.47229], [-117.59846, 33.47224], [-117.59844, 33.47222], [-117.59815, 33.47219], [-117.59813, 33.47215], [-117.59797, 33.47214], [-117.59795, 33.47212], [-117.59799, 33.47179], [-117.59802, 33.47175], [-117.59801, 33.47159], [-117.59793, 33.47146], [-117.59784, 33.47136], [-117.59785, 33.47128], [-117.59807, 33.47121], [-117.59836, 33.47115], [-117.59844, 33.47112], [-117.59856, 33.47105], [-117.59878, 33.47086], [-117.59882, 33.47077], [-117.59886, 33.47073], [-117.59901, 33.47065], [-117.5991, 33.47057], [-117.59919, 33.47045], [-117.59924, 33.47034], [-117.59938, 33.4703], [-117.5994, 33.47027], [-117.59954, 33.47026], [-117.59957, 33.47028], [-117.59984, 33.47024], [-117.59999, 33.47018], [-117.60018, 33.47004], [-117.60028, 33.46993], [-117.60083, 33.46963], [-117.60138, 33.46913], [-117.60145, 33.4691], [-117.6015, 33.46911]]]} | Open Access 1 | 24610 | Liberty Park | 21211 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 8.971 | Liberty Park | 0 | Local Park 2 | 4 | |
14901 | 14901 | 14900 | {"type": "Polygon", "coordinates": [[[-117.20331, 33.82801], [-117.20331, 33.82811], [-117.20305, 33.82823], [-117.2028, 33.82828], [-117.2009, 33.82829], [-117.20067, 33.82826], [-117.20056, 33.82829], [-117.20006, 33.82829], [-117.20006, 33.82684], [-117.20188, 33.82684], [-117.20231, 33.82709], [-117.20266, 33.82735], [-117.20304, 33.82769], [-117.20331, 33.82801]]]} | Open Access 1 | 45453 | Liberty Park | 28258 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parks/liberty-park.html | Riverside 10 | 9.984 | Liberty 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]);