units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where COUNTY = 24 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4108 | 4108 | 4107 | {"type": "Polygon", "coordinates": [[[-123.7877, 39.63706], [-123.78765, 39.63715], [-123.78756, 39.63709], [-123.78747, 39.63706], [-123.78742, 39.637], [-123.78734, 39.63695], [-123.78728, 39.63696], [-123.78707, 39.63694], [-123.78693, 39.63696], [-123.78677, 39.63716], [-123.7867, 39.63731], [-123.78664, 39.63756], [-123.78663, 39.63766], [-123.78665, 39.63786], [-123.78672, 39.63793], [-123.78675, 39.63799], [-123.78679, 39.63805], [-123.78703, 39.63809], [-123.78709, 39.63817], [-123.78709, 39.63824], [-123.78705, 39.63828], [-123.78701, 39.6383], [-123.78677, 39.63832], [-123.78672, 39.63838], [-123.78583, 39.63835], [-123.78581, 39.63823], [-123.78569, 39.63822], [-123.78568, 39.63835], [-123.78539, 39.63835], [-123.78536, 39.6379], [-123.785, 39.63789], [-123.78502, 39.63729], [-123.785, 39.63673], [-123.78517, 39.63673], [-123.78518, 39.63661], [-123.78502, 39.63659], [-123.785, 39.63648], [-123.7852, 39.63649], [-123.78521, 39.63616], [-123.785, 39.63614], [-123.785, 39.63607], [-123.78515, 39.63606], [-123.78514, 39.63598], [-123.785, 39.63598], [-123.78501, 39.6358], [-123.78536, 39.6358], [-123.78538, 39.63565], [-123.78636, 39.63564], [-123.78647, 39.63567], [-123.78654, 39.63571], [-123.78654, 39.63579], [-123.7865, 39.63582], [-123.78642, 39.63586], [-123.78625, 39.63582], [-123.78619, 39.63582], [-123.78615, 39.63585], [-123.78613, 39.6359], [-123.78613, 39.63594], [-123.78616, 39.636], [-123.7862, 39.63604], [-123.78636, 39.63606], [-123.78643, 39.63609], [-123.78645, 39.63618], [-123.78636, 39.63628], [-123.78634, 39.63634], [-123.78636, 39.63639], [-123.78656, 39.63645], [-123.78683, 39.63661], [-123.78692, 39.63669], [-123.78707, 39.63669], [-123.78713, 39.63662], [-123.78723, 39.63664], [-123.78731, 39.63668], [-123.78739, 39.63676], [-123.78757, 39.63684], [-123.78764, 39.6369], [-123.78769, 39.63698], [-123.7877, 39.63706]]]} | Open Access 1 | 47070 | Westport Headlands Park | 30721 | 3375 | Westport Village Society 722 | Non Profit 6 | Non Profit - Conservation 12 | http://www.westportvillagesociety.org/ | Non Governmental Organization 10 | 3375 | Westport Village Society 707 | Non Profit 6 | Non Profit - Conservation 12 | Mendocino 24 | 10.269 | Westport Headlands Park | 0 | Private Recreation or Education 65 | 4 | |
| 4321 | 4321 | 4320 | {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72539, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24933], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} | Open Access 1 | 45423 | Raven's Call | 28205 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/raven.html | Mendocino 24 | 23.564 | Raven's Call | 0 | Private Conservation 16 | 2 |
| 4322 | 4322 | 4321 | {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} | Open Access 1 | 45424 | Albert Cattalini Conservancy | 28204 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/acc.html | Mendocino 24 | 9.326 | Albert Cattalini Conservancy | 0 | Private Conservation 16 | 2 |
| 9133 | 9133 | 9132 | {"type": "Polygon", "coordinates": [[[-123.67793, 38.88158], [-123.67779, 38.88178], [-123.67736, 38.88184], [-123.67704, 38.88184], [-123.67604, 38.88162], [-123.67615, 38.88209], [-123.67607, 38.88208], [-123.67596, 38.88214], [-123.67593, 38.88221], [-123.67594, 38.88229], [-123.67596, 38.88231], [-123.67584, 38.88241], [-123.6752, 38.88217], [-123.67489, 38.88312], [-123.67478, 38.88317], [-123.67461, 38.88321], [-123.6744, 38.8832], [-123.67327, 38.88249], [-123.6732, 38.88249], [-123.67262, 38.88206], [-123.67226, 38.88183], [-123.67086, 38.88065], [-123.67085, 38.88052], [-123.6709, 38.88046], [-123.67115, 38.88027], [-123.67134, 38.88016], [-123.67138, 38.88014], [-123.67143, 38.88015], [-123.67147, 38.88017], [-123.67166, 38.88041], [-123.67226, 38.88107], [-123.67263, 38.88129], [-123.67283, 38.88138], [-123.67289, 38.88139], [-123.67295, 38.88137], [-123.67302, 38.8813], [-123.67304, 38.88121], [-123.67301, 38.88117], [-123.67296, 38.88113], [-123.67285, 38.8811], [-123.67278, 38.88112], [-123.67261, 38.88111], [-123.6725, 38.88106], [-123.67233, 38.88093], [-123.6706, 38.87897], [-123.67134, 38.87867], [-123.67118, 38.87854], [-123.67097, 38.87846], [-123.67085, 38.87838], [-123.67078, 38.87826], [-123.67076, 38.87818], [-123.67066, 38.87809], [-123.67056, 38.87788], [-123.6704, 38.87779], [-123.67032, 38.87786], [-123.67031, 38.87769], [-123.67045, 38.87772], [-123.67068, 38.87788], [-123.67088, 38.87807], [-123.67096, 38.87827], [-123.67122, 38.87844], [-123.67138, 38.87857], [-123.67158, 38.87864], [-123.67166, 38.87882], [-123.67181, 38.87896], [-123.67196, 38.87903], [-123.67202, 38.87914], [-123.67253, 38.87988], [-123.67272, 38.88007], [-123.67286, 38.88031], [-123.67307, 38.88042], [-123.67389, 38.8807], [-123.67458, 38.88089], [-123.67499, 38.88116], [-123.67527, 38.88127], [-123.67704, 38.88176], [-123.67736, 38.88174], [-123.67793, 38.88158]]]} | Open Access 1 | 48997 | Moat Creek Coastal Access | 33692 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 3398 | Moat Creek Managing Agency 878 | Non Profit 6 | Non Profit - Conservation 12 | http://visitredwoodcoast.com/content/moat-creek-coastal-access-and-trail/nco9B9343306A4C803A6 | Mendocino 24 | 23.541 | Moat Creek Coastal Access | 0 | None 755 | ||
| 9139 | 9139 | 9138 | {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.8509], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} | Open Access 1 | 48998 | Hearn Gulch | 33693 | 3303 | Redwood Coast Land Conservancy 904 | Non Profit 6 | Non Profit - Conservation 12 | http://www.rc-lc.org/ | Non Governmental Organization 10 | 3303 | Redwood Coast Land Conservancy 879 | Non Profit 6 | Non Profit - Conservation 12 | https://www.rclc.org/hearn-gulch/ | Mendocino 24 | 6.409 | Hearn Gulch | 2008 | Private Conservation 16 | 2 |
| 16810 | 16810 | 16809 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | 48503 | Redwood Coast Recreation Center | 33212 | 3389 | Redwood Coast Recreation Center 1176 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/ | Mendocino 24 | 11.148 | Redwood Coast Rec. Ctr. | 1999 | 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]);