units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 8 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- San Luis Obispo, County of · 11 ✖
AGNCY_NAME 1 ✖
ACCESS_TYP 1
- Open Access 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10370 | 10370 | 10369 | {"type": "Polygon", "coordinates": [[[-120.70316, 35.18542], [-120.70293, 35.18607], [-120.70292, 35.18601], [-120.70288, 35.18597], [-120.7028, 35.18595], [-120.70274, 35.18597], [-120.70204, 35.18641], [-120.70158, 35.18682], [-120.70176, 35.18626], [-120.70316, 35.18542]]]} | Open Access 1 | 18304 | Ontario Road Staging Area Park | 23147 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.185 | Ontario Road Staging Area Park | 0 | Local Park 2 | 4 | |
14193 | 14193 | 14192 | {"type": "Polygon", "coordinates": [[[-120.8994, 35.44501], [-120.89928, 35.44513], [-120.89917, 35.44528], [-120.8991, 35.44542], [-120.89902, 35.44564], [-120.89897, 35.44571], [-120.89886, 35.44584], [-120.89882, 35.44596], [-120.89867, 35.44589], [-120.89871, 35.44576], [-120.89885, 35.44561], [-120.89897, 35.4453], [-120.89912, 35.44507], [-120.89925, 35.44494], [-120.8994, 35.44501]]]} | Open Access 1 | 44028 | Paul Andrew Park | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | San Luis Obispo 1 | 0.448 | Paul Andrew Park | 0 | Local Park 2 | 4 |
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
128 | 128 | 127 | {"type": "Polygon", "coordinates": [[[-120.6997, 35.75055], [-120.69948, 35.75185], [-120.69912, 35.7518], [-120.6989, 35.75166], [-120.69837, 35.75161], [-120.69849, 35.75083], [-120.69876, 35.75085], [-120.69881, 35.7505], [-120.6997, 35.75055]]]} | Open Access 1 | 394 | San Miguel Community Park | 24955 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.196 | San Miguel Community Park | 0 | Local Park 2 | 4 | |
160 | 160 | 159 | {"type": "Polygon", "coordinates": [[[-120.6906, 35.75373], [-120.68985, 35.75372], [-120.68986, 35.75288], [-120.69045, 35.75267], [-120.6906, 35.75373]]]} | Open Access 1 | 409 | San Miguel Staging Area Park | 24961 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.605 | San Miguel Staging Area Park | 0 | Local Park 2 | 4 | |
142 | 142 | 141 | {"type": "MultiPolygon", "coordinates": [[[[-120.6245, 35.11002], [-120.62419, 35.11012], [-120.62312, 35.1078], [-120.62286, 35.1073], [-120.62239, 35.10649], [-120.62277, 35.10634], [-120.6229, 35.10654], [-120.62301, 35.10675], [-120.6245, 35.11002]]], [[[-120.62952, 35.12079], [-120.6292, 35.12089], [-120.62657, 35.11519], [-120.62426, 35.11027], [-120.62457, 35.11017], [-120.62699, 35.11532], [-120.62952, 35.12079]]]]} | Open Access 1 | 446 | Sand and Surf County Park | 25009 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 13.006 | Sand and Surf County Park | 0 | Local Park 2 | 4 | |
5975 | 5975 | 5974 | {"type": "Polygon", "coordinates": [[[-120.60526, 35.39209], [-120.60496, 35.39235], [-120.60474, 35.3926], [-120.60455, 35.39286], [-120.60443, 35.39309], [-120.60389, 35.39241], [-120.60489, 35.39187], [-120.60496, 35.39195], [-120.60481, 35.39207], [-120.60494, 35.39217], [-120.60518, 35.39199], [-120.60526, 35.39209]]]} | Open Access 1 | 560 | Santa Margarita Community Park | 25094 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.636 | Santa Margarita Community Park | 0 | Local Park 2 | 4 | |
5980 | 5980 | 5979 | {"type": "MultiPolygon", "coordinates": [[[[-120.4173, 35.31679], [-120.40935, 35.31666], [-120.40964, 35.31285], [-120.411, 35.3143], [-120.41124, 35.31444], [-120.41153, 35.31454], [-120.41174, 35.31458], [-120.41192, 35.31459], [-120.41216, 35.31458], [-120.41704, 35.31472], [-120.41731, 35.31477], [-120.41757, 35.31488], [-120.41771, 35.31496], [-120.41782, 35.31508], [-120.41788, 35.31522], [-120.41789, 35.31537], [-120.41781, 35.31555], [-120.41758, 35.31597], [-120.41746, 35.31622], [-120.41737, 35.31647], [-120.4173, 35.31679]]], [[[-120.50681, 35.32693], [-120.5068, 35.34504], [-120.48918, 35.34481], [-120.48917, 35.34537], [-120.48362, 35.34331], [-120.47178, 35.33897], [-120.47169, 35.3526], [-120.46721, 35.35253], [-120.46726, 35.346], [-120.45847, 35.34562], [-120.4583, 35.35033], [-120.44546, 35.34994], [-120.44546, 35.34567], [-120.43653, 35.34543], [-120.43643, 35.34175], [-120.4413, 35.34186], [-120.44114, 35.33459], [-120.43623, 35.33442], [-120.43612, 35.33085], [-120.42645, 35.33093], [-120.4269, 35.32274], [-120.42249, 35.32245], [-120.42254, 35.3195], [-120.41869, 35.31901], [-120.4181, 35.31857], [-120.41785, 35.31834], [-120.41799, 35.31565], [-120.41806, 35.31548], [-120.41809, 35.31529], [-120.41806, 35.31512], [-120.41799, 35.315], [-120.41787, 35.31486], [-120.4177, 35.31475], [-120.41743, 35.31463], [-120.41726, 35.31459], [-120.41706, 35.31456], [-120.41215, 35.31441], [-120.41188, 35.31442], [-120.41165, 35.31439], [-120.4115, 35.31435], [-120.41131, 35.31428], [-120.41114, 35.31419], [-120.40997, 35.31293], [-120.40965, 35.31261], [-120.40973, 35.31163], [-120.40999, 35.31162], [-120.41001, 35.31103], [-120.40978, 35.31101], [-120.40988, 35.30958], [-120.41438, 35.3094], [-120.42561, 35.30914], [-120.42572, 35.31301], [-120.43054, 35.31319], [-120.43058, 35.31709], [-120.43577, 35.31779], [-120.44373, 35.31771], [-120.44383, 35.31362], [-120.45392, 35.31394], [-120.45387, 35.30961], [-120.4577, 35.30976], [-120.45818, 35.3015], [-120.46285, 35.30148], [-120.46288, 35.30578], [-120.46685, 35.30579], [-120.46686, 35.31422], [-120.47191, 35.31425], [-120.47181, 35.332], [-120.48917, 35.33827], [-120.48919, 35.32291], [-120.47969, 35.31989], [-120.47985, 35.31681], [-120.47542, 35.31538], [-120.47634, 35.30343], [-120.4892, 35.30926], [-120.48919, 35.31601], [-120.49278, 35.31592], [-120.49289, 35.3195], [-120.49738, 35.31934], [-120.49736, 35.3228], [-120.49619, 35.32344], [-120.49566, 35.32369], [-120.49491, 35.324], [-120.49417, 35.32435], [-120.49384, 35.32447], [-120.4935, 35.32458], [-120.49191, 35.32494], [-120.49176, 35.325], [-120.49165, 35.32508], [-120.49153, 35.3252], [-120.49146, 35.32535], [-120.49128, 35.32635], [-120.49128, 35.32664], [-120.49133, 35.32692], [-120.4914, 35.3272], [-120.49151, 35.32747], [-120.49164, 35.32744], [-120.49153, 35.32717], [-120.49146, 35.3269], [-120.49142, 35.32658], [-120.49142, 35.32631], [-120.49159, 35.32537], [-120.49165, 35.32525], [-120.49174, 35.32516], [-120.49183, 35.3251], [-120.49195, 35.32505], [-120.49345, 35.3247], [-120.49406, 35.32451], [-120.49448, 35.32434], [-120.49503, 35.32407], [-120.49594, 35.32369], [-120.49644, 35.32344], [-120.49763, 35.32345], [-120.49796, 35.3238], [-120.49794, 35.32503], [-120.50014, 35.32514], [-120.50002, 35.33047], [-120.50232, 35.33054], [-120.50243, 35.32688], [-120.50681, 35.32693]]], [[[-120.41833, 35.31896], [-120.41782, 35.3189], [-120.41783, 35.31858], [-120.41796, 35.31869], [-120.41833, 35.31896]]]]} | Open Access 1 | 564 | Santa Margarita Lake Regional Park and Natural Area | 11439 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/activities/santa_margarita.htm | San Luis Obispo 1 | 5623.374 | Santa Margarita Lake RP and Natural Area | 0 | Local Conservation Area 4 | 2 |
288 | 288 | 287 | {"type": "Polygon", "coordinates": [[[-121.1085, 35.56657], [-121.10785, 35.56657], [-121.10746, 35.56522], [-121.10769, 35.56517], [-121.10777, 35.5654], [-121.10792, 35.56539], [-121.10789, 35.56525], [-121.10824, 35.56519], [-121.1085, 35.56657]]]} | Open Access 1 | 772 | Shamel Park | 25354 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.347 | Shamel Park | 0 | Local Park 2 | 4 | |
423 | 423 | 422 | {"type": "Polygon", "coordinates": [[[-120.7087, 35.54967], [-120.70788, 35.55014], [-120.70681, 35.54963], [-120.7074, 35.54889], [-120.7087, 35.54967]]]} | Open Access 1 | 1306 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.932 | Templeton Community Park | 0 | Local Park 2 | 4 | |
3906 | 3906 | 3905 | {"type": "Polygon", "coordinates": [[[-120.68988, 35.7518], [-120.68637, 35.75282], [-120.68543, 35.7525], [-120.68529, 35.75228], [-120.68512, 35.75228], [-120.68514, 35.75221], [-120.68616, 35.75215], [-120.6861, 35.75083], [-120.68543, 35.75084], [-120.68542, 35.74725], [-120.68987, 35.74723], [-120.68988, 35.7518]]]} | Open Access 1 | 1959 | Wolf Property Natural Area | 27671 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 54.586 | Wolf Property Natural Area | 0 | Local Conservation Area 4 | 2 |
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]);