units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 104, MNG_AGENCY = 47 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 5 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 5 ✖
DES_TP 1
- State Other or Unknown · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1169 | 1169 | 1168 | {"type": "MultiPolygon", "coordinates": [[[[-118.27708, 34.23336], [-118.2746, 34.23281], [-118.27449, 34.23274], [-118.27367, 34.23255], [-118.26859, 34.23141], [-118.268, 34.23107], [-118.26755, 34.23097], [-118.26718, 34.23078], [-118.26693, 34.23072], [-118.2668, 34.23061], [-118.26718, 34.23041], [-118.26682, 34.22994], [-118.26683, 34.22784], [-118.26967, 34.22964], [-118.27167, 34.23046], [-118.27708, 34.23336]]], [[[-118.27981, 34.23393], [-118.27925, 34.23386], [-118.27867, 34.23373], [-118.27191, 34.2301], [-118.26993, 34.22928], [-118.26683, 34.22733], [-118.26687, 34.22185], [-118.27531, 34.22179], [-118.27539, 34.2291], [-118.27975, 34.22907], [-118.27981, 34.23393]]]]} | Open Access 1 | 6828 | Verdugo Mountains Park Property | 1781 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=635 | Los Angeles 6 | 252.47 | Verdugo Mtns. Park Property | 1984 | State Other or Unknown 104 | 4 |
2979 | 2979 | 2978 | {"type": "Polygon", "coordinates": [[[-120.17147, 39.1305], [-120.17145, 39.13637], [-120.1712, 39.13638], [-120.17094, 39.1367], [-120.17066, 39.13676], [-120.17037, 39.13686], [-120.16983, 39.13691], [-120.16953, 39.1369], [-120.16901, 39.1366], [-120.16873, 39.13657], [-120.16812, 39.13666], [-120.16724, 39.13647], [-120.16687, 39.13649], [-120.1665, 39.13654], [-120.16616, 39.13643], [-120.16584, 39.1362], [-120.16563, 39.1361], [-120.16571, 39.13591], [-120.1652, 39.13575], [-120.16498, 39.13614], [-120.16475, 39.13622], [-120.16449, 39.13598], [-120.16342, 39.13584], [-120.16284, 39.13583], [-120.1626, 39.13559], [-120.16205, 39.13522], [-120.16162, 39.13528], [-120.16163, 39.13525], [-120.16143, 39.13496], [-120.16121, 39.13469], [-120.16081, 39.13411], [-120.16023, 39.13417], [-120.16027, 39.13409], [-120.15972, 39.13392], [-120.15967, 39.134], [-120.15941, 39.13389], [-120.15925, 39.13375], [-120.15847, 39.13314], [-120.15794, 39.13293], [-120.15793, 39.1329], [-120.15754, 39.13275], [-120.16017, 39.13035], [-120.16115, 39.12938], [-120.16136, 39.12912], [-120.16153, 39.12885], [-120.16198, 39.12785], [-120.16434, 39.1285], [-120.16376, 39.12982], [-120.16458, 39.13004], [-120.16447, 39.13029], [-120.16447, 39.13031], [-120.16653, 39.13089], [-120.16723, 39.12932], [-120.17147, 39.1305]]]} | Open Access 1 | 20528 | Ward Creek Property | 1782 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=513 | Placer 35 | 183.198 | Ward Creek Property | 1978 | State Other or Unknown 104 | 4 |
4776 | 4776 | 4775 | {"type": "MultiPolygon", "coordinates": [[[[-123.78094, 40.04105], [-123.77631, 40.04038], [-123.77621, 40.03407], [-123.77658, 40.03481], [-123.77778, 40.03667], [-123.77813, 40.03737], [-123.77819, 40.03767], [-123.7784, 40.03788], [-123.77868, 40.0386], [-123.77936, 40.03934], [-123.78039, 40.0401], [-123.78085, 40.0399], [-123.78089, 40.03991], [-123.78086, 40.03993], [-123.78094, 40.04105]]], [[[-124.15793, 40.54867], [-124.15215, 40.54859], [-124.15399, 40.54211], [-124.15466, 40.54314], [-124.15526, 40.54451], [-124.15583, 40.5456], [-124.15629, 40.54623], [-124.157, 40.54706], [-124.15756, 40.54776], [-124.15793, 40.54867]]], [[[-124.15905, 40.56405], [-124.15698, 40.56404], [-124.15638, 40.56307], [-124.15904, 40.5631], [-124.15905, 40.56405]]], [[[-124.17889, 40.59558], [-124.17889, 40.59558], [-124.17622, 40.59879], [-124.17608, 40.59791], [-124.17668, 40.59502], [-124.17645, 40.59463], [-124.17889, 40.59558]]]]} | Open Access 1 | 46941 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Humboldt 45 | 91.244 | 0 | State Other or Unknown 104 | 4 | ||
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]]} | Open Access 1 | 48969 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Los Angeles 6 | 39.075 | 0 | State Other or Unknown 104 | 4 | ||
10166 | 10166 | 10165 | {"type": "Polygon", "coordinates": [[[-121.50965, 38.26426], [-121.504, 38.26799], [-121.50354, 38.26776], [-121.49741, 38.2718], [-121.49714, 38.27079], [-121.49718, 38.27056], [-121.49735, 38.27044], [-121.49739, 38.27031], [-121.49769, 38.27006], [-121.49778, 38.26953], [-121.49789, 38.2695], [-121.49772, 38.26927], [-121.4976, 38.26904], [-121.49618, 38.27013], [-121.49636, 38.27139], [-121.49639, 38.27268], [-121.49826, 38.27354], [-121.49845, 38.27456], [-121.49793, 38.27673], [-121.4954, 38.27672], [-121.49517, 38.27538], [-121.4951, 38.27483], [-121.49506, 38.27443], [-121.49502, 38.27373], [-121.49502, 38.27313], [-121.49508, 38.27226], [-121.49523, 38.27126], [-121.49541, 38.27047], [-121.49531, 38.27045], [-121.49556, 38.2696], [-121.49584, 38.26887], [-121.49583, 38.26885], [-121.49576, 38.26885], [-121.49617, 38.26803], [-121.49757, 38.26552], [-121.49751, 38.26545], [-121.49743, 38.26543], [-121.49724, 38.26541], [-121.49715, 38.26534], [-121.49699, 38.26526], [-121.49701, 38.2652], [-121.4968, 38.26514], [-121.4967, 38.26509], [-121.49661, 38.26509], [-121.49571, 38.26502], [-121.49553, 38.26473], [-121.49532, 38.26455], [-121.49523, 38.26454], [-121.49511, 38.26435], [-121.49489, 38.26415], [-121.49478, 38.26414], [-121.4945, 38.2639], [-121.49426, 38.26356], [-121.49412, 38.26323], [-121.49401, 38.26242], [-121.49388, 38.26202], [-121.49327, 38.26127], [-121.49309, 38.26093], [-121.49298, 38.26063], [-121.49294, 38.25993], [-121.49297, 38.25961], [-121.49309, 38.25931], [-121.49341, 38.25904], [-121.4938, 38.25889], [-121.4939, 38.25893], [-121.49429, 38.25876], [-121.49445, 38.25876], [-121.49481, 38.25864], [-121.49524, 38.25847], [-121.49556, 38.25815], [-121.49606, 38.25758], [-121.49621, 38.25729], [-121.4963, 38.25716], [-121.49746, 38.25638], [-121.49789, 38.25614], [-121.49806, 38.25609], [-121.49821, 38.25602], [-121.49851, 38.25559], [-121.49843, 38.25518], [-121.4982, 38.25464], [-121.49814, 38.25443], [-121.49806, 38.25399], [-121.49802, 38.25353], [-121.49797, 38.25326], [-121.49795, 38.25286], [-121.4979, 38.25256], [-121.49773, 38.25179], [-121.49772, 38.25147], [-121.50104, 38.25101], [-121.50156, 38.25114], [-121.5038, 38.25083], [-121.50375, 38.25063], [-121.50339, 38.25068], [-121.5027, 38.24588], [-121.50353, 38.24609], [-121.5037, 38.24612], [-121.50384, 38.24617], [-121.50863, 38.24741], [-121.50921, 38.24635], [-121.50958, 38.24651], [-121.5081, 38.24892], [-121.50797, 38.24894], [-121.50805, 38.24901], [-121.50763, 38.24968], [-121.50783, 38.25006], [-121.50797, 38.25004], [-121.50312, 38.25795], [-121.5029, 38.25787], [-121.50269, 38.25821], [-121.50498, 38.25966], [-121.5073, 38.26083], [-121.50771, 38.26135], [-121.5083, 38.26215], [-121.50965, 38.26426]]]} | No Public Access 3 | 20470 | Delta Meadows Park Property | 18073 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Sacramento 41 | 533.415 | Delta Meadows Park Property | 1985 | State Other or Unknown 104 | 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]);