units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where DES_TP = 3 and LABEL_NAME = "Uptown OS"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5837 | 5837 | 5836 | {"type": "Polygon", "coordinates": [[[-117.17083, 32.73648], [-117.1707, 32.73656], [-117.17061, 32.73656], [-117.17033, 32.73618], [-117.17009, 32.7358], [-117.17019, 32.73575], [-117.17083, 32.73648]]]} | Open Access 1 | 196 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.442 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
6098 | 6098 | 6097 | {"type": "Polygon", "coordinates": [[[-117.15918, 32.75713], [-117.15912, 32.75716], [-117.15916, 32.75725], [-117.15854, 32.75715], [-117.15815, 32.7573], [-117.15747, 32.75732], [-117.15763, 32.75683], [-117.15876, 32.75665], [-117.15867, 32.7564], [-117.15856, 32.75598], [-117.15902, 32.75688], [-117.15918, 32.75713]]]} | Open Access 1 | 18894 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.149 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
6492 | 6492 | 6491 | {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} | Open Access 1 | 180 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.122 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
10051 | 10051 | 10050 | {"type": "Polygon", "coordinates": [[[-117.16506, 32.75862], [-117.16487, 32.75872], [-117.16435, 32.75831], [-117.16428, 32.7582], [-117.16424, 32.75796], [-117.16418, 32.75793], [-117.16412, 32.75791], [-117.16381, 32.75794], [-117.16365, 32.7579], [-117.16356, 32.75785], [-117.16349, 32.75773], [-117.16345, 32.75754], [-117.16348, 32.75742], [-117.16346, 32.7573], [-117.16342, 32.75727], [-117.16337, 32.75726], [-117.16317, 32.75729], [-117.16304, 32.75725], [-117.16278, 32.75707], [-117.16264, 32.75694], [-117.16289, 32.75677], [-117.16305, 32.75701], [-117.16369, 32.7572], [-117.16372, 32.75726], [-117.16366, 32.75779], [-117.1643, 32.75775], [-117.16447, 32.75793], [-117.16462, 32.75826], [-117.16494, 32.75844], [-117.16506, 32.75862]]]} | Open Access 1 | 18890 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.772 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
10147 | 10147 | 10146 | {"type": "Polygon", "coordinates": [[[-117.17727, 32.74744], [-117.17689, 32.74791], [-117.17662, 32.74774], [-117.17662, 32.74752], [-117.17714, 32.74736], [-117.17727, 32.74744]]]} | Open Access 1 | 18715 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.508 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15958 | 15958 | 15957 | {"type": "MultiPolygon", "coordinates": [[[[-117.16852, 32.75178], [-117.16819, 32.75178], [-117.16819, 32.75095], [-117.16851, 32.75094], [-117.16852, 32.75178]]], [[[-117.17277, 32.75259], [-117.17219, 32.7526], [-117.17221, 32.75382], [-117.17234, 32.75383], [-117.17233, 32.75447], [-117.17188, 32.75448], [-117.17188, 32.75493], [-117.17128, 32.75494], [-117.17129, 32.75521], [-117.17188, 32.75521], [-117.17188, 32.75535], [-117.1704, 32.75535], [-117.1704, 32.75679], [-117.16881, 32.75676], [-117.16879, 32.75595], [-117.16827, 32.75595], [-117.16825, 32.7539], [-117.16825, 32.75383], [-117.16882, 32.75382], [-117.1688, 32.75369], [-117.1688, 32.75301], [-117.16946, 32.75301], [-117.16949, 32.75482], [-117.17153, 32.7548], [-117.17154, 32.75383], [-117.17152, 32.75273], [-117.17153, 32.75233], [-117.17127, 32.75232], [-117.17061, 32.75232], [-117.17062, 32.75197], [-117.17065, 32.75193], [-117.1707, 32.75191], [-117.17127, 32.75191], [-117.17128, 32.75218], [-117.17185, 32.75218], [-117.17186, 32.75225], [-117.17244, 32.75225], [-117.17245, 32.75219], [-117.17277, 32.75219], [-117.17277, 32.75259]]], [[[-117.1731, 32.75421], [-117.17278, 32.75421], [-117.17277, 32.75382], [-117.17309, 32.75381], [-117.1731, 32.75421]]]]} | Open Access 1 | 63 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 22.556 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15959 | 15959 | 15958 | {"type": "Polygon", "coordinates": [[[-117.15844, 32.75574], [-117.15803, 32.75574], [-117.15769, 32.75634], [-117.15747, 32.75625], [-117.15712, 32.75602], [-117.15701, 32.75585], [-117.15677, 32.7558], [-117.15656, 32.75572], [-117.15644, 32.75554], [-117.15643, 32.75545], [-117.15766, 32.75548], [-117.15765, 32.7543], [-117.15782, 32.75454], [-117.158, 32.75474], [-117.15844, 32.75574]]]} | Open Access 1 | 74 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.512 | Uptown OS | 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]);