units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1 and AGNCY_NAME = 785
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 2
ACCESS_TYP 1
- Open Access · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4801 | 4801 | 4800 | {"type": "Polygon", "coordinates": [[[-121.13503, 36.22044], [-121.13428, 36.22083], [-121.13391, 36.22026], [-121.13345, 36.21979], [-121.13422, 36.2194], [-121.13503, 36.22044]]]} | Open Access 1 | 48509 | CreekBridge Soccer Park | 33221 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 2.614 | CreekBridge Soccer Park | 0 | Local Recreation Area 3 | 4 | |
5257 | 5257 | 5256 | {"type": "Polygon", "coordinates": [[[-117.13403, 33.61701], [-117.13395, 33.61707], [-117.13333, 33.617], [-117.13282, 33.61699], [-117.13274, 33.61693], [-117.13274, 33.61667], [-117.13278, 33.6165], [-117.13278, 33.61645], [-117.13273, 33.61639], [-117.13265, 33.61637], [-117.13264, 33.61635], [-117.13261, 33.61635], [-117.1325, 33.61602], [-117.13258, 33.616], [-117.13263, 33.61592], [-117.13259, 33.61572], [-117.13259, 33.61544], [-117.13266, 33.61539], [-117.13289, 33.61536], [-117.13311, 33.61532], [-117.13381, 33.61508], [-117.13391, 33.61513], [-117.13398, 33.61534], [-117.13402, 33.61557], [-117.13403, 33.61701]]]} | Open Access 1 | 48382 | Mahogany Meadows Park | 32946 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://github.com/GreenInfo-Network/cpad/issues/37 | Riverside 10 | 6.166 | Mahogany Meadows Park | 0 | Local Park 2 | 4 |
5283 | 5283 | 5282 | {"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12851, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61271], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]} | Open Access 1 | 48401 | Linear Workout Park | 32968 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.073 | Linear Workout Park | 0 | Local Park 2 | 4 | |
6654 | 6654 | 6653 | {"type": "MultiPolygon", "coordinates": [[[[-117.12789, 33.61483], [-117.12781, 33.61497], [-117.12736, 33.61482], [-117.12736, 33.61462], [-117.12789, 33.61483]]], [[[-117.13261, 33.61635], [-117.13258, 33.61637], [-117.13251, 33.61627], [-117.13216, 33.61628], [-117.1318, 33.61633], [-117.13175, 33.61638], [-117.13168, 33.61636], [-117.13159, 33.61638], [-117.13157, 33.61636], [-117.13119, 33.61627], [-117.13083, 33.61626], [-117.13079, 33.61632], [-117.1307, 33.6163], [-117.13063, 33.61632], [-117.13059, 33.61628], [-117.13025, 33.61622], [-117.12986, 33.61627], [-117.12979, 33.61625], [-117.12974, 33.61624], [-117.12967, 33.61627], [-117.12963, 33.61629], [-117.12928, 33.61634], [-117.12953, 33.61752], [-117.12898, 33.61754], [-117.12897, 33.61697], [-117.1289, 33.61693], [-117.12892, 33.61686], [-117.1289, 33.6168], [-117.12884, 33.61676], [-117.1288, 33.61674], [-117.12879, 33.61611], [-117.12881, 33.61605], [-117.12874, 33.61562], [-117.12851, 33.61563], [-117.12827, 33.61563], [-117.12826, 33.61543], [-117.12832, 33.61507], [-117.12803, 33.61495], [-117.12809, 33.61483], [-117.12838, 33.61496], [-117.12852, 33.61482], [-117.12871, 33.61474], [-117.12865, 33.61447], [-117.12905, 33.6144], [-117.12911, 33.61468], [-117.12905, 33.61474], [-117.12911, 33.6149], [-117.12917, 33.61569], [-117.12942, 33.61577], [-117.12942, 33.61586], [-117.12948, 33.61593], [-117.12957, 33.61595], [-117.12965, 33.61593], [-117.1297, 33.61603], [-117.13006, 33.61602], [-117.13037, 33.61593], [-117.13041, 33.61589], [-117.13048, 33.61591], [-117.13058, 33.61591], [-117.13061, 33.61596], [-117.13097, 33.61604], [-117.13137, 33.61605], [-117.13142, 33.61598], [-117.13148, 33.616], [-117.13156, 33.616], [-117.13161, 33.6161], [-117.13235, 33.61611], [-117.13241, 33.61602], [-117.13248, 33.61604], [-117.1325, 33.61602], [-117.13261, 33.61635]]]]} | Open Access 1 | 48402 | Linear Park | 32969 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/linear-park | Riverside 10 | 7.128 | Linear Park | 0 | Local Park 2 | 4 |
8533 | 8533 | 8532 | {"type": "Polygon", "coordinates": [[[-117.2044, 33.66004], [-117.2044, 33.66054], [-117.20364, 33.66054], [-117.20359, 33.66062], [-117.20354, 33.6606], [-117.20346, 33.6606], [-117.20341, 33.66063], [-117.20336, 33.66068], [-117.20329, 33.66065], [-117.20297, 33.66079], [-117.20284, 33.66059], [-117.20195, 33.66065], [-117.20188, 33.66067], [-117.20183, 33.66063], [-117.20176, 33.6606], [-117.20171, 33.6606], [-117.20164, 33.66063], [-117.20158, 33.66056], [-117.20123, 33.66056], [-117.20122, 33.66075], [-117.20086, 33.66075], [-117.2008, 33.66083], [-117.20069, 33.6608], [-117.20062, 33.66083], [-117.20058, 33.66086], [-117.20053, 33.66083], [-117.19976, 33.66082], [-117.19975, 33.66119], [-117.19974, 33.66126], [-117.19976, 33.66132], [-117.19984, 33.66137], [-117.19983, 33.66196], [-117.19965, 33.66189], [-117.19954, 33.6619], [-117.1991, 33.66179], [-117.19873, 33.66179], [-117.19872, 33.66073], [-117.1987, 33.66058], [-117.19865, 33.66043], [-117.19893, 33.6603], [-117.19895, 33.66028], [-117.19946, 33.66011], [-117.19943, 33.66016], [-117.19942, 33.66021], [-117.19946, 33.66029], [-117.19955, 33.66033], [-117.19967, 33.66031], [-117.19976, 33.6604], [-117.2004, 33.66041], [-117.20046, 33.66038], [-117.20053, 33.66044], [-117.20062, 33.66045], [-117.20069, 33.66043], [-117.20073, 33.66038], [-117.20075, 33.66033], [-117.20074, 33.66025], [-117.20105, 33.66025], [-117.20106, 33.66021], [-117.201, 33.66008], [-117.20101, 33.65909], [-117.2012, 33.65907], [-117.20127, 33.65938], [-117.20143, 33.65965], [-117.20138, 33.65968], [-117.20135, 33.65973], [-117.20134, 33.65978], [-117.20136, 33.65984], [-117.20125, 33.6599], [-117.20126, 33.66018], [-117.2015, 33.66018], [-117.20169, 33.66026], [-117.20192, 33.66029], [-117.20226, 33.66029], [-117.20232, 33.66025], [-117.20237, 33.66029], [-117.20245, 33.66031], [-117.20256, 33.66027], [-117.20261, 33.66031], [-117.20297, 33.66035], [-117.20341, 33.66029], [-117.20345, 33.66024], [-117.20352, 33.66027], [-117.20358, 33.66027], [-117.20366, 33.66022], [-117.20372, 33.66026], [-117.20406, 33.66026], [-117.20406, 33.66004], [-117.2044, 33.66004]]]} | Open Access 1 | 48507 | Hidden Hills Park | 33218 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | https://www.cityofmenifee.us/285/Parks | Riverside 10 | 9.645 | Hidden Hills Park | 2019 | Local Park 2 | 4 |
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63201, 33.95915]]]} | Open Access 1 | 48706 | West Meridian Park | 33436 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 1.242 | West Meridian Park | 0 | Local Park 2 | 4 | |
10628 | 10628 | 10627 | {"type": "Polygon", "coordinates": [[[-117.62852, 33.961], [-117.62791, 33.96119], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961]]]} | Open Access 1 | 48707 | North Meridian Park | 33434 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.926 | North Meridian Park | 0 | Local Park 2 | 4 | |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 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]);