superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where MNG_AGENCY = 22 and MNG_AG_TYP = 2 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4456 | 4456 | 4455 | {"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 | 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 | 1.045 | Future Railroad Area Bike Path | ||
5370 | 5370 | 5369 | {"type": "Polygon", "coordinates": [[[-120.72276, 35.25881], [-120.71907, 35.26446], [-120.7187, 35.26439], [-120.7184, 35.26437], [-120.7182, 35.26433], [-120.71795, 35.26437], [-120.71781, 35.26438], [-120.7174, 35.26431], [-120.717, 35.26417], [-120.71696, 35.26413], [-120.71694, 35.26405], [-120.71691, 35.26402], [-120.71641, 35.26375], [-120.71619, 35.26367], [-120.71597, 35.26365], [-120.71528, 35.26367], [-120.71505, 35.26364], [-120.71472, 35.26357], [-120.71461, 35.26352], [-120.71453, 35.26346], [-120.71449, 35.26339], [-120.7144, 35.26319], [-120.71426, 35.26307], [-120.71422, 35.26297], [-120.71416, 35.26293], [-120.71394, 35.26283], [-120.71384, 35.2628], [-120.71307, 35.26275], [-120.71294, 35.26272], [-120.71281, 35.26268], [-120.71241, 35.26246], [-120.71226, 35.26241], [-120.71206, 35.26239], [-120.71124, 35.2624], [-120.711, 35.26242], [-120.7107, 35.26239], [-120.71032, 35.26247], [-120.71011, 35.26248], [-120.7099, 35.26247], [-120.70968, 35.26243], [-120.70916, 35.26224], [-120.70862, 35.26202], [-120.70911, 35.26118], [-120.7091, 35.26116], [-120.70799, 35.26061], [-120.70769, 35.2605], [-120.70728, 35.2604], [-120.70667, 35.26032], [-120.70363, 35.25931], [-120.71036, 35.25391], [-120.71036, 35.25389], [-120.70875, 35.2538], [-120.70699, 35.25338], [-120.70607, 35.25308], [-120.70513, 35.25297], [-120.70459, 35.25516], [-120.70331, 35.25593], [-120.70128, 35.25617], [-120.70009, 35.25634], [-120.69821, 35.25504], [-120.6978, 35.2545], [-120.69644, 35.25431], [-120.69612, 35.25394], [-120.69564, 35.25421], [-120.69543, 35.25404], [-120.69481, 35.25328], [-120.69227, 35.25114], [-120.69221, 35.25083], [-120.69199, 35.25009], [-120.69178, 35.24991], [-120.69144, 35.24969], [-120.6908, 35.24962], [-120.69007, 35.24946], [-120.68975, 35.2495], [-120.6889, 35.24852], [-120.68574, 35.25036], [-120.68455, 35.24895], [-120.68459, 35.24889], [-120.68344, 35.24726], [-120.6832, 35.24588], [-120.68342, 35.24565], [-120.68334, 35.24548], [-120.68704, 35.24348], [-120.69259, 35.2393], [-120.6958, 35.24208], [-120.70089, 35.2396], [-120.70424, 35.24253], [-120.70425, 35.24252], [-120.70441, 35.24041], [-120.71387, 35.24015], [-120.71391, 35.24413], [-120.70631, 35.24433], [-120.7063, 35.24435], [-120.72276, 35.25881]]]} | Open Access 1 | Irish Hills Natural Reserve | 20233 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1138.832 | Irish Hills Natural Reserve | ||
5423 | 5423 | 5422 | {"type": "Polygon", "coordinates": [[[-120.62757, 35.24826], [-120.62753, 35.24834], [-120.62717, 35.24822], [-120.62704, 35.24835], [-120.62675, 35.24845], [-120.6267, 35.24848], [-120.62669, 35.24859], [-120.62672, 35.24867], [-120.62679, 35.24871], [-120.62679, 35.24881], [-120.62681, 35.24888], [-120.62674, 35.24898], [-120.62645, 35.24914], [-120.62632, 35.24937], [-120.62632, 35.2496], [-120.62638, 35.24977], [-120.62618, 35.25003], [-120.6262, 35.25021], [-120.62562, 35.25022], [-120.62503, 35.25026], [-120.62371, 35.25045], [-120.62291, 35.25047], [-120.62293, 35.25022], [-120.62298, 35.25003], [-120.62334, 35.25036], [-120.62371, 35.25029], [-120.62391, 35.25023], [-120.62414, 35.25008], [-120.62415, 35.25005], [-120.62384, 35.24988], [-120.62385, 35.24985], [-120.62419, 35.25003], [-120.62428, 35.24994], [-120.62428, 35.24963], [-120.62442, 35.2494], [-120.62455, 35.24927], [-120.62579, 35.2485], [-120.62578, 35.24849], [-120.62539, 35.24833], [-120.62564, 35.24819], [-120.62591, 35.24843], [-120.62621, 35.24825], [-120.62657, 35.24791], [-120.62666, 35.2477], [-120.62671, 35.2475], [-120.6267, 35.24714], [-120.62739, 35.24715], [-120.62735, 35.24756], [-120.6272, 35.24786], [-120.6272, 35.24799], [-120.62723, 35.24815], [-120.62757, 35.24826]]]} | Open Access 1 | Islay Hill Park | 20284 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 11.3 | Islay Hill Park | ||
5595 | 5595 | 5594 | {"type": "Polygon", "coordinates": [[[-120.64423, 35.26637], [-120.64385, 35.26695], [-120.64332, 35.26783], [-120.64217, 35.26752], [-120.64322, 35.26607], [-120.64423, 35.26637]]]} | Open Access 1 | Johnson Playground | 20481 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 4.62 | Johnson Playground | ||
5881 | 5881 | 5880 | {"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.26508], [-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 | 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 | 3.392 | Laguna Hills Park | ||
5885 | 5885 | 5884 | {"type": "MultiPolygon", "coordinates": [[[[-120.69736, 35.26693], [-120.69602, 35.268], [-120.69446, 35.26669], [-120.69328, 35.26764], [-120.69317, 35.26757], [-120.68868, 35.26451], [-120.6898, 35.26465], [-120.69018, 35.26441], [-120.6903, 35.26422], [-120.69045, 35.26413], [-120.69072, 35.26405], [-120.6909, 35.26405], [-120.69163, 35.26412], [-120.69174, 35.26409], [-120.69179, 35.26404], [-120.69183, 35.26391], [-120.6918, 35.26368], [-120.69175, 35.26347], [-120.69176, 35.26338], [-120.69181, 35.26321], [-120.69198, 35.26288], [-120.69208, 35.26274], [-120.69218, 35.26265], [-120.69255, 35.2624], [-120.69277, 35.26257], [-120.6924, 35.26288], [-120.69223, 35.26347], [-120.69211, 35.26379], [-120.69214, 35.26419], [-120.6923, 35.26422], [-120.69267, 35.26435], [-120.69345, 35.26485], [-120.69349, 35.26487], [-120.69383, 35.26527], [-120.69431, 35.26531], [-120.69471, 35.2655], [-120.695, 35.26572], [-120.69516, 35.26557], [-120.69528, 35.26523], [-120.69533, 35.26519], [-120.69537, 35.26513], [-120.69574, 35.26517], [-120.69585, 35.26509], [-120.6967, 35.26581], [-120.69659, 35.26588], [-120.69599, 35.26556], [-120.69594, 35.2656], [-120.69583, 35.26588], [-120.69593, 35.26606], [-120.69654, 35.26648], [-120.69736, 35.26693]]], [[[-120.69321, 35.26412], [-120.6929, 35.26444], [-120.69282, 35.26439], [-120.69313, 35.26407], [-120.69321, 35.26412]]]]} | Open Access 1 | Laguna Lake Park | 20861 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 38.754 | Laguna Lake Park | ||
6124 | 6124 | 6123 | {"type": "Polygon", "coordinates": [[[-120.70387, 35.26834], [-120.70338, 35.26878], [-120.70205, 35.27003], [-120.70103, 35.26884], [-120.70133, 35.26864], [-120.70172, 35.26839], [-120.70188, 35.26826], [-120.70206, 35.26816], [-120.70278, 35.26782], [-120.70301, 35.26763], [-120.70387, 35.26834]]]} | Open Access 1 | Let It Be Park | 21184 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 7.933 | Let It Be Park | ||
6396 | 6396 | 6395 | {"type": "Polygon", "coordinates": [[[-120.69862, 35.26213], [-120.69779, 35.26279], [-120.69759, 35.26263], [-120.69787, 35.26237], [-120.6974, 35.26197], [-120.69741, 35.26154], [-120.6972, 35.26136], [-120.69743, 35.26116], [-120.69862, 35.26213]]]} | Restricted Access 2 | Laguna Lake Golf Course | 33055 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 2.349 | Laguna Lake GC | ||
6765 | 6765 | 6764 | {"type": "Polygon", "coordinates": [[[-120.67031, 35.27347], [-120.67028, 35.27355], [-120.67023, 35.27354], [-120.67001, 35.27385], [-120.66985, 35.27411], [-120.66952, 35.27407], [-120.66965, 35.2734], [-120.67031, 35.27347]]]} | Open Access 1 | Matthews Open Space | 21957 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.824 | Matthews OS | ||
6865 | 6865 | 6864 | {"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 | Meadow Park | 22074 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 9.981 | Meadow Park | ||
7068 | 7068 | 7067 | {"type": "Polygon", "coordinates": [[[-120.66585, 35.27882], [-120.66573, 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 | 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 | 0.487 | Mission Plaza OS | ||
7072 | 7072 | 7071 | {"type": "Polygon", "coordinates": [[[-120.65859, 35.2788], [-120.65739, 35.27952], [-120.65681, 35.27887], [-120.658, 35.27814], [-120.65859, 35.2788]]]} | Open Access 1 | Mitchell Park | 22325 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 3.028 | Mitchell Park | ||
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-120.65641, 35.27609], [-120.65609, 35.27575], [-120.65632, 35.27561], [-120.65632, 35.27561], [-120.65641, 35.27609]]]} | Open Access 1 | Osos Street Mini Park | 23238 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.152 | Osos Street MP | ||
7994 | 7994 | 7993 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26775], [-120.66469, 35.26776], [-120.66468, 35.26753], [-120.66465, 35.26734], [-120.66515, 35.26732], [-120.66515, 35.26775]]]} | Open Access 1 | Part of Exposition Park (3) | 23484 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.506 | Part of Exposition Park (3) | ||
8391 | 8391 | 8390 | {"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.69975, 35.25827], [-120.70008, 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 | Prefumo Creek | 23980 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 4.173 | Prefumo Creek | ||
8416 | 8416 | 8415 | {"type": "Polygon", "coordinates": [[[-120.70209, 35.27008], [-120.70097, 35.27111], [-120.69991, 35.27204], [-120.69692, 35.27003], [-120.69534, 35.26892], [-120.69334, 35.26759], [-120.69446, 35.26668], [-120.69602, 35.26799], [-120.69736, 35.26693], [-120.69751, 35.26701], [-120.69768, 35.26715], [-120.69782, 35.26731], [-120.698, 35.26746], [-120.69865, 35.26782], [-120.699, 35.26729], [-120.69983, 35.26729], [-120.69964, 35.26779], [-120.69988, 35.268], [-120.7002, 35.26858], [-120.70054, 35.26884], [-120.70101, 35.26886], [-120.70209, 35.27008]]]} | Open Access 1 | Priolo-Martin Park - Laguna Lake | 24011 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 51.009 | Priolo-Martin Park - Laguna Lake | ||
8877 | 8877 | 8876 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | Rockview Right-of-Way | 24536 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.123 | Rockview Right-of-Way | ||
8899 | 8899 | 8898 | {"type": "Polygon", "coordinates": [[[-120.63097, 35.24673], [-120.63073, 35.24675], [-120.63063, 35.24673], [-120.63043, 35.24674], [-120.6303, 35.24677], [-120.63025, 35.24681], [-120.63016, 35.24683], [-120.63008, 35.24682], [-120.62998, 35.24677], [-120.62994, 35.2467], [-120.62993, 35.24662], [-120.63, 35.24651], [-120.63004, 35.24648], [-120.63007, 35.24644], [-120.63012, 35.24628], [-120.6301, 35.24623], [-120.63011, 35.24615], [-120.63017, 35.2461], [-120.63019, 35.24606], [-120.63018, 35.24601], [-120.63013, 35.24596], [-120.63051, 35.24609], [-120.63065, 35.24616], [-120.63074, 35.24623], [-120.63083, 35.24633], [-120.63089, 35.24643], [-120.63095, 35.2466], [-120.63097, 35.24673]]]} | Open Access 1 | Rodriguez Adobe | 24553 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.39 | Rodriguez Adobe | ||
9216 | 9216 | 9215 | {"type": "Polygon", "coordinates": [[[-120.67302, 35.2668], [-120.67283, 35.26847], [-120.6727, 35.26922], [-120.67258, 35.26972], [-120.67213, 35.26967], [-120.67165, 35.26873], [-120.6726, 35.26791], [-120.67217, 35.26714], [-120.67277, 35.26669], [-120.67286, 35.26668], [-120.67294, 35.2667], [-120.67299, 35.26674], [-120.67302, 35.2668]]]} | Open Access 1 | San Luis Obispo holding 1 | 24934 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 5.055 | San Luis Obispo holding 1 | ||
9217 | 9217 | 9216 | {"type": "Polygon", "coordinates": [[[-120.63621, 35.2961], [-120.63574, 35.29718], [-120.63513, 35.29735], [-120.63415, 35.29709], [-120.63289, 35.29573], [-120.63328, 35.29565], [-120.6337, 35.2956], [-120.63476, 35.29554], [-120.63607, 35.29587], [-120.63621, 35.2961]]]} | Open Access 1 | San Luis Obispo holding 6 | 24935 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 9.746 | San Luis Obispo holding 6 |
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]);