units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 12
- Local Other or Unknown 106
- Local Park 31
- Local Recreation Area 5
- Local Conservation Area 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 149
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 151
MNG_AGENCY 1
- Ventura, City of · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15696 | 15696 | 15695 | {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.24229], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24827, 34.24302], [-119.24768, 34.2431], [-119.24767, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} | Restricted Access 2 | 18293 | Olivas Links Golf Course | 33063 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 254.598 | Olivas Links GC | 0 | Local Recreation Area 3 | 4 | |
15653 | 15653 | 15652 | {"type": "Polygon", "coordinates": [[[-119.21269, 34.24313], [-119.20754, 34.24185], [-119.2021, 34.23827], [-119.20809, 34.23733], [-119.21234, 34.23694], [-119.21269, 34.24313]]]} | Restricted Access 2 | 300 | San Buenaventura Golf Course | 32987 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 97.146 | San Buenaventura GC | 0 | Local Recreation Area 3 | 4 | |
11314 | 11314 | 11313 | {"type": "Polygon", "coordinates": [[[-119.29785, 34.29071], [-119.29772, 34.29114], [-119.2966, 34.29091], [-119.29648, 34.29126], [-119.29632, 34.29123], [-119.29642, 34.29087], [-119.2958, 34.29074], [-119.29592, 34.29032], [-119.29596, 34.2903], [-119.29736, 34.29059], [-119.2978, 34.29069], [-119.29785, 34.29071]]]} | Open Access 1 | 48050 | Kellogg Park | 32544 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.ca.gov/521/Kellogg-Park | Ventura 8 | 2.467 | Kellogg Park | 2012 | Local Park 2 | 4 |
12754 | 12754 | 12753 | {"type": "MultiPolygon", "coordinates": [[[[-119.2706, 34.25499], [-119.27035, 34.25506], [-119.27018, 34.25466], [-119.27042, 34.25458], [-119.2706, 34.25499]]], [[[-119.27083, 34.25554], [-119.27058, 34.25561], [-119.27036, 34.25508], [-119.27061, 34.25501], [-119.27083, 34.25554]]], [[[-119.27122, 34.25601], [-119.27109, 34.25605], [-119.27045, 34.25457], [-119.27049, 34.25456], [-119.2705, 34.2546], [-119.27081, 34.25533], [-119.27117, 34.25591], [-119.27122, 34.25601]]], [[[-119.27105, 34.25606], [-119.27081, 34.25613], [-119.27059, 34.25563], [-119.27084, 34.25556], [-119.27105, 34.25606]]]]} | Open Access 1 | 46907 | City Beach | 30410 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.236 | City Beach | 0 | Local Park 2 | 4 | |
5969 | 5969 | 5968 | {"type": "Polygon", "coordinates": [[[-119.29317, 34.27681], [-119.29303, 34.27679], [-119.29303, 34.27615], [-119.29316, 34.27614], [-119.29317, 34.27681]]]} | Open Access 1 | 46906 | California Plaza | 30409 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.217 | California Plaza | 0 | Local Park 2 | 4 | |
12694 | 12694 | 12693 | {"type": "Polygon", "coordinates": [[[-119.29726, 34.27814], [-119.29629, 34.27815], [-119.29628, 34.2779], [-119.29654, 34.2779], [-119.29655, 34.27783], [-119.29717, 34.27783], [-119.29718, 34.27779], [-119.29726, 34.2778], [-119.29726, 34.27814]]]} | Open Access 1 | 46905 | San Miguel Chapel Site | 30408 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.74 | San Miguel Chapel Site | None 1105 | |||
12690 | 12690 | 12689 | {"type": "Polygon", "coordinates": [[[-119.29927, 34.28098], [-119.29918, 34.28154], [-119.29906, 34.28154], [-119.29914, 34.28097], [-119.29927, 34.28098]]]} | Open Access 1 | 46904 | Valdez Alley | 30407 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.178 | Valdez Alley | None 1103 | |||
10311 | 10311 | 10310 | {"type": "Polygon", "coordinates": [[[-119.26385, 34.27887], [-119.26332, 34.27914], [-119.26332, 34.27914], [-119.26326, 34.27886], [-119.26355, 34.27884], [-119.26385, 34.27887]]]} | Open Access 1 | 18489 | McWherter Corner | 30405 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.229 | McWherter Corner | None 902 | |||
2715 | 2715 | 2714 | {"type": "Polygon", "coordinates": [[[-119.24423, 34.26821], [-119.24402, 34.26824], [-119.24392, 34.26819], [-119.24388, 34.26802], [-119.24397, 34.26778], [-119.2441, 34.26777], [-119.24413, 34.26779], [-119.24423, 34.26821]]]} | Open Access 1 | 18346 | Pacific View Skateboard Bowl | 30404 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.303 | Pacific View Skateboard Bowl | None 224 | |||
4026 | 4026 | 4025 | {"type": "Polygon", "coordinates": [[[-119.2976, 34.27523], [-119.29725, 34.27524], [-119.29725, 34.27573], [-119.29676, 34.27573], [-119.29675, 34.27523], [-119.29711, 34.2751], [-119.29759, 34.27487], [-119.2976, 34.27523]]]} | Open Access 1 | 46901 | Promenade Park | 30403 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.986 | Promenade Park | 0 | Local Park 2 | 4 | |
12697 | 12697 | 12696 | {"type": "Polygon", "coordinates": [[[-119.3071, 34.35257], [-119.30691, 34.35257], [-119.30648, 34.35228], [-119.30602, 34.35205], [-119.30155, 34.35021], [-119.30154, 34.35021], [-119.30083, 34.34992], [-119.30066, 34.3498], [-119.29909, 34.34911], [-119.29885, 34.34897], [-119.29864, 34.34879], [-119.29784, 34.34799], [-119.29773, 34.34779], [-119.29759, 34.34744], [-119.29751, 34.34708], [-119.29744, 34.34658], [-119.29745, 34.34656], [-119.29611, 34.33726], [-119.29563, 34.33453], [-119.29569, 34.33437], [-119.2958, 34.33422], [-119.29592, 34.334], [-119.29596, 34.33391], [-119.29601, 34.33366], [-119.29603, 34.33348], [-119.29598, 34.33327], [-119.29599, 34.3331], [-119.2961, 34.33261], [-119.29621, 34.33237], [-119.29628, 34.33213], [-119.29636, 34.33168], [-119.29638, 34.33123], [-119.29633, 34.33083], [-119.29619, 34.33034], [-119.29613, 34.3302], [-119.29608, 34.33016], [-119.29599, 34.33013], [-119.29554, 34.33004], [-119.29508, 34.33003], [-119.29496, 34.32997], [-119.29468, 34.3297], [-119.29393, 34.32596], [-119.29383, 34.32561], [-119.29367, 34.32528], [-119.29342, 34.32493], [-119.29301, 34.32452], [-119.29234, 34.32395], [-119.29214, 34.32375], [-119.29185, 34.3234], [-119.29161, 34.323], [-119.29148, 34.32268], [-119.2914, 34.32241], [-119.29088, 34.32008], [-119.29082, 34.31959], [-119.29082, 34.31932], [-119.29084, 34.31904], [-119.29144, 34.31425], [-119.29153, 34.31381], [-119.29162, 34.31359], [-119.29172, 34.31337], [-119.29194, 34.31304], [-119.2922, 34.31275], [-119.29375, 34.31136], [-119.29404, 34.31106], [-119.2943, 34.3107], [-119.29503, 34.3095], [-119.29567, 34.30956], [-119.29604, 34.30957], [-119.29713, 34.30959], [-119.29716, 34.30955], [-119.29767, 34.3085], [-119.29789, 34.30798], [-119.2979, 34.30792], [-119.29788, 34.30787], [-119.2977, 34.30776], [-119.29764, 34.30763], [-119.29759, 34.30761], [-119.29779, 34.30742], [-119.29797, 34.30722], [-119.29833, 34.30667], [-119.29857, 34.30618], [-119.29874, 34.30575], [-119.2994, 34.30362], [-119.29946, 34.30327], [-119.29947, 34.30265], [-119.2995, 34.30241], [-119.29956, 34.30214], [-119.29968, 34.30183], [-119.30018, 34.30095], [-119.30034, 34.30064], [-119.30043, 34.30065], [-119.3006, 34.30052], [-119.30097, 34.30059], [-119.30125, 34.3005], [-119.30161, 34.29993], [-119.30201, 34.29942], [-119.30237, 34.29903], [-119.3026, 34.29863], [-119.30282, 34.2983], [-119.3036, 34.29666], [-119.30396, 34.29581], [-119.3041, 34.29555], [-119.30431, 34.29522], [-119.305, 34.29373], [-119.30535, 34.29286], [-119.3057, 34.29213], [-119.30574, 34.29201], [-119.30575, 34.29186], [-119.30561, 34.29197], [-119.30543, 34.29193], [-119.30578, 34.2916], [-119.30602, 34.29132], [-119.30622, 34.29101], [-119.30638, 34.29066], [-119.30645, 34.29042], [-119.30651, 34.29014], [-119.30652, 34.28989], [-119.30651, 34.28958], [-119.30604, 34.28684], [-119.30593, 34.28639], [-119.3058, 34.28609], [-119.30564, 34.28582], [-119.30446, 34.28426], [-119.30448, 34.28415], [-119.30421, 34.28376], [-119.30406, 34.28342], [-119.30401, 34.2834], [-119.3038, 34.28338], [-119.30379, 34.28336], [-119.30381, 34.28335], [-119.30402, 34.28337], [-119.30408, 34.2834], [-119.30424, 34.28375], [-119.30431, 34.28386], [-119.30452, 34.28415], [-119.30457, 34.28415], [-119.30563, 34.28554], [-119.30588, 34.28591], [-119.30604, 34.28624], [-119.30612, 34.28647], [-119.30618, 34.28673], [-119.30667, 34.28957], [-119.30669, 34.2898], [-119.30667, 34.29014], [-119.30662, 34.29043], [-119.30657, 34.2906], [-119.3065, 34.2908], [-119.30634, 34.29111], [-119.30621, 34.29132], [-119.30606, 34.29152], [-119.30541, 34.29292], [-119.30527, 34.29332], [-119.30426, 34.2955], [-119.30408, 34.29584], [-119.30402, 34.29584], [-119.30361, 34.29681], [-119.30321, 34.29763], [-119.30285, 34.29831], [-119.30263, 34.29864], [-119.3024, 34.29904], [-119.30204, 34.29943], [-119.30164, 34.29995], [-119.30127, 34.30052], [-119.30097, 34.30062], [-119.30061, 34.30055], [-119.30046, 34.30066], [-119.3003, 34.301], [-119.2998, 34.30187], [-119.29969, 34.30216], [-119.29963, 34.30243], [-119.29961, 34.30266], [-119.29959, 34.30327], [-119.29953, 34.30364], [-119.29884, 34.30586], [-119.2987, 34.30622], [-119.29846, 34.30669], [-119.29817, 34.30714], [-119.29781, 34.30764], [-119.29782, 34.30765], [-119.29809, 34.30771], [-119.29776, 34.30857], [-119.29756, 34.30902], [-119.29724, 34.30968], [-119.29581, 34.30966], [-119.29513, 34.3096], [-119.29442, 34.31075], [-119.29415, 34.31112], [-119.29394, 34.31135], [-119.2923, 34.31282], [-119.29205, 34.3131], [-119.29184, 34.31342], [-119.29174, 34.31363], [-119.29166, 34.31384], [-119.29157, 34.31426], [-119.29097, 34.31905], [-119.29095, 34.31932], [-119.29095, 34.31959], [-119.29101, 34.32006], [-119.29151, 34.32233], [-119.2916, 34.32265], [-119.29173, 34.32295], [-119.29199, 34.32339], [-119.29221, 34.32366], [-119.29237, 34.32382], [-119.29311, 34.32444], [-119.29353, 34.32487], [-119.29376, 34.32519], [-119.29395, 34.32558], [-119.29406, 34.32594], [-119.29481, 34.32971], [-119.29503, 34.32991], [-119.29511, 34.32995], [-119.29556, 34.32996], [-119.29602, 34.33005], [-119.29615, 34.3301], [-119.29622, 34.33016], [-119.29629, 34.33031], [-119.29643, 34.33082], [-119.29648, 34.33123], [-119.29646, 34.33168], [-119.29638, 34.33215], [-119.2963, 34.33239], [-119.29619, 34.33264], [-119.29609, 34.33311], [-119.29608, 34.33326], [-119.29613, 34.33348], [-119.29611, 34.33367], [-119.29605, 34.33393], [-119.29601, 34.33403], [-119.29575, 34.33447], [-119.29625, 34.33725], [-119.29757, 34.34647], [-119.29759, 34.34648], [-119.29771, 34.34726], [-119.29779, 34.3475], [-119.29789, 34.34774], [-119.29801, 34.34797], [-119.29813, 34.34814], [-119.29844, 34.34851], [-119.29883, 34.34884], [-119.29926, 34.34911], [-119.29957, 34.34925], [-119.30161, 34.35009], [-119.30162, 34.35011], [-119.30602, 34.35193], [-119.30658, 34.35221], [-119.30684, 34.35238], [-119.3071, 34.35257]]]} | Open Access 1 | 46900 | Ventura River Trail | 30402 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 25.175 | Ventura River Trail | 0 | Local Recreation Area 3 | 4 | |
3659 | 3659 | 3658 | {"type": "Polygon", "coordinates": [[[-119.19724, 34.26741], [-119.19685, 34.26747], [-119.19679, 34.26555], [-119.19717, 34.26554], [-119.19724, 34.26741]]]} | Open Access 1 | 46899 | Cornucopia Garden | 30401 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.855 | Cornucopia Garden | 0 | Local Park 2 | 4 | |
3658 | 3658 | 3657 | {"type": "Polygon", "coordinates": [[[-119.18436, 34.27411], [-119.18356, 34.27423], [-119.18352, 34.27406], [-119.18352, 34.27397], [-119.18357, 34.27384], [-119.18369, 34.27373], [-119.18384, 34.27368], [-119.18401, 34.27368], [-119.18416, 34.27373], [-119.18428, 34.27382], [-119.18433, 34.27393], [-119.18437, 34.2741], [-119.18436, 34.27411]]]} | Open Access 1 | 46898 | Citrus Walk Sunstone Park | 30400 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.877 | Citrus Walk Sunstone Park | 0 | Local Park 2 | 4 | |
3652 | 3652 | 3651 | {"type": "Polygon", "coordinates": [[[-119.18157, 34.27235], [-119.18155, 34.27234], [-119.1815, 34.2721], [-119.18151, 34.27206], [-119.18156, 34.27204], [-119.18177, 34.27201], [-119.1818, 34.27202], [-119.18187, 34.27209], [-119.18172, 34.27225], [-119.18157, 34.27235]]]} | Open Access 1 | 46897 | Citrus Walk Gold Park | 30399 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.194 | Citrus Walk Gold Park | 0 | Local Park 2 | 4 | |
4025 | 4025 | 4024 | {"type": "Polygon", "coordinates": [[[-119.2436, 34.24393], [-119.24298, 34.24398], [-119.24187, 34.24402], [-119.24185, 34.24357], [-119.24184, 34.24356], [-119.24183, 34.24303], [-119.2422, 34.24282], [-119.24288, 34.24238], [-119.24343, 34.24302], [-119.24348, 34.24318], [-119.2436, 34.24393]]]} | Open Access 1 | 46896 | Olivas Adobe Historical Park | 30398 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.374 | Olivas Adobe Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
2554 | 2554 | 2553 | {"type": "Polygon", "coordinates": [[[-119.29544, 34.2807], [-119.29517, 34.28071], [-119.29517, 34.28016], [-119.29543, 34.28015], [-119.29544, 34.2807]]]} | Open Access 1 | 17815 | Downtown Mini Park | 30396 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.367 | Downtown MP | 0 | Local Park 2 | 4 | |
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 4.99 | Surfer's Point | None 29 | |||
4584 | 4584 | 4583 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.2935, 34.28196], [-119.29342, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | 35403 | Unknown park - Ventura, City of | 30393 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.37 | 0 | Local Other or Unknown 14 | 4 | ||
10582 | 10582 | 10581 | {"type": "Polygon", "coordinates": [[[-119.29759, 34.27487], [-119.29711, 34.2751], [-119.29675, 34.27523], [-119.29406, 34.276], [-119.29353, 34.27611], [-119.29296, 34.27615], [-119.29296, 34.27585], [-119.29317, 34.27581], [-119.29354, 34.2757], [-119.29388, 34.27557], [-119.294, 34.27551], [-119.29421, 34.27545], [-119.29488, 34.27522], [-119.29675, 34.27469], [-119.29758, 34.27441], [-119.29759, 34.27487]]]} | Open Access 1 | 18842 | Waterfront Promenade | 30392 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.853 | Waterfront Promenade | 0 | None 931 | ||
6399 | 6399 | 6398 | {"type": "Polygon", "coordinates": [[[-119.30632, 34.28842], [-119.30581, 34.28848], [-119.30579, 34.28839], [-119.30544, 34.28832], [-119.30545, 34.28825], [-119.30517, 34.28819], [-119.30526, 34.28788], [-119.30528, 34.28788], [-119.30548, 34.28723], [-119.3048, 34.28708], [-119.30488, 34.28682], [-119.30484, 34.2868], [-119.30508, 34.286], [-119.30511, 34.28599], [-119.30523, 34.28552], [-119.30545, 34.28556], [-119.30573, 34.28597], [-119.30591, 34.28634], [-119.30599, 34.2866], [-119.30604, 34.28684], [-119.30632, 34.28842]]]} | Open Access 1 | 1843 | Westpark Community Center | 27416 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.235 | Westpark Community Ctr. | 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]);