units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, AGNCY_WEB = "http://www.delmonteforestfoundation.org/" and DES_TP = 16
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13186 | 13186 | 13185 | {"type": "Polygon", "coordinates": [[[-121.95578, 36.56241], [-121.95541, 36.5627], [-121.95521, 36.56252], [-121.9544, 36.56194], [-121.95423, 36.56185], [-121.95402, 36.56181], [-121.95408, 36.56142], [-121.95494, 36.56186], [-121.95578, 36.56241]]]} | Open Access 1 | 35176 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.664 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
13187 | 13187 | 13186 | {"type": "Polygon", "coordinates": [[[-121.95407, 36.56142], [-121.95402, 36.56181], [-121.95362, 36.56184], [-121.9532, 36.56194], [-121.9528, 36.56209], [-121.95254, 36.56226], [-121.95162, 36.56178], [-121.95157, 36.56134], [-121.95185, 36.56108], [-121.95365, 36.5612], [-121.95407, 36.56142]]]} | Open Access 1 | 35177 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 4.86 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-121.97264, 36.58026], [-121.97194, 36.58041], [-121.97168, 36.58018], [-121.97156, 36.57995], [-121.97243, 36.57965], [-121.97257, 36.57999], [-121.97264, 36.58026]]]} | Open Access 1 | 35189 | S.F.B. Morse Memorial Lot | 28537 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.252 | S.F.B. Morse Memorial Lot | 0 | Private Conservation 16 | 2 | |
13193 | 13193 | 13192 | {"type": "Polygon", "coordinates": [[[-121.97332, 36.57802], [-121.97338, 36.57809], [-121.97338, 36.57814], [-121.97336, 36.57819], [-121.97331, 36.57824], [-121.97312, 36.57833], [-121.97302, 36.57843], [-121.97297, 36.57853], [-121.97293, 36.57871], [-121.97263, 36.57919], [-121.97258, 36.57922], [-121.97253, 36.57924], [-121.97246, 36.57923], [-121.97242, 36.57921], [-121.9721, 36.57881], [-121.97039, 36.57694], [-121.97018, 36.57673], [-121.97014, 36.57667], [-121.97012, 36.57657], [-121.97014, 36.57584], [-121.97018, 36.57573], [-121.97027, 36.57565], [-121.97038, 36.5756], [-121.97052, 36.57559], [-121.97066, 36.57564], [-121.97074, 36.57569], [-121.97096, 36.57594], [-121.97118, 36.57611], [-121.97227, 36.57678], [-121.97236, 36.57686], [-121.97251, 36.57711], [-121.97271, 36.57731], [-121.97281, 36.57755], [-121.97292, 36.57771], [-121.97307, 36.57787], [-121.97332, 36.57802]]]} | Open Access 1 | 35190 | Crocker Grove | 28538 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 12.522 | Crocker Grove | 0 | Private Conservation 16 | 2 | |
13714 | 13714 | 13713 | {"type": "Polygon", "coordinates": [[[-121.93865, 36.5922], [-121.9385, 36.59231], [-121.93833, 36.59246], [-121.93821, 36.59261], [-121.93805, 36.59288], [-121.93796, 36.59297], [-121.93785, 36.59304], [-121.93772, 36.59309], [-121.93748, 36.59312], [-121.93697, 36.59309], [-121.93678, 36.59312], [-121.93661, 36.59321], [-121.93653, 36.59328], [-121.93647, 36.59336], [-121.93641, 36.59351], [-121.93642, 36.59371], [-121.9365, 36.59392], [-121.93628, 36.59392], [-121.93582, 36.59325], [-121.93533, 36.59259], [-121.93454, 36.59162], [-121.93252, 36.59221], [-121.93076, 36.58845], [-121.93099, 36.5882], [-121.93124, 36.58796], [-121.93174, 36.58756], [-121.932, 36.58739], [-121.93225, 36.58726], [-121.93273, 36.58707], [-121.9333, 36.58694], [-121.93358, 36.5869], [-121.93397, 36.58689], [-121.9343, 36.5869], [-121.93458, 36.58694], [-121.93495, 36.58702], [-121.93518, 36.5871], [-121.93554, 36.58733], [-121.93565, 36.5894], [-121.93609, 36.58973], [-121.93683, 36.59097], [-121.93736, 36.59214], [-121.93865, 36.5922]]]} | Open Access 1 | 36121 | SFB Morse Botanical Reserve | 28568 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestconservancy.org/documents/DMFC%20SFBMorseBotanicalReserve.pdf | Monterey 14 | 63.599 | SFB Morse Botanical Reserve | 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]);