units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "5.315" and MNG_AGENCY = 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1415 | 1415 | 1414 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76657, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31238], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77227, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31318], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77537, 37.31301], [-121.77534, 37.31303], [-121.77515, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77412, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297], [-121.77537, 37.31301]]]]} | Open Access 1 | 8906 | Cortona Park | 17666 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.315 | Cortona Park | 2004 | Local Park 2 | 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]);