units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 1, MNG_AGENCY = 38 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92 | 92 | 91 | {"type": "MultiPolygon", "coordinates": [[[[-120.46865, 34.63751], [-120.46863, 34.63892], [-120.46689, 34.6389], [-120.46691, 34.63749], [-120.46865, 34.63751]]], [[[-120.47057, 34.63592], [-120.47056, 34.63741], [-120.46885, 34.6374], [-120.46884, 34.63734], [-120.46691, 34.63732], [-120.46693, 34.63589], [-120.47057, 34.63592]]]]} | Open Access 1 | 238 | Ryon Park | 24763 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 19.613 | Ryon Park | 0 | Local Park 2 | 4 | |
422 | 422 | 421 | {"type": "Polygon", "coordinates": [[[-120.47173, 34.64553], [-120.47171, 34.64701], [-120.47055, 34.647], [-120.47057, 34.64552], [-120.47173, 34.64553]]]} | Open Access 1 | 1352 | Thompson Park | 26315 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 4.345 | Thompson Park | 0 | Local Park 2 | 4 | |
1361 | 1361 | 1360 | {"type": "Polygon", "coordinates": [[[-120.46093, 34.64714], [-120.46091, 34.64863], [-120.45969, 34.64862], [-120.45971, 34.64713], [-120.46093, 34.64714]]]} | Open Access 1 | 8073 | College Park | 17509 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 4.568 | College Park | 0 | Local Park 2 | 4 | |
2032 | 2032 | 2031 | {"type": "Polygon", "coordinates": [[[-120.45135, 34.64228], [-120.45134, 34.64331], [-120.44908, 34.64329], [-120.44909, 34.64226], [-120.45135, 34.64228]]]} | Open Access 1 | 17052 | Johns-Manville Park | 20474 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 5.856 | Johns-Manville Park | 0 | Local Park 2 | 4 | |
2167 | 2167 | 2166 | {"type": "MultiPolygon", "coordinates": [[[[-120.44563, 34.6289], [-120.44556, 34.62931], [-120.44504, 34.6301], [-120.44501, 34.6307], [-120.44122, 34.63067], [-120.44123, 34.6295], [-120.44288, 34.62952], [-120.44464, 34.62878], [-120.44563, 34.6289]]], [[[-120.44655, 34.63243], [-120.44654, 34.63391], [-120.44274, 34.63388], [-120.44276, 34.63239], [-120.44153, 34.63238], [-120.44155, 34.63089], [-120.44517, 34.63093], [-120.44531, 34.63098], [-120.44529, 34.632], [-120.44537, 34.63218], [-120.44612, 34.63242], [-120.44655, 34.63243]]]]} | Open Access 1 | 17641 | Beattie Park | 15938 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 43.189 | Beattie Park | 0 | Local Park 2 | 4 | |
2796 | 2796 | 2795 | {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} | Open Access 1 | 18575 | Pioneer Park | 23724 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 4.712 | Pioneer Park | 0 | Local Park 2 | 4 | |
3416 | 3416 | 3415 | {"type": "Polygon", "coordinates": [[[-120.45474, 34.63166], [-120.45474, 34.63208], [-120.45449, 34.63208], [-120.45449, 34.6318], [-120.45474, 34.63166]]]} | Open Access 1 | 35325 | Lompoc holding 11 | 21422 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.216 | Lompoc holding 11 | 0 | Local Other or Unknown 14 | 4 | |
5801 | 5801 | 5800 | {"type": "Polygon", "coordinates": [[[-120.44863, 34.66551], [-120.44853, 34.6679], [-120.44856, 34.67117], [-120.44719, 34.67074], [-120.44611, 34.67003], [-120.44498, 34.66914], [-120.4443, 34.66829], [-120.44427, 34.66788], [-120.44428, 34.66667], [-120.44863, 34.66551]]]} | Open Access 1 | 70 | Riverbend Park | 30314 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/river.htm | Santa Barbara 7 | 42.802 | Riverbend Park | 0 | Local Park 2 | 4 |
6400 | 6400 | 6399 | {"type": "Polygon", "coordinates": [[[-120.47471, 34.6314], [-120.4747, 34.63191], [-120.47317, 34.6319], [-120.47317, 34.63139], [-120.47471, 34.6314]]]} | Open Access 1 | 1845 | Westvale Street Park | 27431 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 1.964 | Westvale Street Park | 0 | Local Park 2 | 4 | |
6793 | 6793 | 6792 | {"type": "MultiPolygon", "coordinates": [[[[-120.45773, 34.63741], [-120.45773, 34.63769], [-120.45726, 34.63768], [-120.45727, 34.63741], [-120.45773, 34.63741]]], [[[-120.45774, 34.63692], [-120.45773, 34.63719], [-120.45727, 34.63719], [-120.45727, 34.63692], [-120.45774, 34.63692]]]]} | Open Access 1 | 5299 | Centennial Park | 17023 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.643 | Centennial Park | 0 | Local Park 2 | 4 | |
8755 | 8755 | 8754 | {"type": "MultiPolygon", "coordinates": [[[[-120.46631, 34.656], [-120.46631, 34.65631], [-120.46521, 34.65579], [-120.46496, 34.6557], [-120.46479, 34.65567], [-120.46441, 34.65564], [-120.46083, 34.65564], [-120.46084, 34.65536], [-120.46457, 34.65537], [-120.46477, 34.65539], [-120.46501, 34.65543], [-120.46528, 34.65552], [-120.46631, 34.656]]], [[[-120.47501, 34.65624], [-120.47501, 34.65677], [-120.47483, 34.65677], [-120.47481, 34.65667], [-120.47474, 34.65659], [-120.47464, 34.65654], [-120.47453, 34.65652], [-120.46659, 34.65645], [-120.4666, 34.65617], [-120.47501, 34.65624]]]]} | Open Access 1 | 14232 | East/West Channel Bike Path | 18387 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 9.863 | East/West Channel Bike Path | 0 | Local Recreation Area 3 | 4 | |
9935 | 9935 | 9934 | {"type": "Polygon", "coordinates": [[[-120.47033, 34.67658], [-120.47019, 34.68004], [-120.46995, 34.67953], [-120.46594, 34.67676], [-120.46119, 34.6781], [-120.45882, 34.68059], [-120.45811, 34.68082], [-120.45769, 34.68022], [-120.45741, 34.67976], [-120.45701, 34.67918], [-120.45686, 34.67882], [-120.45675, 34.67823], [-120.45674, 34.67778], [-120.45693, 34.67671], [-120.45726, 34.67633], [-120.45722, 34.67563], [-120.45746, 34.67483], [-120.45767, 34.67402], [-120.45765, 34.67344], [-120.45936, 34.67368], [-120.46116, 34.67354], [-120.46388, 34.67549], [-120.47033, 34.67658]]]} | Open Access 1 | 17101 | Ken Adam Park | 20595 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 114.031 | Ken Adam Park | 0 | Local Park 2 | 4 | |
9969 | 9969 | 9968 | {"type": "Polygon", "coordinates": [[[-120.46339, 34.65709], [-120.46247, 34.65709], [-120.46226, 34.65668], [-120.46125, 34.65652], [-120.46082, 34.65626], [-120.46083, 34.65564], [-120.46204, 34.65564], [-120.46204, 34.65571], [-120.46221, 34.65601], [-120.46241, 34.65604], [-120.46244, 34.65611], [-120.46252, 34.65616], [-120.46258, 34.65617], [-120.46265, 34.65616], [-120.4628, 34.65642], [-120.46322, 34.65642], [-120.46339, 34.65709]]]} | Open Access 1 | 17146 | Barton Park | 15845 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 5.119 | Barton Park | 0 | Local Park 2 | 4 | |
13208 | 13208 | 13207 | {"type": "Polygon", "coordinates": [[[-120.45602, 34.63102], [-120.45601, 34.6313], [-120.45541, 34.63129], [-120.45542, 34.63102], [-120.45602, 34.63102]]]} | Open Access 1 | 35243 | Lompoc holding 3 | 21429 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.414 | Lompoc holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13210 | 13210 | 13209 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63198], [-120.45534, 34.63209], [-120.45504, 34.63209], [-120.45504, 34.63198], [-120.45534, 34.63198]]]} | Open Access 1 | 35246 | Lompoc holding 4 | 21430 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.083 | Lompoc holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13213 | 13213 | 13212 | {"type": "Polygon", "coordinates": [[[-120.45331, 34.65345], [-120.45328, 34.65553], [-120.4529, 34.65553], [-120.45289, 34.65395], [-120.45288, 34.65374], [-120.45277, 34.65345], [-120.45331, 34.65345]]]} | Open Access 1 | 35251 | Lompoc holding 5 | 21431 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 2.15 | Lompoc holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13227 | 13227 | 13226 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.6553], [-120.45638, 34.65537], [-120.45512, 34.65556], [-120.45512, 34.65548], [-120.45638, 34.6553]]]} | Open Access 1 | 35268 | Lompoc holding 6 | 21432 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.235 | Lompoc holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13256 | 13256 | 13255 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63177], [-120.45534, 34.63198], [-120.45481, 34.63197], [-120.45481, 34.63177], [-120.45534, 34.63177]]]} | Open Access 1 | 35301 | Lompoc holding 8 | 21434 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.275 | Lompoc holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13262 | 13262 | 13261 | {"type": "Polygon", "coordinates": [[[-120.4419, 34.65701], [-120.44087, 34.65701], [-120.44017, 34.65588], [-120.44101, 34.65643], [-120.4419, 34.65701]]]} | Open Access 1 | 35309 | Lompoc holding 9 | 21435 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 1.467 | Lompoc holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13270 | 13270 | 13269 | {"type": "Polygon", "coordinates": [[[-120.45601, 34.63164], [-120.45551, 34.63164], [-120.45551, 34.63143], [-120.45581, 34.63142], [-120.45601, 34.63144], [-120.45601, 34.63164]]]} | Open Access 1 | 35395 | Lompoc holding 1 | 21420 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.265 | Lompoc holding 1 | 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]);