units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where GAP_STS = 4, MNG_AGENCY = 388 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
DES_TP 2
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 8 ✖
MNG_AGENCY 1
- Livermore Area Recreation and Park District · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1623 | 1623 | 1622 | {"type": "MultiPolygon", "coordinates": [[[[-121.76002, 37.62547], [-121.75891, 37.62692], [-121.75782, 37.62729], [-121.7578, 37.62944], [-121.75603, 37.62944], [-121.75664, 37.62567], [-121.75676, 37.62564], [-121.75689, 37.62563], [-121.75801, 37.62572], [-121.75818, 37.62571], [-121.75834, 37.62568], [-121.75847, 37.62564], [-121.75886, 37.62539], [-121.75908, 37.62537], [-121.75959, 37.62536], [-121.75981, 37.62539], [-121.76002, 37.62547]]], [[[-121.76102, 37.62522], [-121.76058, 37.62534], [-121.75976, 37.62497], [-121.75962, 37.62497], [-121.75926, 37.62501], [-121.759, 37.62509], [-121.75884, 37.62516], [-121.75851, 37.62537], [-121.7584, 37.62541], [-121.75689, 37.62534], [-121.7567, 37.62535], [-121.75686, 37.62434], [-121.75799, 37.62352], [-121.76017, 37.6241], [-121.76102, 37.62522]]]]} | Open Access 1 | 12392 | Veterans Park | 27055 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 32.099 | Veterans Park | 0 | Local Park 2 | 4 | |
2228 | 2228 | 2227 | {"type": "Polygon", "coordinates": [[[-121.71671, 37.72148], [-121.71669, 37.72289], [-121.71655, 37.72282], [-121.71638, 37.72284], [-121.7163, 37.72283], [-121.71614, 37.72271], [-121.71604, 37.72268], [-121.71589, 37.72271], [-121.7157, 37.7228], [-121.71557, 37.72281], [-121.71548, 37.72278], [-121.71522, 37.72262], [-121.71518, 37.72256], [-121.71517, 37.72242], [-121.71509, 37.72236], [-121.71509, 37.72164], [-121.71547, 37.72166], [-121.71605, 37.72163], [-121.71635, 37.72158], [-121.71671, 37.72148]]]} | Open Access 1 | 47875 | Altamont Creek Park | 31819 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.384 | Altamont Creek Park | 0 | Local Park 2 | 4 | |
2331 | 2331 | 2330 | {"type": "Polygon", "coordinates": [[[-121.78282, 37.64863], [-121.78279, 37.65129], [-121.7812, 37.6513], [-121.78154, 37.65043], [-121.78091, 37.65026], [-121.78027, 37.64999], [-121.77988, 37.65027], [-121.77971, 37.65015], [-121.77949, 37.65007], [-121.77927, 37.65003], [-121.77901, 37.65002], [-121.77901, 37.64866], [-121.78282, 37.64863]]]} | Open Access 1 | 17022 | Independence Park | 20194 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.829 | Independence Park | 0 | Local Park 2 | 4 | |
5796 | 5796 | 5795 | {"type": "Polygon", "coordinates": [[[-121.77192, 37.65198], [-121.77207, 37.65215], [-121.77213, 37.65227], [-121.77217, 37.65245], [-121.77216, 37.65261], [-121.77211, 37.65276], [-121.77203, 37.65288], [-121.77193, 37.653], [-121.77174, 37.65313], [-121.77139, 37.65283], [-121.77068, 37.65348], [-121.77003, 37.65337], [-121.76837, 37.65337], [-121.76838, 37.64984], [-121.77159, 37.64981], [-121.77009, 37.65039], [-121.77009, 37.6509], [-121.77077, 37.65131], [-121.77152, 37.65219], [-121.77192, 37.65198]]]} | Restricted Access 2 | 53 | Ravenswood Historic Site | 24199 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 23.335 | Ravenswood Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
5830 | 5830 | 5829 | {"type": "MultiPolygon", "coordinates": [[[[-121.75351, 37.6671], [-121.75347, 37.66943], [-121.75222, 37.66955], [-121.7518, 37.67095], [-121.75163, 37.67111], [-121.74978, 37.66992], [-121.74978, 37.66658], [-121.75158, 37.66658], [-121.7518, 37.6666], [-121.75201, 37.66664], [-121.75216, 37.6667], [-121.75258, 37.66692], [-121.75283, 37.66701], [-121.75315, 37.66708], [-121.75351, 37.6671]]], [[[-121.76804, 37.67187], [-121.76786, 37.67183], [-121.76782, 37.67226], [-121.76721, 37.67219], [-121.7672, 37.67204], [-121.76607, 37.67215], [-121.76474, 37.67184], [-121.76409, 37.67193], [-121.76329, 37.67196], [-121.76223, 37.67195], [-121.76223, 37.67138], [-121.76128, 37.67111], [-121.76095, 37.67105], [-121.7606, 37.67102], [-121.75812, 37.67102], [-121.75811, 37.67099], [-121.75351, 37.67099], [-121.75358, 37.66698], [-121.75521, 37.66698], [-121.75761, 37.66704], [-121.75762, 37.66708], [-121.7621, 37.66709], [-121.76212, 37.6703], [-121.76373, 37.67101], [-121.7664, 37.67101], [-121.76663, 37.67089], [-121.76693, 37.67081], [-121.76707, 37.6708], [-121.768, 37.67079], [-121.76801, 37.67101], [-121.76711, 37.67101], [-121.76711, 37.67181], [-121.76801, 37.67182], [-121.76804, 37.67187]]], [[[-121.76857, 37.67267], [-121.76839, 37.67259], [-121.76834, 37.67252], [-121.76851, 37.67255], [-121.76856, 37.67262], [-121.76857, 37.67267]]]]} | Open Access 1 | 218 | Robertson Park | 24497 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 127.799 | Robertson Park | 0 | Local Park 2 | 4 | |
5864 | 5864 | 5863 | {"type": "Polygon", "coordinates": [[[-121.74212, 37.68003], [-121.74211, 37.68414], [-121.73903, 37.68414], [-121.73905, 37.68002], [-121.74212, 37.68003]]]} | Open Access 1 | 211 | Robert Livermore Park | 24491 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 30.673 | Robert Livermore Park | 0 | Local Park 2 | 4 | |
6281 | 6281 | 6280 | {"type": "Polygon", "coordinates": [[[-121.78658, 37.62857], [-121.78639, 37.62858], [-121.78639, 37.629], [-121.78301, 37.63081], [-121.78301, 37.63221], [-121.78169, 37.63162], [-121.78099, 37.63201], [-121.77771, 37.63469], [-121.77856, 37.63573], [-121.77897, 37.63582], [-121.77921, 37.63623], [-121.77965, 37.63653], [-121.77979, 37.63678], [-121.779, 37.63755], [-121.78164, 37.63973], [-121.78239, 37.64025], [-121.78297, 37.64099], [-121.78298, 37.64103], [-121.78298, 37.64187], [-121.78303, 37.64198], [-121.783, 37.64511], [-121.78017, 37.64511], [-121.78016, 37.64456], [-121.77334, 37.64016], [-121.77442, 37.63941], [-121.77442, 37.6394], [-121.76549, 37.63598], [-121.7649, 37.63596], [-121.76378, 37.63796], [-121.76341, 37.63779], [-121.76341, 37.63776], [-121.76197, 37.63689], [-121.76193, 37.63691], [-121.761, 37.63635], [-121.76005, 37.63603], [-121.75954, 37.63572], [-121.7589, 37.635], [-121.75806, 37.63426], [-121.75585, 37.63251], [-121.75566, 37.63222], [-121.75562, 37.63187], [-121.75547, 37.63119], [-121.75543, 37.63067], [-121.75555, 37.63037], [-121.75597, 37.62978], [-121.75602, 37.62951], [-121.75839, 37.62951], [-121.7587, 37.63008], [-121.75854, 37.63151], [-121.75914, 37.63199], [-121.75989, 37.63222], [-121.76148, 37.63231], [-121.76343, 37.63202], [-121.76358, 37.63204], [-121.7638, 37.63203], [-121.76409, 37.63198], [-121.76519, 37.6316], [-121.76571, 37.63146], [-121.7663, 37.63135], [-121.76661, 37.63132], [-121.76697, 37.63133], [-121.76731, 37.6314], [-121.76839, 37.6317], [-121.76951, 37.63212], [-121.76974, 37.63218], [-121.77002, 37.63222], [-121.77003, 37.63221], [-121.77003, 37.6315], [-121.77034, 37.63139], [-121.77076, 37.63138], [-121.77119, 37.63148], [-121.77159, 37.6317], [-121.77259, 37.63185], [-121.77329, 37.63181], [-121.77317, 37.63095], [-121.77286, 37.62999], [-121.77233, 37.62864], [-121.77225, 37.62807], [-121.77203, 37.62782], [-121.77003, 37.62782], [-121.77003, 37.62239], [-121.78373, 37.62241], [-121.78376, 37.62256], [-121.78454, 37.62258], [-121.7849, 37.62297], [-121.78524, 37.62373], [-121.78524, 37.62422], [-121.78591, 37.62585], [-121.78588, 37.62623], [-121.78639, 37.62693], [-121.78657, 37.62688], [-121.78658, 37.62857]]]} | Open Access 1 | 1367 | Sycamore Grove Park | 5294 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.org/open_space/sycamore.html | Alameda 17 | 730.948 | Sycamore Grove Park | 0 | Local Park 2 | 4 |
14257 | 14257 | 14256 | {"type": "Polygon", "coordinates": [[[-121.72695, 37.67496], [-121.72684, 37.67528], [-121.72671, 37.67554], [-121.72653, 37.67583], [-121.72647, 37.67583], [-121.72627, 37.67574], [-121.72578, 37.67555], [-121.72536, 37.67535], [-121.72535, 37.6746], [-121.72528, 37.67459], [-121.72528, 37.67446], [-121.72535, 37.67445], [-121.72535, 37.67393], [-121.72482, 37.67393], [-121.72473, 37.67385], [-121.72459, 37.67381], [-121.72391, 37.67381], [-121.72379, 37.67385], [-121.72371, 37.67392], [-121.72282, 37.67392], [-121.72273, 37.67383], [-121.72266, 37.6738], [-121.72257, 37.67379], [-121.72192, 37.67379], [-121.72181, 37.67382], [-121.72174, 37.67386], [-121.72167, 37.67382], [-121.72085, 37.67382], [-121.72078, 37.67387], [-121.72065, 37.6738], [-121.72046, 37.67378], [-121.72041, 37.67376], [-121.72038, 37.67371], [-121.72038, 37.67355], [-121.7212, 37.67355], [-121.72129, 37.67347], [-121.72136, 37.67351], [-121.72146, 37.67353], [-121.72213, 37.67353], [-121.72228, 37.67349], [-121.72234, 37.67344], [-121.72237, 37.67338], [-121.72325, 37.67338], [-121.72326, 37.67347], [-121.72331, 37.67355], [-121.72339, 37.67359], [-121.72349, 37.67362], [-121.7242, 37.67362], [-121.7243, 37.67366], [-121.72437, 37.67366], [-121.7245, 37.67362], [-121.72526, 37.67361], [-121.72535, 37.67358], [-121.72542, 37.67354], [-121.72548, 37.67357], [-121.7259, 37.67357], [-121.72589, 37.67205], [-121.72623, 37.67236], [-121.7265, 37.67268], [-121.72672, 37.67303], [-121.72689, 37.67339], [-121.727, 37.67382], [-121.72704, 37.6742], [-121.72703, 37.67458], [-121.72695, 37.67496]]]} | Open Access 1 | 44176 | Bruno Canziani Park | 16451 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.965 | Bruno Canziani 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]);