units_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)
Suggested facets: YR_EST
DES_TP 5
- Local Park 35
- Local Recreation Area 6
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 44
MNG_AGENCY 1
- Richmond, City of · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9303 | 9303 | 9302 | {"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 | 15503 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.167 | Virginia Play Lot | 0 | Local Recreation Area 3 | 4 | |
2027 | 2027 | 2026 | {"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 | 15486 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.224 | Humphrey Play Lot | 0 | Local Recreation Area 3 | 4 | |
2028 | 2028 | 2027 | {"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 | 15489 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.274 | Kern Playlot | 0 | Local Recreation Area 3 | 4 | |
7439 | 7439 | 7438 | {"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 | 13122 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.36 | Harrison MP | 0 | Local Park 2 | 4 | |
14667 | 14667 | 14666 | {"type": "Polygon", "coordinates": [[[-122.31198, 37.91187], [-122.31137, 37.91213], [-122.31113, 37.91177], [-122.31143, 37.91164], [-122.31163, 37.91194], [-122.31194, 37.91181], [-122.31198, 37.91187]]]} | Open Access 1 | 44938 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.399 | Mendocino Park | 0 | Local Park 2 | 4 | |
6557 | 6557 | 6556 | {"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 | 15498 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.438 | Monterey Playlot | 0 | Local Recreation Area 3 | 4 | |
8444 | 8444 | 8443 | {"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 | 13119 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.448 | Elm Park | 0 | Local Park 2 | 4 | |
8442 | 8442 | 8441 | {"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 | 13115 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.569 | Abraham Braxton Park | 0 | Local Park 2 | 4 | |
2031 | 2031 | 2030 | {"type": "Polygon", "coordinates": [[[-122.36656, 37.93894], [-122.36622, 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 | 15501 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.793 | Stuart Playground | 0 | Local Recreation Area 3 | 4 | |
8439 | 8439 | 8438 | {"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 | 13108 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 0.985 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
1558 | 1558 | 1557 | {"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 | 13067 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 1.148 | Burg Park | 0 | Local Park 2 | 4 | |
8443 | 8443 | 8442 | {"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 | 13117 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 1.192 | Point Molate Beach Park | 0 | Local Park 2 | 4 | |
11600 | 11600 | 11599 | {"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 | 23705 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 1.507 | Central Park | 0 | Local Park 2 | 4 | |
8435 | 8435 | 8434 | {"type": "Polygon", "coordinates": [[[-122.32571, 37.91578], [-122.32449, 37.91607], [-122.32422, 37.91565], [-122.32452, 37.91545], [-122.32472, 37.91559], [-122.32522, 37.91525], [-122.32571, 37.91578]]]} | Open Access 1 | 13087 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 1.517 | Crescent Park | 0 | Local Park 2 | 4 | |
9294 | 9294 | 9293 | {"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 | 15484 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.057 | Belding-Garcia Park | 0 | Local Park 2 | 4 | |
8436 | 8436 | 8435 | {"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 | 13089 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.1 | Plaza One Park | 0 | Local Park 2 | 4 | |
8426 | 8426 | 8425 | {"type": "Polygon", "coordinates": [[[-122.34496, 37.94599], [-122.34331, 37.946], [-122.34329, 37.94522], [-122.34411, 37.94522], [-122.34411, 37.94554], [-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 | 13065 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.187 | Wendell Park | 0 | Local Park 2 | 4 | |
5064 | 5064 | 5063 | {"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 | 13095 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.212 | Parchester Park | 0 | Local Park 2 | 4 | |
1763 | 1763 | 1762 | {"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 | 13106 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.347 | Sheridan Point Park | 0 | Local Park 2 | 4 | |
8434 | 8434 | 8433 | {"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 | 13085 | 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 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 2.382 | Mira Vista Park | 0 | Local Park 2 | 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]);