units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_LEV = 2 and MNG_AGENCY = 79
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199 | 199 | 198 | {"type": "Polygon", "coordinates": [[[-120.16151, 34.59253], [-120.16137, 34.59261], [-120.16006, 34.59216], [-120.15908, 34.5915], [-120.15736, 34.59022], [-120.15748, 34.58949], [-120.15913, 34.59074], [-120.15995, 34.59087], [-120.16151, 34.59253]]]} | Open Access 1 | 629 | Santa Ynez River | 25146 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 8.216 | Santa Ynez River | None 22 | |||
657 | 657 | 656 | {"type": "Polygon", "coordinates": [[[-120.14287, 34.588], [-120.1423, 34.58955], [-120.14208, 34.58947], [-120.14139, 34.58931], [-120.14146, 34.58926], [-120.14226, 34.58911], [-120.14247, 34.58854], [-120.14266, 34.58832], [-120.14287, 34.588]]]} | Open Access 1 | 3221 | Alisal Commons Park | 15367 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 1.023 | Alisal Commons Park | 0 | Local Park 2 | 4 | |
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | 35310 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 3.005 | 0 | Local Other or Unknown 14 | 4 | ||
5655 | 5655 | 5654 | {"type": "Polygon", "coordinates": [[[-120.14075, 34.59592], [-120.13946, 34.5959], [-120.13946, 34.5959], [-120.13963, 34.59555], [-120.14075, 34.59592]]]} | Open Access 1 | 35244 | Unknown park - Solvang, City of | 28669 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.581 | 0 | Local Other or Unknown 14 | 4 | ||
9799 | 9799 | 9798 | {"type": "MultiPolygon", "coordinates": [[[[-120.14195, 34.60161], [-120.14181, 34.60194], [-120.14097, 34.60137], [-120.14118, 34.60112], [-120.14132, 34.6012], [-120.14151, 34.60119], [-120.14161, 34.60126], [-120.14195, 34.60161]]], [[[-120.15176, 34.59442], [-120.15012, 34.59555], [-120.14969, 34.59583], [-120.14812, 34.59663], [-120.14789, 34.59691], [-120.14745, 34.59692], [-120.14732, 34.59716], [-120.14736, 34.59744], [-120.14721, 34.59774], [-120.1467, 34.59823], [-120.14674, 34.59849], [-120.14648, 34.59942], [-120.14615, 34.59974], [-120.14639, 34.60041], [-120.1469, 34.60083], [-120.14713, 34.6018], [-120.14701, 34.60175], [-120.14673, 34.60171], [-120.14665, 34.60172], [-120.14654, 34.60093], [-120.14602, 34.60086], [-120.14578, 34.60045], [-120.14548, 34.60021], [-120.14514, 34.60016], [-120.14476, 34.60065], [-120.14419, 34.60057], [-120.14372, 34.60195], [-120.14365, 34.60189], [-120.14358, 34.60186], [-120.14347, 34.60192], [-120.14322, 34.60181], [-120.14274, 34.60139], [-120.14232, 34.60139], [-120.14218, 34.60133], [-120.14192, 34.60111], [-120.14157, 34.60069], [-120.1414, 34.6003], [-120.1414, 34.60007], [-120.14133, 34.59992], [-120.14242, 34.6001], [-120.14367, 34.5994], [-120.14378, 34.59946], [-120.14407, 34.59916], [-120.14413, 34.59905], [-120.14416, 34.59897], [-120.14462, 34.59869], [-120.14506, 34.59868], [-120.14519, 34.59858], [-120.14518, 34.59856], [-120.14485, 34.59846], [-120.14472, 34.59783], [-120.14535, 34.59704], [-120.14552, 34.59687], [-120.14573, 34.59633], [-120.14603, 34.59632], [-120.14649, 34.59611], [-120.14673, 34.59597], [-120.14688, 34.59579], [-120.14696, 34.5955], [-120.14826, 34.59466], [-120.14938, 34.59451], [-120.15005, 34.59411], [-120.15014, 34.5941], [-120.15047, 34.59408], [-120.15079, 34.59409], [-120.15154, 34.59425], [-120.15176, 34.59442]], [[-120.15062, 34.59483], [-120.15062, 34.59481], [-120.15017, 34.59438], [-120.14963, 34.59462], [-120.14998, 34.59515], [-120.15062, 34.59483]]]]} | Open Access 1 | 16732 | Hans Christian Andersen Park | 19647 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 51.225 | Hans Christian Andersen Park | 0 | Local Park 2 | 4 | |
13200 | 13200 | 13199 | {"type": "Polygon", "coordinates": [[[-120.14624, 34.60823], [-120.14615, 34.60863], [-120.14538, 34.60859], [-120.14546, 34.60827], [-120.14599, 34.60822], [-120.14624, 34.60823]]]} | Open Access 1 | 35228 | Solvang holding 1 | 25601 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.735 | Solvang holding 1 | 0 | Local Other or Unknown 14 | 4 | |
14754 | 14754 | 14753 | {"type": "Polygon", "coordinates": [[[-120.12471, 34.60687], [-120.12345, 34.60767], [-120.12316, 34.60789], [-120.12289, 34.60815], [-120.12264, 34.60842], [-120.12242, 34.60872], [-120.12223, 34.60903], [-120.12203, 34.60943], [-120.12205, 34.60685], [-120.12471, 34.60687]]]} | Open Access 1 | 45125 | Sunny Fields Park | 26003 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 6.694 | Sunny Fields Park | 0 | Local Recreation Area 3 | 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]);