superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 20 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10938 | 10938 | 10937 | {"type": "Polygon", "coordinates": [[[-122.35249, 37.92695], [-122.35223, 37.92695], [-122.35223, 37.92668], [-122.35249, 37.92668], [-122.35249, 37.92695]]]} | Open Access 1 | Virginia Play Lot | 27159 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.167 | Virginia Play Lot | ||
4698 | 4698 | 4697 | {"type": "Polygon", "coordinates": [[[-122.34306, 37.9484], [-122.34271, 37.94841], [-122.34271, 37.94814], [-122.34305, 37.94814], [-122.34306, 37.9484]]]} | Open Access 1 | Humphrey Play Lot | 20151 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.224 | Humphrey Play Lot | ||
5723 | 5723 | 5722 | {"type": "Polygon", "coordinates": [[[-122.32472, 37.94789], [-122.32433, 37.94801], [-122.32421, 37.94775], [-122.32459, 37.94764], [-122.32472, 37.94789]]]} | Open Access 1 | Kern Playlot | 20630 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.274 | Kern Playlot | ||
4927 | 4927 | 4926 | {"type": "Polygon", "coordinates": [[[-122.39456, 37.92869], [-122.3943, 37.9289], [-122.39391, 37.92865], [-122.39417, 37.92843], [-122.39456, 37.92869]]]} | Open Access 1 | Harrison Mini Park | 19700 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.359 | Harrison MP | ||
6940 | 6940 | 6939 | {"type": "Polygon", "coordinates": [[[-122.31198, 37.91187], [-122.31137, 37.91213], [-122.31113, 37.91177], [-122.31143, 37.91164], [-122.31163, 37.91193], [-122.31194, 37.91181], [-122.31198, 37.91187]]]} | Open Access 1 | Mendocino Park | 22150 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.4 | Mendocino Park | ||
7151 | 7151 | 7150 | {"type": "Polygon", "coordinates": [[[-122.32076, 37.91089], [-122.32036, 37.9111], [-122.32004, 37.91085], [-122.32053, 37.91061], [-122.32076, 37.91089]]]} | Open Access 1 | Monterey Playlot | 22430 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.438 | Monterey Playlot | ||
550 | 550 | 549 | {"type": "Polygon", "coordinates": [[[-122.36227, 37.94055], [-122.36227, 37.94103], [-122.36188, 37.94102], [-122.36188, 37.94054], [-122.36227, 37.94055]]]} | Open Access 1 | Elm Park | 18595 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.448 | Elm Park | ||
1392 | 1392 | 1391 | {"type": "Polygon", "coordinates": [[[-122.3226, 37.92415], [-122.32259, 37.92453], [-122.32253, 37.92457], [-122.32213, 37.92457], [-122.32209, 37.92453], [-122.32209, 37.92415], [-122.32215, 37.9241], [-122.32254, 37.9241], [-122.3226, 37.92415]]]} | Open Access 1 | Abraham Braxton Park | 15238 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.568 | Abraham Braxton Park | ||
10036 | 10036 | 10035 | {"type": "Polygon", "coordinates": [[[-122.36656, 37.93894], [-122.36623, 37.93894], [-122.36622, 37.93901], [-122.36587, 37.93901], [-122.36587, 37.9385], [-122.36656, 37.9385], [-122.36656, 37.93894]]]} | Open Access 1 | Stuart Playground | 25935 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.794 | Stuart Playground | ||
10800 | 10800 | 10799 | {"type": "Polygon", "coordinates": [[[-122.35897, 37.93446], [-122.35888, 37.93458], [-122.35876, 37.93467], [-122.35862, 37.9347], [-122.35847, 37.93468], [-122.35833, 37.93462], [-122.35805, 37.93439], [-122.35804, 37.93416], [-122.35896, 37.93416], [-122.35897, 37.93446]]]} | Open Access 1 | Veteran's Memorial Park | 27013 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.984 | Veteran's Memorial Park | ||
638 | 638 | 637 | {"type": "Polygon", "coordinates": [[[-122.3401, 37.94269], [-122.33896, 37.94269], [-122.33861, 37.9426], [-122.33865, 37.94242], [-122.33889, 37.94235], [-122.34009, 37.94235], [-122.3401, 37.94269]]]} | Open Access 1 | Burg Park | 16517 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1.147 | Burg Park | ||
8275 | 8275 | 8274 | {"type": "Polygon", "coordinates": [[[-122.41635, 37.94604], [-122.41628, 37.94614], [-122.41509, 37.94594], [-122.41481, 37.94585], [-122.41211, 37.94404], [-122.41218, 37.94401], [-122.41487, 37.94575], [-122.41517, 37.94583], [-122.41548, 37.94587], [-122.41568, 37.94584], [-122.41635, 37.94604]]]} | Open Access 1 | Point Molate Beach Park | 23855 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1.192 | Point Molate Beach Park | ||
2773 | 2773 | 2772 | {"type": "Polygon", "coordinates": [[[-122.30787, 37.90159], [-122.30773, 37.90176], [-122.30731, 37.90245], [-122.30705, 37.9025], [-122.30678, 37.90164], [-122.30779, 37.90148], [-122.30787, 37.90159]]]} | Open Access 1 | Central Park | 17057 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1.506 | Central Park | ||
3312 | 3312 | 3311 | {"type": "Polygon", "coordinates": [[[-122.32571, 37.91578], [-122.32449, 37.91607], [-122.32422, 37.91565], [-122.32452, 37.91545], [-122.32473, 37.91558], [-122.32522, 37.91525], [-122.32571, 37.91578]]]} | Open Access 1 | Crescent Park | 17795 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1.518 | Crescent Park | ||
1914 | 1914 | 1913 | {"type": "Polygon", "coordinates": [[[-122.35546, 37.94732], [-122.3539, 37.94732], [-122.3539, 37.94677], [-122.35545, 37.94677], [-122.35546, 37.94732]]]} | Open Access 1 | Belding-Garcia Park | 15966 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.056 | Belding-Garcia Park | ||
8233 | 8233 | 8232 | {"type": "Polygon", "coordinates": [[[-122.32541, 37.92277], [-122.32536, 37.92398], [-122.32459, 37.92398], [-122.32469, 37.92347], [-122.32472, 37.92316], [-122.32465, 37.92275], [-122.32541, 37.92277]]]} | Open Access 1 | Plaza One Park | 23780 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.1 | Plaza One Park | ||
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-122.34496, 37.94599], [-122.34331, 37.946], [-122.34329, 37.94522], [-122.34411, 37.94522], [-122.34411, 37.94553], [-122.34415, 37.94561], [-122.34422, 37.94565], [-122.34432, 37.94566], [-122.34435, 37.9457], [-122.34442, 37.94572], [-122.34448, 37.94571], [-122.34457, 37.94567], [-122.34495, 37.94567], [-122.34496, 37.94599]]]} | Open Access 1 | Wendell Park | 27345 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.186 | Wendell Park | ||
7944 | 7944 | 7943 | {"type": "Polygon", "coordinates": [[[-122.35362, 37.98233], [-122.35355, 37.98332], [-122.3531, 37.98328], [-122.35252, 37.98313], [-122.35277, 37.98227], [-122.35362, 37.98233]]]} | Open Access 1 | Parchester Park | 23416 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.212 | Parchester Park | ||
9601 | 9601 | 9600 | {"type": "Polygon", "coordinates": [[[-122.36073, 37.91008], [-122.3591, 37.91005], [-122.35912, 37.90945], [-122.36066, 37.90945], [-122.36073, 37.91008]]]} | Open Access 1 | Sheridan Point Park | 25394 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.347 | Sheridan Point Park | ||
7037 | 7037 | 7036 | {"type": "Polygon", "coordinates": [[[-122.32224, 37.93726], [-122.32192, 37.93762], [-122.3213, 37.93766], [-122.32099, 37.93777], [-122.32019, 37.93753], [-122.31996, 37.93752], [-122.31993, 37.93731], [-122.32079, 37.93728], [-122.32174, 37.93695], [-122.32224, 37.93726]]]} | Open Access 1 | Mira Vista Park | 22279 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.382 | Mira Vista 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]);