units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where AGNCY_LEV = 2 and MNG_AGENCY = 22 sorted by GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2377 | 2377 | 2376 | {"type": "Polygon", "coordinates": [[[-120.7032, 35.26459], [-120.70313, 35.26495], [-120.70303, 35.26496], [-120.70295, 35.26501], [-120.70291, 35.26507], [-120.70291, 35.26517], [-120.70268, 35.26549], [-120.70264, 35.26551], [-120.70213, 35.26546], [-120.70199, 35.26538], [-120.70188, 35.26538], [-120.70174, 35.26507], [-120.70158, 35.26512], [-120.70152, 35.26504], [-120.70168, 35.26481], [-120.70175, 35.26479], [-120.70181, 35.26476], [-120.70262, 35.2641], [-120.7032, 35.26459]]]} | Open Access 1 | 17192 | Laguna Hills Park | 20857 | 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.39 | Laguna Hills Park | 0 | Local Park 2 | 4 | |
2534 | 2534 | 2533 | {"type": "Polygon", "coordinates": [[[-120.66036, 35.26938], [-120.65818, 35.26938], [-120.65817, 35.2674], [-120.65853, 35.26738], [-120.65871, 35.26733], [-120.65883, 35.26728], [-120.65901, 35.26753], [-120.66031, 35.26772], [-120.66036, 35.26938]]]} | Open Access 1 | 17748 | Meadow Park | 22074 | 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.981 | Meadow Park | 0 | Local Park 2 | 4 | |
2886 | 2886 | 2885 | {"type": "Polygon", "coordinates": [[[-120.65576, 35.25766], [-120.65408, 35.25768], [-120.65407, 35.25753], [-120.65421, 35.25737], [-120.65447, 35.25723], [-120.65475, 35.2571], [-120.65516, 35.25694], [-120.65534, 35.25701], [-120.65529, 35.25714], [-120.65563, 35.25729], [-120.65576, 35.25766]]]} | Open Access 1 | 1000 | South St Water Tank / Open Space | 25679 | 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 | 2.019 | South St Water Tank / OS | 0 | Local Recreation Area 3 | 4 | |
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | Unnamed site - San Luis Obispo, City of | 28661 | 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.637 | 0 | Local Other or Unknown 14 | 4 | ||
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 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.137 | 0 | Local Other or Unknown 14 | 4 | ||
4656 | 4656 | 4655 | {"type": "Polygon", "coordinates": [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]]} | Open Access 1 | 36580 | Unnamed site - San Luis Obispo, City of | 28661 | 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.06 | 0 | Local Other or Unknown 14 | 4 | ||
5209 | 5209 | 5208 | {"type": "Polygon", "coordinates": [[[-120.64834, 35.27987], [-120.64777, 35.28012], [-120.64769, 35.28005], [-120.64693, 35.28028], [-120.64762, 35.28098], [-120.64659, 35.28143], [-120.64705, 35.28222], [-120.64729, 35.28232], [-120.64701, 35.28266], [-120.6462, 35.28292], [-120.64597, 35.28404], [-120.64486, 35.28361], [-120.64485, 35.2833], [-120.64358, 35.28331], [-120.64076, 35.28337], [-120.64085, 35.28694], [-120.63102, 35.28738], [-120.63113, 35.27994], [-120.64057, 35.2798], [-120.64326, 35.27863], [-120.64343, 35.27889], [-120.64348, 35.27962], [-120.64386, 35.27961], [-120.64429, 35.27923], [-120.64468, 35.27912], [-120.64499, 35.2792], [-120.64532, 35.27924], [-120.64567, 35.27918], [-120.64605, 35.2792], [-120.64675, 35.2796], [-120.6469, 35.27965], [-120.64704, 35.27963], [-120.64793, 35.27936], [-120.64834, 35.27987]]]} | Open Access 1 | 13 | Bowden Ranch | 16306 | 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 | 242.507 | Bowden Ranch | 0 | Local Park 2 | 4 | |
5516 | 5516 | 5515 | {"type": "MultiPolygon", "coordinates": [[[[-120.69549, 35.26127], [-120.69548, 35.26128], [-120.69541, 35.26128], [-120.69525, 35.26141], [-120.69521, 35.26138], [-120.69516, 35.26142], [-120.69512, 35.26139], [-120.69469, 35.26174], [-120.69444, 35.2619], [-120.69428, 35.26211], [-120.69453, 35.26232], [-120.69428, 35.26244], [-120.69411, 35.2625], [-120.69402, 35.26226], [-120.69374, 35.26222], [-120.69335, 35.26231], [-120.69301, 35.26246], [-120.6928, 35.26259], [-120.69256, 35.2624], [-120.6928, 35.26223], [-120.6933, 35.26193], [-120.69392, 35.26169], [-120.69501, 35.26115], [-120.69505, 35.2609], [-120.69549, 35.26127]]], [[[-120.70148, 35.25778], [-120.70136, 35.25781], [-120.70118, 35.25801], [-120.7008, 35.25828], [-120.70044, 35.25829], [-120.69958, 35.25844], [-120.69948, 35.2583], [-120.69956, 35.2583], [-120.69968, 35.25822], [-120.69974, 35.25827], [-120.70009, 35.25821], [-120.70024, 35.25809], [-120.70039, 35.25812], [-120.70056, 35.25786], [-120.7006, 35.25786], [-120.70047, 35.25809], [-120.70048, 35.25812], [-120.7008, 35.25812], [-120.70097, 35.25799], [-120.70118, 35.25774], [-120.70127, 35.25768], [-120.70133, 35.25754], [-120.70146, 35.25757], [-120.70144, 35.25765], [-120.70148, 35.25778]]]]} | Open Access 1 | 18808 | Prefumo Creek | 23980 | 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 | 4.164 | Prefumo Creek | 0 | Local Other or Unknown 14 | 4 | |
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 | |
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 | |
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 | |
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 |
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]);