units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where DES_TP = 2 and MNG_AGENCY = 8
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7318 | 7318 | 7317 | {"type": "Polygon", "coordinates": [[[-120.38069, 35.65556], [-120.38069, 35.65694], [-120.37742, 35.65689], [-120.37739, 35.65552], [-120.38069, 35.65556]]]} | Open Access 1 | 11956 | CW Clarke Park | 17868 | 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 | 11.182 | CW Clarke Park | 0 | Local Park 2 | 4 | |
9841 | 9841 | 9840 | {"type": "Polygon", "coordinates": [[[-120.64277, 35.46619], [-120.64156, 35.46683], [-120.64042, 35.46748], [-120.64028, 35.46754], [-120.64011, 35.46754], [-120.64004, 35.46759], [-120.63996, 35.46768], [-120.63992, 35.4678], [-120.63996, 35.46802], [-120.63999, 35.46815], [-120.64005, 35.46834], [-120.64011, 35.46844], [-120.6402, 35.46857], [-120.64037, 35.46871], [-120.63791, 35.47016], [-120.63743, 35.46939], [-120.63727, 35.46901], [-120.63719, 35.4686], [-120.63727, 35.46813], [-120.63748, 35.46751], [-120.63739, 35.46725], [-120.63738, 35.46625], [-120.63752, 35.46583], [-120.63746, 35.46519], [-120.6386, 35.46461], [-120.64051, 35.46353], [-120.64277, 35.46619]]]} | Open Access 1 | 16821 | Heilmann Regional Park | 33134 | 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 | 48.892 | Heilmann RP | 0 | Local Park 2 | 4 | |
10296 | 10296 | 10295 | {"type": "MultiPolygon", "coordinates": [[[[-120.50201, 35.02849], [-120.49971, 35.03343], [-120.4986, 35.03308], [-120.49843, 35.03301], [-120.49819, 35.03289], [-120.49524, 35.03088], [-120.49522, 35.03085], [-120.49522, 35.0308], [-120.49548, 35.03047], [-120.49593, 35.02976], [-120.49622, 35.02925], [-120.49661, 35.02847], [-120.49909, 35.02926], [-120.49982, 35.02776], [-120.50201, 35.02849]]], [[[-120.50667, 35.03003], [-120.50484, 35.03377], [-120.50263, 35.03787], [-120.50037, 35.03396], [-120.50026, 35.03382], [-120.5001, 35.03366], [-120.49995, 35.03355], [-120.49978, 35.03346], [-120.50209, 35.02851], [-120.50667, 35.03003]]]]} | Open Access 1 | 18118 | Nipomo Community Park | 22767 | 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 | 134.886 | Nipomo Community Park | 0 | Local Park 2 | 4 | |
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 |
14206 | 14206 | 14205 | {"type": "MultiPolygon", "coordinates": [[[[-120.64475, 35.29287], [-120.64465, 35.29305], [-120.64413, 35.29433], [-120.64404, 35.29441], [-120.64389, 35.29445], [-120.64286, 35.29441], [-120.64292, 35.29421], [-120.6425, 35.29418], [-120.64267, 35.29411], [-120.64372, 35.29308], [-120.64418, 35.29278], [-120.64434, 35.29269], [-120.64475, 35.29287]]], [[[-120.64377, 35.29458], [-120.6437, 35.29472], [-120.64281, 35.29519], [-120.64277, 35.29455], [-120.64377, 35.29458]]]]} | Open Access 1 | 44067 | Cuesta Canyon County Park | 17849 | 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 | 5.731 | Cuesta Canyon County 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]);