superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14869 | 14869 | 14868 | {"type": "Polygon", "coordinates": [[[-121.5578, 38.65543], [-121.55595, 38.65546], [-121.55593, 38.65492], [-121.55599, 38.65492], [-121.55604, 38.65499], [-121.55611, 38.65503], [-121.55631, 38.65504], [-121.55638, 38.65503], [-121.55644, 38.65499], [-121.55649, 38.65494], [-121.5565, 38.65489], [-121.55648, 38.65446], [-121.55643, 38.65405], [-121.55633, 38.65365], [-121.55621, 38.65325], [-121.55595, 38.65267], [-121.55548, 38.65187], [-121.55526, 38.65142], [-121.55486, 38.65042], [-121.5548, 38.6502], [-121.55477, 38.64995], [-121.55469, 38.64975], [-121.55457, 38.64959], [-121.55441, 38.64946], [-121.55427, 38.64938], [-121.55407, 38.64929], [-121.55396, 38.64921], [-121.55387, 38.64911], [-121.55382, 38.64901], [-121.5538, 38.64891], [-121.5538, 38.6488], [-121.55395, 38.64848], [-121.55398, 38.64826], [-121.55396, 38.64769], [-121.55393, 38.64752], [-121.55384, 38.64732], [-121.55333, 38.64648], [-121.55242, 38.64482], [-121.55236, 38.64477], [-121.55228, 38.64475], [-121.5522, 38.64476], [-121.55206, 38.64481], [-121.552, 38.64485], [-121.55196, 38.6449], [-121.55196, 38.64494], [-121.55197, 38.645], [-121.55192, 38.64502], [-121.55163, 38.64479], [-121.55185, 38.64462], [-121.55194, 38.64452], [-121.55201, 38.64437], [-121.55204, 38.64422], [-121.55201, 38.64405], [-121.55188, 38.64377], [-121.55178, 38.64364], [-121.55165, 38.64352], [-121.55141, 38.6434], [-121.55044, 38.64309], [-121.55027, 38.643], [-121.55022, 38.64299], [-121.55015, 38.643], [-121.55009, 38.64304], [-121.55005, 38.64313], [-121.5499, 38.64332], [-121.54975, 38.64346], [-121.54958, 38.64358], [-121.54937, 38.64369], [-121.54921, 38.64375], [-121.549, 38.6438], [-121.5488, 38.64383], [-121.54843, 38.64384], [-121.5482, 38.64381], [-121.54801, 38.64377], [-121.54765, 38.64362], [-121.54733, 38.64343], [-121.54724, 38.64336], [-121.54713, 38.64334], [-121.54705, 38.64337], [-121.547, 38.64344], [-121.54692, 38.64351], [-121.54636, 38.64384], [-121.5459, 38.64417], [-121.54571, 38.64427], [-121.54544, 38.64432], [-121.54433, 38.64434], [-121.54408, 38.64439], [-121.54399, 38.64436], [-121.54382, 38.64412], [-121.54359, 38.6439], [-121.54336, 38.64375], [-121.54305, 38.6436], [-121.54074, 38.64294], [-121.54036, 38.64288], [-121.53986, 38.64287], [-121.53984, 38.64283], [-121.53984, 38.64233], [-121.54182, 38.643], [-121.54315, 38.64333], [-121.54372, 38.64357], [-121.54509, 38.64385], [-121.54629, 38.6436], [-121.54632, 38.64308], [-121.54656, 38.64288], [-121.54706, 38.64294], [-121.54799, 38.64325], [-121.54852, 38.64336], [-121.54913, 38.64326], [-121.54949, 38.64294], [-121.5498, 38.64235], [-121.55017, 38.64227], [-121.55094, 38.6425], [-121.5522, 38.64321], [-121.5531, 38.6451], [-121.5538, 38.64639], [-121.5547, 38.64791], [-121.5545, 38.64835], [-121.55498, 38.64936], [-121.55531, 38.65028], [-121.55584, 38.65162], [-121.55617, 38.65217], [-121.55665, 38.6529], [-121.5568, 38.65357], [-121.55703, 38.65396], [-121.5578, 38.65543]]]} | Open Access 1 | Fisherman's Lake Parkway and Open Space | 18922 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 33.72 | Fisherman's Lake Parkway and OS | ||
10154 | 10154 | 10153 | {"type": "Polygon", "coordinates": [[[-121.55006, 38.64762], [-121.5497, 38.64762], [-121.5496, 38.64772], [-121.54954, 38.6477], [-121.54901, 38.64771], [-121.54896, 38.64772], [-121.54885, 38.64763], [-121.54849, 38.64763], [-121.54847, 38.6466], [-121.5485, 38.64646], [-121.54858, 38.64634], [-121.54874, 38.6462], [-121.54891, 38.64608], [-121.54904, 38.64602], [-121.54922, 38.646], [-121.54938, 38.646], [-121.54954, 38.64605], [-121.54965, 38.6461], [-121.54987, 38.64625], [-121.54998, 38.64638], [-121.55002, 38.64645], [-121.55005, 38.64655], [-121.55006, 38.64762]]]} | Open Access 1 | Swainson's Hawk Park Site | 26091 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.696 | Swainson's Hawk Park Site | ||
29 | 29 | 28 | {"type": "Polygon", "coordinates": [[[-121.55005, 38.66466], [-121.54694, 38.6659], [-121.54688, 38.66578], [-121.54685, 38.66564], [-121.54679, 38.66557], [-121.54682, 38.66554], [-121.54681, 38.66549], [-121.5491, 38.66457], [-121.55005, 38.66416], [-121.55005, 38.66466]]]} | Open Access 1 | Egret Park Open Space | 18469 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.603 | Egret Park OS | ||
6134 | 6134 | 6133 | {"type": "Polygon", "coordinates": [[[-121.54983, 38.50739], [-121.54826, 38.50827], [-121.54806, 38.50804], [-121.54827, 38.5079], [-121.54789, 38.50745], [-121.54906, 38.50678], [-121.54983, 38.50739]]]} | Open Access 1 | Lewis Park | 21193 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.312 | Lewis Park | ||
2039 | 2039 | 2038 | {"type": "Polygon", "coordinates": [[[-121.54805, 38.65366], [-121.54371, 38.65373], [-121.54371, 38.65373], [-121.54373, 38.65347], [-121.54381, 38.6532], [-121.5441, 38.65269], [-121.54414, 38.65266], [-121.54417, 38.65266], [-121.54447, 38.65269], [-121.54786, 38.65266], [-121.54803, 38.65268], [-121.54805, 38.65366]]]} | Open Access 1 | Blackbird Park Site | 16141 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.175 | Blackbird Park Site | ||
11019 | 11019 | 11018 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | Warbler Park Site | 27253 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.086 | Warbler Park Site | ||
11135 | 11135 | 11134 | {"type": "Polygon", "coordinates": [[[-121.54712, 38.65619], [-121.5467, 38.65619], [-121.5466, 38.65618], [-121.54594, 38.65752], [-121.5455, 38.65742], [-121.5451, 38.65737], [-121.54468, 38.65737], [-121.54412, 38.65744], [-121.54408, 38.65743], [-121.54405, 38.65739], [-121.54394, 38.65712], [-121.54385, 38.6568], [-121.54377, 38.65637], [-121.54375, 38.65586], [-121.54377, 38.65583], [-121.54383, 38.6558], [-121.5468, 38.65578], [-121.54678, 38.65585], [-121.54678, 38.65586], [-121.54711, 38.65586], [-121.54712, 38.65619]]]} | Open Access 1 | Westlake Community Park | 27401 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.227 | Westlake Community Park | ||
3873 | 3873 | 3872 | {"type": "Polygon", "coordinates": [[[-121.54694, 38.6659], [-121.54415, 38.66702], [-121.54415, 38.66693], [-121.54408, 38.66682], [-121.54401, 38.66683], [-121.5437, 38.66634], [-121.54462, 38.66597], [-121.54509, 38.66576], [-121.54527, 38.66602], [-121.54537, 38.66599], [-121.54548, 38.66591], [-121.54555, 38.66582], [-121.54559, 38.66571], [-121.54565, 38.66571], [-121.54566, 38.66579], [-121.54573, 38.66585], [-121.5458, 38.66587], [-121.54588, 38.66586], [-121.54632, 38.66568], [-121.54635, 38.66565], [-121.54637, 38.6656], [-121.54635, 38.66552], [-121.54673, 38.66552], [-121.54681, 38.66549], [-121.54683, 38.66554], [-121.5468, 38.66557], [-121.54685, 38.66564], [-121.54688, 38.66578], [-121.54694, 38.6659]]]} | Open Access 1 | Egret Park | 18467 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.721 | Egret Park | ||
7461 | 7461 | 7460 | {"type": "Polygon", "coordinates": [[[-121.54627, 38.51423], [-121.54497, 38.5146], [-121.54474, 38.51413], [-121.54556, 38.51393], [-121.54592, 38.51391], [-121.54607, 38.51387], [-121.54627, 38.51423]]]} | Open Access 1 | North Point Way River Access | 22847 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.531 | North Point Way River Access | ||
9262 | 9262 | 9261 | {"type": "Polygon", "coordinates": [[[-121.54546, 38.59936], [-121.54545, 38.59952], [-121.54517, 38.59959], [-121.54484, 38.59969], [-121.54458, 38.59979], [-121.54429, 38.59994], [-121.54083, 38.60212], [-121.54085, 38.60157], [-121.54092, 38.60144], [-121.54138, 38.60116], [-121.54185, 38.60075], [-121.54239, 38.60014], [-121.54291, 38.59938], [-121.54318, 38.59929], [-121.54346, 38.59928], [-121.54382, 38.59914], [-121.54408, 38.59894], [-121.54425, 38.59872], [-121.54453, 38.59892], [-121.54454, 38.59899], [-121.54482, 38.5989], [-121.54507, 38.59937], [-121.54546, 38.59936]]]} | Open Access 1 | Sand Cove Park | 25011 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.847 | Sand Cove Park | ||
4479 | 4479 | 4478 | {"type": "Polygon", "coordinates": [[[-121.54386, 38.47907], [-121.5413, 38.48076], [-121.53988, 38.47961], [-121.53967, 38.47947], [-121.54192, 38.47755], [-121.54295, 38.47837], [-121.54336, 38.47881], [-121.54386, 38.47907]]]} | Open Access 1 | Garcia Bend Park | 19191 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.6 | Garcia Bend Park | ||
8766 | 8766 | 8765 | {"type": "Polygon", "coordinates": [[[-121.54376, 38.62959], [-121.54373, 38.62962], [-121.54368, 38.62964], [-121.54122, 38.62964], [-121.54118, 38.6296], [-121.54117, 38.62886], [-121.5412, 38.62882], [-121.54124, 38.62881], [-121.54371, 38.6288], [-121.54376, 38.62885], [-121.54376, 38.62959]]]} | Open Access 1 | River View Park | 24426 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.146 | River View Park | ||
8625 | 8625 | 8624 | {"type": "Polygon", "coordinates": [[[-121.54356, 38.48812], [-121.54349, 38.48819], [-121.54354, 38.48845], [-121.54195, 38.4886], [-121.54191, 38.48828], [-121.54186, 38.48825], [-121.5419, 38.48819], [-121.5419, 38.48814], [-121.54187, 38.48761], [-121.54185, 38.48755], [-121.54181, 38.48751], [-121.54186, 38.48746], [-121.5418, 38.48678], [-121.54323, 38.48662], [-121.54334, 38.48721], [-121.54329, 38.48726], [-121.54329, 38.48732], [-121.54331, 38.48736], [-121.54335, 38.48739], [-121.54345, 38.48794], [-121.54354, 38.48799], [-121.54352, 38.48806], [-121.54356, 38.48812]]]} | Open Access 1 | Reginald Renfree Park | 24274 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.704 | Reginald Renfree Park | ||
4099 | 4099 | 4098 | {"type": "Polygon", "coordinates": [[[-121.54328, 38.50023], [-121.54324, 38.50055], [-121.54269, 38.50051], [-121.54277, 38.50022], [-121.54289, 38.50019], [-121.54328, 38.50023]]]} | Open Access 1 | Evelyn Dutra Park | 18759 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.413 | Evelyn Dutra Park | ||
2860 | 2860 | 2859 | {"type": "Polygon", "coordinates": [[[-121.54287, 38.48454], [-121.54187, 38.48493], [-121.54142, 38.48517], [-121.54135, 38.48511], [-121.54076, 38.48491], [-121.54058, 38.48492], [-121.54054, 38.48497], [-121.54054, 38.48505], [-121.54053, 38.48508], [-121.54043, 38.48514], [-121.54036, 38.48515], [-121.54031, 38.4851], [-121.54038, 38.48394], [-121.54034, 38.48386], [-121.54044, 38.48383], [-121.54282, 38.4844], [-121.54287, 38.48454]]]} | Open Access 1 | Charter Pointe Park | 17152 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.869 | Charter Pointe Park | ||
3156 | 3156 | 3155 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48581], [-121.54226, 38.48585], [-121.54184, 38.48591], [-121.5417, 38.48591], [-121.54162, 38.48595], [-121.54159, 38.486], [-121.54102, 38.48588], [-121.54172, 38.48551], [-121.54172, 38.48543], [-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-121.54229, 38.48581]]]} | Open Access 1 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.159 | Cool Wind Way Park | ||
9850 | 9850 | 9849 | {"type": "Polygon", "coordinates": [[[-121.54197, 38.66281], [-121.54193, 38.66283], [-121.54147, 38.66283], [-121.54133, 38.6628], [-121.5412, 38.66285], [-121.54111, 38.66281], [-121.54111, 38.66195], [-121.54118, 38.66195], [-121.54127, 38.66193], [-121.54168, 38.66193], [-121.54181, 38.66197], [-121.54191, 38.66197], [-121.54197, 38.662], [-121.54197, 38.66281]]]} | Open Access 1 | Sparrow Park | 25717 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.809 | Sparrow Park | ||
8756 | 8756 | 8755 | {"type": "Polygon", "coordinates": [[[-121.54063, 38.60843], [-121.5401, 38.60923], [-121.54001, 38.60924], [-121.53949, 38.61001], [-121.53938, 38.60997], [-121.53958, 38.60968], [-121.53966, 38.60952], [-121.5397, 38.60948], [-121.53976, 38.60931], [-121.53978, 38.60908], [-121.53976, 38.60885], [-121.53969, 38.60861], [-121.53954, 38.60834], [-121.53938, 38.60817], [-121.53938, 38.6081], [-121.53953, 38.608], [-121.54036, 38.60834], [-121.54039, 38.60833], [-121.54046, 38.60839], [-121.54055, 38.6084], [-121.54063, 38.60843]]]} | Open Access 1 | River Otter Park | 24415 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.115 | River Otter Park | ||
6532 | 6532 | 6531 | {"type": "Polygon", "coordinates": [[[-121.53719, 38.67975], [-121.53719, 38.68044], [-121.53664, 38.68044], [-121.53429, 38.68025], [-121.53425, 38.68023], [-121.53422, 38.6802], [-121.53426, 38.67993], [-121.53434, 38.67958], [-121.53627, 38.67975], [-121.53719, 38.67975]]]} | Open Access 1 | Magnolia Park Site | 21684 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.68 | Magnolia Park Site | ||
7186 | 7186 | 7185 | {"type": "Polygon", "coordinates": [[[-121.53713, 38.65115], [-121.53714, 38.65221], [-121.53713, 38.65224], [-121.53708, 38.65226], [-121.53664, 38.65228], [-121.53536, 38.65229], [-121.53531, 38.65226], [-121.53527, 38.65204], [-121.53507, 38.65134], [-121.53509, 38.65128], [-121.53513, 38.65127], [-121.53597, 38.65116], [-121.5365, 38.65112], [-121.53707, 38.65112], [-121.53713, 38.65115]]]} | Open Access 1 | Quail Park | 24046 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.192 | Quail 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]);