superunits_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 | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6261 | 6261 | 6260 | {"type": "Polygon", "coordinates": [[[-121.87403, 37.65996], [-121.87324, 37.66069], [-121.87298, 37.66051], [-121.87377, 37.65978], [-121.87403, 37.65996]]]} | Open Access 1 | Lions Wayside Park | 21328 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.803 | Lions Wayside Park | ||
6881 | 6881 | 6880 | {"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 | Meadowlark Park | 22090 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.577 | Meadowlark Park | ||
6888 | 6888 | 6887 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | Meadows Park | 22098 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 4.868 | Meadows Park | ||
7020 | 7020 | 7019 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.86141, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.8615, 37.67899], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67985], [-121.86242, 37.67993]]]} | Open Access 1 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.663 | Pleasanton holding 1 | ||
7055 | 7055 | 7054 | {"type": "MultiPolygon", "coordinates": [[[[-121.87194, 37.64739], [-121.87184, 37.64769], [-121.87168, 37.64785], [-121.87161, 37.64812], [-121.87143, 37.64811], [-121.87124, 37.64811], [-121.87109, 37.64787], [-121.87092, 37.64767], [-121.87067, 37.64752], [-121.87044, 37.64734], [-121.86941, 37.64669], [-121.86909, 37.64642], [-121.86933, 37.64636], [-121.86961, 37.64634], [-121.87065, 37.64645], [-121.87061, 37.64677], [-121.87138, 37.64686], [-121.8716, 37.64691], [-121.8716, 37.64693], [-121.87176, 37.64705], [-121.87187, 37.64719], [-121.87194, 37.64739]]], [[[-121.87319, 37.65007], [-121.87297, 37.65046], [-121.87262, 37.65035], [-121.87256, 37.65055], [-121.87075, 37.64993], [-121.87068, 37.64995], [-121.87046, 37.65015], [-121.87027, 37.65039], [-121.8702, 37.65037], [-121.87017, 37.65033], [-121.87018, 37.65029], [-121.87068, 37.64963], [-121.87078, 37.64946], [-121.8709, 37.64906], [-121.87095, 37.64884], [-121.87097, 37.64865], [-121.87093, 37.64838], [-121.87098, 37.64834], [-121.87129, 37.64827], [-121.87147, 37.64827], [-121.87169, 37.64832], [-121.87189, 37.6484], [-121.87203, 37.6485], [-121.87211, 37.64859], [-121.87217, 37.64869], [-121.87225, 37.64898], [-121.87236, 37.64915], [-121.87246, 37.64923], [-121.87259, 37.6493], [-121.87274, 37.64935], [-121.87285, 37.64937], [-121.87276, 37.64976], [-121.87314, 37.64979], [-121.87313, 37.64985], [-121.87307, 37.64992], [-121.87306, 37.64997], [-121.87311, 37.65004], [-121.87319, 37.65007]]]]} | Open Access 1 | Mission Hills Park | 22300 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 13.731 | Mission Hills Park | 1999 | |
7101 | 7101 | 7100 | {"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 | Moller Park | 22361 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 7.635 | Moller Park | ||
7380 | 7380 | 7379 | {"type": "Polygon", "coordinates": [[[-121.87206, 37.68809], [-121.87038, 37.68876], [-121.8697, 37.6881], [-121.87007, 37.68773], [-121.87022, 37.68738], [-121.87023, 37.68721], [-121.87084, 37.68715], [-121.87099, 37.68721], [-121.87112, 37.68723], [-121.87206, 37.68809]]]} | Open Access 1 | Nielsen Park | 22755 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 5.222 | Nielsen Park | ||
7602 | 7602 | 7601 | {"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 | Oakhill Park | 23028 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.493 | Oakhill Park | ||
7751 | 7751 | 7750 | {"type": "Polygon", "coordinates": [[[-121.87408, 37.67782], [-121.87375, 37.67788], [-121.8736, 37.6778], [-121.87339, 37.67784], [-121.87336, 37.67786], [-121.8733, 37.67785], [-121.87308, 37.67789], [-121.873, 37.67797], [-121.87297, 37.67802], [-121.87264, 37.67807], [-121.87261, 37.67805], [-121.87226, 37.67811], [-121.87219, 37.67808], [-121.87212, 37.67808], [-121.87182, 37.67814], [-121.87169, 37.67823], [-121.87165, 37.67824], [-121.87145, 37.67841], [-121.87145, 37.67844], [-121.8714, 37.67848], [-121.87136, 37.67849], [-121.87116, 37.67866], [-121.87115, 37.6787], [-121.87087, 37.67893], [-121.86969, 37.67807], [-121.86968, 37.67804], [-121.86969, 37.678], [-121.87006, 37.6777], [-121.87021, 37.67763], [-121.87036, 37.67759], [-121.87076, 37.6776], [-121.87091, 37.67768], [-121.87137, 37.6777], [-121.87152, 37.67761], [-121.87222, 37.67763], [-121.87227, 37.67761], [-121.87233, 37.67764], [-121.87244, 37.67766], [-121.87247, 37.67768], [-121.87277, 37.67769], [-121.8728, 37.67767], [-121.87294, 37.67765], [-121.87301, 37.6776], [-121.87304, 37.67753], [-121.87306, 37.67717], [-121.87303, 37.6771], [-121.87297, 37.67705], [-121.87306, 37.67679], [-121.8733, 37.67682], [-121.87362, 37.67683], [-121.87368, 37.67684], [-121.87372, 37.67687], [-121.87408, 37.67782]]]} | Open Access 1 | Orloff Park | 23205 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 7.691 | Orloff Park | ||
7823 | 7823 | 7822 | {"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 | Owens Plaza Park | 23276 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.554 | Owens Plaza Park | ||
8253 | 8253 | 8252 | {"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 | Pleasanton holding 3 | 23806 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 22.766 | Pleasanton holding 3 | ||
8254 | 8254 | 8253 | {"type": "Polygon", "coordinates": [[[-121.85023, 37.68137], [-121.84817, 37.68139], [-121.84815, 37.67994], [-121.84777, 37.67993], [-121.84787, 37.67968], [-121.8483, 37.67911], [-121.84925, 37.67858], [-121.84933, 37.67753], [-121.84827, 37.67712], [-121.84772, 37.67721], [-121.8468, 37.67765], [-121.84666, 37.67735], [-121.84668, 37.67708], [-121.8464, 37.67694], [-121.84614, 37.67698], [-121.84562, 37.67737], [-121.84513, 37.67742], [-121.84497, 37.67734], [-121.84477, 37.67645], [-121.8468, 37.67577], [-121.85001, 37.67585], [-121.85023, 37.68137]]]} | Open Access 1 | Pleasanton holding 4 | 23807 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 32.779 | Pleasanton holding 4 | ||
10148 | 10148 | 10147 | {"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.88009, 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.88428, 37.68682], [-121.886, 37.6863], [-121.8862, 37.68633]]]} | Open Access 1 | Sutter Creek Gate Park | 26084 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.199 | Sutter Creek Gate Park | ||
10236 | 10236 | 10235 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85568, 37.66323], [-121.85554, 37.66341], [-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 | Tawny Park | 26198 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.543 | Tawny Park | ||
10278 | 10278 | 10277 | {"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 | Tennis & Community Park | 26243 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 15.594 | Tennis & Community Park | ||
10584 | 10584 | 10583 | {"type": "Polygon", "coordinates": [[[-121.87537, 37.65526], [-121.87412, 37.65639], [-121.87282, 37.6555], [-121.87259, 37.65569], [-121.87194, 37.65524], [-121.87305, 37.65422], [-121.87363, 37.65459], [-121.87398, 37.65478], [-121.87442, 37.65495], [-121.87537, 37.65526]]]} | Open Access 1 | Upper Pleasanton Field | 26734 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 8.261 | Upper Pleasanton Field | ||
10601 | 10601 | 10600 | {"type": "Polygon", "coordinates": [[[-121.91517, 37.68433], [-121.91515, 37.68437], [-121.91335, 37.68473], [-121.91323, 37.68479], [-121.91318, 37.68487], [-121.91318, 37.68496], [-121.91443, 37.68894], [-121.91445, 37.68905], [-121.91443, 37.68916], [-121.91438, 37.68925], [-121.91429, 37.68934], [-121.91419, 37.6894], [-121.91403, 37.68946], [-121.91317, 37.68963], [-121.91246, 37.68738], [-121.91254, 37.68713], [-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], [-121.91517, 37.6843], [-121.91517, 37.68433]]]} | Open Access 1 | Val Vista Park | 26757 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 23.868 | Val Vista Park | ||
10639 | 10639 | 10638 | {"type": "Polygon", "coordinates": [[[-121.91033, 37.67583], [-121.90964, 37.67707], [-121.90929, 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 | Valley Trails Park | 26803 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 13.053 | Valley Trails Park | ||
10844 | 10844 | 10843 | {"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 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.595 | Veterans Plaza | ||
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.85036, 37.65762], [-121.84964, 37.65799], [-121.84955, 37.65798], [-121.84914, 37.65787], [-121.84905, 37.6582], [-121.84875, 37.65815], [-121.84864, 37.65811], [-121.84855, 37.65812], [-121.84834, 37.65768], [-121.84763, 37.65711], [-121.84817, 37.65719], [-121.8486, 37.65721], [-121.84898, 37.65717], [-121.84946, 37.65708], [-121.84975, 37.65705], [-121.84979, 37.65744], [-121.85021, 37.65742], [-121.85036, 37.65762]]]} | Open Access 1 | Vintage Hills Park | 27146 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.866 | Vintage Hills Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);