units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 24, DES_TP = 1397 and MNG_AGENCY = 529
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);