units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_NAME = 672
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3723 | 3723 | 3722 | {"type": "Polygon", "coordinates": [[[-124.21314, 41.8682], [-124.213, 41.86893], [-124.21297, 41.86902], [-124.21287, 41.86916], [-124.21219, 41.86918], [-124.21116, 41.86925], [-124.21155, 41.8682], [-124.21314, 41.86807], [-124.21314, 41.8682]]]} | Unknown Access 4 | 44703 | Kellogg Beach | 20579 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 4.007 | Kellogg Beach | 0 | Local Park 2 | 4 | |
5442 | 5442 | 5441 | {"type": "Polygon", "coordinates": [[[-124.12175, 41.85473], [-124.12022, 41.8547], [-124.12029, 41.85451], [-124.12039, 41.85336], [-124.12051, 41.85288], [-124.12086, 41.85203], [-124.12082, 41.85183], [-124.1206, 41.85116], [-124.12052, 41.85103], [-124.11957, 41.84978], [-124.11897, 41.84931], [-124.11887, 41.84921], [-124.11873, 41.84904], [-124.11853, 41.84866], [-124.11837, 41.84841], [-124.11816, 41.84818], [-124.11785, 41.84791], [-124.11786, 41.84746], [-124.11787, 41.84745], [-124.11789, 41.844], [-124.11857, 41.84418], [-124.11873, 41.84427], [-124.11878, 41.84428], [-124.11892, 41.8444], [-124.11931, 41.84468], [-124.11935, 41.84475], [-124.1195, 41.84487], [-124.11963, 41.84504], [-124.11963, 41.84517], [-124.1196, 41.8453], [-124.11931, 41.84591], [-124.1192, 41.84639], [-124.11922, 41.84657], [-124.11919, 41.84694], [-124.11925, 41.8474], [-124.11925, 41.84746], [-124.11923, 41.84747], [-124.11922, 41.84771], [-124.11927, 41.8479], [-124.11933, 41.84838], [-124.11951, 41.8488], [-124.1196, 41.84896], [-124.11967, 41.84915], [-124.11975, 41.84929], [-124.1202, 41.84969], [-124.12029, 41.84987], [-124.12034, 41.85003], [-124.12035, 41.85018], [-124.12044, 41.85039], [-124.12052, 41.85067], [-124.12103, 41.85116], [-124.12122, 41.85138], [-124.12141, 41.85169], [-124.1216, 41.85199], [-124.12187, 41.85262], [-124.12197, 41.85302], [-124.12195, 41.85363], [-124.12196, 41.85398], [-124.12188, 41.85421], [-124.12175, 41.85473]]]} | Open Access 1 | 47734 | Ruby Van Deventer County Park | 31536 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/park/ruby-van-deventer-county-park/ | Del Norte 50 | 27.24 | Ruby Van Deventer County Park | None 439 | ||
6712 | 6712 | 6711 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20236, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.20349, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | 48412 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 5.186 | Pyke Field | 0 | Local Recreation Area 3 | 4 | |
12165 | 12165 | 12164 | {"type": "Polygon", "coordinates": [[[-124.15163, 41.80908], [-124.15102, 41.809], [-124.15049, 41.80888], [-124.1496, 41.80854], [-124.14788, 41.80801], [-124.14838, 41.80521], [-124.15153, 41.80524], [-124.15163, 41.80908]]]} | Open Access 1 | 25368 | Florence Keller Park | 18961 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 26.849 | Florence Keller Park | 0 | Local Park 2 | 4 | |
12166 | 12166 | 12165 | {"type": "Polygon", "coordinates": [[[-124.20572, 41.97312], [-124.20571, 41.97334], [-124.20565, 41.97363], [-124.20569, 41.97397], [-124.20568, 41.97417], [-124.20317, 41.97415], [-124.20314, 41.9731], [-124.20572, 41.97312]]]} | Open Access 1 | 25369 | Kamph Memorial Park | 20548 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 6.049 | Kamph Memorial Park | 0 | Local Park 2 | 4 | |
12684 | 12684 | 12683 | {"type": "MultiPolygon", "coordinates": [[[[-124.23966, 41.77097], [-124.23864, 41.77117], [-124.23847, 41.77079], [-124.23837, 41.77061], [-124.2383, 41.77053], [-124.23809, 41.77029], [-124.23778, 41.76998], [-124.23727, 41.76955], [-124.22932, 41.76403], [-124.23032, 41.76399], [-124.2313, 41.7646], [-124.23231, 41.76529], [-124.23319, 41.76587], [-124.23412, 41.76635], [-124.2342, 41.76637], [-124.23494, 41.76685], [-124.23562, 41.76742], [-124.236, 41.76782], [-124.23687, 41.76861], [-124.23692, 41.7687], [-124.2371, 41.76889], [-124.2383, 41.77003], [-124.23917, 41.77076], [-124.23952, 41.7709], [-124.23966, 41.77097]]], [[[-124.25357, 41.78535], [-124.2531, 41.78529], [-124.25267, 41.78538], [-124.25246, 41.7854], [-124.25172, 41.78564], [-124.25108, 41.78595], [-124.25085, 41.78611], [-124.25074, 41.78616], [-124.25049, 41.78634], [-124.24986, 41.78696], [-124.24973, 41.78716], [-124.24952, 41.78732], [-124.2494, 41.78752], [-124.24871, 41.78753], [-124.24443, 41.78444], [-124.24436, 41.78221], [-124.24399, 41.77305], [-124.24457, 41.77304], [-124.24459, 41.77204], [-124.24479, 41.77198], [-124.24507, 41.77183], [-124.24528, 41.7716], [-124.2457, 41.77092], [-124.24621, 41.77072], [-124.24689, 41.77071], [-124.2469, 41.77073], [-124.24706, 41.77073], [-124.24772, 41.77089], [-124.24788, 41.77103], [-124.24788, 41.77115], [-124.24811, 41.77166], [-124.24833, 41.7718], [-124.24836, 41.77244], [-124.24816, 41.77264], [-124.24818, 41.77302], [-124.24825, 41.77336], [-124.24824, 41.77358], [-124.2483, 41.77389], [-124.2485, 41.77414], [-124.24875, 41.77441], [-124.24879, 41.77451], [-124.24899, 41.77468], [-124.24914, 41.77488], [-124.24932, 41.77485], [-124.24943, 41.77486], [-124.24979, 41.7748], [-124.24995, 41.7747], [-124.25017, 41.77466], [-124.25035, 41.77471], [-124.25073, 41.77472], [-124.25085, 41.77478], [-124.25094, 41.77496], [-124.25088, 41.77517], [-124.25097, 41.77524], [-124.251, 41.77532], [-124.25099, 41.77543], [-124.2509, 41.7755], [-124.25091, 41.77559], [-124.2508, 41.77563], [-124.2504, 41.77569], [-124.25012, 41.77588], [-124.2501, 41.77596], [-124.25024, 41.7763], [-124.25046, 41.77656], [-124.25068, 41.77671], [-124.25078, 41.77687], [-124.25111, 41.77717], [-124.25126, 41.77726], [-124.25139, 41.77729], [-124.25165, 41.77755], [-124.25177, 41.77759], [-124.25209, 41.77775], [-124.25226, 41.77793], [-124.25269, 41.77815], [-124.25297, 41.77831], [-124.25301, 41.7783], [-124.25344, 41.77855], [-124.25346, 41.7795], [-124.25344, 41.78037], [-124.25349, 41.7824], [-124.25189, 41.78253], [-124.25191, 41.78428], [-124.25247, 41.78431], [-124.25301, 41.78431], [-124.25302, 41.78446], [-124.25355, 41.78445], [-124.25357, 41.78535]]]]} | Open Access 1 | 29662 | Point St. George | 3081 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.visitredwoodcoast.com/content/point-st-george-heritage-area/ncoC5001D7E35E00EA39 | Del Norte 50 | 262.074 | Point St. George | None 1102 | ||
14917 | 14917 | 14916 | {"type": "Polygon", "coordinates": [[[-124.15565, 41.74626], [-124.15565, 41.74659], [-124.15543, 41.7466], [-124.15543, 41.74692], [-124.15471, 41.74692], [-124.15467, 41.74626], [-124.15565, 41.74626]]]} | Open Access 1 | 45487 | Bertsch Tract Park | 28317 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 1.281 | Bertsch Tract 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]);