units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 2, AGNCY_TYP = 2 and COUNTY = 12
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY 6
DES_TP 4
- Local Recreation Area 3
- Local Park 1
- None 1
- None 1
MNG_AG_TYP 1
ACCESS_TYP 1
- Restricted Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
3448 | 3448 | 3447 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35981, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.9007], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35737, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89558], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35471, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.352, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | 25298 | Brooks Island | 16426 | 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 | 289.362 | Brooks Island | None 282 | |||
3449 | 3449 | 3448 | {"type": "Polygon", "coordinates": [[[-122.10288, 37.98676], [-122.10284, 37.98741], [-122.0973, 37.9875], [-122.09724, 37.98631], [-122.09749, 37.98606], [-122.09779, 37.98587], [-122.0981, 37.98575], [-122.09846, 37.98558], [-122.09872, 37.98543], [-122.09892, 37.98521], [-122.09945, 37.98532], [-122.10123, 37.98528], [-122.10169, 37.98536], [-122.10203, 37.98589], [-122.10241, 37.98638], [-122.1027, 37.98663], [-122.10288, 37.98676]]]} | Restricted Access 2 | 25304 | Martinez | 21925 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 24.888 | Martinez | None 283 | |||
4887 | 4887 | 4886 | {"type": "Polygon", "coordinates": [[[-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.02371, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.02429, 38.01472], [-122.02586, 38.01793], [-122.02616, 38.01785], [-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685]]]} | Restricted Access 2 | 13617 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 150.576 | Diablo Creek GC | 0 | Local Recreation Area 3 | 4 | |
15689 | 15689 | 15688 | {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.9766], [-121.8055, 37.97675], [-121.80486, 37.9766], [-121.80409, 37.97634], [-121.80327, 37.97567], [-121.80324, 37.9754], [-121.80326, 37.97517], [-121.80333, 37.97497], [-121.80346, 37.97479], [-121.80354, 37.9747], [-121.80373, 37.97456], [-121.80442, 37.97421], [-121.80467, 37.97405], [-121.80478, 37.97396], [-121.80496, 37.97375], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80558, 37.97145], [-121.80557, 37.97081], [-121.80557, 37.97013], [-121.80559, 37.96964], [-121.80559, 37.96849], [-121.81433, 37.96848], [-121.81438, 37.97557]]]} | Restricted Access 2 | 16938 | Lone Tree Golf Course | 33051 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 198.557 | Lone Tree GC | 0 | Local Recreation Area 3 | 4 | |
15704 | 15704 | 15703 | {"type": "Polygon", "coordinates": [[[-122.0059, 37.9266], [-122.00588, 37.92724], [-122.00532, 37.92828], [-122.0051, 37.92889], [-122.00468, 37.92966], [-122.00455, 37.92973], [-122.00424, 37.92981], [-122.00406, 37.92996], [-122.00278, 37.93026], [-122.0022, 37.9292], [-121.99905, 37.92943], [-121.99763, 37.92761], [-121.99599, 37.92776], [-121.99374, 37.92453], [-121.99457, 37.92375], [-121.99637, 37.9236], [-121.99942, 37.92264], [-122.00486, 37.92176], [-122.00508, 37.9224], [-122.0052, 37.92451], [-122.00519, 37.92546], [-122.0054, 37.9259], [-122.00549, 37.92588], [-122.00561, 37.92605], [-122.0059, 37.9266]]]} | Restricted Access 2 | 23698 | Boundary Oak Golf Course | 33081 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 159.583 | Boundary Oak GC | 0 | Local Recreation Area 3 | 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]);