units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where LAYER = 3, MNG_AGENCY = 661 and MNG_AG_TYP = 7
This data as json, copyable, CSV (advanced)
DES_TP 3
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency - Parks · 6 ✖
MNG_AGENCY 1
- Del Norte County Parks, County of · 6 ✖
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 | |
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]);