units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 95
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
237 | 237 | 236 | {"type": "Polygon", "coordinates": [[[-119.23698, 34.4506], [-119.23695, 34.45232], [-119.23694, 34.45239], [-119.23691, 34.45246], [-119.23683, 34.45254], [-119.23606, 34.45308], [-119.23529, 34.45315], [-119.23533, 34.45069], [-119.23698, 34.4506]]]} | Open Access 1 | 638 | Sarzotti Park | 25162 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 9.473 | Sarzotti Park | 0 | Local Park 2 | 4 | |
3958 | 3958 | 3957 | {"type": "Polygon", "coordinates": [[[-119.24147, 34.44813], [-119.24145, 34.44942], [-119.24039, 34.44949], [-119.24062, 34.44906], [-119.2405, 34.44882], [-119.24081, 34.44818], [-119.24147, 34.44813]]]} | Open Access 1 | 47057 | Ojai Skate Park | 30707 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 2.794 | Ojai Skate Park | 0 | Local Recreation Area 3 | 4 | |
5631 | 5631 | 5630 | {"type": "MultiPolygon", "coordinates": [[[[-119.26451, 34.42519], [-119.26412, 34.42529], [-119.26374, 34.42534], [-119.26015, 34.42557], [-119.25978, 34.42564], [-119.25946, 34.42577], [-119.25919, 34.42595], [-119.25899, 34.4261], [-119.25886, 34.42623], [-119.25865, 34.42653], [-119.2586, 34.42642], [-119.25849, 34.42647], [-119.25855, 34.42667], [-119.25846, 34.42676], [-119.25828, 34.4269], [-119.25577, 34.42687], [-119.25612, 34.42613], [-119.25767, 34.42317], [-119.25953, 34.4251], [-119.25986, 34.42499], [-119.26096, 34.42507], [-119.26186, 34.42529], [-119.26324, 34.42527], [-119.26446, 34.42492], [-119.26451, 34.42519]]], [[[-119.25869, 34.42706], [-119.25859, 34.42709], [-119.25848, 34.42697], [-119.25855, 34.42692], [-119.25869, 34.42706]]], [[[-119.26467, 34.42615], [-119.26289, 34.42623], [-119.26218, 34.42623], [-119.26122, 34.4265], [-119.26054, 34.42658], [-119.25979, 34.42672], [-119.25938, 34.42681], [-119.25912, 34.42692], [-119.25887, 34.42698], [-119.25876, 34.42687], [-119.25872, 34.42676], [-119.259, 34.42635], [-119.25914, 34.42621], [-119.25938, 34.42602], [-119.25955, 34.42592], [-119.25975, 34.42583], [-119.25994, 34.42578], [-119.26017, 34.42574], [-119.26367, 34.42551], [-119.26411, 34.42546], [-119.26454, 34.42536], [-119.26467, 34.42615]]]]} | Open Access 1 | 2072 | Camp Comfort Park | 16772 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 34.786 | Camp Comfort Park | 0 | Local Park 2 | 4 | |
8504 | 8504 | 8503 | {"type": "MultiPolygon", "coordinates": [[[[-119.20169, 34.4379], [-119.20077, 34.43822], [-119.19912, 34.43753], [-119.19946, 34.43675], [-119.20103, 34.43497], [-119.2014, 34.43489], [-119.20144, 34.43506], [-119.2016, 34.43554], [-119.20163, 34.43578], [-119.20149, 34.43744], [-119.2015, 34.43754], [-119.20156, 34.43774], [-119.20169, 34.4379]]], [[[-119.20536, 34.43703], [-119.20295, 34.43746], [-119.20188, 34.43784], [-119.20179, 34.43775], [-119.20174, 34.43768], [-119.20169, 34.43751], [-119.20183, 34.43578], [-119.20179, 34.43548], [-119.20164, 34.43504], [-119.20159, 34.43482], [-119.20301, 34.43427], [-119.20536, 34.43703]]]]} | Open Access 1 | 13323 | Dennison Park | 18094 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 32.377 | Dennison Park | 0 | Local Park 2 | 4 | |
12103 | 12103 | 12102 | {"type": "MultiPolygon", "coordinates": [[[[-119.24151, 34.46173], [-119.24148, 34.46343], [-119.23758, 34.46454], [-119.2375, 34.46447], [-119.23737, 34.46441], [-119.23724, 34.4644], [-119.23712, 34.46442], [-119.23702, 34.46445], [-119.23684, 34.46457], [-119.23673, 34.46469], [-119.23666, 34.4648], [-119.23505, 34.46526], [-119.2349, 34.46528], [-119.23474, 34.46535], [-119.2338, 34.46562], [-119.23386, 34.46199], [-119.23433, 34.462], [-119.23434, 34.46202], [-119.23465, 34.46202], [-119.23466, 34.46175], [-119.23491, 34.46176], [-119.23506, 34.4621], [-119.23533, 34.46211], [-119.23533, 34.46245], [-119.23567, 34.46245], [-119.23568, 34.46247], [-119.23619, 34.46247], [-119.2362, 34.46239], [-119.23649, 34.46239], [-119.23648, 34.46244], [-119.2365, 34.46248], [-119.23654, 34.46251], [-119.23659, 34.46251], [-119.23667, 34.46247], [-119.23669, 34.46243], [-119.23668, 34.46239], [-119.23773, 34.4624], [-119.23774, 34.4622], [-119.24038, 34.46201], [-119.2413, 34.46202], [-119.24131, 34.46179], [-119.24141, 34.46158], [-119.24151, 34.46173]]], [[[-119.23738, 34.4646], [-119.23738, 34.4646], [-119.23694, 34.46472], [-119.23703, 34.46465], [-119.23717, 34.46457], [-119.23729, 34.46456], [-119.23738, 34.4646]]], [[[-119.24078, 34.46013], [-119.2407, 34.46043], [-119.24042, 34.46076], [-119.24022, 34.4611], [-119.23984, 34.4611], [-119.23984, 34.46073], [-119.23988, 34.46057], [-119.23985, 34.46048], [-119.23979, 34.46043], [-119.23969, 34.4604], [-119.23907, 34.4604], [-119.23903, 34.46038], [-119.23902, 34.46036], [-119.23902, 34.46012], [-119.24078, 34.46013]]]]} | Open Access 1 | 25007 | Daly Ranch Park | 17900 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 47.416 | Daly Ranch Park | 0 | Local Park 2 | 4 | |
12104 | 12104 | 12103 | {"type": "Polygon", "coordinates": [[[-119.24595, 34.44555], [-119.24595, 34.44579], [-119.24588, 34.44576], [-119.24587, 34.44577], [-119.24584, 34.44702], [-119.24548, 34.44699], [-119.24555, 34.4477], [-119.24476, 34.44776], [-119.24471, 34.44736], [-119.24461, 34.44736], [-119.2446, 34.44737], [-119.24464, 34.44777], [-119.24451, 34.44778], [-119.24445, 34.44728], [-119.24428, 34.4473], [-119.24428, 34.4474], [-119.24354, 34.44739], [-119.24416, 34.44739], [-119.24411, 34.44707], [-119.24406, 34.44702], [-119.244, 34.44685], [-119.24427, 34.44685], [-119.24428, 34.44666], [-119.24457, 34.44664], [-119.24447, 34.44613], [-119.24434, 34.44606], [-119.24428, 34.44573], [-119.24451, 34.44561], [-119.24469, 34.44559], [-119.2447, 34.44555], [-119.24471, 34.44531], [-119.2445, 34.44522], [-119.24416, 34.44514], [-119.24358, 34.4451], [-119.2436, 34.44402], [-119.24525, 34.44348], [-119.24593, 34.44235], [-119.2459, 34.44426], [-119.24536, 34.44426], [-119.24535, 34.44427], [-119.24547, 34.44483], [-119.24542, 34.44483], [-119.24541, 34.4449], [-119.24588, 34.44516], [-119.24587, 34.44552], [-119.24595, 34.44555]]]} | Open Access 1 | 25008 | Libbey Park | 21201 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | https://www.ojairec.com/parks-and-facilities/city-parks/libbey-park/ | Ventura 8 | 17.377 | Libbey Park | 0 | Local Park 2 | 4 |
12994 | 12994 | 12993 | {"type": "Polygon", "coordinates": [[[-119.26105, 34.44077], [-119.26101, 34.44093], [-119.26086, 34.44126], [-119.26068, 34.44144], [-119.26051, 34.44155], [-119.26032, 34.44164], [-119.25961, 34.44198], [-119.25924, 34.44214], [-119.259, 34.44173], [-119.25965, 34.44153], [-119.26032, 34.44125], [-119.26055, 34.44112], [-119.26105, 34.44077]]]} | Open Access 1 | 47054 | Rotary Community Park | 30704 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 1.948 | Rotary Community Park | 0 | Local Park 2 | 4 | |
13030 | 13030 | 13029 | {"type": "Polygon", "coordinates": [[[-119.26155, 34.44189], [-119.26153, 34.44196], [-119.26055, 34.44183], [-119.26057, 34.44177], [-119.26061, 34.44174], [-119.26085, 34.4416], [-119.26093, 34.44159], [-119.26125, 34.44177], [-119.26155, 34.44189]]]} | Open Access 1 | 47055 | Weinberger Memorial Garden | 30705 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 0.438 | Weinberger Memorial Garden | 0 | Local Park 2 | 4 | |
14447 | 14447 | 14446 | {"type": "Polygon", "coordinates": [[[-119.25049, 34.44744], [-119.25048, 34.44744], [-119.2496, 34.4475], [-119.25043, 34.44685], [-119.25049, 34.44744]]]} | Open Access 1 | 47053 | Cluff Vista Park | 30703 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 0.657 | Cluff Vista 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]);