units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 2, LAYER = 3 and MNG_AGENCY = 736
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | 45592 | Lake Forest Park | 28418 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 0.17 | Lake Forest Park | 0 | Local Park 2 | 4 | |
12365 | 12365 | 12364 | {"type": "Polygon", "coordinates": [[[-121.13882, 41.1215], [-121.1388, 41.12256], [-121.13851, 41.12256], [-121.13851, 41.1227], [-121.13831, 41.1227], [-121.13798, 41.12334], [-121.13683, 41.12331], [-121.13678, 41.12411], [-121.13849, 41.12478], [-121.13372, 41.12466], [-121.13375, 41.12141], [-121.13483, 41.12142], [-121.1348, 41.12231], [-121.13481, 41.12232], [-121.13606, 41.12234], [-121.13611, 41.12143], [-121.13872, 41.12145], [-121.13882, 41.1215]]]} | Open Access 1 | 26506 | Clara Beiber Memorial Park | 17378 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 29.359 | Clara Beiber Memorial Park | 0 | Local Park 2 | 4 | |
13006 | 13006 | 13005 | {"type": "MultiPolygon", "coordinates": [[[[-120.68104, 40.45295], [-120.68099, 40.46019], [-120.67649, 40.46022], [-120.67654, 40.45661], [-120.67653, 40.4566], [-120.66706, 40.45665], [-120.667, 40.46027], [-120.66226, 40.4603], [-120.6623, 40.45668], [-120.6531, 40.45655], [-120.65312, 40.45293], [-120.65304, 40.44917], [-120.66237, 40.44922], [-120.66239, 40.44043], [-120.66338, 40.44176], [-120.66359, 40.44199], [-120.66482, 40.4428], [-120.66579, 40.44331], [-120.66713, 40.44409], [-120.6671, 40.45302], [-120.68104, 40.45295]]], [[[-120.69991, 40.43132], [-120.67685, 40.43119], [-120.67664, 40.4383], [-120.67663, 40.44185], [-120.66715, 40.44196], [-120.66712, 40.44374], [-120.6654, 40.44268], [-120.66459, 40.44227], [-120.66384, 40.44171], [-120.66272, 40.44014], [-120.66252, 40.43976], [-120.66257, 40.43835], [-120.66716, 40.43833], [-120.66725, 40.43476], [-120.66527, 40.43474], [-120.66533, 40.43308], [-120.66498, 40.4331], [-120.66395, 40.43311], [-120.66334, 40.43308], [-120.66261, 40.43303], [-120.6639, 40.43309], [-120.6649, 40.43309], [-120.66554, 40.43306], [-120.66589, 40.43303], [-120.6672, 40.43283], [-120.66692, 40.43187], [-120.66677, 40.43189], [-120.66669, 40.43169], [-120.66653, 40.43117], [-120.66621, 40.43004], [-120.66606, 40.42961], [-120.66606, 40.42947], [-120.66595, 40.42852], [-120.66656, 40.4289], [-120.66691, 40.42853], [-120.66647, 40.42826], [-120.66593, 40.42826], [-120.66556, 40.42755], [-120.66555, 40.42742], [-120.66707, 40.42744], [-120.66708, 40.42711], [-120.66746, 40.42741], [-120.66747, 40.42751], [-120.6955, 40.42767], [-120.69768, 40.4277], [-120.69986, 40.4277], [-120.69991, 40.43132]], [[-120.66836, 40.42939], [-120.66836, 40.42938], [-120.66777, 40.42911], [-120.66749, 40.42957], [-120.66773, 40.42965], [-120.66809, 40.4298], [-120.66836, 40.42939]]]]} | Open Access 1 | 31210 | Susanville Ranch Park | 5230 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.susanvilleranchpark.com/ | Lassen 54 | 1083.674 | Susanville Ranch Park | 0 | Local Park 2 | 4 |
14927 | 14927 | 14926 | {"type": "Polygon", "coordinates": [[[-121.05053, 40.29888], [-121.05041, 40.29895], [-121.05002, 40.29909], [-121.04992, 40.29928], [-121.04993, 40.3001], [-121.04991, 40.30054], [-121.04995, 40.30076], [-121.05009, 40.3012], [-121.05036, 40.3026], [-121.05035, 40.30285], [-121.05022, 40.30338], [-121.04992, 40.30358], [-121.04899, 40.30369], [-121.04872, 40.30348], [-121.04859, 40.30305], [-121.04872, 40.30279], [-121.04882, 40.30251], [-121.04853, 40.30131], [-121.04835, 40.30045], [-121.04823, 40.29965], [-121.04858, 40.29925], [-121.05, 40.29859], [-121.05053, 40.29888]]]} | Open Access 1 | 45503 | Clear Creek Park | 28335 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 17.372 | Clear Creek Park | 0 | Local Park 2 | 4 | |
14965 | 14965 | 14964 | {"type": "Polygon", "coordinates": [[[-120.52341, 40.29987], [-120.52322, 40.30012], [-120.52303, 40.30027], [-120.52307, 40.30052], [-120.52318, 40.3009], [-120.52313, 40.30104], [-120.52303, 40.30109], [-120.52292, 40.30119], [-120.52286, 40.30126], [-120.52242, 40.30161], [-120.52148, 40.30112], [-120.52143, 40.30107], [-120.52173, 40.3007], [-120.52205, 40.30035], [-120.52233, 40.29995], [-120.5226, 40.29976], [-120.5227, 40.29966], [-120.5231, 40.29967], [-120.52341, 40.29987]]]} | Open Access 1 | 45579 | Janesville Park | 28404 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 4.808 | Janesville Park | 0 | Local Park 2 | 4 | |
14977 | 14977 | 14976 | {"type": "Polygon", "coordinates": [[[-120.52303, 40.3739], [-120.52281, 40.37423], [-120.52276, 40.37436], [-120.52276, 40.37473], [-120.5228, 40.37498], [-120.52221, 40.37504], [-120.52204, 40.37449], [-120.52192, 40.37367], [-120.52292, 40.37384], [-120.52291, 40.37388], [-120.52303, 40.3739]]]} | Open Access 1 | 45596 | Leavitt Lake Park | 28422 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 2.292 | Leavitt Lake 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]);