units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, AGNCY_TYP = 13 and COUNTY = 6
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID
MNG_AGENCY 8
DES_TP 5
- Local Park 5
- Local Recreation Area 1
- None 1
- None 1
- None 1
MNG_AG_TYP 3
ACCESS_TYP 1
- Open Access · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1200 | 1200 | 1199 | {"type": "MultiPolygon", "coordinates": [[[[-117.90541, 34.1585], [-117.90453, 34.15837], [-117.90437, 34.15839], [-117.90421, 34.15845], [-117.904, 34.15843], [-117.90408, 34.15835], [-117.90423, 34.15828], [-117.9044, 34.15824], [-117.90456, 34.15824], [-117.9054, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15868], [-117.90754, 34.15881], [-117.90649, 34.15867], [-117.90649, 34.15852], [-117.90754, 34.15868]]], [[[-117.90401, 34.15871], [-117.90397, 34.15877], [-117.90371, 34.15961], [-117.9033, 34.15961], [-117.90163, 34.16004], [-117.89984, 34.1611], [-117.89886, 34.16208], [-117.89885, 34.16256], [-117.89881, 34.16256], [-117.89882, 34.16212], [-117.89861, 34.16211], [-117.89973, 34.16101], [-117.90022, 34.1607], [-117.89901, 34.16124], [-117.89884, 34.16139], [-117.8987, 34.16156], [-117.89728, 34.16357], [-117.89714, 34.16374], [-117.89686, 34.164], [-117.89655, 34.1642], [-117.89633, 34.16431], [-117.89605, 34.16441], [-117.89461, 34.1647], [-117.89323, 34.16486], [-117.89298, 34.16493], [-117.89253, 34.16513], [-117.89224, 34.16513], [-117.89224, 34.1651], [-117.89289, 34.16481], [-117.89305, 34.16475], [-117.89459, 34.16456], [-117.89597, 34.16429], [-117.89617, 34.16423], [-117.8964, 34.16412], [-117.89668, 34.16396], [-117.89684, 34.16383], [-117.89705, 34.16361], [-117.89856, 34.16149], [-117.89868, 34.16134], [-117.8989, 34.16114], [-117.90321, 34.15912], [-117.90322, 34.1591], [-117.90317, 34.15875], [-117.90362, 34.1587], [-117.90401, 34.15871]], [[-117.90325, 34.15927], [-117.90321, 34.15927], [-117.90307, 34.15933], [-117.90229, 34.15971], [-117.90327, 34.15948], [-117.90325, 34.15927]]]]} | Open Access 1 | 6939 | San Gabriel River | 24896 | 2137 | San Gabriel River Water Committee 332 | Special District 4 | Water District 13 | Special District 4 | 2137 | San Gabriel River Water Committee 329 | Special District 4 | Water District 13 | Los Angeles 6 | 8.661 | San Gabriel River | 0 | None 106 | |||
1711 | 1711 | 1710 | {"type": "MultiPolygon", "coordinates": [[[[-117.75671, 34.13628], [-117.75616, 34.13503], [-117.75433, 34.13264], [-117.75496, 34.13229], [-117.75515, 34.13228], [-117.75538, 34.13231], [-117.75558, 34.13237], [-117.75577, 34.13247], [-117.7559, 34.13258], [-117.756, 34.1327], [-117.75602, 34.1327], [-117.75598, 34.13277], [-117.75599, 34.13287], [-117.75608, 34.13297], [-117.75617, 34.13316], [-117.75628, 34.13334], [-117.75649, 34.13358], [-117.75668, 34.13374], [-117.75692, 34.13388], [-117.75719, 34.13399], [-117.75749, 34.13408], [-117.75752, 34.1341], [-117.75671, 34.13628]]], [[[-117.75871, 34.13267], [-117.75854, 34.13285], [-117.75791, 34.13333], [-117.75789, 34.13339], [-117.7577, 34.13366], [-117.75762, 34.13385], [-117.75758, 34.13387], [-117.75731, 34.1338], [-117.75708, 34.1337], [-117.75687, 34.13358], [-117.75668, 34.13343], [-117.75651, 34.13324], [-117.75639, 34.13303], [-117.75634, 34.13292], [-117.75637, 34.13283], [-117.75637, 34.13278], [-117.75632, 34.1327], [-117.75737, 34.13269], [-117.75791, 34.13213], [-117.75871, 34.13267]]]]} | Open Access 1 | 12847 | Live Oak Park | 21373 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Los Angeles 6 | 16.964 | Live Oak Park | 0 | Local Park 2 | 4 | |
7360 | 7360 | 7359 | {"type": "Polygon", "coordinates": [[[-118.08782, 34.09166], [-118.08668, 34.09167], [-118.08664, 34.09164], [-118.08661, 34.08959], [-118.08664, 34.08955], [-118.0867, 34.08954], [-118.08774, 34.08992], [-118.08782, 34.09166]]]} | Open Access 1 | 6756 | Sally Tanner Park | 29852 | 2136 | San Gabriel County Water District 858 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 5.656 | Sally Tanner Park | 0 | Local Park 2 | 4 | |
7373 | 7373 | 7372 | {"type": "Polygon", "coordinates": [[[-118.11443, 34.10438], [-118.1143, 34.10445], [-118.11408, 34.10404], [-118.11378, 34.10418], [-118.11341, 34.10321], [-118.1138, 34.10302], [-118.11397, 34.10334], [-118.11419, 34.10387], [-118.11414, 34.10389], [-118.11421, 34.10408], [-118.11434, 34.10429], [-118.11439, 34.10429], [-118.11443, 34.10438]]]} | Open Access 1 | 6757 | Alhambra Wash | 15358 | 2136 | San Gabriel County Water District 858 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 2136 | San Gabriel County Water District 836 | Special District 4 | Water District 13 | Los Angeles 6 | 1.369 | Alhambra Wash | None 612 | |||
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-118.55086, 34.42777], [-118.55071, 34.42814], [-118.55003, 34.42806], [-118.54982, 34.42802], [-118.54982, 34.428], [-118.54977, 34.42799], [-118.54976, 34.42802], [-118.54855, 34.42796], [-118.54655, 34.42794], [-118.54585, 34.42615], [-118.54604, 34.42614], [-118.54672, 34.42619], [-118.54707, 34.42614], [-118.54709, 34.42619], [-118.54768, 34.42609], [-118.54894, 34.42607], [-118.54869, 34.42636], [-118.55086, 34.42777]]]} | Open Access 1 | 20658 | Bridgeport Park | 16380 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.763 | Bridgeport Park | 0 | Local Park 2 | 4 | |
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52373, 34.43438], [-118.52366, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52356, 34.43443], [-118.52349, 34.43445], [-118.52292, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.51831, 34.43207], [-118.51831, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42936], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52384, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.5253, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} | Open Access 1 | 24527 | Central Park | 5954 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=409 | Los Angeles 6 | 122.849 | Central Park | 0 | Local Park 2 | 4 |
15200 | 15200 | 15199 | {"type": "Polygon", "coordinates": [[[-118.70299, 34.13344], [-118.70263, 34.13507], [-118.70242, 34.13504], [-118.70246, 34.13481], [-118.70253, 34.13472], [-118.70254, 34.1346], [-118.70246, 34.13445], [-118.70233, 34.13449], [-118.70199, 34.13442], [-118.70197, 34.13438], [-118.70198, 34.1343], [-118.70207, 34.13416], [-118.70211, 34.13395], [-118.70221, 34.13372], [-118.70237, 34.13352], [-118.70261, 34.13343], [-118.70299, 34.13344]]]} | Open Access 1 | 46078 | Calabasas Bark Park | 29419 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation/barkpark.html | Los Angeles 6 | 2.209 | Calabasas Bark Park | 0 | Local Park 2 | 4 |
15212 | 15212 | 15211 | {"type": "Polygon", "coordinates": [[[-118.12969, 34.59423], [-118.12962, 34.5943], [-118.12838, 34.59431], [-118.12835, 34.59165], [-118.12827, 34.59164], [-118.12835, 34.59164], [-118.12837, 34.59289], [-118.12967, 34.59288], [-118.12969, 34.59423]]]} | Open Access 1 | 46107 | American Indian Little League Site | 29449 | 2386 | Palmdale Water District 1141 | Special District 4 | Water District 13 | http://www.palmdalewater.org/ | Special District 4 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 4.657 | American Indian Little League Site | None 1332 | |||
16262 | 16262 | 16261 | {"type": "Polygon", "coordinates": [[[-117.93705, 33.96918], [-117.93697, 33.96925], [-117.93701, 33.96946], [-117.93701, 33.96978], [-117.93684, 33.96991], [-117.93654, 33.96989], [-117.93623, 33.96967], [-117.93635, 33.96954], [-117.93648, 33.96933], [-117.9366, 33.96936], [-117.93669, 33.96909], [-117.93671, 33.9689], [-117.9369, 33.96915], [-117.937, 33.96914], [-117.93705, 33.96918]]]} | Open Access 1 | 46395 | Powder Canyon Open Space | 29673 | 2392 | La Habra Heights County Water District 1168 | Special District 4 | Water District 13 | http://www.lhhcwd.com/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.12 | Powder Canyon 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]);