superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 322 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12460 | 12460 | 12459 | {"type": "Polygon", "coordinates": [[[-118.52918, 34.37774], [-118.52876, 34.37796], [-118.5283, 34.37737], [-118.5283, 34.37737], [-118.52918, 34.37774]]]} | Open Access 1 | Veterans Historical Plaza | http://www.santa-clarita.com/index.aspx?page=422 | 29505 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 0.434 | Veterans Historical Plaza | |
858 | 858 | 857 | {"type": "Polygon", "coordinates": [[[-118.55494, 34.44777], [-118.55391, 34.44758], [-118.55351, 34.44757], [-118.55306, 34.44759], [-118.55321, 34.44728], [-118.55333, 34.44695], [-118.55344, 34.44661], [-118.55347, 34.44659], [-118.55446, 34.4467], [-118.55494, 34.44777]]]} | Open Access 1 | Summerhill Park | 32719 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 3.493 | Summerhill Park | ||
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.5352, 34.39926], [-118.53466, 34.39936], [-118.53487, 34.40053], [-118.53406, 34.40064], [-118.53387, 34.39968], [-118.53393, 34.39948], [-118.53438, 34.39903], [-118.53425, 34.39893], [-118.53412, 34.39904], [-118.53381, 34.39935], [-118.53374, 34.39902], [-118.53411, 34.39885], [-118.53451, 34.3986], [-118.5346, 34.39897], [-118.53464, 34.39893], [-118.53469, 34.39894], [-118.53475, 34.39884], [-118.53489, 34.39877], [-118.53505, 34.39864], [-118.53505, 34.39879], [-118.5352, 34.39926]]]} | Open Access 1 | Circle J Ranch Park | 17263 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.107 | Circle J Ranch Park | ||
1901 | 1901 | 1900 | {"type": "Polygon", "coordinates": [[[-118.39597, 34.43856], [-118.39415, 34.43852], [-118.39416, 34.43766], [-118.39535, 34.4373], [-118.39547, 34.43749], [-118.39559, 34.43762], [-118.39566, 34.43771], [-118.39571, 34.43786], [-118.39571, 34.43806], [-118.39574, 34.43819], [-118.39584, 34.43841], [-118.39597, 34.43856]]]} | Open Access 1 | Begonias Lane Park | 15956 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.192 | Begonias Lane Park | ||
645 | 645 | 644 | {"type": "Polygon", "coordinates": [[[-118.5452, 34.39992], [-118.54518, 34.40007], [-118.54511, 34.40017], [-118.54512, 34.40031], [-118.54511, 34.40039], [-118.54481, 34.40102], [-118.54462, 34.4013], [-118.54457, 34.40143], [-118.54453, 34.40157], [-118.5444, 34.40157], [-118.54422, 34.40153], [-118.54382, 34.40139], [-118.54351, 34.40121], [-118.54338, 34.40112], [-118.5432, 34.40097], [-118.54313, 34.40089], [-118.54486, 34.39997], [-118.54492, 34.39998], [-118.54516, 34.3999], [-118.5452, 34.39992]]]} | Open Access 1 | Almendra Park | 15395 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.337 | Almendra Park | ||
7586 | 7586 | 7585 | {"type": "Polygon", "coordinates": [[[-118.41508, 34.43102], [-118.41508, 34.43191], [-118.41454, 34.4314], [-118.41426, 34.4312], [-118.41413, 34.43116], [-118.41379, 34.43115], [-118.41378, 34.43104], [-118.41362, 34.43103], [-118.41335, 34.43038], [-118.41411, 34.43019], [-118.41439, 34.43019], [-118.41447, 34.42991], [-118.41505, 34.42992], [-118.41508, 34.42995], [-118.41508, 34.43102]]]} | Open Access 1 | Oak Spring Park | 23006 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.918 | Oak Spring Park | ||
12471 | 12471 | 12470 | {"type": "Polygon", "coordinates": [[[-118.50169, 34.43095], [-118.5016, 34.43099], [-118.501, 34.43114], [-118.50088, 34.43132], [-118.50101, 34.43147], [-118.50082, 34.43159], [-118.50064, 34.43166], [-118.50052, 34.432], [-118.50031, 34.43202], [-118.50019, 34.43207], [-118.50007, 34.432], [-118.49939, 34.43176], [-118.49947, 34.43157], [-118.49952, 34.43137], [-118.49953, 34.43117], [-118.49952, 34.43059], [-118.49975, 34.4306], [-118.49996, 34.43065], [-118.50014, 34.43067], [-118.50071, 34.43068], [-118.50117, 34.43073], [-118.50151, 34.43074], [-118.50169, 34.43095]]]} | Open Access 1 | Golden Valley Park | http://www.santa-clarita.com/Home/Components/FacilityDirectory/FacilityDirectory/54/1386 | 29512 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.97 | Golden Valley Park | |
7653 | 7653 | 7652 | {"type": "Polygon", "coordinates": [[[-118.54936, 34.37941], [-118.54915, 34.38025], [-118.54883, 34.3801], [-118.54667, 34.38023], [-118.54631, 34.38034], [-118.54612, 34.37991], [-118.54608, 34.37971], [-118.54608, 34.37963], [-118.54614, 34.37958], [-118.54936, 34.37941]]]} | Open Access 1 | Old Orchard Park | 23096 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 5.386 | Old Orchard Park | ||
10594 | 10594 | 10593 | {"type": "Polygon", "coordinates": [[[-118.55633, 34.39477], [-118.55578, 34.39487], [-118.55576, 34.3948], [-118.55602, 34.39465], [-118.55597, 34.39448], [-118.55601, 34.39443], [-118.55602, 34.39437], [-118.55598, 34.39432], [-118.55586, 34.39423], [-118.55454, 34.39252], [-118.55448, 34.3924], [-118.55466, 34.39242], [-118.55585, 34.39202], [-118.55597, 34.3918], [-118.55612, 34.39197], [-118.55617, 34.39208], [-118.55619, 34.39223], [-118.55619, 34.39415], [-118.55615, 34.39427], [-118.55615, 34.39432], [-118.55619, 34.39437], [-118.55626, 34.3944], [-118.55625, 34.39446], [-118.55633, 34.39477]]]} | Open Access 1 | Valencia Meadows Park | 26763 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 6.126 | Valencia Meadows Park | ||
11825 | 11825 | 11824 | {"type": "Polygon", "coordinates": [[[-118.43986, 34.40521], [-118.43984, 34.40534], [-118.43953, 34.40525], [-118.43935, 34.40522], [-118.43917, 34.40522], [-118.4389, 34.40527], [-118.43874, 34.40535], [-118.43846, 34.40555], [-118.43827, 34.40566], [-118.43757, 34.4059], [-118.43714, 34.40612], [-118.43711, 34.40611], [-118.437, 34.406], [-118.43702, 34.40597], [-118.43665, 34.40549], [-118.43641, 34.4052], [-118.43639, 34.40512], [-118.43633, 34.4051], [-118.43633, 34.40506], [-118.43638, 34.40492], [-118.43652, 34.40487], [-118.43661, 34.40478], [-118.43674, 34.40445], [-118.43712, 34.40454], [-118.43851, 34.40493], [-118.43929, 34.40518], [-118.43966, 34.40522], [-118.43967, 34.40519], [-118.43977, 34.40518], [-118.43986, 34.40521]]]} | Open Access 1 | Fair Oaks Park | http://www.santa-clarita.com/index.aspx?page=986 | 28467 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 6.299 | Fair Oaks Park | |
14165 | 14165 | 14164 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.4284], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | North Oaks Park | http://www.santa-clarita.com/index.aspx?page=413 | 31633 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 6.4 | North Oaks Park | |
9303 | 9303 | 9302 | {"type": "Polygon", "coordinates": [[[-118.53612, 34.44773], [-118.53506, 34.44778], [-118.53487, 34.44533], [-118.5361, 34.44527], [-118.53612, 34.44773]]]} | Open Access 1 | Santa Clarita Park | 25059 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.125 | Santa Clarita Park | ||
12099 | 12099 | 12098 | {"type": "Polygon", "coordinates": [[[-118.54852, 34.45524], [-118.54772, 34.45535], [-118.54673, 34.45561], [-118.5462, 34.45564], [-118.54608, 34.45561], [-118.54585, 34.45444], [-118.5464, 34.45436], [-118.54704, 34.4543], [-118.54743, 34.45429], [-118.54834, 34.45432], [-118.54837, 34.45434], [-118.54839, 34.45437], [-118.54845, 34.45489], [-118.54852, 34.45524]]]} | Open Access 1 | Chesebrough Park | http://www.santa-clarita.com/chesebroughpark | 29034 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.136 | Chesebrough Park | |
10602 | 10602 | 10601 | {"type": "Polygon", "coordinates": [[[-118.55064, 34.39482], [-118.55036, 34.39498], [-118.55004, 34.39523], [-118.54984, 34.39543], [-118.54956, 34.39575], [-118.54943, 34.39583], [-118.54939, 34.39588], [-118.54936, 34.39588], [-118.54928, 34.39603], [-118.54867, 34.39579], [-118.54863, 34.39585], [-118.54858, 34.396], [-118.54855, 34.396], [-118.54854, 34.39603], [-118.54833, 34.396], [-118.54817, 34.39593], [-118.54799, 34.39579], [-118.54791, 34.3957], [-118.54781, 34.39553], [-118.54776, 34.39534], [-118.54772, 34.39529], [-118.54765, 34.39524], [-118.54759, 34.39523], [-118.54758, 34.3952], [-118.54755, 34.39519], [-118.54747, 34.39491], [-118.54758, 34.39484], [-118.54754, 34.39476], [-118.54766, 34.3947], [-118.5478, 34.3946], [-118.54794, 34.39451], [-118.54798, 34.39454], [-118.5481, 34.3945], [-118.54813, 34.39456], [-118.54821, 34.3946], [-118.54821, 34.39468], [-118.54847, 34.39482], [-118.54843, 34.39489], [-118.54849, 34.39495], [-118.54862, 34.39502], [-118.5487, 34.39501], [-118.54871, 34.39504], [-118.54876, 34.39508], [-118.54883, 34.3951], [-118.54884, 34.39517], [-118.54909, 34.39528], [-118.55, 34.39402], [-118.55012, 34.39408], [-118.55045, 34.39451], [-118.55064, 34.39482]]]} | Open Access 1 | Valencia Glen Park | 26760 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.262 | Valencia Glen Park | ||
12470 | 12470 | 12469 | {"type": "Polygon", "coordinates": [[[-118.55874, 34.40582], [-118.55864, 34.40606], [-118.55852, 34.40619], [-118.55843, 34.40633], [-118.55825, 34.40674], [-118.55808, 34.40688], [-118.55799, 34.40703], [-118.558, 34.40721], [-118.5581, 34.4074], [-118.55781, 34.40752], [-118.55768, 34.40753], [-118.55757, 34.40749], [-118.55743, 34.40735], [-118.55717, 34.40725], [-118.55703, 34.40723], [-118.5569, 34.40728], [-118.55678, 34.40735], [-118.55643, 34.40742], [-118.55629, 34.40748], [-118.5564, 34.40778], [-118.55615, 34.40793], [-118.55557, 34.40723], [-118.55637, 34.4068], [-118.55641, 34.40682], [-118.55727, 34.40635], [-118.55752, 34.40606], [-118.55766, 34.40574], [-118.55794, 34.40547], [-118.55874, 34.40582]]]} | Open Access 1 | Valencia Summit Park | http://www.santa-clarita.com/Home/Components/FacilityDirectory/FacilityDirectory/82/1386 | 29511 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.37 | Valencia Summit Park | |
7911 | 7911 | 7910 | {"type": "Polygon", "coordinates": [[[-118.52879, 34.45008], [-118.52769, 34.45186], [-118.52742, 34.45177], [-118.52714, 34.4517], [-118.52679, 34.45165], [-118.52658, 34.45164], [-118.52658, 34.45113], [-118.52664, 34.45086], [-118.52677, 34.45061], [-118.52751, 34.44954], [-118.52879, 34.45008]]]} | Open Access 1 | Pamplico Park | 23381 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.596 | Pamplico Park | ||
12459 | 12459 | 12458 | {"type": "Polygon", "coordinates": [[[-118.50784, 34.46051], [-118.50782, 34.46054], [-118.50706, 34.46107], [-118.50688, 34.46119], [-118.5066, 34.46133], [-118.5061, 34.46152], [-118.50581, 34.46159], [-118.50553, 34.46164], [-118.50552, 34.45964], [-118.50688, 34.45967], [-118.50703, 34.45993], [-118.50732, 34.46008], [-118.50739, 34.46008], [-118.50745, 34.46017], [-118.50763, 34.4603], [-118.50784, 34.46051]]]} | Open Access 1 | Copper Hill Park | http://www.santa-clarita.com/index.aspx?page=989 | 29503 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 7.977 | Copper Hill Park | |
780 | 780 | 779 | {"type": "Polygon", "coordinates": [[[-118.53748, 34.35617], [-118.53731, 34.35774], [-118.53341, 34.35619], [-118.53341, 34.35619], [-118.53748, 34.35617]]]} | Open Access 1 | Newhall Pass_Plourde | 32717 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 8.054 | Newhall Pass_Plourde | ||
3307 | 3307 | 3306 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52156, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52103, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | Creekview Park | http://www.santa-clarita.com/index.aspx?page=411 | 17788 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 8.227 | Creekview Park | |
2169 | 2169 | 2168 | {"type": "Polygon", "coordinates": [[[-118.50693, 34.45383], [-118.50419, 34.45385], [-118.50418, 34.45232], [-118.50691, 34.4523], [-118.50693, 34.45383]]]} | Open Access 1 | Bouquet Canyon Park | 16302 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 10.564 | Bouquet Canyon Park |
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]);