superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 8 sorted by PARK_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7693 | 7693 | 7692 | {"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 | Ontario Road Staging Area Park | 23147 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.185 | Ontario Road Staging Area Park | ||
13858 | 13858 | 13857 | {"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 | Paul Andrew Park | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 0.448 | Paul Andrew Park | |
8732 | 8732 | 8731 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73761], [-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 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 3.26 | Rios Caledonia Adobe | ||
9228 | 9228 | 9227 | {"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 | San Miguel Community Park | 24955 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 3.198 | San Miguel Community Park | ||
9230 | 9230 | 9229 | {"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 | San Miguel Staging Area Park | 24961 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.605 | San Miguel Staging Area Park | ||
9187 | 9187 | 9186 | {"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 | Sand and Surf County Park | 25009 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 13.004 | Sand and Surf County Park | ||
9322 | 9322 | 9321 | {"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.60482, 35.39207], [-120.60493, 35.39216], [-120.60518, 35.39199], [-120.60526, 35.39209]]]} | Open Access 1 | Santa Margarita Community Park | 25094 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.639 | Santa Margarita Community Park | ||
764 | 764 | 763 | {"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.31457], [-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.41788, 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.48919, 35.34481], [-120.48917, 35.34537], [-120.48362, 35.34331], [-120.47179, 35.33897], [-120.47169, 35.3526], [-120.46721, 35.35253], [-120.46725, 35.346], [-120.45847, 35.34562], [-120.4583, 35.35033], [-120.44546, 35.34994], [-120.44545, 35.34567], [-120.43653, 35.34543], [-120.43643, 35.34175], [-120.4413, 35.34186], [-120.44113, 35.33459], [-120.43623, 35.33442], [-120.43611, 35.33085], [-120.42645, 35.33093], [-120.4269, 35.32274], [-120.42249, 35.32245], [-120.42254, 35.31951], [-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.31513], [-120.41799, 35.31499], [-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.31161], [-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.44372, 35.31771], [-120.44383, 35.31362], [-120.45392, 35.31393], [-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.46687, 35.31422], [-120.47191, 35.31425], [-120.47181, 35.332], [-120.48917, 35.33827], [-120.48919, 35.32292], [-120.47969, 35.31989], [-120.47984, 35.31681], [-120.47542, 35.31538], [-120.47634, 35.30343], [-120.4892, 35.30926], [-120.4892, 35.316], [-120.49278, 35.31592], [-120.4929, 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.49177, 35.325], [-120.49165, 35.32508], [-120.49153, 35.3252], [-120.49146, 35.32536], [-120.49128, 35.32636], [-120.49129, 35.32664], [-120.49133, 35.32692], [-120.4914, 35.3272], [-120.49151, 35.32746], [-120.49163, 35.32743], [-120.49153, 35.32716], [-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.49795, 35.32503], [-120.50014, 35.32514], [-120.50002, 35.33047], [-120.50232, 35.33053], [-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 | Santa Margarita Lake Regional Park and Natural Area | http://www.slocountyparks.com/activities/santa_margarita.htm | 11439 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 5624.637 | Santa Margarita Lake RP and Natural Area | |
9550 | 9550 | 9549 | {"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 | Shamel Park | 25354 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 2.35 | Shamel Park | ||
10267 | 10267 | 10266 | {"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 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 2.931 | Templeton Community Park | ||
11358 | 11358 | 11357 | {"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.75214], [-120.6861, 35.75084], [-120.68543, 35.75084], [-120.68542, 35.74725], [-120.68987, 35.74723], [-120.68988, 35.7518]]]} | Open Access 1 | Wolf Property Natural Area | 27671 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 54.6 | Wolf Property Natural Area |
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]);