units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, AGNCY_TYP = 24 and MNG_AGENCY = 529
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Clara Valley Habitat Agency · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2587 | 2587 | 2586 | {"type": "Polygon", "coordinates": [[[-121.6993, 37.1374], [-121.69927, 37.13758], [-121.69925, 37.13763], [-121.69897, 37.1379], [-121.69889, 37.13803], [-121.69886, 37.13818], [-121.69891, 37.13845], [-121.69887, 37.13856], [-121.69879, 37.13863], [-121.69835, 37.13886], [-121.69819, 37.13898], [-121.69812, 37.13906], [-121.69804, 37.13918], [-121.698, 37.13927], [-121.69798, 37.1394], [-121.69502, 37.13925], [-121.69459, 37.14231], [-121.69775, 37.14279], [-121.69751, 37.1432], [-121.69747, 37.14338], [-121.69749, 37.14349], [-121.69753, 37.14359], [-121.69773, 37.14385], [-121.69774, 37.1439], [-121.6977, 37.14408], [-121.69774, 37.14423], [-121.69782, 37.14433], [-121.69793, 37.14441], [-121.69814, 37.14449], [-121.6985, 37.14457], [-121.69858, 37.14461], [-121.69862, 37.14465], [-121.69873, 37.14492], [-121.69878, 37.145], [-121.69885, 37.14507], [-121.69906, 37.14521], [-121.69907, 37.14526], [-121.69904, 37.1453], [-121.69893, 37.14534], [-121.69881, 37.14534], [-121.69868, 37.14529], [-121.6984, 37.14513], [-121.69831, 37.1451], [-121.69784, 37.14504], [-121.69732, 37.1449], [-121.69711, 37.14489], [-121.69657, 37.14502], [-121.69609, 37.1451], [-121.69592, 37.14514], [-121.69575, 37.14523], [-121.69534, 37.14556], [-121.69429, 37.14477], [-121.69077, 37.14709], [-121.68949, 37.14741], [-121.6883, 37.14735], [-121.68766, 37.14771], [-121.68593, 37.14831], [-121.68474, 37.14958], [-121.6848, 37.15033], [-121.68234, 37.15043], [-121.68145, 37.15097], [-121.68134, 37.15101], [-121.68069, 37.15066], [-121.67969, 37.1506], [-121.6794, 37.15055], [-121.67913, 37.15046], [-121.67887, 37.15036], [-121.67862, 37.15023], [-121.67818, 37.15011], [-121.67231, 37.14686], [-121.67232, 37.14683], [-121.67103, 37.14611], [-121.67103, 37.14609], [-121.67071, 37.14589], [-121.67035, 37.14558], [-121.67011, 37.1453], [-121.68383, 37.13848], [-121.69306, 37.1338], [-121.69859, 37.13656], [-121.69832, 37.13693], [-121.6993, 37.1374]]]} | Restricted Access 2 | 49052 | Baird Open Space Regional Reserve | 33794 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 597.843 | Baird OS RR | None 211 | ||
2588 | 2588 | 2587 | {"type": "Polygon", "coordinates": [[[-121.68265, 37.13906], [-121.67601, 37.14237], [-121.67267, 37.13922], [-121.67394, 37.13832], [-121.67414, 37.13831], [-121.67414, 37.13825], [-121.67417, 37.13816], [-121.67413, 37.13806], [-121.67415, 37.138], [-121.67421, 37.13787], [-121.67433, 37.13771], [-121.6747, 37.13788], [-121.67611, 37.13687], [-121.67571, 37.13647], [-121.67744, 37.13531], [-121.67854, 37.13499], [-121.68054, 37.1365], [-121.68265, 37.13906]]]} | Restricted Access 2 | 49053 | Davidson Open Space Regional Reserve | 33795 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 93.914 | Davidson OS RR | None 212 | ||
10243 | 10243 | 10242 | {"type": "Polygon", "coordinates": [[[-121.75635, 37.21971], [-121.75564, 37.22071], [-121.75151, 37.2261], [-121.75121, 37.2259], [-121.75107, 37.22578], [-121.75107, 37.22539], [-121.75109, 37.22526], [-121.75121, 37.225], [-121.74995, 37.22425], [-121.74922, 37.22423], [-121.74873, 37.22405], [-121.74844, 37.22381], [-121.74917, 37.22299], [-121.75427, 37.22089], [-121.75529, 37.22009], [-121.75635, 37.21971]]]} | Restricted Access 2 | 49054 | Tulare Hill Wedge Open Space Regional Reserve | 33796 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 37.498 | Tulare Hill Wedge OS RR | None 890 | ||
16268 | 16268 | 16267 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 37.01942], [-121.33188, 37.02043], [-121.33185, 37.02053], [-121.33057, 37.02153], [-121.33035, 37.02153], [-121.32883, 37.02266], [-121.32829, 37.02321], [-121.32786, 37.02394], [-121.32768, 37.02432], [-121.32755, 37.02471], [-121.32745, 37.0251], [-121.32742, 37.02652], [-121.32737, 37.0269], [-121.32722, 37.02747], [-121.32709, 37.02784], [-121.32692, 37.0282], [-121.32672, 37.02855], [-121.32649, 37.02888], [-121.32623, 37.02921], [-121.3252, 37.03042], [-121.32465, 37.03112], [-121.32441, 37.03131], [-121.32412, 37.03164], [-121.32389, 37.03184], [-121.32365, 37.03202], [-121.3234, 37.03219], [-121.32313, 37.03235], [-121.32284, 37.03249], [-121.32254, 37.03261], [-121.31959, 37.03369], [-121.31926, 37.03379], [-121.3186, 37.03397], [-121.31804, 37.03408], [-121.3177, 37.03412], [-121.31603, 37.03443], [-121.31486, 37.03474], [-121.31471, 37.03445], [-121.3168, 37.03364], [-121.31661, 37.03311], [-121.31967, 37.03186], [-121.31922, 37.03113], [-121.32124, 37.03039], [-121.32143, 37.0303], [-121.3216, 37.0302], [-121.32172, 37.0301], [-121.32223, 37.0296], [-121.32263, 37.02907], [-121.32378, 37.02772], [-121.32397, 37.02745], [-121.32412, 37.02716], [-121.32424, 37.02686], [-121.32431, 37.02656], [-121.32434, 37.02635], [-121.3244, 37.02473], [-121.32454, 37.02415], [-121.32474, 37.02358], [-121.32499, 37.02302], [-121.32573, 37.02181], [-121.32578, 37.02182], [-121.32633, 37.02319], [-121.32831, 37.02267], [-121.32847, 37.02224], [-121.32838, 37.02221], [-121.32871, 37.02123], [-121.33079, 37.01895], [-121.33135, 37.01868], [-121.33202, 37.0188], [-121.33318, 37.01942]]], [[[-121.3394, 37.01452], [-121.33674, 37.01658], [-121.3366, 37.01662], [-121.33598, 37.01721], [-121.33518, 37.01785], [-121.33503, 37.01782], [-121.33494, 37.01789], [-121.33498, 37.01801], [-121.33349, 37.01917], [-121.33146, 37.01808], [-121.33411, 37.01517], [-121.33462, 37.01488], [-121.33712, 37.01426], [-121.3394, 37.01452]]]]} | Restricted Access 2 | 49051 | Pacheco Creek Open Space Regional Reserve | 33793 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 162.38 | Pacheco Creek OS RR | None 1397 |
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]);