units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 24, MNG_AGENCY = 50 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- Non Profit - Land Trust · 3 ✖
MNG_AGENCY 1
- Save the Redwoods League · 3 ✖
DES_TP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120 | 120 | 119 | {"type": "Polygon", "coordinates": [[[-123.78052, 39.29709], [-123.78043, 39.29964], [-123.77587, 39.29973], [-123.77122, 39.29977], [-123.77099, 39.29555], [-123.77061, 39.29557], [-123.77054, 39.29471], [-123.7708, 39.29489], [-123.77101, 39.29492], [-123.77111, 39.29503], [-123.77132, 39.29511], [-123.77154, 39.29529], [-123.77225, 39.29551], [-123.77299, 39.29488], [-123.77329, 39.29439], [-123.77335, 39.29402], [-123.77311, 39.29345], [-123.77325, 39.29328], [-123.77364, 39.29341], [-123.77396, 39.29356], [-123.77417, 39.29367], [-123.77432, 39.2938], [-123.77443, 39.29393], [-123.7745, 39.29409], [-123.77451, 39.29457], [-123.7746, 39.29494], [-123.77467, 39.29504], [-123.775, 39.29528], [-123.77583, 39.29574], [-123.77585, 39.29616], [-123.7769, 39.29616], [-123.77711, 39.2962], [-123.77803, 39.29633], [-123.77875, 39.29629], [-123.77892, 39.29631], [-123.77935, 39.29648], [-123.78002, 39.29686], [-123.7802, 39.297], [-123.78052, 39.29709]]]} | Unknown Access 4 | 46785 | Big River-Mendocino Old-Growth Redwoods | 30239 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 92.451 | Big River-Mendocino Old-Growth Redwoods | 0 | Private Conservation 16 | 2 | |
| 12688 | 12688 | 12687 | {"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.72754], [-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.83106, 39.72859], [-123.83095, 39.72855], [-123.83088, 39.72851], [-123.8308, 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.72551], [-123.81834, 39.72548], [-123.81816, 39.72494], [-123.81858, 39.72449], [-123.81843, 39.72437], [-123.81805, 39.72432], [-123.81535, 39.72206], [-123.81496, 39.72203], [-123.81466, 39.72193], [-123.81443, 39.72182], [-123.81392, 39.72201], [-123.81347, 39.72226], [-123.81315, 39.72247], [-123.81299, 39.72247], [-123.81267, 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.82186, 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.71915], [-123.82596, 39.71928], [-123.82619, 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.82834, 39.72174], [-123.8284, 39.72179], [-123.82847, 39.72181], [-123.82873, 39.72202], [-123.8288, 39.72205], [-123.82889, 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.82957, 39.72305], [-123.8296, 39.72303], [-123.82967, 39.72302], [-123.82972, 39.72306], [-123.82973, 39.7231], [-123.82978, 39.72311], [-123.82981, 39.72307], [-123.83001, 39.72303], [-123.83016, 39.72305], [-123.83023, 39.72304], [-123.83032, 39.72305], [-123.83042, 39.72313], [-123.83051, 39.72319], [-123.83053, 39.72325], [-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.72395], [-123.83009, 39.72405], [-123.83008, 39.72421], [-123.83, 39.72448], [-123.83, 39.72452], [-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 | 29682 | Cape Vizcaino | 16831 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 374.258 | Cape Vizcaino | 0 | Private Conservation 16 | 2 | |
| 14322 | 14322 | 14321 | {"type": "Polygon", "coordinates": [[[-123.84998, 39.82879], [-123.84743, 39.82888], [-123.84723, 39.82902], [-123.84606, 39.82912], [-123.84512, 39.82986], [-123.8439, 39.82981], [-123.84369, 39.83019], [-123.84342, 39.83063], [-123.84468, 39.832], [-123.8437, 39.83385], [-123.84267, 39.83451], [-123.8423, 39.8347], [-123.84174, 39.83484], [-123.84164, 39.83488], [-123.84048, 39.83364], [-123.84022, 39.83228], [-123.84092, 39.83265], [-123.84166, 39.83204], [-123.8409, 39.83138], [-123.83928, 39.83063], [-123.83855, 39.83078], [-123.83781, 39.83039], [-123.83608, 39.82986], [-123.835, 39.82912], [-123.83365, 39.82914], [-123.83284, 39.8296], [-123.83172, 39.82996], [-123.83053, 39.83054], [-123.82851, 39.8297], [-123.8269, 39.82887], [-123.82652, 39.82819], [-123.82603, 39.8281], [-123.82494, 39.82707], [-123.82412, 39.82717], [-123.82356, 39.82668], [-123.82286, 39.82556], [-123.82225, 39.82506], [-123.8219, 39.82385], [-123.82061, 39.82348], [-123.81982, 39.82279], [-123.81968, 39.82278], [-123.8189, 39.82265], [-123.81814, 39.82257], [-123.81738, 39.8221], [-123.81669, 39.8222], [-123.81582, 39.82008], [-123.81601, 39.81927], [-123.81574, 39.81862], [-123.81664, 39.81784], [-123.81724, 39.81709], [-123.81572, 39.81621], [-123.82022, 39.81587], [-123.83988, 39.81637], [-123.84643, 39.81657], [-123.84664, 39.81772], [-123.8469, 39.81806], [-123.84715, 39.81865], [-123.84717, 39.81884], [-123.84711, 39.81894], [-123.84703, 39.81899], [-123.84689, 39.81899], [-123.84684, 39.81901], [-123.8468, 39.81914], [-123.84683, 39.81937], [-123.84695, 39.81981], [-123.84712, 39.82005], [-123.84721, 39.82012], [-123.84758, 39.82025], [-123.84788, 39.82024], [-123.84802, 39.82028], [-123.84808, 39.82035], [-123.84808, 39.82061], [-123.84814, 39.82079], [-123.84813, 39.8209], [-123.84824, 39.82138], [-123.84823, 39.82153], [-123.84816, 39.82163], [-123.84808, 39.8217], [-123.84799, 39.82187], [-123.84799, 39.82206], [-123.8481, 39.82323], [-123.84828, 39.82379], [-123.84852, 39.82438], [-123.84882, 39.82518], [-123.84895, 39.82547], [-123.84919, 39.82612], [-123.84921, 39.82628], [-123.84945, 39.82705], [-123.84953, 39.82724], [-123.84967, 39.82793], [-123.84981, 39.82833], [-123.84998, 39.82879]]]} | Open Access 1 | 44294 | Shady Dell | 12383 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 927.538 | Shady Dell | 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]);