units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 65 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
MNG_AGENCY 4
MNG_AG_TYP 1
- Non Profit - Land Trust · 5 ✖
DES_TP 1
- Private Recreation or Education · 5 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15972 | 15972 | 15971 | {"type": "Polygon", "coordinates": [[[-122.03205, 38.21576], [-122.03199, 38.2159], [-122.03163, 38.21621], [-122.03151, 38.21621], [-122.0312, 38.21632], [-122.02996, 38.21683], [-122.02982, 38.21715], [-122.02989, 38.21743], [-122.03, 38.21828], [-122.02988, 38.21849], [-122.03008, 38.21854], [-122.02997, 38.21896], [-122.02979, 38.21912], [-122.02965, 38.21923], [-122.0293, 38.21942], [-122.02899, 38.21912], [-122.02876, 38.21895], [-122.02842, 38.21862], [-122.02802, 38.21838], [-122.02759, 38.21816], [-122.02704, 38.218], [-122.02616, 38.21841], [-122.02546, 38.21854], [-122.02498, 38.2186], [-122.0247, 38.21905], [-122.02456, 38.21939], [-122.02449, 38.21949], [-122.02424, 38.21965], [-122.02444, 38.21995], [-122.0246, 38.22035], [-122.02464, 38.22068], [-122.02503, 38.22075], [-122.02535, 38.22074], [-122.02631, 38.2206], [-122.02662, 38.22052], [-122.02702, 38.22081], [-122.02695, 38.22124], [-122.02682, 38.22172], [-122.02666, 38.22202], [-122.02642, 38.22235], [-122.02612, 38.22229], [-122.02602, 38.22201], [-122.02602, 38.22161], [-122.02594, 38.22134], [-122.02578, 38.2212], [-122.02545, 38.22117], [-122.02506, 38.22117], [-122.02465, 38.22132], [-122.02394, 38.22167], [-122.02374, 38.22182], [-122.02316, 38.22212], [-122.02297, 38.22213], [-122.02257, 38.22221], [-122.02236, 38.22267], [-122.02214, 38.22292], [-122.02183, 38.22353], [-122.02184, 38.22393], [-122.02184, 38.22458], [-122.02197, 38.22501], [-122.02223, 38.22511], [-122.02252, 38.22533], [-122.02299, 38.22561], [-122.02322, 38.22563], [-122.02358, 38.22595], [-122.02342, 38.22609], [-122.02316, 38.22615], [-122.02292, 38.2261], [-122.02254, 38.22589], [-122.02178, 38.22575], [-122.02146, 38.22582], [-122.02121, 38.22602], [-122.02104, 38.22631], [-122.0211, 38.22692], [-122.02113, 38.22742], [-122.02102, 38.22784], [-122.02082, 38.228], [-122.02048, 38.22815], [-122.01981, 38.22829], [-122.01943, 38.22827], [-122.01908, 38.22809], [-122.01902, 38.22767], [-122.01914, 38.22729], [-122.01945, 38.22684], [-122.01948, 38.22656], [-122.01984, 38.22618], [-122.0202, 38.22587], [-122.02035, 38.22571], [-122.02052, 38.22534], [-122.01997, 38.22483], [-122.01969, 38.22454], [-122.01937, 38.22414], [-122.01921, 38.22369], [-122.01907, 38.22316], [-122.01898, 38.22308], [-122.01867, 38.22305], [-122.01791, 38.2228], [-122.01747, 38.22286], [-122.01737, 38.22295], [-122.01697, 38.22313], [-122.01672, 38.22319], [-122.01659, 38.22342], [-122.01653, 38.2236], [-122.01658, 38.22396], [-122.01683, 38.22407], [-122.01709, 38.22409], [-122.01756, 38.22419], [-122.01773, 38.22449], [-122.01769, 38.22496], [-122.01767, 38.22536], [-122.01778, 38.22552], [-122.01793, 38.22587], [-122.01795, 38.2262], [-122.01779, 38.2263], [-122.01618, 38.22606], [-122.01579, 38.22595], [-122.01546, 38.22574], [-122.0151, 38.22524], [-122.01477, 38.22523], [-122.01482, 38.22521], [-122.01484, 38.22468], [-122.01437, 38.2236], [-122.0141, 38.2234], [-122.01411, 38.22336], [-122.01403, 38.22316], [-122.0139, 38.22309], [-122.01369, 38.22307], [-122.01342, 38.22311], [-122.0126, 38.22025], [-122.01138, 38.21489], [-122.00995, 38.20984], [-122.00725, 38.2096], [-122.0092, 38.20838], [-122.01085, 38.20677], [-122.01103, 38.20618], [-122.01111, 38.20527], [-122.0107, 38.20449], [-122.01077, 38.20419], [-122.00984, 38.2012], [-122.00988, 38.20067], [-122.00984, 38.20046], [-122.00968, 38.20013], [-122.00919, 38.19981], [-122.00887, 38.19871], [-122.00914, 38.19868], [-122.01003, 38.19839], [-122.01131, 38.19751], [-122.01221, 38.1968], [-122.01242, 38.19647], [-122.01243, 38.19644], [-122.01245, 38.19643], [-122.01261, 38.19616], [-122.01264, 38.19587], [-122.01299, 38.19559], [-122.01476, 38.19522], [-122.01842, 38.19498], [-122.02227, 38.19512], [-122.02309, 38.1953], [-122.02456, 38.19596], [-122.02561, 38.1966], [-122.02651, 38.19755], [-122.02732, 38.19869], [-122.02729, 38.19956], [-122.02677, 38.2008], [-122.027, 38.20186], [-122.02653, 38.20294], [-122.02575, 38.20342], [-122.02566, 38.2037], [-122.02575, 38.20399], [-122.0261, 38.20441], [-122.02659, 38.20487], [-122.02697, 38.20519], [-122.0281, 38.20569], [-122.02938, 38.20615], [-122.02998, 38.2067], [-122.03045, 38.20725], [-122.03045, 38.20729], [-122.03074, 38.20743], [-122.03134, 38.20828], [-122.03036, 38.20808], [-122.02981, 38.20872], [-122.02978, 38.20901], [-122.02961, 38.2092], [-122.02961, 38.20931], [-122.02978, 38.20947], [-122.03013, 38.20961], [-122.03027, 38.21036], [-122.03036, 38.21048], [-122.03036, 38.21073], [-122.03065, 38.21137], [-122.03076, 38.21167], [-122.03074, 38.21201], [-122.03001, 38.21281], [-122.03001, 38.21359], [-122.03062, 38.21482], [-122.0314, 38.2149], [-122.03205, 38.21576]]]} | Open Access 1 | 308 | Rush Ranch Open Space | 12546 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RushRanch.aspx | Solano 26 | 1177.494 | Rush Ranch OS | 1987 | Private Recreation or Education 65 | 4 |
16019 | 16019 | 16018 | {"type": "MultiPolygon", "coordinates": [[[[-119.50311, 34.38539], [-119.50308, 34.38568], [-119.50203, 34.38548], [-119.50073, 34.38536], [-119.49887, 34.38533], [-119.49817, 34.38537], [-119.49748, 34.38535], [-119.49678, 34.38526], [-119.49447, 34.3849], [-119.49448, 34.38485], [-119.49679, 34.38513], [-119.49887, 34.38526], [-119.50073, 34.38526], [-119.50311, 34.38539]]], [[[-119.50306, 34.38596], [-119.50288, 34.38954], [-119.5017, 34.38915], [-119.5012, 34.38892], [-119.50096, 34.38879], [-119.50056, 34.38856], [-119.50013, 34.38825], [-119.49921, 34.38755], [-119.49896, 34.3874], [-119.49863, 34.38725], [-119.4986, 34.38722], [-119.4986, 34.38718], [-119.49881, 34.38671], [-119.49883, 34.38663], [-119.49857, 34.38656], [-119.49832, 34.38711], [-119.49827, 34.38715], [-119.49793, 34.38709], [-119.49748, 34.38708], [-119.49613, 34.38716], [-119.49585, 34.38715], [-119.49556, 34.38711], [-119.49517, 34.38702], [-119.49525, 34.38542], [-119.49629, 34.38558], [-119.49673, 34.3856], [-119.49793, 34.38562], [-119.49986, 34.38559], [-119.50095, 34.38564], [-119.50186, 34.38572], [-119.50275, 34.38589], [-119.50306, 34.38596]]], [[[-119.50861, 34.39081], [-119.50768, 34.39055], [-119.50768, 34.39119], [-119.50603, 34.39037], [-119.50539, 34.39025], [-119.50539, 34.39014], [-119.50559, 34.39014], [-119.5056, 34.38959], [-119.50861, 34.39049], [-119.50861, 34.39081]]]]} | Open Access 1 | 3980 | Carpinteria Bluffs Public Open Space | 16893 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 3033 | Land Trust for Santa Barbara County 264 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Barbara 7 | 52.141 | Carpinteria Bluffs Public OS | 0 | Private Recreation or Education 65 | 4 | |
16200 | 16200 | 16199 | {"type": "Polygon", "coordinates": [[[-122.0897, 37.9062], [-122.08967, 37.90933], [-122.08958, 37.90936], [-122.08957, 37.91025], [-122.08787, 37.91065], [-122.08733, 37.91063], [-122.08703, 37.90902], [-122.08705, 37.90838], [-122.08752, 37.90706], [-122.0882, 37.90623], [-122.0897, 37.9062]]]} | Open Access 1 | 29704 | Acalanes Ridge Open Space | 15246 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 24.054 | Acalanes Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
16202 | 16202 | 16201 | {"type": "Polygon", "coordinates": [[[-118.12246, 34.20342], [-118.12199, 34.20383], [-118.12181, 34.20394], [-118.12159, 34.20406], [-118.12133, 34.20415], [-118.12098, 34.20421], [-118.12096, 34.20413], [-118.12062, 34.20418], [-118.1205, 34.20422], [-118.12039, 34.20428], [-118.11999, 34.20456], [-118.11991, 34.20464], [-118.11985, 34.20472], [-118.11976, 34.2049], [-118.11975, 34.20495], [-118.11975, 34.20535], [-118.11971, 34.20545], [-118.11961, 34.20559], [-118.11777, 34.20453], [-118.11778, 34.20046], [-118.11887, 34.20046], [-118.11886, 34.19944], [-118.11983, 34.19943], [-118.11984, 34.19938], [-118.12033, 34.19937], [-118.12025, 34.19942], [-118.12025, 34.19943], [-118.12091, 34.19968], [-118.12158, 34.19968], [-118.1216, 34.19987], [-118.12137, 34.19987], [-118.12136, 34.19992], [-118.12123, 34.20005], [-118.12106, 34.20006], [-118.12106, 34.20047], [-118.12014, 34.20047], [-118.12013, 34.20176], [-118.1206, 34.20183], [-118.12138, 34.20261], [-118.12214, 34.20259], [-118.12221, 34.20322], [-118.12246, 34.20342]]]} | Open Access 1 | 46181 | Rubio Canyon Open Space | 29487 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 42.645 | Rubio Canyon OS | 0 | Private Recreation or Education 65 | 4 | |
16207 | 16207 | 16206 | {"type": "Polygon", "coordinates": [[[-118.16315, 34.21033], [-118.16181, 34.21207], [-118.16127, 34.2127], [-118.16129, 34.21319], [-118.16097, 34.21354], [-118.16082, 34.21341], [-118.16075, 34.21375], [-118.16061, 34.21387], [-118.16041, 34.21379], [-118.16033, 34.21393], [-118.16036, 34.21397], [-118.16043, 34.21401], [-118.15982, 34.21427], [-118.15969, 34.21437], [-118.15945, 34.2147], [-118.15914, 34.21455], [-118.15889, 34.21474], [-118.15844, 34.21497], [-118.15739, 34.21492], [-118.1604, 34.21271], [-118.16131, 34.21155], [-118.16185, 34.21158], [-118.16183, 34.21032], [-118.16315, 34.21033]]]} | Open Access 1 | 46184 | Millard Canyon Open Space | 29489 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/millard/ | Los Angeles 6 | 13.581 | Millard Canyon 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]);