units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 410 sorted by DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13971 | 13971 | 13970 | {"type": "Polygon", "coordinates": [[[-121.64923, 37.11735], [-121.64827, 37.11568], [-121.64669, 37.11625], [-121.64579, 37.11463], [-121.64632, 37.11444], [-121.64626, 37.11431], [-121.64731, 37.11393], [-121.64642, 37.11231], [-121.64774, 37.11159], [-121.65067, 37.11677], [-121.65066, 37.11682], [-121.65062, 37.11685], [-121.64923, 37.11735]]]} | Open Access 1 | 36638 | Morgan Hill holding 3 | 22482 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 29.883 | Morgan Hill holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13972 | 13972 | 13971 | {"type": "Polygon", "coordinates": [[[-121.67307, 37.12075], [-121.67269, 37.1219], [-121.6661, 37.12198], [-121.6661, 37.12148], [-121.6667, 37.12121], [-121.66665, 37.121], [-121.66732, 37.12079], [-121.66731, 37.12073], [-121.66735, 37.12071], [-121.66764, 37.12123], [-121.668, 37.12105], [-121.66799, 37.12067], [-121.66792, 37.12032], [-121.66765, 37.12036], [-121.66754, 37.12016], [-121.66758, 37.11983], [-121.66702, 37.11999], [-121.66738, 37.11973], [-121.6674, 37.11966], [-121.66739, 37.1196], [-121.66736, 37.11954], [-121.66718, 37.11941], [-121.66712, 37.11933], [-121.66708, 37.11924], [-121.66701, 37.11929], [-121.66667, 37.11941], [-121.66669, 37.11947], [-121.66618, 37.11962], [-121.6658, 37.11892], [-121.66479, 37.1192], [-121.66477, 37.11877], [-121.66592, 37.11804], [-121.66555, 37.11732], [-121.67204, 37.11703], [-121.67277, 37.11831], [-121.67106, 37.11883], [-121.67307, 37.12075]], [[-121.66687, 37.11787], [-121.66668, 37.11788], [-121.66652, 37.1179], [-121.66627, 37.11813], [-121.66658, 37.1186], [-121.66791, 37.1186], [-121.66768, 37.11842], [-121.6675, 37.11814], [-121.66734, 37.11795], [-121.66723, 37.11788], [-121.66687, 37.11787]]]} | Open Access 1 | 36639 | Morgan Hill holding 4 | 22483 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 67.307 | Morgan Hill holding 4 | 0 | Local Other or Unknown 14 | 4 | |
12766 | 12766 | 12765 | {"type": "Polygon", "coordinates": [[[-121.66244, 37.12502], [-121.66156, 37.1255], [-121.66085, 37.12469], [-121.66099, 37.12461], [-121.66139, 37.12504], [-121.66161, 37.12494], [-121.66161, 37.12492], [-121.66121, 37.12449], [-121.66172, 37.12421], [-121.66186, 37.12436], [-121.6615, 37.12455], [-121.66175, 37.12485], [-121.66211, 37.12466], [-121.66244, 37.12502]]]} | Open Access 1 | 29868 | Civic Centre/City Hall | 17371 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 1.842 | Civic Centre/City Hall | None 1119 |
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]);