units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where ACCESS_TYP = 3 and DES_TP = 65 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
MNG_AG_TYP 2
DES_TP 1
- Private Recreation or Education · 5 ✖
ACCESS_TYP 1
- No Public Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12370 | 12370 | 12369 | {"type": "MultiPolygon", "coordinates": [[[[-122.99606, 38.50153], [-122.99573, 38.50173], [-122.99551, 38.50189], [-122.99444, 38.50252], [-122.99426, 38.50269], [-122.99358, 38.50215], [-122.99512, 38.50083], [-122.99561, 38.50114], [-122.99561, 38.50132], [-122.99606, 38.50153]]], [[[-122.99562, 38.5004], [-122.99561, 38.50099], [-122.99561, 38.50099], [-122.99523, 38.50073], [-122.99562, 38.5004]]]]} | No Public Access 3 | 26073 | Riverkeeper Park | 24442 | 3132 | Russian Riverkeeper 1021 | Non Profit 6 | Non Profit - Conservation 12 | http://www.russianriverkeeper.org/ | Non Governmental Organization 10 | 3132 | Russian Riverkeeper 983 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 5.046 | Riverkeeper Park | 0 | Private Recreation or Education 65 | 4 | |
3140 | 3140 | 3139 | {"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]} | No Public Access 3 | 25800 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 22.717 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
8339 | 8339 | 8338 | {"type": "Polygon", "coordinates": [[[-116.53359, 33.16797], [-116.53794, 33.16809], [-116.53811, 33.17231], [-116.53815, 33.17515], [-116.54258, 33.17521], [-116.54272, 33.17873], [-116.53401, 33.17867], [-116.53373, 33.17153], [-116.52949, 33.17168], [-116.52931, 33.16798], [-116.53359, 33.16797]]]} | No Public Access 3 | 12844 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 197.03 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
4129 | 4129 | 4128 | {"type": "Polygon", "coordinates": [[[-118.5962, 34.10228], [-118.59481, 34.10227], [-118.59481, 34.10169], [-118.59619, 34.1017], [-118.5962, 34.10228]]]} | No Public Access 3 | 12686 | Topanga Open Space | 29663 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 2.028 | Topanga OS | 0 | Private Recreation or Education 65 | 4 | |
12491 | 12491 | 12490 | {"type": "Polygon", "coordinates": [[[-118.59323, 34.10829], [-118.59283, 34.10826], [-118.59281, 34.10794], [-118.59295, 34.10796], [-118.59321, 34.10791], [-118.59323, 34.10829]]]} | No Public Access 3 | 12687 | Topanga Open Space | 29663 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.339 | Topanga OS | 0 | Private Recreation or Education 65 | 4 |
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]);