superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 3, MNG_AGENCY = 50 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 2 ✖
MNG_AGENCY 1
- Save the Redwoods League · 2 ✖
ACCESS_TYP 1
- No Public Access · 2 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2608 | 2608 | 2607 | {"type": "Polygon", "coordinates": [[[-123.83146, 39.72663], [-123.83143, 39.72668], [-123.83132, 39.72676], [-123.83116, 39.72681], [-123.83096, 39.72683], [-123.8309, 39.72688], [-123.83086, 39.72695], [-123.83085, 39.727], [-123.83085, 39.72714], [-123.83084, 39.72726], [-123.83071, 39.72753], [-123.83078, 39.72761], [-123.83077, 39.72765], [-123.83065, 39.72767], [-123.83063, 39.72778], [-123.83053, 39.7279], [-123.83052, 39.72794], [-123.83055, 39.72807], [-123.83064, 39.72812], [-123.83091, 39.7281], [-123.83098, 39.72814], [-123.83119, 39.72818], [-123.83121, 39.72824], [-123.83119, 39.72835], [-123.83127, 39.72842], [-123.83126, 39.7285], [-123.83123, 39.72855], [-123.83118, 39.72857], [-123.8311, 39.72859], [-123.83095, 39.72855], [-123.83088, 39.72851], [-123.83079, 39.72851], [-123.83074, 39.72855], [-123.83074, 39.72859], [-123.83087, 39.72871], [-123.82548, 39.72866], [-123.8199, 39.72866], [-123.82007, 39.72771], [-123.81978, 39.72773], [-123.81941, 39.72767], [-123.81892, 39.7272], [-123.81835, 39.72704], [-123.81823, 39.72655], [-123.81849, 39.72625], [-123.81855, 39.72552], [-123.81834, 39.72548], [-123.81816, 39.72494], [-123.81857, 39.72448], [-123.81843, 39.72437], [-123.81805, 39.72432], [-123.81535, 39.72206], [-123.81496, 39.72203], [-123.81442, 39.72183], [-123.81392, 39.72201], [-123.81347, 39.72226], [-123.81315, 39.72247], [-123.81299, 39.72247], [-123.81266, 39.7223], [-123.81169, 39.72253], [-123.81178, 39.72144], [-123.81176, 39.71622], [-123.8196, 39.71633], [-123.81988, 39.71646], [-123.82011, 39.7166], [-123.82027, 39.71666], [-123.8206, 39.71683], [-123.82102, 39.71696], [-123.82136, 39.71713], [-123.82166, 39.71723], [-123.82187, 39.71727], [-123.8221, 39.71726], [-123.82258, 39.71736], [-123.8229, 39.71745], [-123.82358, 39.71774], [-123.82376, 39.71776], [-123.82398, 39.71786], [-123.82442, 39.71796], [-123.8248, 39.71814], [-123.82517, 39.71849], [-123.82542, 39.71878], [-123.82578, 39.71914], [-123.82596, 39.71927], [-123.82618, 39.71949], [-123.82624, 39.71953], [-123.82628, 39.71959], [-123.82643, 39.71977], [-123.82646, 39.71985], [-123.82663, 39.72008], [-123.82677, 39.72022], [-123.82699, 39.72042], [-123.82712, 39.72048], [-123.82719, 39.72058], [-123.82766, 39.72112], [-123.8279, 39.72132], [-123.82819, 39.72162], [-123.8283, 39.72168], [-123.82839, 39.72179], [-123.82847, 39.72181], [-123.82873, 39.72202], [-123.8288, 39.72205], [-123.82888, 39.72212], [-123.82897, 39.72216], [-123.82909, 39.72228], [-123.82913, 39.72229], [-123.82916, 39.72232], [-123.82918, 39.7224], [-123.82936, 39.72256], [-123.82936, 39.72261], [-123.82934, 39.72264], [-123.82936, 39.72278], [-123.82943, 39.72295], [-123.82951, 39.72304], [-123.82956, 39.72305], [-123.8296, 39.72303], [-123.82967, 39.72302], [-123.82972, 39.72306], [-123.82973, 39.7231], [-123.82977, 39.72311], [-123.82981, 39.72307], [-123.83001, 39.72303], [-123.83016, 39.72305], [-123.83023, 39.72304], [-123.83032, 39.72305], [-123.83041, 39.72313], [-123.83051, 39.72319], [-123.83052, 39.72329], [-123.83055, 39.72332], [-123.83054, 39.72354], [-123.83052, 39.7236], [-123.83042, 39.72371], [-123.83027, 39.72373], [-123.83023, 39.72377], [-123.83021, 39.72384], [-123.83011, 39.72394], [-123.83009, 39.72405], [-123.83008, 39.72421], [-123.83, 39.72448], [-123.83001, 39.72453], [-123.83007, 39.7247], [-123.83004, 39.72482], [-123.83007, 39.72501], [-123.83005, 39.7251], [-123.83005, 39.72518], [-123.83007, 39.72529], [-123.83011, 39.72539], [-123.83005, 39.7255], [-123.83009, 39.72578], [-123.83013, 39.72585], [-123.83023, 39.72599], [-123.83036, 39.72611], [-123.83041, 39.72614], [-123.8305, 39.72614], [-123.83055, 39.72611], [-123.83069, 39.72597], [-123.83075, 39.72595], [-123.83082, 39.72596], [-123.83088, 39.726], [-123.83097, 39.72611], [-123.83106, 39.72613], [-123.83116, 39.72626], [-123.8312, 39.72636], [-123.83125, 39.72641], [-123.83142, 39.72652], [-123.83146, 39.72659], [-123.83146, 39.72663]]]} | No Public Access 3 | Cape Vizcaino | 16831 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 374.272 | Cape Vizcaino | ||
| 11620 | 11620 | 11619 | {"type": "Polygon", "coordinates": [[[-123.14988, 38.62899], [-123.12765, 38.62914], [-123.12689, 38.61779], [-123.13593, 38.6178], [-123.14053, 38.61778], [-123.14063, 38.62152], [-123.14948, 38.6215], [-123.14988, 38.62899]]]} | No Public Access 3 | The Cedars Area of Critical Environmental Concern | http://www.savetheredwoods.org/our-work/protect/create/acres-protected-by-the-league/ | 28162 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 522.786 | The Cedars Area of Critical Environmental Concern |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);