units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
9265 | 9265 | 9264 | {"type": "Polygon", "coordinates": [[[-121.87743, 37.66136], [-121.87705, 37.66208], [-121.87682, 37.66199], [-121.87683, 37.66197], [-121.87682, 37.66193], [-121.87705, 37.66136], [-121.87711, 37.66126], [-121.87743, 37.66136]]]} | Open Access 1 | 15455 | Veterans Plaza | 27060 | 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.595 | Veterans Plaza | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
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 | |
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 | |
9277 | 9277 | 9276 | {"type": "Polygon", "coordinates": [[[-121.8838, 37.66917], [-121.88337, 37.66981], [-121.88292, 37.66957], [-121.88313, 37.66928], [-121.88296, 37.66872], [-121.88345, 37.66858], [-121.8838, 37.66917]]]} | Open Access 1 | 15452 | Harvest Park | 19723 | 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 | 1.567 | Harvest Park | 0 | Local Park 2 | 4 | |
9282 | 9282 | 9281 | {"type": "Polygon", "coordinates": [[[-121.87494, 37.65914], [-121.87422, 37.6598], [-121.87396, 37.65962], [-121.87468, 37.65896], [-121.87494, 37.65914]]]} | Open Access 1 | 15463 | Delucchi Park | 18079 | 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.731 | Delucchi Park | 0 | Local Park 2 | 4 | |
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-121.86652, 37.65941], [-121.86612, 37.66004], [-121.86508, 37.65957], [-121.86553, 37.65894], [-121.86652, 37.65941]]]} | Open Access 1 | 15469 | McKinley Park | 22047 | 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.047 | McKinley Park | 0 | Local Park 2 | 4 | |
9289 | 9289 | 9288 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85569, 37.66322], [-121.85554, 37.66342], [-121.8556, 37.66364], [-121.85545, 37.66393], [-121.85512, 37.66409], [-121.85492, 37.66412], [-121.8546, 37.66419], [-121.85432, 37.66405], [-121.85418, 37.66405], [-121.85397, 37.66408], [-121.85398, 37.6634], [-121.85656, 37.66294]]]} | Open Access 1 | 15475 | Tawny Park | 26198 | 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.542 | Tawny Park | 0 | Local Park 2 | 4 | |
9452 | 9452 | 9451 | {"type": "Polygon", "coordinates": [[[-121.87721, 37.67438], [-121.87705, 37.6744], [-121.87693, 37.67448], [-121.87685, 37.67458], [-121.87492, 37.67454], [-121.87477, 37.67435], [-121.87417, 37.67454], [-121.87339, 37.67466], [-121.87279, 37.67287], [-121.87277, 37.67231], [-121.87485, 37.67227], [-121.87479, 37.67327], [-121.87616, 37.67387], [-121.87718, 37.67366], [-121.87721, 37.67438]]]} | Open Access 1 | 15809 | Amador Valley Community Park | 15435 | 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 | 14.984 | Amador Valley Community Park | 0 | Local Park 2 | 4 | |
11569 | 11569 | 11568 | {"type": "Polygon", "coordinates": [[[-121.85913, 37.66996], [-121.85864, 37.67006], [-121.85845, 37.66932], [-121.85888, 37.66925], [-121.85913, 37.66996]]]} | Open Access 1 | 23664 | BMX Facility | 16201 | 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.847 | BMX Facility | None 1030 | |||
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 | |||
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 | |
13757 | 13757 | 13756 | {"type": "Polygon", "coordinates": [[[-121.84934, 37.67753], [-121.84925, 37.67858], [-121.8483, 37.67911], [-121.84787, 37.67968], [-121.84777, 37.67993], [-121.84555, 37.67995], [-121.84497, 37.67734], [-121.84513, 37.67742], [-121.84562, 37.67737], [-121.84614, 37.67698], [-121.8464, 37.67694], [-121.84669, 37.67707], [-121.84666, 37.67735], [-121.84681, 37.67764], [-121.84772, 37.67721], [-121.84827, 37.67712], [-121.84934, 37.67753]]]} | Open Access 1 | 36272 | Pleasanton holding 3 | 23806 | 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 | 22.762 | Pleasanton holding 3 | 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]);