units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Oak Park"
This data as json, copyable, CSV (advanced)
These facets timed out: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1655 | 1655 | 1654 | {"type": "Polygon", "coordinates": [[[-117.49797, 34.03513], [-117.49753, 34.03552], [-117.49749, 34.0355], [-117.497, 34.03594], [-117.49702, 34.03597], [-117.49689, 34.03608], [-117.49555, 34.03502], [-117.49576, 34.03499], [-117.49733, 34.03499], [-117.4976, 34.03502], [-117.49765, 34.03505], [-117.49769, 34.03511], [-117.49777, 34.03514], [-117.49786, 34.03514], [-117.49794, 34.0351], [-117.49797, 34.03513]]]} | Open Access 1 | 12527 | Oak Park | 22998 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.382 | Oak Park | 0 | Local Park 2 | 4 | |
2666 | 2666 | 2665 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | 18207 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 542 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 24.875 | Oak Park | 0 | Local Park 2 | 4 | ||
2673 | 2673 | 2672 | {"type": "MultiPolygon", "coordinates": [[[[-119.72877, 34.4307], [-119.72837, 34.43096], [-119.72829, 34.43092], [-119.72818, 34.43091], [-119.72808, 34.43094], [-119.72799, 34.431], [-119.72781, 34.43118], [-119.72776, 34.43126], [-119.72774, 34.43137], [-119.72774, 34.43162], [-119.7277, 34.43173], [-119.72764, 34.4318], [-119.72727, 34.43209], [-119.72714, 34.43214], [-119.72701, 34.43216], [-119.72653, 34.43211], [-119.72666, 34.43129], [-119.7267, 34.43114], [-119.72674, 34.43099], [-119.72713, 34.42993], [-119.72715, 34.42981], [-119.72715, 34.42968], [-119.72712, 34.42956], [-119.72708, 34.42944], [-119.72697, 34.42928], [-119.72687, 34.42918], [-119.72623, 34.42871], [-119.72773, 34.42732], [-119.72773, 34.42735], [-119.7279, 34.42748], [-119.7282, 34.42791], [-119.72826, 34.42846], [-119.72814, 34.42903], [-119.72803, 34.42974], [-119.72832, 34.43009], [-119.72859, 34.43049], [-119.72877, 34.4307]]], [[[-119.72833, 34.43216], [-119.72769, 34.43231], [-119.72715, 34.43226], [-119.7273, 34.43224], [-119.72744, 34.43218], [-119.72784, 34.43187], [-119.72789, 34.4318], [-119.72792, 34.43172], [-119.72792, 34.43143], [-119.72795, 34.43132], [-119.72815, 34.43109], [-119.72822, 34.43105], [-119.72828, 34.43104], [-119.72825, 34.43108], [-119.72813, 34.43138], [-119.72824, 34.43162], [-119.72833, 34.43216]]]]} | Open Access 1 | 18199 | Oak Park | 23002 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 16.2 | Oak Park | 0 | Local Park 2 | 4 | |
5677 | 5677 | 5676 | {"type": "Polygon", "coordinates": [[[-121.46394, 38.5431], [-121.46359, 38.54311], [-121.46358, 38.54387], [-121.46331, 38.54388], [-121.46331, 38.54451], [-121.46245, 38.54451], [-121.46245, 38.54311], [-121.46189, 38.5431], [-121.46189, 38.54231], [-121.46295, 38.54232], [-121.46394, 38.5431]]]} | Open Access 1 | 21179 | Oak Park | 22999 | 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 | 6.342 | Oak Park | 0 | Local Park 2 | 4 | |
8631 | 8631 | 8630 | {"type": "Polygon", "coordinates": [[[-122.24374, 37.85662], [-122.24374, 37.85706], [-122.24373, 37.85708], [-122.24362, 37.857], [-122.24337, 37.85676], [-122.24374, 37.85662]]]} | Open Access 1 | 13801 | Oak Park | 22996 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.22 | Oak Park | 0 | Local Park 2 | 4 | |
9553 | 9553 | 9552 | {"type": "MultiPolygon", "coordinates": [[[[-122.57174, 37.9877], [-122.57157, 37.98793], [-122.5715, 37.98795], [-122.57136, 37.98792], [-122.57122, 37.98785], [-122.57112, 37.98781], [-122.57091, 37.98781], [-122.57063, 37.98785], [-122.57061, 37.98783], [-122.57079, 37.98761], [-122.57139, 37.98731], [-122.57174, 37.9877]]], [[[-122.57181, 37.98811], [-122.57174, 37.98818], [-122.5716, 37.98804], [-122.57162, 37.98803], [-122.57181, 37.98811]]]]} | Open Access 1 | 16127 | Oak Park | 23000 | 1292 | San Anselmo, City of 437 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | Marin 23 | 0.94 | Oak Park | 0 | Local Park 2 | 4 | |
9747 | 9747 | 9746 | {"type": "MultiPolygon", "coordinates": [[[[-121.2903, 37.9856], [-121.2888, 37.98595], [-121.28776, 37.98324], [-121.2892, 37.98287], [-121.2903, 37.9856]]], [[[-121.29659, 37.98407], [-121.29051, 37.98555], [-121.28941, 37.98282], [-121.29117, 37.98237], [-121.29137, 37.9823], [-121.29178, 37.98212], [-121.292, 37.98203], [-121.29224, 37.98196], [-121.29542, 37.98117], [-121.29611, 37.98284], [-121.29659, 37.98407]]]]} | Open Access 1 | 17908 | Oak Park | 23003 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 56.221 | Oak Park | 0 | Local Park 2 | 4 | |
10336 | 10336 | 10335 | {"type": "MultiPolygon", "coordinates": [[[[-118.82837, 34.28883], [-118.82756, 34.29078], [-118.82605, 34.29033], [-118.82605, 34.29002], [-118.82513, 34.28993], [-118.82504, 34.29067], [-118.82482, 34.29087], [-118.82301, 34.29112], [-118.82013, 34.29098], [-118.81961, 34.29067], [-118.81913, 34.29065], [-118.81838, 34.29091], [-118.81713, 34.29077], [-118.81742, 34.28732], [-118.81387, 34.28711], [-118.81386, 34.28684], [-118.82324, 34.28737], [-118.82426, 34.28747], [-118.82492, 34.28758], [-118.82541, 34.28769], [-118.82693, 34.28812], [-118.82693, 34.28841], [-118.82837, 34.28883]]], [[[-118.83611, 34.2928], [-118.83604, 34.2928], [-118.83544, 34.29239], [-118.83335, 34.29227], [-118.83289, 34.29177], [-118.83124, 34.29189], [-118.83026, 34.2917], [-118.82828, 34.29155], [-118.82764, 34.29087], [-118.82847, 34.28886], [-118.83037, 34.28943], [-118.83031, 34.28956], [-118.83084, 34.28976], [-118.8308, 34.28984], [-118.83137, 34.29009], [-118.83203, 34.29044], [-118.83209, 34.29037], [-118.83224, 34.29046], [-118.83234, 34.29035], [-118.83505, 34.29206], [-118.83555, 34.29234], [-118.83591, 34.29252], [-118.83611, 34.2928]]]]} | Open Access 1 | 18203 | Oak Park | 22993 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 122.012 | Oak Park | 0 | Local Park 2 | 4 | |
10650 | 10650 | 10649 | {"type": "Polygon", "coordinates": [[[-117.76934, 33.83943], [-117.76919, 33.8398], [-117.76877, 33.83968], [-117.76842, 33.83961], [-117.76782, 33.83956], [-117.76746, 33.83956], [-117.76578, 33.83972], [-117.76531, 33.83981], [-117.76502, 33.83983], [-117.76473, 33.83983], [-117.76452, 33.83979], [-117.76455, 33.83963], [-117.76457, 33.83965], [-117.76481, 33.83965], [-117.76504, 33.83962], [-117.76506, 33.83962], [-117.76627, 33.83904], [-117.76643, 33.83894], [-117.76644, 33.83892], [-117.76669, 33.83878], [-117.76667, 33.83852], [-117.76725, 33.83858], [-117.76812, 33.83826], [-117.7675, 33.83775], [-117.76856, 33.83801], [-117.76925, 33.83878], [-117.76934, 33.83943]]]} | Open Access 1 | 18991 | Oak Park | 22995 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 10.905 | Oak Park | 0 | Local Park 2 | 4 | |
11169 | 11169 | 11168 | {"type": "Polygon", "coordinates": [[[-122.25867, 37.81866], [-122.25819, 37.81906], [-122.25812, 37.81906], [-122.25805, 37.81891], [-122.25791, 37.81879], [-122.25839, 37.81849], [-122.25867, 37.81866]]]} | Open Access 1 | 47999 | Oak Park | 32421 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.493 | Oak Park | 0 | Local Park 2 | 4 | |
12911 | 12911 | 12910 | {"type": "Polygon", "coordinates": [[[-117.73406, 33.56494], [-117.73385, 33.56509], [-117.73401, 33.56555], [-117.73298, 33.56582], [-117.73269, 33.56569], [-117.73282, 33.56524], [-117.73297, 33.56489], [-117.73314, 33.56456], [-117.73328, 33.56434], [-117.7335, 33.56441], [-117.73363, 33.56437], [-117.73371, 33.56446], [-117.73388, 33.5646], [-117.73392, 33.56466], [-117.734, 33.56481], [-117.73406, 33.56494]]]} | Open Access 1 | 30364 | Oak Park | 22994 | 1004 | Aliso Viejo, City of 758 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | Orange 3 | 3.357 | Oak Park | 0 | Local Park 2 | 4 | |
14310 | 14310 | 14309 | {"type": "Polygon", "coordinates": [[[-120.20549, 34.62013], [-120.20458, 34.62171], [-120.20416, 34.62157], [-120.20415, 34.62153], [-120.20431, 34.6212], [-120.20442, 34.621], [-120.2045, 34.62088], [-120.20479, 34.62055], [-120.20487, 34.62043], [-120.20504, 34.62006], [-120.2051, 34.62005], [-120.20549, 34.62013]]]} | Open Access 1 | 44259 | Oak Park | 22997 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 2.003 | Oak Park | 0 | Local Park 2 | 4 | |
15422 | 15422 | 15421 | {"type": "Polygon", "coordinates": [[[-117.34147, 33.16315], [-117.34136, 33.16303], [-117.34116, 33.16316], [-117.34123, 33.16287], [-117.34126, 33.16266], [-117.34126, 33.16249], [-117.34147, 33.16315]]]} | Open Access 1 | 46663 | Oak Park | 29998 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 0.189 | Oak 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]);