units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, AGNCY_TYP = 10, DES_TP = 16 and MNG_AGENCY = 622
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Save Mount Diablo · 4 ✖
DES_TP 1
- Private Conservation · 4 ✖
ACCESS_TYP 1
- Restricted Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3725 | 3725 | 3724 | {"type": "Polygon", "coordinates": [[[-121.79546, 37.80038], [-121.78656, 37.80059], [-121.78629, 37.79553], [-121.79272, 37.79569], [-121.79534, 37.79581], [-121.79536, 37.79761], [-121.79527, 37.79956], [-121.79546, 37.80038]]]} | Restricted Access 2 | 44708 | Highland Springs | 19939 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 104.068 | Highland Springs | 0 | Private Conservation 16 | 2 | |
5502 | 5502 | 5501 | {"type": "Polygon", "coordinates": [[[-121.86775, 37.88967], [-121.86773, 37.89262], [-121.86305, 37.89266], [-121.86296, 37.8891], [-121.85868, 37.8891], [-121.85869, 37.88548], [-121.86322, 37.88545], [-121.86466, 37.88548], [-121.8647, 37.88562], [-121.86472, 37.88588], [-121.86455, 37.88655], [-121.86486, 37.88681], [-121.86542, 37.8876], [-121.86593, 37.88815], [-121.866, 37.88863], [-121.86574, 37.88912], [-121.86545, 37.88935], [-121.86551, 37.88951], [-121.86626, 37.88943], [-121.86694, 37.88947], [-121.86775, 37.88967]]]} | Restricted Access 2 | 47797 | Anderson Ranch | 31682 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 95.912 | Anderson Ranch | 0 | Private Conservation 16 | 2 | |
5617 | 5617 | 5616 | {"type": "MultiPolygon", "coordinates": [[[[-121.8962, 37.83937], [-121.8958, 37.84565], [-121.89578, 37.84968], [-121.88663, 37.84971], [-121.88657, 37.86141], [-121.88646, 37.86144], [-121.88629, 37.86152], [-121.88615, 37.86164], [-121.88603, 37.86181], [-121.8859, 37.86192], [-121.8857, 37.86203], [-121.88473, 37.86232], [-121.88456, 37.8624], [-121.88425, 37.86262], [-121.88415, 37.86274], [-121.88404, 37.86294], [-121.88399, 37.86307], [-121.88396, 37.8634], [-121.88304, 37.86443], [-121.8829, 37.86463], [-121.88285, 37.86466], [-121.88248, 37.86478], [-121.88222, 37.86495], [-121.88209, 37.86502], [-121.88185, 37.86512], [-121.88117, 37.86536], [-121.88083, 37.86551], [-121.87916, 37.86642], [-121.87905, 37.8665], [-121.87894, 37.86665], [-121.87857, 37.86726], [-121.87847, 37.86738], [-121.87828, 37.86747], [-121.87741, 37.86748], [-121.87739, 37.86772], [-121.87676, 37.86777], [-121.87658, 37.86781], [-121.8745, 37.86868], [-121.87431, 37.8688], [-121.87423, 37.86889], [-121.87417, 37.869], [-121.87414, 37.86911], [-121.87414, 37.86922], [-121.87418, 37.86934], [-121.87448, 37.86998], [-121.87451, 37.8701], [-121.87452, 37.87023], [-121.87449, 37.87036], [-121.87395, 37.87191], [-121.87393, 37.87203], [-121.87389, 37.87272], [-121.87147, 37.87271], [-121.87146, 37.87295], [-121.87036, 37.87295], [-121.86985, 37.87288], [-121.86959, 37.87282], [-121.86874, 37.87276], [-121.86799, 37.87292], [-121.86771, 37.87294], [-121.86545, 37.87632], [-121.86505, 37.87367], [-121.86441, 37.87098], [-121.86227, 37.87178], [-121.85914, 37.87271], [-121.85927, 37.869], [-121.85934, 37.86754], [-121.8774, 37.86747], [-121.87755, 37.85319], [-121.87788, 37.84584], [-121.87823, 37.84583], [-121.87812, 37.83958], [-121.8962, 37.83937]]], [[[-121.88657, 37.86155], [-121.88655, 37.86747], [-121.87985, 37.86745], [-121.87861, 37.86746], [-121.87872, 37.86732], [-121.87909, 37.86671], [-121.87919, 37.86658], [-121.87927, 37.86652], [-121.88092, 37.86563], [-121.88124, 37.86548], [-121.88193, 37.86524], [-121.88218, 37.86514], [-121.88233, 37.86506], [-121.88257, 37.8649], [-121.88293, 37.86478], [-121.88302, 37.86472], [-121.88318, 37.86451], [-121.88412, 37.86346], [-121.88414, 37.86338], [-121.88416, 37.86309], [-121.8842, 37.86298], [-121.88438, 37.86271], [-121.88466, 37.86251], [-121.8848, 37.86245], [-121.88577, 37.86216], [-121.88601, 37.86203], [-121.88618, 37.86189], [-121.8863, 37.86172], [-121.8864, 37.86162], [-121.88657, 37.86155]]]]} | Restricted Access 2 | 44706 | Curry Canyon Ranch | 28349 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/lands_acquisition_currycanyon.html | Contra Costa 12 | 1023.4 | Curry Canyon Ranch | 0 | Private Conservation 16 | 2 |
10316 | 10316 | 10315 | {"type": "Polygon", "coordinates": [[[-121.86545, 37.87632], [-121.86404, 37.87695], [-121.86245, 37.87713], [-121.86222, 37.87667], [-121.86199, 37.87647], [-121.86441, 37.87097], [-121.86505, 37.87367], [-121.86545, 37.87632]]]} | Restricted Access 2 | 49068 | Smith Canyon | 33771 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Contra Costa 12 | 26.971 | Smith Canyon | 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]);