units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where AGNCY_NAME = 690 and MNG_AGENCY = 680
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-124.12251, 41.04406], [-124.12176, 41.04463], [-124.12151, 41.04441], [-124.12099, 41.04406], [-124.12081, 41.04391], [-124.12065, 41.04375], [-124.12044, 41.04348], [-124.12027, 41.04316], [-124.1202, 41.04307], [-124.12117, 41.04308], [-124.12124, 41.04322], [-124.12149, 41.04344], [-124.1218, 41.0436], [-124.1221, 41.04381], [-124.12227, 41.04396], [-124.12251, 41.04406]]]} | Open Access 1 | 45380 | North Luffenholtz Beach | 27913 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 3.699 | North Luffenholtz Beach | 0 | Private Conservation 16 | 2 | |
3835 | 3835 | 3834 | {"type": "Polygon", "coordinates": [[[-124.11643, 41.03233], [-124.11537, 41.03235], [-124.11554, 41.03287], [-124.11572, 41.03287], [-124.11566, 41.03292], [-124.11567, 41.03296], [-124.11594, 41.03323], [-124.11503, 41.03408], [-124.11491, 41.0341], [-124.11473, 41.03419], [-124.11322, 41.03444], [-124.11308, 41.03445], [-124.1129, 41.03441], [-124.11286, 41.03437], [-124.11271, 41.03428], [-124.11244, 41.03421], [-124.11217, 41.03384], [-124.1122, 41.03373], [-124.11219, 41.03363], [-124.11215, 41.0335], [-124.11208, 41.03341], [-124.11203, 41.03336], [-124.11182, 41.03326], [-124.11171, 41.03319], [-124.11162, 41.03308], [-124.11171, 41.03308], [-124.11167, 41.033], [-124.11156, 41.033], [-124.11097, 41.03215], [-124.11133, 41.03215], [-124.11252, 41.03264], [-124.11253, 41.03263], [-124.11251, 41.03213], [-124.116, 41.03208], [-124.11626, 41.0322], [-124.11643, 41.03233]]]} | No Public Access 3 | 45381 | Pilot Point Nature Reserve | 31338 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://trinidadcoastallandtrust.org/holdings/pilotpoint/ | Humboldt 45 | 18.424 | Pilot Point Nature Reserve | 0 | Private Conservation 16 | 2 |
4058 | 4058 | 4057 | {"type": "Polygon", "coordinates": [[[-124.12861, 41.05046], [-124.12855, 41.05211], [-124.1267, 41.05095], [-124.12658, 41.05085], [-124.12646, 41.05069], [-124.12641, 41.05057], [-124.1264, 41.05039], [-124.12632, 41.05022], [-124.12623, 41.0501], [-124.12612, 41.04998], [-124.12577, 41.04975], [-124.12539, 41.04958], [-124.12508, 41.04939], [-124.12488, 41.04924], [-124.1247, 41.04907], [-124.12446, 41.0488], [-124.12435, 41.04863], [-124.12413, 41.04824], [-124.124, 41.04793], [-124.12393, 41.04771], [-124.12392, 41.0476], [-124.12482, 41.04671], [-124.12503, 41.04672], [-124.1253, 41.04675], [-124.1256, 41.04687], [-124.12574, 41.04699], [-124.12573, 41.04731], [-124.12526, 41.04767], [-124.12525, 41.04806], [-124.12541, 41.04821], [-124.12542, 41.04847], [-124.12546, 41.04863], [-124.1256, 41.04881], [-124.12591, 41.04914], [-124.12659, 41.04937], [-124.12769, 41.04967], [-124.128, 41.04977], [-124.1282, 41.05019], [-124.1285, 41.05033], [-124.12861, 41.05046]]]} | Open Access 1 | 44399 | Baker Beach | 15766 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 17.458 | Baker Beach | 0 | Private Conservation 16 | 2 | |
4311 | 4311 | 4310 | {"type": "Polygon", "coordinates": [[[-124.14215, 41.06163], [-124.14216, 41.06222], [-124.14214, 41.06229], [-124.14209, 41.0624], [-124.14204, 41.06246], [-124.14198, 41.06251], [-124.14186, 41.06258], [-124.14184, 41.06248], [-124.14083, 41.06253], [-124.14052, 41.06219], [-124.14117, 41.06192], [-124.14071, 41.06151], [-124.14108, 41.06136], [-124.14118, 41.06161], [-124.14194, 41.0615], [-124.14195, 41.0613], [-124.14192, 41.06121], [-124.14212, 41.06118], [-124.14215, 41.06163]]]} | Open Access 1 | 45379 | Saunders Park | 27897 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/holdings/index.html | Humboldt 45 | 3.134 | Saunders Park | 0 | Private Recreation or Education 65 | 4 |
7541 | 7541 | 7540 | {"type": "Polygon", "coordinates": [[[-124.11965, 41.03876], [-124.11891, 41.0388], [-124.11852, 41.0388], [-124.11838, 41.03832], [-124.11834, 41.03786], [-124.11845, 41.03761], [-124.1185, 41.0374], [-124.11848, 41.03711], [-124.11845, 41.03703], [-124.11803, 41.03637], [-124.11803, 41.03607], [-124.11812, 41.03579], [-124.11835, 41.03581], [-124.11849, 41.03571], [-124.1189, 41.0358], [-124.11916, 41.03613], [-124.11919, 41.03682], [-124.11911, 41.0371], [-124.11907, 41.03794], [-124.11913, 41.03827], [-124.11933, 41.03852], [-124.11965, 41.03876]]]} | Open Access 1 | 47608 | Houda Point/Camel Rock Beach Park | 31339 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://trinidadcoastallandtrust.org/holdings/houdapoint/ | Humboldt 45 | 5.877 | Houda Point/Camel Rock Beach Park | 0 | Private Recreation or Education 65 | 4 |
7542 | 7542 | 7541 | {"type": "Polygon", "coordinates": [[[-124.13929, 41.06003], [-124.13917, 41.06023], [-124.1392, 41.0603], [-124.1392, 41.06036], [-124.13919, 41.06045], [-124.13914, 41.06056], [-124.13914, 41.06105], [-124.139, 41.06087], [-124.13894, 41.06077], [-124.13889, 41.06064], [-124.13881, 41.06034], [-124.13872, 41.06014], [-124.13853, 41.0599], [-124.13853, 41.05847], [-124.13916, 41.05822], [-124.13886, 41.05927], [-124.13888, 41.05935], [-124.13894, 41.05944], [-124.139, 41.05949], [-124.13903, 41.0595], [-124.13912, 41.0596], [-124.13912, 41.05966], [-124.13903, 41.0597], [-124.13903, 41.05972], [-124.13918, 41.05981], [-124.13927, 41.05989], [-124.13929, 41.06003]]]} | Open Access 1 | 47609 | Bruno Groth Grove | 31341 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 2.651 | Bruno Groth Grove | 0 | Private Conservation 16 | 2 |
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]);