units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where ACCESS_TYP = 1, AGNCY_NAME = 202 and MNG_AGENCY = 198
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543 | 543 | 542 | {"type": "Polygon", "coordinates": [[[-118.79147, 34.41667], [-118.79144, 34.41725], [-118.79115, 34.41732], [-118.79079, 34.41734], [-118.79041, 34.4173], [-118.79004, 34.41718], [-118.78978, 34.41704], [-118.78916, 34.41666], [-118.78927, 34.41636], [-118.79085, 34.41637], [-118.79098, 34.41637], [-118.79098, 34.41667], [-118.79147, 34.41667]]]} | Open Access 1 | 1806 | Warring Park | 27265 | 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 | 4.168 | Warring Park | 0 | Local Park 2 | 4 | |
1847 | 1847 | 1846 | {"type": "Polygon", "coordinates": [[[-119.30603, 34.41124], [-119.30554, 34.41189], [-119.30469, 34.41188], [-119.30483, 34.41141], [-119.30603, 34.41124]]]} | Open Access 1 | 15791 | Feraud Park | 18872 | 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 | 1.386 | Feraud Park | 0 | Local Park 2 | 4 | |
1936 | 1936 | 1935 | {"type": "Polygon", "coordinates": [[[-119.25439, 34.20843], [-119.25369, 34.2087], [-119.25159, 34.20484], [-119.2522, 34.20457], [-119.25218, 34.20452], [-119.25326, 34.20611], [-119.25361, 34.20692], [-119.25439, 34.20843]]]} | Open Access 1 | 16625 | Mandalay County Park | 21734 | 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 | 8.661 | Mandalay County Park | 0 | Local Park 2 | 4 | |
4217 | 4217 | 4216 | {"type": "Polygon", "coordinates": [[[-119.39128, 34.31905], [-119.39127, 34.31915], [-119.39124, 34.31923], [-119.39116, 34.31928], [-119.39106, 34.31928], [-119.39066, 34.31903], [-119.39022, 34.31881], [-119.38975, 34.31864], [-119.38925, 34.31852], [-119.3896, 34.31785], [-119.3898, 34.31799], [-119.39049, 34.31836], [-119.39104, 34.31874], [-119.39128, 34.31905]]]} | Open Access 1 | 44967 | Faria Beach Park | 32733 | 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 | 2.757 | Faria Beach Park | 0 | Local Park 2 | 4 | |
4220 | 4220 | 4219 | {"type": "Polygon", "coordinates": [[[-119.22967, 34.44042], [-119.22934, 34.44104], [-119.22896, 34.44199], [-119.22891, 34.4424], [-119.2287, 34.44271], [-119.2267, 34.44309], [-119.22634, 34.44335], [-119.22505, 34.44413], [-119.22493, 34.44422], [-119.22486, 34.44385], [-119.22446, 34.44408], [-119.22421, 34.44417], [-119.22364, 34.44429], [-119.22324, 34.44458], [-119.22283, 34.44477], [-119.22248, 34.44279], [-119.22792, 34.44213], [-119.22748, 34.43959], [-119.22936, 34.43921], [-119.22967, 34.44042]]]} | Open Access 1 | 44996 | Soule Recreation Area | 25633 | 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 | 30.851 | Soule Rec. Area | 0 | Local Recreation Area 3 | 4 | |
4585 | 4585 | 4584 | {"type": "Polygon", "coordinates": [[[-119.02666, 34.17663], [-119.02303, 34.17889], [-119.02303, 34.17889], [-119.0227, 34.17654], [-119.0266, 34.17657], [-119.02666, 34.17663]]]} | Open Access 1 | 35461 | Unnamed site - Ventura, County of | 28674 | 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 | 12.065 | 0 | Local Other or Unknown 14 | 4 | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-119.01933, 34.18141], [-119.01855, 34.18199], [-119.01765, 34.18222], [-119.01703, 34.18076], [-119.01778, 34.1799], [-119.01782, 34.18047], [-119.01889, 34.18048], [-119.01925, 34.18102], [-119.01933, 34.18141]]]} | Open Access 1 | 35758 | Unnamed site - Ventura, County of | 28674 | 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 | 7.641 | 0 | Local Other or Unknown 14 | 4 | ||
4657 | 4657 | 4656 | {"type": "Polygon", "coordinates": [[[-118.65926, 34.28468], [-118.65925, 34.28475], [-118.65918, 34.28484], [-118.65918, 34.28491], [-118.65916, 34.28495], [-118.65909, 34.28501], [-118.65903, 34.28503], [-118.65866, 34.28502], [-118.65824, 34.28486], [-118.65827, 34.28481], [-118.65866, 34.28496], [-118.659, 34.28498], [-118.65901, 34.28497], [-118.65901, 34.28485], [-118.65893, 34.28478], [-118.6589, 34.28472], [-118.6589, 34.28466], [-118.65893, 34.28461], [-118.65902, 34.28455], [-118.65913, 34.28455], [-118.65922, 34.28459], [-118.65926, 34.28468]]]} | Open Access 1 | 36586 | Unnamed site - Ventura, County of | 28674 | 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 | 0.389 | 0 | Local Other or Unknown 14 | 4 | ||
4658 | 4658 | 4657 | {"type": "Polygon", "coordinates": [[[-119.02661, 34.17427], [-119.0266, 34.17657], [-119.0227, 34.17653], [-119.02268, 34.17641], [-119.02661, 34.17427]]]} | Open Access 1 | 36587 | Unnamed site - Ventura, County of | 28674 | 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 | 11.961 | 0 | Local Other or Unknown 14 | 4 | ||
4659 | 4659 | 4658 | {"type": "Polygon", "coordinates": [[[-119.03011, 34.17448], [-119.02666, 34.17663], [-119.0266, 34.17657], [-119.02661, 34.17427], [-119.02686, 34.17414], [-119.03011, 34.17448]]]} | Open Access 1 | 36588 | Unnamed site - Ventura, County of | 28674 | 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 | 11.275 | 0 | Local Other or Unknown 14 | 4 | ||
4905 | 4905 | 4904 | {"type": "Polygon", "coordinates": [[[-118.93429, 34.23097], [-118.93156, 34.2316], [-118.93117, 34.23166], [-118.93075, 34.23168], [-118.93077, 34.2258], [-118.93428, 34.22579], [-118.93429, 34.23097]]]} | Open Access 1 | 49004 | Santa Rosa Valley Park | 33703 | 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 | 49.627 | Santa Rosa Valley Park | 0 | Local Park 2 | 4 | |
5457 | 5457 | 5456 | {"type": "Polygon", "coordinates": [[[-119.4125, 34.33772], [-119.41169, 34.33833], [-119.41074, 34.33763], [-119.40944, 34.3368], [-119.41101, 34.3373], [-119.41172, 34.33737], [-119.41209, 34.33748], [-119.4125, 34.33772]]]} | Open Access 1 | 25006 | Hobson County Park | 20018 | 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 | 3.329 | Hobson County Park | 0 | Local Park 2 | 4 | |
5490 | 5490 | 5489 | {"type": "Polygon", "coordinates": [[[-118.95092, 34.40854], [-118.95013, 34.40944], [-118.94986, 34.40922], [-118.94914, 34.40899], [-118.94818, 34.40814], [-118.94767, 34.40888], [-118.94762, 34.40898], [-118.94721, 34.40865], [-118.94731, 34.40861], [-118.94743, 34.40843], [-118.94754, 34.40818], [-118.94761, 34.40776], [-118.94774, 34.40755], [-118.94697, 34.40694], [-118.94788, 34.40614], [-118.95092, 34.40854]]]} | Open Access 1 | 25030 | Kenney Grove Park | 20611 | 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 | 14.57 | Kenney Grove Park | 0 | Local Park 2 | 4 | |
5493 | 5493 | 5492 | {"type": "Polygon", "coordinates": [[[-119.0078, 34.39328], [-118.99911, 34.39332], [-118.99911, 34.3918], [-118.99905, 34.3917], [-118.9991, 34.39158], [-118.99906, 34.3845], [-119.00044, 34.38449], [-119.00044, 34.38277], [-119.00339, 34.38276], [-119.00341, 34.38349], [-119.00659, 34.38347], [-119.0066, 34.38275], [-119.00777, 34.38275], [-119.00781, 34.38584], [-119.0078, 34.39328]]]} | Open Access 1 | 25033 | Toland Park | 14571 | 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 | http://www.ventura.org/inland-parks/toland-park-santa-paula | Ventura 8 | 219.628 | Toland Park | 0 | Local Park 2 | 4 |
6225 | 6225 | 6224 | {"type": "Polygon", "coordinates": [[[-118.71972, 34.32451], [-118.71967, 34.32504], [-118.7185, 34.32571], [-118.71778, 34.32668], [-118.71731, 34.32746], [-118.71631, 34.32771], [-118.71575, 34.32827], [-118.71603, 34.32874], [-118.71583, 34.32891], [-118.71559, 34.32902], [-118.71494, 34.32961], [-118.7136, 34.32963], [-118.71316, 34.33], [-118.71277, 34.33037], [-118.71281, 34.33097], [-118.71234, 34.33151], [-118.71163, 34.33193], [-118.71071, 34.33218], [-118.71001, 34.33264], [-118.70935, 34.33303], [-118.70894, 34.333], [-118.70894, 34.32301], [-118.70895, 34.32296], [-118.71, 34.32189], [-118.7105, 34.32224], [-118.71808, 34.32119], [-118.71836, 34.32157], [-118.71842, 34.32211], [-118.71885, 34.32299], [-118.71929, 34.32375], [-118.71955, 34.32442], [-118.71972, 34.32451]]]} | Open Access 1 | 1284 | Tapo Canyon Park | 14570 | 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 | http://www.ventura.org/inland-parks/tapo-canyon-simi-valley | Ventura 8 | 202.835 | Tapo Canyon 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 | |
12105 | 12105 | 12104 | {"type": "Polygon", "coordinates": [[[-119.08541, 34.41844], [-119.08519, 34.41845], [-119.08538, 34.41881], [-119.08542, 34.41896], [-119.08544, 34.41912], [-119.08544, 34.4193], [-119.0853, 34.42036], [-119.08525, 34.42055], [-119.08518, 34.42071], [-119.08473, 34.42151], [-119.08466, 34.42169], [-119.08462, 34.42187], [-119.08463, 34.4221], [-119.08469, 34.42234], [-119.08478, 34.42252], [-119.08461, 34.42271], [-119.07608, 34.39874], [-119.07833, 34.39784], [-119.07711, 34.39605], [-119.07706, 34.39563], [-119.07855, 34.39781], [-119.07962, 34.39869], [-119.07974, 34.39882], [-119.07982, 34.39894], [-119.08057, 34.40085], [-119.08065, 34.40114], [-119.08081, 34.40207], [-119.08091, 34.40238], [-119.08106, 34.40267], [-119.08229, 34.40468], [-119.08301, 34.40615], [-119.08311, 34.40639], [-119.08414, 34.4092], [-119.08447, 34.41012], [-119.08453, 34.41037], [-119.08459, 34.41075], [-119.0846, 34.41106], [-119.08458, 34.41132], [-119.08445, 34.41201], [-119.08442, 34.41225], [-119.08442, 34.41252], [-119.08445, 34.41276], [-119.08451, 34.41303], [-119.08494, 34.4143], [-119.085, 34.41453], [-119.08504, 34.41478], [-119.08505, 34.41503], [-119.08504, 34.41527], [-119.08492, 34.41588], [-119.0849, 34.41611], [-119.08488, 34.41721], [-119.08489, 34.41739], [-119.08494, 34.41756], [-119.08501, 34.41773], [-119.08541, 34.41844]]]} | Open Access 1 | 25009 | Steckel Park | 25818 | 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 | 199.585 | Steckel Park | 0 | Local Park 2 | 4 | |
12107 | 12107 | 12106 | {"type": "MultiPolygon", "coordinates": [[[[-119.31911, 34.34872], [-119.31774, 34.35916], [-119.31723, 34.35838], [-119.3171, 34.35824], [-119.31692, 34.35811], [-119.31667, 34.35799], [-119.31642, 34.35793], [-119.31546, 34.35788], [-119.31527, 34.35785], [-119.31511, 34.35779], [-119.31491, 34.3577], [-119.31475, 34.35758], [-119.3143, 34.35709], [-119.3142, 34.35725], [-119.31451, 34.3576], [-119.31466, 34.35773], [-119.31485, 34.35786], [-119.31506, 34.35796], [-119.31499, 34.35794], [-119.31412, 34.35743], [-119.314, 34.35744], [-119.31419, 34.35724], [-119.31408, 34.35712], [-119.31377, 34.35746], [-119.30911, 34.35781], [-119.30864, 34.35584], [-119.30828, 34.35451], [-119.30815, 34.35412], [-119.30793, 34.3537], [-119.30765, 34.35329], [-119.30732, 34.35292], [-119.30691, 34.35257], [-119.30709, 34.35257], [-119.30781, 34.35229], [-119.30859, 34.3516], [-119.31051, 34.35245], [-119.31248, 34.34918], [-119.31911, 34.34872]]], [[[-119.31635, 34.35809], [-119.31591, 34.35825], [-119.31578, 34.35821], [-119.31579, 34.35806], [-119.31635, 34.35809]]], [[[-119.31771, 34.35945], [-119.31767, 34.35975], [-119.31703, 34.35843], [-119.31672, 34.3582], [-119.31692, 34.35832], [-119.31706, 34.35846], [-119.31771, 34.35945]]]]} | Open Access 1 | 25012 | Foster Park | 14558 | 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 | http://www.ventura.org/inland-parks/foster-park-ventura | Ventura 8 | 201.467 | Foster Park | 0 | Local Park 2 | 4 |
12111 | 12111 | 12110 | {"type": "Polygon", "coordinates": [[[-119.14885, 34.28641], [-119.14759, 34.28717], [-119.14695, 34.28643], [-119.14821, 34.28567], [-119.14885, 34.28641]]]} | Open Access 1 | 25020 | Saticoy Park | 25166 | 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 | 3.561 | Saticoy Park | 0 | Local Park 2 | 4 | |
14993 | 14993 | 14992 | {"type": "Polygon", "coordinates": [[[-119.16829, 34.23725], [-119.16763, 34.23817], [-119.16758, 34.2382], [-119.16753, 34.2382], [-119.16746, 34.23817], [-119.16734, 34.23807], [-119.16807, 34.23713], [-119.16829, 34.23725]]]} | Open Access 1 | 45640 | Roger Jones Community Park | 28456 | 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 | http://www.ventura.org/community-centers/roger-jones-community-center-el-rio | Ventura 8 | 0.823 | Roger Jones Community 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]);