units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where DES_TP = 14, GAP_STS = 4 and MNG_AGENCY = 38
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 14
MNG_AGENCY 1
- Lompoc, City of · 14 ✖
DES_TP 1
- Local Other or Unknown · 14 ✖
ACCESS_TYP 1
- Open Access 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
13272 | 13272 | 13271 | {"type": "Polygon", "coordinates": [[[-120.43525, 34.6351], [-120.43509, 34.63553], [-120.43525, 34.63607], [-120.43523, 34.63638], [-120.43497, 34.63671], [-120.43491, 34.63688], [-120.43475, 34.637], [-120.43464, 34.63713], [-120.4346, 34.63731], [-120.43466, 34.63749], [-120.43477, 34.63761], [-120.43493, 34.63771], [-120.43448, 34.63775], [-120.43436, 34.63705], [-120.43452, 34.63632], [-120.43454, 34.63613], [-120.43454, 34.63601], [-120.43451, 34.63582], [-120.43446, 34.63567], [-120.43433, 34.63543], [-120.43525, 34.6351]]]} | Open Access 1 | 35324 | Lompoc holding 12 | 21423 | 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 | 3.384 | Lompoc holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13329 | 13329 | 13328 | {"type": "Polygon", "coordinates": [[[-120.45748, 34.65505], [-120.45746, 34.65537], [-120.45452, 34.65581], [-120.45328, 34.65606], [-120.45327, 34.65656], [-120.45294, 34.65567], [-120.4529, 34.65553], [-120.45328, 34.65553], [-120.45329, 34.65574], [-120.45414, 34.65562], [-120.45415, 34.65559], [-120.45477, 34.65559], [-120.45512, 34.65556], [-120.45637, 34.65537], [-120.45639, 34.65521], [-120.45748, 34.65505]]]} | Open Access 1 | 35399 | Lompoc holding 2 | 21428 | 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 | 3.048 | Lompoc holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13947 | 13947 | 13946 | {"type": "Polygon", "coordinates": [[[-120.43629, 34.64], [-120.43609, 34.64011], [-120.43523, 34.63954], [-120.43457, 34.63831], [-120.43448, 34.63776], [-120.43493, 34.63771], [-120.43511, 34.63843], [-120.43571, 34.63942], [-120.43582, 34.63979], [-120.43601, 34.63994], [-120.43629, 34.64]]]} | Open Access 1 | 36577 | Lompoc holding 16 | 21427 | 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.691 | Lompoc holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13948 | 13948 | 13947 | {"type": "Polygon", "coordinates": [[[-120.45658, 34.63103], [-120.45653, 34.63116], [-120.45657, 34.63126], [-120.45658, 34.63136], [-120.45601, 34.6313], [-120.45602, 34.63102], [-120.45658, 34.63103]]]} | Open Access 1 | 36579 | Lompoc holding 15 | 21426 | 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.418 | Lompoc holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13951 | 13951 | 13950 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.65553], [-120.45638, 34.65556], [-120.45535, 34.65571], [-120.45528, 34.65585], [-120.45483, 34.65579], [-120.45328, 34.65609], [-120.45328, 34.65606], [-120.45452, 34.65581], [-120.45638, 34.65553]]]} | Open Access 1 | 36582 | Lompoc holding 14 | 21425 | 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.316 | Lompoc holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13952 | 13952 | 13951 | {"type": "Polygon", "coordinates": [[[-120.45415, 34.65559], [-120.45415, 34.65562], [-120.45328, 34.65574], [-120.45328, 34.65558], [-120.45415, 34.65559]]]} | Open Access 1 | 36583 | Lompoc holding 13 | 21424 | 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.201 | Lompoc holding 13 | 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]);