units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11575 | 11575 | 11574 | {"type": "Polygon", "coordinates": [[[-121.93836, 37.69196], [-121.93762, 37.69268], [-121.93722, 37.6928], [-121.93685, 37.69281], [-121.93661, 37.69292], [-121.93487, 37.69179], [-121.93427, 37.69086], [-121.93388, 37.69013], [-121.93406, 37.69], [-121.93436, 37.69028], [-121.93449, 37.69038], [-121.93466, 37.69047], [-121.93499, 37.69058], [-121.93548, 37.69065], [-121.93578, 37.69074], [-121.93707, 37.69133], [-121.93731, 37.69142], [-121.93763, 37.6915], [-121.93784, 37.69159], [-121.93809, 37.69173], [-121.93836, 37.69196]]]} | Open Access 1 | 23670 | Laurel Creek Park and Staging Area | 21092 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 13.056 | Laurel Creek Park and Staging Area | None 1032 | |||
9268 | 9268 | 9267 | {"type": "Polygon", "coordinates": [[[-121.92999, 37.6877], [-121.92972, 37.68758], [-121.92907, 37.68769], [-121.92859, 37.68768], [-121.92791, 37.68645], [-121.92834, 37.68629], [-121.92864, 37.68598], [-121.92872, 37.68555], [-121.92939, 37.68495], [-121.92942, 37.685], [-121.92968, 37.68637], [-121.92999, 37.6877]]]} | Open Access 1 | 15429 | Moller Park | 22361 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 7.634 | Moller Park | 0 | Local Park 2 | 4 | |
9259 | 9259 | 9258 | {"type": "Polygon", "coordinates": [[[-121.9189, 37.68452], [-121.91839, 37.68498], [-121.91683, 37.68536], [-121.91606, 37.68339], [-121.91604, 37.68338], [-121.91546, 37.68183], [-121.91681, 37.6815], [-121.91713, 37.68231], [-121.91725, 37.68254], [-121.91739, 37.68276], [-121.91866, 37.68431], [-121.9189, 37.68452]]]} | Open Access 1 | 15420 | Muirwood Park | 22585 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.404 | Muirwood Park | 0 | Local Park 2 | 4 | |
9258 | 9258 | 9257 | {"type": "Polygon", "coordinates": [[[-121.91748, 37.67551], [-121.91697, 37.67568], [-121.91623, 37.67439], [-121.91451, 37.67491], [-121.91436, 37.67469], [-121.91537, 37.67446], [-121.91538, 37.67433], [-121.91695, 37.67405], [-121.91699, 37.67425], [-121.91694, 37.67437], [-121.91748, 37.67551]]]} | Open Access 1 | 15418 | Oakhill Park | 23028 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.484 | Oakhill Park | 0 | Local Park 2 | 4 | |
9260 | 9260 | 9259 | {"type": "Polygon", "coordinates": [[[-121.9149, 37.68359], [-121.91517, 37.6843], [-121.91517, 37.68433], [-121.91515, 37.68437], [-121.91335, 37.68473], [-121.91322, 37.6848], [-121.91317, 37.68487], [-121.91318, 37.68496], [-121.91443, 37.68894], [-121.91445, 37.68905], [-121.91443, 37.68916], [-121.91438, 37.68926], [-121.91429, 37.68934], [-121.91419, 37.6894], [-121.91403, 37.68946], [-121.91317, 37.68963], [-121.91246, 37.68738], [-121.91255, 37.68714], [-121.91216, 37.68589], [-121.91208, 37.68571], [-121.91199, 37.68554], [-121.91187, 37.68538], [-121.91174, 37.68523], [-121.91158, 37.68509], [-121.91138, 37.68496], [-121.91111, 37.68488], [-121.91119, 37.68448], [-121.91126, 37.68429], [-121.91136, 37.6841], [-121.91149, 37.68392], [-121.91156, 37.68384], [-121.91163, 37.68385], [-121.91196, 37.68404], [-121.91209, 37.68415], [-121.91216, 37.68418], [-121.91224, 37.68419], [-121.91238, 37.68414], [-121.91251, 37.684], [-121.91271, 37.68387], [-121.91293, 37.68377], [-121.91319, 37.6837], [-121.91331, 37.68399], [-121.9149, 37.68359]]]} | Open Access 1 | 15423 | Val Vista Park | 26757 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 23.865 | Val Vista Park | 0 | Local Park 2 | 4 | |
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-121.91483, 37.63509], [-121.91478, 37.64364], [-121.9097, 37.64611], [-121.90561, 37.63248], [-121.90568, 37.63243], [-121.91279, 37.63249], [-121.9128, 37.63255], [-121.91326, 37.63289], [-121.91409, 37.63322], [-121.91427, 37.63348], [-121.91481, 37.63393], [-121.91472, 37.63444], [-121.91458, 37.63451], [-121.91479, 37.63476], [-121.9147, 37.63482], [-121.91478, 37.63509], [-121.91483, 37.63509]]]} | Open Access 1 | 185 | Augustin Bernal Park | 8732 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/services/recreation/rec-augustinpark.html | Alameda 17 | 217.388 | Augustin Bernal Park | 0 | Local Park 2 | 4 |
12099 | 12099 | 12098 | {"type": "Polygon", "coordinates": [[[-121.91451, 37.66298], [-121.9139, 37.66231], [-121.91367, 37.66208], [-121.91168, 37.66028], [-121.91138, 37.65999], [-121.91113, 37.65971], [-121.9109, 37.65941], [-121.91052, 37.65879], [-121.91106, 37.65944], [-121.91312, 37.66055], [-121.91371, 37.66114], [-121.91422, 37.66235], [-121.91451, 37.66282], [-121.91451, 37.66298]]]} | Open Access 1 | 24929 | Adobe Park | 15272 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.76 | Adobe Park | 0 | Local Park 2 | 4 | |
9271 | 9271 | 9270 | {"type": "Polygon", "coordinates": [[[-121.91123, 37.66511], [-121.90939, 37.66585], [-121.90889, 37.66483], [-121.90929, 37.66467], [-121.90961, 37.66481], [-121.91004, 37.6649], [-121.91048, 37.66487], [-121.91099, 37.66471], [-121.91123, 37.66511]]]} | Open Access 1 | 15437 | Meadowlark Park | 22090 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.577 | Meadowlark Park | 0 | Local Park 2 | 4 | |
9257 | 9257 | 9256 | {"type": "Polygon", "coordinates": [[[-121.91033, 37.67583], [-121.90964, 37.67707], [-121.9093, 37.67674], [-121.90882, 37.67666], [-121.90786, 37.67671], [-121.90789, 37.67634], [-121.90747, 37.67629], [-121.90705, 37.67622], [-121.90657, 37.67632], [-121.90605, 37.67632], [-121.90561, 37.67656], [-121.9053, 37.67651], [-121.90463, 37.6768], [-121.90451, 37.67717], [-121.90384, 37.67729], [-121.90379, 37.67751], [-121.90285, 37.67763], [-121.90244, 37.6779], [-121.90227, 37.67772], [-121.9024, 37.67758], [-121.90275, 37.67744], [-121.90336, 37.67733], [-121.90465, 37.67645], [-121.90543, 37.67629], [-121.9061, 37.67612], [-121.90666, 37.67609], [-121.90754, 37.6757], [-121.90995, 37.6748], [-121.91033, 37.67583]]]} | Open Access 1 | 15415 | Valley Trails Park | 26803 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 13.044 | Valley Trails Park | 0 | Local Park 2 | 4 | |
9273 | 9273 | 9272 | {"type": "Polygon", "coordinates": [[[-121.90762, 37.66974], [-121.90641, 37.67016], [-121.90629, 37.66994], [-121.90608, 37.66966], [-121.90591, 37.66939], [-121.90574, 37.66904], [-121.90569, 37.66872], [-121.90696, 37.66847], [-121.90762, 37.66974]]]} | Open Access 1 | 15440 | Del Prado Park | 18047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.872 | Del Prado Park | 0 | Local Park 2 | 4 | |
394 | 394 | 393 | {"type": "Polygon", "coordinates": [[[-121.90274, 37.6751], [-121.89877, 37.67675], [-121.89728, 37.6759], [-121.89877, 37.67439], [-121.89993, 37.67487], [-121.90048, 37.67498], [-121.90108, 37.67494], [-121.90163, 37.67477], [-121.90224, 37.67434], [-121.90254, 37.67469], [-121.90274, 37.6751]]]} | Open Access 1 | 1438 | Tennis & Community Park | 26243 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.595 | Tennis & Community Park | 0 | Local Park 2 | 4 | |
5073 | 5073 | 5072 | {"type": "Polygon", "coordinates": [[[-121.89957, 37.6779], [-121.89857, 37.67888], [-121.89813, 37.67962], [-121.89724, 37.68008], [-121.89381, 37.68153], [-121.88504, 37.68509], [-121.88456, 37.68472], [-121.88425, 37.68451], [-121.88395, 37.68427], [-121.8838, 37.68402], [-121.88385, 37.68391], [-121.89103, 37.68002], [-121.89847, 37.67722], [-121.89957, 37.6779]]]} | Open Access 1 | 1060 | Sports and Recreation Park | 25728 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 82.403 | Sports and Rec. Park | 0 | Local Recreation Area 3 | 4 | |
14265 | 14265 | 14264 | {"type": "Polygon", "coordinates": [[[-121.8986, 37.65004], [-121.89857, 37.65009], [-121.89765, 37.65055], [-121.89754, 37.65064], [-121.89742, 37.65077], [-121.89738, 37.65079], [-121.89687, 37.65061], [-121.89668, 37.65051], [-121.89655, 37.65036], [-121.89636, 37.65005], [-121.89639, 37.65], [-121.89668, 37.64988], [-121.89691, 37.64974], [-121.89707, 37.64962], [-121.89744, 37.64927], [-121.8976, 37.64917], [-121.89774, 37.64909], [-121.8978, 37.64911], [-121.89821, 37.64954], [-121.8986, 37.65004]]]} | Open Access 1 | 44185 | Fawn Hills Park | 18854 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.875 | Fawn Hills Park | 0 | Local Park 2 | 4 | |
9274 | 9274 | 9273 | {"type": "Polygon", "coordinates": [[[-121.89538, 37.67097], [-121.89482, 37.67152], [-121.89403, 37.67123], [-121.89309, 37.67062], [-121.89239, 37.66998], [-121.8933, 37.66949], [-121.89367, 37.66993], [-121.89538, 37.67097]]]} | Open Access 1 | 15443 | Hansen Park | 19650 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.898 | Hansen Park | 0 | Local Park 2 | 4 | |
9252 | 9252 | 9251 | {"type": "Polygon", "coordinates": [[[-121.89397, 37.67515], [-121.89395, 37.67527], [-121.89376, 37.67545], [-121.89348, 37.67556], [-121.89341, 37.67537], [-121.89323, 37.67523], [-121.89234, 37.67522], [-121.89234, 37.67507], [-121.89287, 37.67507], [-121.89288, 37.67514], [-121.89397, 37.67515]]]} | Open Access 1 | 15446 | Heatherlark Park | 19786 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.742 | Heatherlark Park | 0 | Local Park 2 | 4 | |
9186 | 9186 | 9185 | {"type": "Polygon", "coordinates": [[[-121.88873, 37.69503], [-121.88788, 37.69574], [-121.8871, 37.69516], [-121.88798, 37.69443], [-121.88873, 37.69503]]]} | Open Access 1 | 15251 | Owens Plaza Park | 23276 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.554 | Owens Plaza Park | 0 | Local Park 2 | 4 | |
9197 | 9197 | 9196 | {"type": "Polygon", "coordinates": [[[-121.88663, 37.67994], [-121.88658, 37.68116], [-121.88644, 37.6813], [-121.88546, 37.68088], [-121.8855, 37.67988], [-121.88663, 37.67994]]]} | Open Access 1 | 15265 | Woodthrush Park | 27749 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.297 | Woodthrush Park | 0 | Local Park 2 | 4 | |
9276 | 9276 | 9275 | {"type": "Polygon", "coordinates": [[[-121.88627, 37.67414], [-121.88627, 37.67462], [-121.88625, 37.67466], [-121.88621, 37.67468], [-121.88577, 37.67469], [-121.88559, 37.67473], [-121.88544, 37.67479], [-121.88525, 37.67491], [-121.88509, 37.67508], [-121.88499, 37.67527], [-121.88495, 37.67548], [-121.88451, 37.67547], [-121.88458, 37.67544], [-121.88462, 37.6754], [-121.88463, 37.67516], [-121.8847, 37.67509], [-121.88472, 37.67501], [-121.88468, 37.67491], [-121.88458, 37.67485], [-121.88458, 37.67469], [-121.8843, 37.67468], [-121.88431, 37.67456], [-121.88448, 37.67442], [-121.88448, 37.67414], [-121.88627, 37.67414]]]} | Open Access 1 | 15449 | Walnut Grove Park | 27231 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.453 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
9256 | 9256 | 9255 | {"type": "Polygon", "coordinates": [[[-121.8862, 37.68633], [-121.8843, 37.6869], [-121.88257, 37.68739], [-121.88056, 37.68806], [-121.88019, 37.68815], [-121.88, 37.68814], [-121.87747, 37.68635], [-121.8774, 37.68618], [-121.87946, 37.68766], [-121.8797, 37.68789], [-121.88008, 37.68805], [-121.88048, 37.688], [-121.88253, 37.68731], [-121.88284, 37.68722], [-121.88291, 37.68699], [-121.88326, 37.68702], [-121.88357, 37.68699], [-121.88425, 37.6868], [-121.88427, 37.68682], [-121.886, 37.6863], [-121.8862, 37.68633]]]} | Open Access 1 | 15413 | Sutter Creek Gate Park | 26084 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.197 | Sutter Creek Gate Park | 0 | Local Park 2 | 4 | |
9194 | 9194 | 9193 | {"type": "Polygon", "coordinates": [[[-121.88586, 37.69157], [-121.88515, 37.69244], [-121.88287, 37.69077], [-121.88321, 37.69053], [-121.88397, 37.69108], [-121.88453, 37.69057], [-121.88586, 37.69157]]]} | Open Access 1 | 15260 | Creekside Park | 17777 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.719 | Creekside Park | 2000 | 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]);