units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 1066, MNG_AG_TYP = 10 and SUID_NMA = 32806
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 1 ✖
MNG_AGENCY 1
- Ojai Valley Land Conservancy · 1 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14433 | 14433 | 14432 | {"type": "MultiPolygon", "coordinates": [[[[-119.25067, 34.46479], [-119.25063, 34.46704], [-119.2506, 34.47067], [-119.23676, 34.47049], [-119.23685, 34.46486], [-119.23694, 34.46472], [-119.23738, 34.4646], [-119.23742, 34.46464], [-119.23746, 34.46475], [-119.23747, 34.46484], [-119.23746, 34.46504], [-119.23738, 34.46541], [-119.23738, 34.46552], [-119.23742, 34.46565], [-119.23753, 34.46591], [-119.23761, 34.46603], [-119.2378, 34.46614], [-119.23788, 34.46617], [-119.238, 34.46618], [-119.2381, 34.46616], [-119.23821, 34.46612], [-119.23878, 34.46578], [-119.23916, 34.46561], [-119.23926, 34.46559], [-119.23964, 34.46563], [-119.23975, 34.46561], [-119.23986, 34.46556], [-119.23996, 34.46547], [-119.24002, 34.46535], [-119.24003, 34.46527], [-119.24002, 34.46497], [-119.24005, 34.46489], [-119.24011, 34.46482], [-119.2402, 34.46475], [-119.24045, 34.46465], [-119.24055, 34.46466], [-119.24074, 34.46472], [-119.2408, 34.46476], [-119.2409, 34.46487], [-119.24094, 34.46496], [-119.24092, 34.46523], [-119.24094, 34.46535], [-119.24105, 34.46548], [-119.24121, 34.46556], [-119.24132, 34.46557], [-119.24144, 34.46554], [-119.24178, 34.46526], [-119.24187, 34.46523], [-119.24193, 34.46524], [-119.24198, 34.46527], [-119.24207, 34.46542], [-119.24218, 34.46551], [-119.24232, 34.46555], [-119.24247, 34.46553], [-119.2426, 34.46547], [-119.24307, 34.46505], [-119.24314, 34.46502], [-119.24321, 34.465], [-119.24334, 34.46502], [-119.24343, 34.46508], [-119.24348, 34.46513], [-119.24355, 34.46532], [-119.24364, 34.46541], [-119.24371, 34.46545], [-119.24379, 34.46549], [-119.24392, 34.46551], [-119.24411, 34.46547], [-119.24425, 34.46539], [-119.24436, 34.46527], [-119.24442, 34.46518], [-119.24446, 34.46506], [-119.24458, 34.46455], [-119.24467, 34.46437], [-119.24536, 34.46346], [-119.24544, 34.46341], [-119.24551, 34.46339], [-119.24561, 34.4634], [-119.24571, 34.46344], [-119.24594, 34.46372], [-119.24602, 34.46378], [-119.24616, 34.46385], [-119.24629, 34.46386], [-119.24641, 34.46385], [-119.24651, 34.46381], [-119.24659, 34.46376], [-119.24666, 34.46369], [-119.2467, 34.46359], [-119.24672, 34.4635], [-119.2467, 34.46342], [-119.24667, 34.46333], [-119.2483, 34.46335], [-119.24844, 34.46381], [-119.24848, 34.4639], [-119.24856, 34.464], [-119.24867, 34.46409], [-119.24881, 34.46417], [-119.24894, 34.46422], [-119.24917, 34.46426], [-119.24928, 34.46432], [-119.24938, 34.46442], [-119.24947, 34.46463], [-119.24958, 34.46473], [-119.24969, 34.46478], [-119.24981, 34.4648], [-119.25031, 34.46474], [-119.25045, 34.46475], [-119.25067, 34.46479]]], [[[-119.24645, 34.46333], [-119.24651, 34.46346], [-119.2465, 34.46358], [-119.24646, 34.46363], [-119.24641, 34.46367], [-119.24629, 34.4637], [-119.2462, 34.46368], [-119.24612, 34.46364], [-119.24584, 34.46332], [-119.24645, 34.46333]]], [[[-119.2507, 34.46338], [-119.25067, 34.46462], [-119.25049, 34.46459], [-119.2503, 34.46458], [-119.24985, 34.46464], [-119.24976, 34.46462], [-119.24966, 34.46457], [-119.24963, 34.46452], [-119.24954, 34.46432], [-119.24945, 34.46423], [-119.24937, 34.46417], [-119.24921, 34.4641], [-119.24891, 34.46403], [-119.24874, 34.46392], [-119.24869, 34.46386], [-119.24863, 34.46376], [-119.24851, 34.46339], [-119.24857, 34.46335], [-119.2507, 34.46338]]]]} | Open Access 1 | 48254 | Valley View Preserve | 32806 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/valley-view-preserve/ | Ventura 8 | 208.805 | Valley View Preserve | 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]);