units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, AGNCY_LEV = 4 and MNG_AGENCY = 468
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Clara Valley Open Space Authority · 2 ✖
DES_TP 1
ACCESS_TYP 1
- Restricted Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15900 | 15900 | 15899 | {"type": "MultiPolygon", "coordinates": [[[[-121.79333, 37.13188], [-121.79239, 37.13241], [-121.79211, 37.13263], [-121.79195, 37.1328], [-121.79173, 37.13309], [-121.79157, 37.13338], [-121.79142, 37.13374], [-121.79129, 37.13416], [-121.79119, 37.13462], [-121.79113, 37.13477], [-121.79102, 37.13536], [-121.79099, 37.13544], [-121.79086, 37.13567], [-121.79066, 37.1359], [-121.79049, 37.13604], [-121.79026, 37.13618], [-121.78941, 37.13637], [-121.78913, 37.13648], [-121.78877, 37.13669], [-121.78845, 37.13689], [-121.7881, 37.13707], [-121.78762, 37.13726], [-121.78744, 37.13735], [-121.78647, 37.13794], [-121.78628, 37.13807], [-121.78616, 37.13818], [-121.78605, 37.13835], [-121.78594, 37.13854], [-121.78592, 37.13885], [-121.78583, 37.13916], [-121.78603, 37.13977], [-121.78614, 37.14004], [-121.78613, 37.14012], [-121.78591, 37.14035], [-121.78575, 37.14044], [-121.78551, 37.1405], [-121.78492, 37.14049], [-121.78462, 37.14052], [-121.78414, 37.1406], [-121.78401, 37.14064], [-121.78391, 37.14069], [-121.78384, 37.14076], [-121.78383, 37.14084], [-121.78386, 37.14121], [-121.78384, 37.14142], [-121.78372, 37.14172], [-121.78362, 37.14183], [-121.78329, 37.14206], [-121.78321, 37.14219], [-121.78307, 37.14237], [-121.78294, 37.14247], [-121.78279, 37.14255], [-121.7824, 37.1427], [-121.78219, 37.14282], [-121.78198, 37.14305], [-121.78189, 37.14319], [-121.78174, 37.14332], [-121.78162, 37.14339], [-121.7814, 37.14345], [-121.78078, 37.14345], [-121.78049, 37.14347], [-121.78021, 37.14354], [-121.78014, 37.14358], [-121.78011, 37.14363], [-121.78012, 37.14376], [-121.7802, 37.14391], [-121.78029, 37.14405], [-121.78031, 37.14414], [-121.78029, 37.14422], [-121.78022, 37.14431], [-121.78, 37.14453], [-121.77947, 37.14479], [-121.77905, 37.14502], [-121.77871, 37.14522], [-121.7784, 37.14537], [-121.77796, 37.14566], [-121.77783, 37.14577], [-121.77769, 37.14593], [-121.77705, 37.14545], [-121.77673, 37.14548], [-121.77614, 37.14532], [-121.77581, 37.14548], [-121.77551, 37.14567], [-121.77532, 37.1459], [-121.77476, 37.14624], [-121.77443, 37.1468], [-121.77454, 37.14748], [-121.77428, 37.14783], [-121.76345, 37.13979], [-121.76652, 37.13763], [-121.76652, 37.13761], [-121.74558, 37.12204], [-121.74134, 37.12008], [-121.74137, 37.11983], [-121.74137, 37.11958], [-121.74148, 37.11951], [-121.74153, 37.11938], [-121.7416, 37.11915], [-121.74174, 37.11896], [-121.74279, 37.11838], [-121.74308, 37.11838], [-121.74338, 37.11846], [-121.74372, 37.11851], [-121.7447, 37.11852], [-121.74492, 37.11844], [-121.74502, 37.1182], [-121.74829, 37.11806], [-121.7491, 37.11698], [-121.75103, 37.11648], [-121.75061, 37.11495], [-121.75284, 37.11195], [-121.76286, 37.11685], [-121.76549, 37.11806], [-121.77168, 37.1212], [-121.79333, 37.13188]]], [[[-121.8305, 37.1323], [-121.82138, 37.13232], [-121.82134, 37.12872], [-121.82128, 37.12507], [-121.83043, 37.12505], [-121.8305, 37.1323]]], [[[-121.8415, 37.16061], [-121.84057, 37.16122], [-121.83917, 37.1616], [-121.83798, 37.16174], [-121.83576, 37.16133], [-121.83397, 37.15718], [-121.8395, 37.15564], [-121.8415, 37.16061]]]]} | Restricted Access 2 | 47772 | Rancho Cañada del Oro Open Space Preserve | 31572 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 2087.26 | Rancho Cañada del Oro OSP | 2000 | Local Conservation Area 4 | 2 |
15918 | 15918 | 15917 | {"type": "Polygon", "coordinates": [[[-121.85815, 37.22884], [-121.85695, 37.22901], [-121.85587, 37.22908], [-121.85461, 37.22903], [-121.85434, 37.22903], [-121.85412, 37.22913], [-121.85392, 37.22915], [-121.84989, 37.22873], [-121.84963, 37.22856], [-121.84824, 37.2282], [-121.84765, 37.22588], [-121.84714, 37.22428], [-121.84524, 37.22443], [-121.84525, 37.22462], [-121.8443, 37.22466], [-121.84366, 37.22463], [-121.84346, 37.22335], [-121.8435, 37.2233], [-121.84431, 37.22403], [-121.8454, 37.2238], [-121.84606, 37.22367], [-121.84744, 37.22335], [-121.84798, 37.22337], [-121.84832, 37.22282], [-121.84828, 37.22297], [-121.84831, 37.22313], [-121.84837, 37.22323], [-121.84843, 37.22328], [-121.84859, 37.22337], [-121.84801, 37.2235], [-121.84835, 37.22396], [-121.84894, 37.22421], [-121.84983, 37.2247], [-121.84979, 37.22477], [-121.84967, 37.22532], [-121.84947, 37.22559], [-121.84898, 37.22589], [-121.84897, 37.22613], [-121.84915, 37.22614], [-121.84856, 37.22667], [-121.84856, 37.22669], [-121.8501, 37.22725], [-121.85178, 37.22751], [-121.8518, 37.22756], [-121.85275, 37.22781], [-121.85286, 37.22778], [-121.85307, 37.22767], [-121.8534, 37.22777], [-121.85375, 37.2276], [-121.8542, 37.22755], [-121.85524, 37.22754], [-121.85548, 37.22748], [-121.85626, 37.22758], [-121.85664, 37.22779], [-121.8577, 37.22855], [-121.85815, 37.22884]]]} | Restricted Access 2 | 49045 | Santa Teresa Foothills Open Space Preserve | 33751 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 53.071 | Santa Teresa Foothills OSP | 0 | Local Conservation Area 4 | 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]);