units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 206 and MNG_AG_TYP = 3 sorted by MNG_AG_TYP
This data as json, copyable, CSV (advanced)
DES_TP 2
- Local Park 7
- None 1
MNG_AG_TYP 1
- County Agency · 8 ✖
MNG_AGENCY 1
- Placer, County of · 8 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12418 | 12418 | 12417 | {"type": "Polygon", "coordinates": [[[-120.99014, 38.99939], [-120.99012, 39.00034], [-120.98886, 38.99995], [-120.98888, 38.99938], [-120.99014, 38.99939]]]} | Open Access 1 | 27024 | Applegate Park | 15541 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 2.294 | Applegate Park | 0 | Local Park 2 | 4 | |
12631 | 12631 | 12630 | {"type": "MultiPolygon", "coordinates": [[[[-121.36451, 38.73326], [-121.36449, 38.7361], [-121.35996, 38.73507], [-121.35997, 38.7338], [-121.36061, 38.73381], [-121.36097, 38.73337], [-121.36099, 38.73285], [-121.36178, 38.73295], [-121.362, 38.73295], [-121.36217, 38.73298], [-121.36282, 38.733], [-121.36321, 38.73309], [-121.36356, 38.73321], [-121.36383, 38.73325], [-121.36451, 38.73326]]], [[[-121.37398, 38.73924], [-121.37212, 38.74046], [-121.37182, 38.74079], [-121.37185, 38.74104], [-121.37115, 38.74152], [-121.37051, 38.74146], [-121.37019, 38.74165], [-121.37026, 38.74184], [-121.36981, 38.74212], [-121.36954, 38.74214], [-121.36921, 38.74175], [-121.36829, 38.74183], [-121.36759, 38.74218], [-121.36701, 38.74209], [-121.3669, 38.74241], [-121.36623, 38.74336], [-121.36504, 38.74337], [-121.36502, 38.74327], [-121.3658, 38.74324], [-121.36594, 38.74282], [-121.36585, 38.7427], [-121.36604, 38.74258], [-121.36636, 38.74232], [-121.36653, 38.74215], [-121.36667, 38.74197], [-121.36683, 38.74182], [-121.36701, 38.74168], [-121.36722, 38.74157], [-121.36744, 38.74149], [-121.3678, 38.74141], [-121.36805, 38.74139], [-121.36898, 38.7414], [-121.3692, 38.74138], [-121.36952, 38.74129], [-121.3698, 38.74114], [-121.37047, 38.74058], [-121.3708, 38.74035], [-121.3711, 38.74017], [-121.37136, 38.73998], [-121.37168, 38.73968], [-121.37186, 38.73946], [-121.37207, 38.7391], [-121.37217, 38.73882], [-121.37217, 38.73878], [-121.37214, 38.73873], [-121.37218, 38.7387], [-121.37227, 38.73844], [-121.37225, 38.73839], [-121.37222, 38.73835], [-121.37213, 38.73833], [-121.37126, 38.73836], [-121.37094, 38.73866], [-121.37086, 38.73865], [-121.37077, 38.73869], [-121.37069, 38.73884], [-121.3704, 38.73913], [-121.37032, 38.73916], [-121.36981, 38.73898], [-121.36906, 38.73876], [-121.36823, 38.73859], [-121.36791, 38.73855], [-121.36711, 38.73854], [-121.36636, 38.73849], [-121.36619, 38.73851], [-121.36599, 38.73855], [-121.36591, 38.73844], [-121.36582, 38.73839], [-121.36471, 38.73816], [-121.3647, 38.73613], [-121.37388, 38.73601], [-121.37398, 38.73924]]]]} | Open Access 1 | 29434 | Doyle Ranch Park | 18261 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 99.275 | Doyle Ranch Park | 0 | Local Park 2 | 4 | |
14225 | 14225 | 14224 | {"type": "Polygon", "coordinates": [[[-121.20513, 38.75006], [-121.2051, 38.75074], [-121.20505, 38.75091], [-121.20505, 38.75097], [-121.20469, 38.75097], [-121.20469, 38.75085], [-121.20425, 38.75085], [-121.20424, 38.75095], [-121.20296, 38.75098], [-121.20298, 38.75003], [-121.20359, 38.75003], [-121.20394, 38.75008], [-121.20513, 38.75006]]]} | Open Access 1 | 44180 | Douglas Ranch Park | 18247 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 4.525 | Douglas Ranch Park | 0 | Local Park 2 | 4 | |
14262 | 14262 | 14261 | {"type": "Polygon", "coordinates": [[[-120.88547, 38.99559], [-120.88476, 38.99803], [-120.88426, 38.99987], [-120.88414, 39.00024], [-120.88399, 39.00062], [-120.88211, 39.00029], [-120.88091, 39.00005], [-120.88049, 38.99993], [-120.87854, 38.99932], [-120.87858, 38.99925], [-120.87857, 38.99923], [-120.87529, 38.99813], [-120.87506, 38.99807], [-120.87516, 38.99801], [-120.87515, 38.99796], [-120.87786, 38.99721], [-120.87802, 38.9971], [-120.87996, 38.99662], [-120.88336, 38.99558], [-120.88347, 38.99558], [-120.88348, 38.99571], [-120.8839, 38.99572], [-120.88431, 38.99558], [-120.88547, 38.99559]]]} | Open Access 1 | 44181 | Todd Valley Pond Park | 26386 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 67.976 | Todd Valley Pond Park | 0 | Local Park 2 | 4 | |
14292 | 14292 | 14291 | {"type": "Polygon", "coordinates": [[[-121.20948, 38.73356], [-121.20744, 38.73356], [-121.20743, 38.73275], [-121.20753, 38.73277], [-121.20762, 38.73275], [-121.20768, 38.7327], [-121.20772, 38.73262], [-121.20769, 38.73253], [-121.20756, 38.73245], [-121.20752, 38.73237], [-121.20748, 38.72982], [-121.20749, 38.72978], [-121.20751, 38.72976], [-121.20782, 38.72973], [-121.2081, 38.72968], [-121.20831, 38.7296], [-121.20865, 38.72945], [-121.20887, 38.72939], [-121.20912, 38.72935], [-121.20944, 38.72934], [-121.20948, 38.73356]]]} | Open Access 1 | 44226 | Ronald L. Feist Park | 24588 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 18.832 | Ronald L. Feist Park | 0 | Local Park 2 | 4 | |
14465 | 14465 | 14464 | {"type": "Polygon", "coordinates": [[[-121.1883, 38.72061], [-121.18821, 38.72077], [-121.18793, 38.72141], [-121.18783, 38.72158], [-121.18709, 38.72158], [-121.18709, 38.72083], [-121.1883, 38.72061]]]} | Open Access 1 | 47083 | Baldwin Reservoir Trailhead | 30737 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/trails/baldwin-reservoir-trail | Placer 35 | 1.941 | Baldwin Reservoir Trailhead | None 1232 | ||
14466 | 14466 | 14465 | {"type": "Polygon", "coordinates": [[[-121.18912, 38.74187], [-121.18896, 38.74188], [-121.18901, 38.74375], [-121.18894, 38.7438], [-121.18699, 38.74373], [-121.18509, 38.74368], [-121.1852, 38.74249], [-121.18805, 38.7417], [-121.18911, 38.74168], [-121.18912, 38.74187]]]} | Open Access 1 | 47084 | Granite Bay Park | 30738 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/granite-bay-park | Placer 35 | 15.941 | Granite Bay Park | 0 | Local Park 2 | 4 |
16420 | 16420 | 16419 | {"type": "MultiPolygon", "coordinates": [[[[-121.18213, 38.97105], [-121.1726, 38.97098], [-121.16305, 38.97055], [-121.16315, 38.9633], [-121.16337, 38.95628], [-121.16418, 38.95627], [-121.16436, 38.95648], [-121.16487, 38.95686], [-121.16513, 38.95721], [-121.16527, 38.95736], [-121.16559, 38.95748], [-121.16589, 38.95782], [-121.16614, 38.95819], [-121.16611, 38.96087], [-121.16915, 38.96346], [-121.17248, 38.96354], [-121.18199, 38.96348], [-121.19112, 38.96335], [-121.2006, 38.96332], [-121.20992, 38.96332], [-121.20989, 38.96696], [-121.20985, 38.96762], [-121.20985, 38.97062], [-121.20974, 38.97424], [-121.20966, 38.97782], [-121.20022, 38.97793], [-121.19116, 38.978], [-121.19131, 38.97085], [-121.18213, 38.97105]]], [[[-121.21912, 38.97648], [-121.21872, 38.97647], [-121.2185, 38.97649], [-121.21802, 38.97633], [-121.21801, 38.97634], [-121.21816, 38.97662], [-121.21813, 38.97665], [-121.2181, 38.97674], [-121.2181, 38.97683], [-121.21815, 38.97692], [-121.21826, 38.97706], [-121.21895, 38.97778], [-121.21443, 38.97778], [-121.21449, 38.97418], [-121.21911, 38.97416], [-121.21912, 38.97648]]]]} | Open Access 1 | 44942 | Hidden Falls Regional Park | 8647 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/hidden-falls | Placer 35 | 1234.21 | Hidden Falls RP | 2006 | 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]);