units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
3584 | 3584 | 3583 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | 36691 | Ventura holding 106 | 26859 | 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.046 | Ventura holding 106 | 0 | Local Other or Unknown 14 | 4 | |
13988 | 13988 | 13987 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | 36671 | Ventura holding 115 | 26869 | 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.051 | Ventura holding 115 | 0 | Local Other or Unknown 14 | 4 | |
13978 | 13978 | 13977 | {"type": "Polygon", "coordinates": [[[-119.16687, 34.2964], [-119.16665, 34.29659], [-119.1664, 34.29639], [-119.16607, 34.29624], [-119.16634, 34.29607], [-119.16687, 34.2964]]]} | Open Access 1 | 36645 | Ventura holding 4 | 26918 | 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.422 | Ventura holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13950 | 13950 | 13949 | {"type": "Polygon", "coordinates": [[[-119.30362, 34.29574], [-119.3034, 34.29607], [-119.30138, 34.29859], [-119.30112, 34.29895], [-119.30099, 34.29893], [-119.30127, 34.29853], [-119.30318, 34.29613], [-119.30334, 34.2959], [-119.30346, 34.29571], [-119.30362, 34.29574]]]} | Open Access 1 | 36581 | Ventura holding 129 | 26884 | 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.293 | Ventura holding 129 | 0 | Local Other or Unknown 14 | 4 | |
13934 | 13934 | 13933 | {"type": "Polygon", "coordinates": [[[-119.15013, 34.27654], [-119.15013, 34.27655], [-119.15007, 34.27656], [-119.15004, 34.27659], [-119.14986, 34.27736], [-119.14985, 34.27734], [-119.15003, 34.27659], [-119.15007, 34.27654], [-119.15013, 34.27654]]]} | Open Access 1 | 36540 | Ventura holding 125 | 26880 | 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.036 | Ventura holding 125 | 0 | Local Other or Unknown 14 | 4 | |
13931 | 13931 | 13930 | {"type": "Polygon", "coordinates": [[[-119.17513, 34.27798], [-119.17494, 34.27809], [-119.17486, 34.27808], [-119.1748, 34.27804], [-119.17505, 34.27789], [-119.17513, 34.27798]]]} | Open Access 1 | 36537 | Ventura holding 124 | 26879 | 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.075 | Ventura holding 124 | 0 | Local Other or Unknown 14 | 4 | |
13366 | 13366 | 13365 | {"type": "Polygon", "coordinates": [[[-119.23078, 34.26794], [-119.23067, 34.26801], [-119.23012, 34.26824], [-119.22828, 34.26888], [-119.22827, 34.26888], [-119.22763, 34.26905], [-119.22708, 34.26919], [-119.22632, 34.26934], [-119.22629, 34.26922], [-119.22652, 34.26918], [-119.22658, 34.26907], [-119.22667, 34.26907], [-119.22675, 34.26904], [-119.22688, 34.26911], [-119.2273, 34.26901], [-119.22734, 34.26895], [-119.22745, 34.26896], [-119.22751, 34.26894], [-119.22755, 34.2689], [-119.22764, 34.26892], [-119.22785, 34.26888], [-119.22807, 34.26881], [-119.2281, 34.26874], [-119.2282, 34.26874], [-119.2283, 34.26866], [-119.22831, 34.2686], [-119.22844, 34.26854], [-119.22876, 34.26844], [-119.22962, 34.26828], [-119.22984, 34.26822], [-119.23014, 34.26806], [-119.23028, 34.26803], [-119.23073, 34.26776], [-119.23078, 34.26794]]]} | Open Access 1 | 35450 | Ventura holding 83 | 26966 | 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.931 | Ventura holding 83 | 0 | Local Other or Unknown 14 | 4 | |
13364 | 13364 | 13363 | {"type": "Polygon", "coordinates": [[[-119.16402, 34.26635], [-119.16385, 34.26637], [-119.16372, 34.26644], [-119.16282, 34.26747], [-119.16251, 34.2678], [-119.16206, 34.26825], [-119.16157, 34.2687], [-119.16099, 34.26909], [-119.16055, 34.26934], [-119.16056, 34.2694], [-119.16043, 34.26944], [-119.16041, 34.26935], [-119.16045, 34.26929], [-119.16078, 34.26907], [-119.16111, 34.26888], [-119.16175, 34.26841], [-119.16204, 34.26813], [-119.16259, 34.26754], [-119.1629, 34.26729], [-119.163, 34.26716], [-119.16328, 34.26671], [-119.1636, 34.26628], [-119.16368, 34.26625], [-119.16375, 34.26624], [-119.16402, 34.26635]]]} | Open Access 1 | 35448 | Ventura holding 84 | 26967 | 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.391 | Ventura holding 84 | 0 | Local Other or Unknown 14 | 4 | |
13362 | 13362 | 13361 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19345, 34.28278], [-119.19343, 34.28277], [-119.19323, 34.28259], [-119.19307, 34.28242], [-119.1929, 34.28221], [-119.19282, 34.28219], [-119.19258, 34.28229], [-119.19281, 34.28217], [-119.19293, 34.2822], [-119.19318, 34.28249], [-119.19348, 34.28277]]]} | Open Access 1 | 35446 | Ventura holding 79 | 26961 | 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.08 | Ventura holding 79 | 0 | Local Other or Unknown 14 | 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]);