units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
66 rows where MNG_AGENCY = 22 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
DES_TP 11
- Local Recreation Area 23
- Local Park 13
- Local Other or Unknown 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 46
MNG_AGENCY 1
- San Luis Obispo, City of · 46 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5525 | 5525 | 5524 | {"type": "Polygon", "coordinates": [[[-120.64638, 35.29111], [-120.64605, 35.29112], [-120.64578, 35.2913], [-120.64578, 35.29163], [-120.64528, 35.29166], [-120.64483, 35.29192], [-120.64445, 35.29207], [-120.64409, 35.29225], [-120.64375, 35.29245], [-120.64345, 35.29265], [-120.64344, 35.29262], [-120.64305, 35.29277], [-120.64306, 35.29272], [-120.64346, 35.29252], [-120.64355, 35.29243], [-120.64361, 35.29245], [-120.6437, 35.29244], [-120.64375, 35.29241], [-120.6438, 35.29235], [-120.64407, 35.29219], [-120.64439, 35.29203], [-120.64488, 35.29183], [-120.645, 35.29176], [-120.64525, 35.29155], [-120.64562, 35.29112], [-120.64612, 35.29079], [-120.64638, 35.29111]]]} | Open Access 1 | 379 | San Luis Drive Open Space | 24931 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.278 | San Luis Drive OS | 0 | Local Recreation Area 3 | 4 | |
5892 | 5892 | 5891 | {"type": "Polygon", "coordinates": [[[-120.67182, 35.26907], [-120.67141, 35.26903], [-120.67144, 35.26882], [-120.67171, 35.26885], [-120.67182, 35.26907]]]} | Open Access 1 | 471 | Brook St Park | 16418 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.179 | Brook St Park | 0 | Local Park 2 | 4 | |
5952 | 5952 | 5951 | {"type": "Polygon", "coordinates": [[[-120.66639, 35.2902], [-120.66634, 35.29022], [-120.66628, 35.29034], [-120.66262, 35.29041], [-120.66264, 35.28911], [-120.66293, 35.28918], [-120.66311, 35.2892], [-120.66328, 35.2892], [-120.66367, 35.28915], [-120.66468, 35.28928], [-120.66536, 35.28932], [-120.66557, 35.2892], [-120.66618, 35.28991], [-120.66616, 35.28994], [-120.66639, 35.2902]]]} | Open Access 1 | 607 | Santa Rosa Park | 25135 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 9.811 | Santa Rosa Park | 0 | Local Park 2 | 4 | |
6145 | 6145 | 6144 | {"type": "Polygon", "coordinates": [[[-120.65583, 35.26164], [-120.65564, 35.26199], [-120.65549, 35.26196], [-120.65536, 35.26197], [-120.65525, 35.26201], [-120.65509, 35.2621], [-120.65493, 35.26108], [-120.65583, 35.26164]]]} | Open Access 1 | 1145 | Stoneridge Development Park | 25896 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.191 | Stoneridge Development Park | 0 | Local Park 2 | 4 | |
6147 | 6147 | 6146 | {"type": "Polygon", "coordinates": [[[-120.65509, 35.2621], [-120.65487, 35.26189], [-120.65504, 35.26178], [-120.65504, 35.26178], [-120.65509, 35.2621]]]} | Open Access 1 | 1140 | Stoneridge Development Open Space | 25895 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.077 | Stoneridge Development OS | 0 | Local Recreation Area 3 | 4 | |
6230 | 6230 | 6229 | {"type": "Polygon", "coordinates": [[[-120.65301, 35.27273], [-120.65302, 35.27286], [-120.65292, 35.27335], [-120.65296, 35.27363], [-120.65296, 35.27399], [-120.65274, 35.27434], [-120.65179, 35.27497], [-120.65146, 35.27512], [-120.65131, 35.27486], [-120.6508, 35.27482], [-120.65055, 35.27474], [-120.65017, 35.27428], [-120.6495, 35.27385], [-120.6491, 35.27349], [-120.64888, 35.27307], [-120.64864, 35.27283], [-120.64972, 35.27171], [-120.65008, 35.27225], [-120.65014, 35.27225], [-120.65047, 35.27231], [-120.65047, 35.2723], [-120.65028, 35.27205], [-120.65068, 35.27182], [-120.65079, 35.27194], [-120.65086, 35.27196], [-120.65118, 35.27228], [-120.65214, 35.27228], [-120.65229, 35.27221], [-120.65242, 35.27234], [-120.65242, 35.27242], [-120.65246, 35.27246], [-120.65286, 35.27262], [-120.65301, 35.27273]]]} | Open Access 1 | 1310 | Terrace Hill | 26257 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 22.731 | Terrace Hill | None 503 | |||
6240 | 6240 | 6239 | {"type": "Polygon", "coordinates": [[[-120.65048, 35.27232], [-120.65015, 35.27225], [-120.65007, 35.27225], [-120.64975, 35.27174], [-120.65003, 35.2716], [-120.65004, 35.27181], [-120.65022, 35.27208], [-120.65028, 35.27205], [-120.65048, 35.27232]]]} | Open Access 1 | 1314 | Terrace Hill Water Tank | 26258 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.442 | Terrace Hill Water Tank | None 505 | |||
6334 | 6334 | 6333 | {"type": "MultiPolygon", "coordinates": [[[[-120.64648, 35.26403], [-120.6472, 35.26495], [-120.64806, 35.26558], [-120.65018, 35.26686], [-120.65005, 35.26688], [-120.65051, 35.26715], [-120.6505, 35.26724], [-120.65042, 35.26725], [-120.65016, 35.26742], [-120.65007, 35.26754], [-120.65021, 35.26759], [-120.65035, 35.26745], [-120.65045, 35.26738], [-120.65055, 35.26736], [-120.65064, 35.26737], [-120.65075, 35.26743], [-120.65084, 35.26751], [-120.65095, 35.26769], [-120.65107, 35.26796], [-120.65113, 35.26821], [-120.65121, 35.26863], [-120.65115, 35.26905], [-120.65112, 35.2692], [-120.6511, 35.26907], [-120.65069, 35.26907], [-120.65068, 35.26822], [-120.65061, 35.26821], [-120.65061, 35.26808], [-120.64979, 35.26807], [-120.64979, 35.26784], [-120.64983, 35.26767], [-120.6499, 35.26748], [-120.64949, 35.26732], [-120.64925, 35.26727], [-120.64799, 35.26586], [-120.64717, 35.26522], [-120.64705, 35.26501], [-120.64543, 35.26502], [-120.64631, 35.26418], [-120.6441, 35.26144], [-120.64438, 35.26143], [-120.64607, 35.26355], [-120.64648, 35.26403]]], [[[-120.6551, 35.27467], [-120.65496, 35.27451], [-120.65502, 35.27417], [-120.65502, 35.27394], [-120.655, 35.27378], [-120.65496, 35.27356], [-120.65486, 35.27327], [-120.65477, 35.2731], [-120.65245, 35.26974], [-120.65236, 35.26973], [-120.65236, 35.26961], [-120.65211, 35.26932], [-120.65193, 35.26903], [-120.65131, 35.26903], [-120.65137, 35.26862], [-120.65123, 35.2679], [-120.65103, 35.2675], [-120.6509, 35.26736], [-120.65104, 35.26744], [-120.65135, 35.26773], [-120.65214, 35.26877], [-120.65262, 35.26946], [-120.65269, 35.26961], [-120.65408, 35.27162], [-120.65489, 35.27288], [-120.65481, 35.27292], [-120.65499, 35.2733], [-120.65518, 35.27398], [-120.65519, 35.2742], [-120.65518, 35.27438], [-120.6551, 35.27467]]]]} | Open Access 1 | 1645 | Railroad Safety Trail | 28708 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 17.512 | Railroad Safety Trail | 1998 | Local Recreation Area 3 | 4 | |
7801 | 7801 | 7800 | {"type": "Polygon", "coordinates": [[[-120.66948, 35.27794], [-120.66942, 35.27805], [-120.66924, 35.27827], [-120.66871, 35.27798], [-120.66901, 35.27765], [-120.66948, 35.27794]]]} | Open Access 1 | 12682 | Dana Adobe | 17907 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.62 | Dana Adobe | None 649 | |||
7998 | 7998 | 7997 | {"type": "MultiPolygon", "coordinates": [[[[-120.63572, 35.24436], [-120.63555, 35.24438], [-120.63528, 35.24446], [-120.63511, 35.24448], [-120.63487, 35.24442], [-120.6347, 35.24431], [-120.63467, 35.24433], [-120.63416, 35.24422], [-120.6339, 35.24428], [-120.63382, 35.24434], [-120.63378, 35.2444], [-120.633, 35.24412], [-120.63374, 35.24413], [-120.63401, 35.24404], [-120.6346, 35.24405], [-120.63476, 35.2441], [-120.63508, 35.24423], [-120.63534, 35.244], [-120.63564, 35.244], [-120.63567, 35.24401], [-120.63569, 35.24404], [-120.63572, 35.24436]]], [[[-120.63656, 35.24442], [-120.63639, 35.24445], [-120.63612, 35.24445], [-120.63596, 35.24441], [-120.63591, 35.24438], [-120.63589, 35.24417], [-120.63613, 35.24422], [-120.63638, 35.24416], [-120.63656, 35.24442]]]]} | Open Access 1 | 11114 | Creek dedication | 17762 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.954 | Creek dedication | None 667 | |||
8107 | 8107 | 8106 | {"type": "Polygon", "coordinates": [[[-120.66794, 35.28932], [-120.66778, 35.28934], [-120.66772, 35.289], [-120.66786, 35.28898], [-120.66794, 35.28932]]]} | Open Access 1 | 12200 | Anholm Park | 15499 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.132 | Anholm Park | 0 | Local Park 2 | 4 | |
8233 | 8233 | 8232 | {"type": "Polygon", "coordinates": [[[-120.64907, 35.25038], [-120.64905, 35.25181], [-120.64766, 35.25297], [-120.64745, 35.25312], [-120.64703, 35.25335], [-120.64593, 35.25381], [-120.64506, 35.25159], [-120.64478, 35.25108], [-120.64579, 35.25068], [-120.64582, 35.25067], [-120.64586, 35.2507], [-120.64593, 35.25081], [-120.64699, 35.25038], [-120.64907, 35.25038]]]} | Open Access 1 | 12564 | Damon-Garcia Sports Complex | 17901 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 23.938 | Damon-Garcia Sports Complex | 0 | Local Recreation Area 3 | 4 | |
9266 | 9266 | 9265 | {"type": "Polygon", "coordinates": [[[-120.65309, 35.28478], [-120.65265, 35.28513], [-120.65267, 35.28516], [-120.6525, 35.28528], [-120.65261, 35.28492], [-120.65298, 35.28474], [-120.65306, 35.28476], [-120.65306, 35.28477], [-120.65309, 35.28478]]]} | Open Access 1 | 15459 | Elsford Park | 18604 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.233 | Elsford Park | 0 | Local Park 2 | 4 | |
9324 | 9324 | 9323 | {"type": "Polygon", "coordinates": [[[-120.66559, 35.2758], [-120.66437, 35.27654], [-120.66375, 35.27585], [-120.66497, 35.27511], [-120.66559, 35.2758]]]} | Open Access 1 | 15547 | Emerson Park | 18623 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 3.252 | Emerson Park | 0 | Local Park 2 | 4 | |
9387 | 9387 | 9386 | {"type": "Polygon", "coordinates": [[[-120.66218, 35.26785], [-120.66213, 35.26785], [-120.66206, 35.26787], [-120.66202, 35.26791], [-120.662, 35.26796], [-120.66032, 35.268], [-120.6603, 35.26772], [-120.65908, 35.26754], [-120.65941, 35.26724], [-120.65983, 35.26735], [-120.66207, 35.26735], [-120.66208, 35.26705], [-120.66214, 35.26705], [-120.66214, 35.26735], [-120.66218, 35.26785]]]} | Open Access 1 | 15744 | Exposition Park (1) | 18777 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 3.823 | Exposition Park (1) | None 772 | |||
9508 | 9508 | 9507 | {"type": "Polygon", "coordinates": [[[-120.64765, 35.28009], [-120.64706, 35.28043], [-120.64684, 35.28024], [-120.64756, 35.28002], [-120.64765, 35.28009]]]} | Open Access 1 | 17375 | Lizzie Street Open Space | 21387 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.329 | Lizzie Street OS | 0 | Local Recreation Area 3 | 4 | |
9621 | 9621 | 9620 | {"type": "Polygon", "coordinates": [[[-120.63819, 35.24749], [-120.63787, 35.24753], [-120.63786, 35.24756], [-120.63747, 35.24762], [-120.63741, 35.24765], [-120.63736, 35.24762], [-120.63677, 35.24801], [-120.63677, 35.24803], [-120.63614, 35.24844], [-120.63513, 35.24743], [-120.63512, 35.24739], [-120.63514, 35.24736], [-120.63584, 35.24689], [-120.6361, 35.24668], [-120.63633, 35.24646], [-120.63664, 35.24608], [-120.6367, 35.24606], [-120.63735, 35.24636], [-120.63757, 35.2465], [-120.63774, 35.24665], [-120.6379, 35.24684], [-120.63804, 35.24704], [-120.63813, 35.24726], [-120.63819, 35.24749]]]} | Open Access 1 | 16206 | French Park | 19106 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 9.348 | French Park | 0 | Local Park 2 | 4 | |
9661 | 9661 | 9660 | {"type": "MultiPolygon", "coordinates": [[[[-120.64348, 35.26058], [-120.64327, 35.26067], [-120.6434, 35.26084], [-120.64332, 35.26088], [-120.64332, 35.26132], [-120.64289, 35.26132], [-120.64288, 35.26051], [-120.64329, 35.26034], [-120.64348, 35.26058]]], [[[-120.64408, 35.26132], [-120.64356, 35.26132], [-120.64355, 35.26077], [-120.64362, 35.26075], [-120.64408, 35.26132]]]]} | Open Access 1 | 16290 | Future Ocutt/Bullock Alignment | 19157 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.469 | Future Ocutt/Bullock Alignment | 0 | None 825 | ||
9668 | 9668 | 9667 | {"type": "Polygon", "coordinates": [[[-120.65128, 35.26695], [-120.65108, 35.26705], [-120.6498, 35.2662], [-120.64958, 35.266], [-120.64939, 35.26574], [-120.64957, 35.26564], [-120.64973, 35.26588], [-120.64997, 35.2661], [-120.65128, 35.26695]]]} | Open Access 1 | 16311 | Future Railroad Area Bike Path | 19160 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.045 | Future Railroad Area Bike Path | 0 | Local Recreation Area 3 | 4 | |
9723 | 9723 | 9722 | {"type": "Polygon", "coordinates": [[[-120.66585, 35.27882], [-120.66574, 35.27879], [-120.66561, 35.27879], [-120.66488, 35.27923], [-120.66485, 35.27919], [-120.66488, 35.27903], [-120.6649, 35.27899], [-120.66497, 35.27894], [-120.66518, 35.27881], [-120.66563, 35.27858], [-120.66585, 35.27882]]]} | Open Access 1 | 17859 | Mission Plaza Open Space | 22308 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.487 | Mission Plaza OS | 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]);