superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 176
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 178
MNG_AGENCY 1
- Sacramento, City of · 178 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10075 | 10075 | 10074 | {"type": "Polygon", "coordinates": [[[-121.53615, 38.64507], [-121.53571, 38.64508], [-121.53503, 38.64517], [-121.53497, 38.64516], [-121.53493, 38.64514], [-121.5347, 38.6449], [-121.53466, 38.64487], [-121.53466, 38.64452], [-121.53611, 38.64454], [-121.53615, 38.64458], [-121.53615, 38.64507]]]} | Open Access 1 | Sundance Park | 25987 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.989 | Sundance Park | ||
10017 | 10017 | 10016 | {"type": "Polygon", "coordinates": [[[-121.48395, 38.62283], [-121.48381, 38.62283], [-121.48279, 38.62304], [-121.4823, 38.62309], [-121.48181, 38.62308], [-121.48134, 38.623], [-121.48107, 38.62291], [-121.48121, 38.62256], [-121.48286, 38.62257], [-121.48354, 38.62242], [-121.48395, 38.62239], [-121.48395, 38.62283]]]} | Open Access 1 | Strauch Park | 25912 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.193 | Strauch Park | ||
9961 | 9961 | 9960 | {"type": "Polygon", "coordinates": [[[-121.48269, 38.48528], [-121.48244, 38.48529], [-121.48206, 38.48546], [-121.48183, 38.48538], [-121.48151, 38.4855], [-121.481, 38.48554], [-121.48048, 38.48553], [-121.48046, 38.48472], [-121.48058, 38.48472], [-121.48059, 38.48463], [-121.48062, 38.48459], [-121.48097, 38.48455], [-121.48121, 38.48449], [-121.48139, 38.48443], [-121.48174, 38.48427], [-121.4819, 38.48422], [-121.48217, 38.48419], [-121.48268, 38.48419], [-121.48269, 38.48528]]]} | Open Access 1 | Steve Jones Park | 25840 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.718 | Steve Jones 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 | ||
9834 | 9834 | 9833 | {"type": "Polygon", "coordinates": [[[-121.50477, 38.5675], [-121.50345, 38.57057], [-121.50108, 38.56994], [-121.5024, 38.56688], [-121.50243, 38.56686], [-121.50473, 38.56747], [-121.50477, 38.5675]]]} | Open Access 1 | Southside Park | 25699 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 19.476 | Southside Park | ||
9806 | 9806 | 9805 | {"type": "Polygon", "coordinates": [[[-121.50204, 38.62022], [-121.49848, 38.62022], [-121.49847, 38.62001], [-121.49806, 38.62001], [-121.49806, 38.6179], [-121.49808, 38.61787], [-121.49813, 38.61785], [-121.4987, 38.61784], [-121.49919, 38.61778], [-121.49958, 38.61772], [-121.49996, 38.61763], [-121.50033, 38.61753], [-121.50078, 38.61737], [-121.50142, 38.61707], [-121.50158, 38.61727], [-121.50158, 38.61745], [-121.50188, 38.61843], [-121.50201, 38.61891], [-121.50207, 38.61928], [-121.50209, 38.61953], [-121.50209, 38.62], [-121.50204, 38.62022]]]} | Open Access 1 | South Natomas Community Park | 25667 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 24.224 | South Natomas Community Park | ||
9757 | 9757 | 9756 | {"type": "Polygon", "coordinates": [[[-121.53577, 38.49612], [-121.53493, 38.49616], [-121.53492, 38.49438], [-121.53534, 38.49435], [-121.53529, 38.49366], [-121.53558, 38.49365], [-121.53577, 38.49612]]]} | Open Access 1 | Sojourner Truth Park | 25592 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.786 | Sojourner Truth Park | ||
9718 | 9718 | 9717 | {"type": "Polygon", "coordinates": [[[-121.52421, 38.63228], [-121.52415, 38.63234], [-121.52343, 38.63269], [-121.52336, 38.63271], [-121.52332, 38.63268], [-121.52264, 38.63201], [-121.52263, 38.63196], [-121.52266, 38.63193], [-121.52337, 38.63149], [-121.52343, 38.63147], [-121.52394, 38.63197], [-121.52421, 38.63228]]]} | Open Access 1 | Skylark Park Site | 25537 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.524 | Skylark Park Site | ||
9713 | 9713 | 9712 | {"type": "Polygon", "coordinates": [[[-121.44321, 38.50131], [-121.44203, 38.50133], [-121.442, 38.50019], [-121.44201, 38.50015], [-121.44205, 38.50012], [-121.44243, 38.50001], [-121.44282, 38.49984], [-121.44317, 38.49975], [-121.44321, 38.50131]]]} | Open Access 1 | Sky Park | 25532 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.896 | Sky Park | ||
9660 | 9660 | 9659 | {"type": "MultiPolygon", "coordinates": [[[[-121.44531, 38.55478], [-121.44524, 38.55494], [-121.44395, 38.55458], [-121.44361, 38.55445], [-121.44357, 38.55443], [-121.44355, 38.55439], [-121.44357, 38.55436], [-121.44361, 38.55436], [-121.44391, 38.5544], [-121.44531, 38.55478]]], [[[-121.44712, 38.55534], [-121.44711, 38.55537], [-121.44708, 38.55539], [-121.44675, 38.55535], [-121.4454, 38.55498], [-121.44547, 38.55483], [-121.44679, 38.55519], [-121.44703, 38.55528], [-121.4471, 38.55531], [-121.44712, 38.55534]]]]} | Open Access 1 | Sierra Vista Park | 25469 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.304 | Sierra Vista Park | ||
9635 | 9635 | 9634 | {"type": "Polygon", "coordinates": [[[-121.48279, 38.554], [-121.48176, 38.55372], [-121.48174, 38.55259], [-121.48273, 38.55257], [-121.48279, 38.554]]]} | Open Access 1 | Sierra 2 Park | 25443 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.092 | Sierra 2 Park | ||
9612 | 9612 | 9611 | {"type": "Polygon", "coordinates": [[[-121.53661, 38.60557], [-121.53659, 38.60561], [-121.5363, 38.60571], [-121.53578, 38.60588], [-121.53557, 38.60592], [-121.53531, 38.60596], [-121.53528, 38.60562], [-121.53516, 38.60525], [-121.53586, 38.60506], [-121.53639, 38.60489], [-121.53643, 38.60495], [-121.5364, 38.60499], [-121.53641, 38.60504], [-121.53643, 38.60509], [-121.53649, 38.60514], [-121.53653, 38.60523], [-121.53656, 38.60544], [-121.53661, 38.60557]]]} | Open Access 1 | Shorebird Park | 25423 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.344 | Shorebird Park | ||
9608 | 9608 | 9607 | {"type": "Polygon", "coordinates": [[[-121.5329, 38.47493], [-121.53289, 38.4756], [-121.53283, 38.47574], [-121.53284, 38.4758], [-121.53263, 38.47635], [-121.53264, 38.47648], [-121.5326, 38.4767], [-121.53225, 38.47664], [-121.53176, 38.4766], [-121.53179, 38.47629], [-121.53198, 38.47578], [-121.53224, 38.4753], [-121.53224, 38.47491], [-121.5329, 38.47493]]]} | Open Access 1 | Shore Park | 25418 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.25 | Shore Park | ||
9575 | 9575 | 9574 | {"type": "Polygon", "coordinates": [[[-121.41796, 38.45057], [-121.41795, 38.45252], [-121.41372, 38.45254], [-121.41369, 38.45135], [-121.41404, 38.45133], [-121.41402, 38.45103], [-121.41368, 38.45103], [-121.41367, 38.4506], [-121.41796, 38.45057]]]} | Open Access 1 | Shasta Community Park Site | 25368 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 19.563 | Shasta Community Park Site | ||
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 | ||
9207 | 9207 | 9206 | {"type": "Polygon", "coordinates": [[[-121.53606, 38.63461], [-121.53596, 38.63488], [-121.53508, 38.63486], [-121.53466, 38.63481], [-121.53425, 38.63471], [-121.53391, 38.6346], [-121.53349, 38.63441], [-121.5332, 38.63424], [-121.53245, 38.63373], [-121.5321, 38.63354], [-121.53166, 38.63337], [-121.5312, 38.63325], [-121.53123, 38.63315], [-121.53128, 38.63315], [-121.5329, 38.63256], [-121.53289, 38.62786], [-121.53361, 38.62786], [-121.53367, 38.6278], [-121.53477, 38.62836], [-121.53478, 38.63459], [-121.53606, 38.63461]]]} | Open Access 1 | San Juan Reservoir Park | 24921 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 32.925 | San Juan Reservoir Park | ||
9127 | 9127 | 9126 | {"type": "Polygon", "coordinates": [[[-121.52884, 38.6071], [-121.52883, 38.60764], [-121.52883, 38.60879], [-121.52846, 38.6085], [-121.52828, 38.60849], [-121.5282, 38.60817], [-121.5282, 38.60786], [-121.52828, 38.60748], [-121.52828, 38.60709], [-121.52884, 38.6071]]]} | Open Access 1 | Sally Hudson Park | 24805 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.109 | Sally Hudson Park | ||
9120 | 9120 | 9119 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | University Park | 26687 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.716 | University Park | ||
9107 | 9107 | 9106 | {"type": "Polygon", "coordinates": [[[-121.51621, 38.53667], [-121.51548, 38.53708], [-121.51409, 38.53818], [-121.51411, 38.53822], [-121.51314, 38.53912], [-121.51236, 38.54029], [-121.51175, 38.54103], [-121.51167, 38.54115], [-121.51161, 38.54115], [-121.51156, 38.54127], [-121.5113, 38.54174], [-121.51126, 38.54192], [-121.51118, 38.5421], [-121.51111, 38.54232], [-121.51083, 38.54287], [-121.51059, 38.54344], [-121.51055, 38.54362], [-121.51054, 38.54384], [-121.51047, 38.54423], [-121.51048, 38.54436], [-121.51045, 38.54455], [-121.51046, 38.54484], [-121.51054, 38.54526], [-121.51054, 38.54537], [-121.5105, 38.54548], [-121.51051, 38.54555], [-121.51053, 38.54563], [-121.51059, 38.54571], [-121.51067, 38.54603], [-121.51066, 38.54613], [-121.5106, 38.54622], [-121.51073, 38.54632], [-121.51076, 38.54636], [-121.51078, 38.54648], [-121.51086, 38.54677], [-121.51088, 38.54703], [-121.51098, 38.54723], [-121.51104, 38.54753], [-121.51103, 38.54759], [-121.51095, 38.54764], [-121.51085, 38.54763], [-121.51078, 38.54757], [-121.5107, 38.54754], [-121.51049, 38.54752], [-121.51041, 38.54755], [-121.51031, 38.54764], [-121.51034, 38.54794], [-121.51041, 38.54828], [-121.5105, 38.54851], [-121.51074, 38.54849], [-121.51072, 38.54793], [-121.51114, 38.54779], [-121.51175, 38.54909], [-121.51177, 38.5493], [-121.51179, 38.54932], [-121.51187, 38.54931], [-121.51193, 38.54954], [-121.51201, 38.54996], [-121.51191, 38.55041], [-121.51191, 38.55056], [-121.51194, 38.55064], [-121.51201, 38.55071], [-121.51221, 38.55081], [-121.51231, 38.55089], [-121.51237, 38.55097], [-121.5124, 38.55105], [-121.51254, 38.55165], [-121.51257, 38.55203], [-121.5126, 38.55213], [-121.5127, 38.5523], [-121.51274, 38.55241], [-121.51278, 38.55279], [-121.51307, 38.55344], [-121.51323, 38.55394], [-121.51339, 38.55419], [-121.5134, 38.55431], [-121.51362, 38.55502], [-121.51369, 38.55534], [-121.5139, 38.55594], [-121.51392, 38.55606], [-121.51398, 38.55618], [-121.51408, 38.55658], [-121.5142, 38.55687], [-121.51426, 38.55714], [-121.51431, 38.55723], [-121.51438, 38.55743], [-121.51444, 38.55749], [-121.51446, 38.55756], [-121.51429, 38.55754], [-121.51428, 38.55756], [-121.51446, 38.55808], [-121.51476, 38.55866], [-121.51469, 38.55865], [-121.51468, 38.55866], [-121.51491, 38.55911], [-121.51466, 38.55917], [-121.51418, 38.55818], [-121.51385, 38.55738], [-121.51371, 38.55697], [-121.51354, 38.55635], [-121.51323, 38.55533], [-121.513, 38.55454], [-121.51268, 38.55367], [-121.51232, 38.55289], [-121.51149, 38.55139], [-121.51101, 38.55044], [-121.51065, 38.54957], [-121.51024, 38.54848], [-121.5101, 38.54796], [-121.51003, 38.54762], [-121.51001, 38.54721], [-121.51003, 38.54681], [-121.50998, 38.54643], [-121.50994, 38.54622], [-121.50987, 38.54601], [-121.50978, 38.5458], [-121.50966, 38.54558], [-121.50969, 38.54514], [-121.50971, 38.54516], [-121.50972, 38.54515], [-121.50968, 38.54493], [-121.50967, 38.5446], [-121.50972, 38.54423], [-121.50983, 38.54392], [-121.51135, 38.54107], [-121.5113, 38.54104], [-121.51147, 38.54082], [-121.5115, 38.54082], [-121.5121, 38.54011], [-121.51245, 38.53953], [-121.5128, 38.53904], [-121.51443, 38.53752], [-121.51488, 38.53719], [-121.51533, 38.53693], [-121.51587, 38.53642], [-121.51621, 38.53667]]]} | Open Access 1 | Sacramento River Parkway Land Park Area | 24772 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 33.348 | Sacramento River Parkway Land Park Area | ||
9038 | 9038 | 9037 | {"type": "Polygon", "coordinates": [[[-121.44468, 38.48209], [-121.44336, 38.48288], [-121.44213, 38.48157], [-121.44206, 38.48156], [-121.44184, 38.48133], [-121.44182, 38.48127], [-121.44186, 38.48123], [-121.44313, 38.48048], [-121.44468, 38.48209]]]} | Open Access 1 | Roy Nielsen Park | 24711 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.013 | Roy Nielsen 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]);