units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
211 rows where DES_TP = 3 and MNG_AGENCY = 4 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL, YR_EST
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency 211
MNG_AGENCY 1
- San Diego, City of · 211 ✖
DES_TP 1
- Local Recreation Area · 211 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15524 | 15524 | 15523 | {"type": "Polygon", "coordinates": [[[-117.22892, 32.73309], [-117.22881, 32.73321], [-117.22872, 32.73319], [-117.22845, 32.73238], [-117.22814, 32.73121], [-117.22805, 32.73081], [-117.22812, 32.73078], [-117.22825, 32.73086], [-117.22819, 32.73095], [-117.22843, 32.73188], [-117.2287, 32.73205], [-117.22876, 32.73233], [-117.2286, 32.73251], [-117.22875, 32.73299], [-117.22892, 32.73309]]]} | Open Access 1 | 202 | Wawona Drive Open Space | 27321 | 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.988 | Wawona Drive OS | 0 | Local Recreation Area 3 | 4 | |
15556 | 15556 | 15555 | {"type": "Polygon", "coordinates": [[[-117.08751, 32.73595], [-117.087, 32.73677], [-117.08672, 32.73676], [-117.08689, 32.73654], [-117.08677, 32.73643], [-117.08694, 32.73621], [-117.08711, 32.73629], [-117.08739, 32.73587], [-117.08751, 32.73595]]]} | Open Access 1 | 45200 | Wadsworths Olive Grove Open Space | 27207 | 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.601 | Wadsworths Olive Grove OS | 0 | Local Recreation Area 3 | 4 | |
16012 | 16012 | 16011 | {"type": "MultiPolygon", "coordinates": [[[[-117.07284, 32.70758], [-117.07214, 32.70758], [-117.07203, 32.70744], [-117.07218, 32.70724], [-117.0722, 32.70691], [-117.07203, 32.70673], [-117.07107, 32.70686], [-117.07091, 32.70689], [-117.07092, 32.70466], [-117.07142, 32.70466], [-117.07163, 32.70497], [-117.07266, 32.70701], [-117.07278, 32.70734], [-117.07284, 32.70758]]], [[[-117.07322, 32.70759], [-117.07316, 32.70759], [-117.07308, 32.70728], [-117.07299, 32.70705], [-117.07191, 32.70491], [-117.07177, 32.70467], [-117.07255, 32.70467], [-117.07255, 32.70409], [-117.07296, 32.70409], [-117.07307, 32.70406], [-117.0732, 32.70406], [-117.07317, 32.70595], [-117.07322, 32.70759]]]]} | Open Access 1 | 1809 | Valencia Canyon Ext. Open Space | 26759 | 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 | 13.169 | Valencia Canyon Ext. OS | 0 | Local Recreation Area 3 | 4 | |
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 | |
10590 | 10590 | 10589 | {"type": "Polygon", "coordinates": [[[-117.15749, 32.76255], [-117.1525, 32.7624], [-117.15249, 32.76167], [-117.15329, 32.7615], [-117.15361, 32.76141], [-117.1537, 32.76139], [-117.1538, 32.7614], [-117.15416, 32.76151], [-117.15425, 32.76156], [-117.15448, 32.76177], [-117.15463, 32.76185], [-117.15476, 32.76189], [-117.15506, 32.7619], [-117.15533, 32.76198], [-117.15594, 32.76201], [-117.15612, 32.762], [-117.15613, 32.7619], [-117.15623, 32.76184], [-117.15632, 32.76183], [-117.15634, 32.76197], [-117.15663, 32.76189], [-117.15686, 32.76181], [-117.15715, 32.76168], [-117.15748, 32.76149], [-117.15749, 32.76255]]]} | Open Access 1 | 18871 | University Heights Open Space Park | 26682 | 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 | 9.486 | University Heights OS Park | 0 | Local Recreation Area 3 | 4 | |
16164 | 16164 | 16163 | {"type": "Polygon", "coordinates": [[[-117.15079, 32.76235], [-117.14895, 32.76236], [-117.14894, 32.76223], [-117.14952, 32.76191], [-117.14993, 32.7618], [-117.15012, 32.76172], [-117.15017, 32.76172], [-117.15018, 32.76182], [-117.15034, 32.76188], [-117.15041, 32.76192], [-117.1505, 32.76201], [-117.15059, 32.76216], [-117.15079, 32.76235]]]} | Open Access 1 | 18854 | University Heights Open Space Park | 26682 | 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.822 | University Heights OS Park | 0 | Local Recreation Area 3 | 4 | |
4935 | 4935 | 4934 | {"type": "Polygon", "coordinates": [[[-117.13894, 32.76418], [-117.13897, 32.7643], [-117.13895, 32.76456], [-117.13872, 32.76547], [-117.13868, 32.76573], [-117.13868, 32.76599], [-117.1379, 32.76599], [-117.1379, 32.76539], [-117.13854, 32.76539], [-117.13852, 32.76419], [-117.13894, 32.76418]]]} | Open Access 1 | 18884 | University Heights Open Space | 26681 | 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.316 | University Heights OS | 0 | Local Recreation Area 3 | 4 | |
15973 | 15973 | 15972 | {"type": "Polygon", "coordinates": [[[-117.21568, 32.84699], [-117.2151, 32.84705], [-117.21482, 32.84731], [-117.21479, 32.84754], [-117.21499, 32.84817], [-117.2154, 32.84849], [-117.21504, 32.84905], [-117.21448, 32.84907], [-117.21443, 32.8489], [-117.21444, 32.84851], [-117.2141, 32.84827], [-117.21406, 32.84805], [-117.21376, 32.84808], [-117.21366, 32.84832], [-117.21335, 32.8485], [-117.21307, 32.84786], [-117.21295, 32.84691], [-117.21274, 32.84621], [-117.21215, 32.84528], [-117.21138, 32.84541], [-117.20987, 32.846], [-117.20987, 32.84594], [-117.21133, 32.84537], [-117.21408, 32.84494], [-117.21413, 32.84494], [-117.2142, 32.84507], [-117.21448, 32.8451], [-117.21496, 32.84529], [-117.21479, 32.84563], [-117.2147, 32.84559], [-117.21428, 32.84578], [-117.2142, 32.84614], [-117.21431, 32.84638], [-117.21524, 32.84649], [-117.2155, 32.84672], [-117.21568, 32.84699]]]} | Open Access 1 | 320 | University City Open Space | 26674 | 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 | 18.827 | University City OS | 0 | Local Recreation Area 3 | 4 | |
15624 | 15624 | 15623 | {"type": "Polygon", "coordinates": [[[-117.25401, 32.90718], [-117.25377, 32.90874], [-117.25262, 32.90918], [-117.24994, 32.90895], [-117.24794, 32.9092], [-117.24821, 32.91061], [-117.24923, 32.91094], [-117.25048, 32.91053], [-117.25122, 32.91156], [-117.24972, 32.91275], [-117.24806, 32.91462], [-117.24673, 32.91482], [-117.24619, 32.91416], [-117.24559, 32.91285], [-117.24534, 32.91288], [-117.24527, 32.91268], [-117.24423, 32.90787], [-117.24323, 32.90302], [-117.24456, 32.90286], [-117.24504, 32.90279], [-117.245, 32.90244], [-117.24482, 32.90135], [-117.24476, 32.90057], [-117.24393, 32.90056], [-117.24393, 32.89928], [-117.24361, 32.89931], [-117.24339, 32.89538], [-117.24311, 32.89479], [-117.243, 32.89303], [-117.2429, 32.89074], [-117.24399, 32.89061], [-117.24399, 32.89004], [-117.24568, 32.89008], [-117.2485, 32.8908], [-117.24981, 32.89148], [-117.24979, 32.89123], [-117.24893, 32.89001], [-117.24905, 32.88967], [-117.24895, 32.88953], [-117.24912, 32.88945], [-117.24949, 32.88918], [-117.24956, 32.88871], [-117.24948, 32.88821], [-117.24675, 32.88752], [-117.24675, 32.88716], [-117.24929, 32.88717], [-117.24931, 32.88608], [-117.25316, 32.88609], [-117.25325, 32.88745], [-117.25336, 32.8895], [-117.25341, 32.89232], [-117.25347, 32.89308], [-117.25341, 32.89309], [-117.25342, 32.89313], [-117.25326, 32.89416], [-117.25312, 32.89498], [-117.25313, 32.89595], [-117.2531, 32.89605], [-117.25307, 32.89665], [-117.25207, 32.8971], [-117.24992, 32.89617], [-117.24919, 32.89482], [-117.24868, 32.89411], [-117.2478, 32.89401], [-117.24696, 32.89485], [-117.24697, 32.89486], [-117.24824, 32.89499], [-117.2483, 32.89632], [-117.24733, 32.89745], [-117.24658, 32.89793], [-117.24674, 32.89866], [-117.248, 32.89905], [-117.24715, 32.90058], [-117.24714, 32.90063], [-117.24882, 32.90056], [-117.24967, 32.89857], [-117.25065, 32.89747], [-117.25183, 32.89836], [-117.25235, 32.90141], [-117.25196, 32.90284], [-117.25085, 32.90429], [-117.24791, 32.90569], [-117.24852, 32.90688], [-117.24931, 32.9069], [-117.2531, 32.90488], [-117.2532, 32.90552], [-117.25401, 32.90718]]]} | Restricted Access 2 | 12118 | Torrey Pines Golf Course | 33030 | 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 | 484.153 | Torrey Pines GC | 0 | Local Recreation Area 3 | 4 | |
5943 | 5943 | 5942 | {"type": "Polygon", "coordinates": [[[-117.23864, 32.92632], [-117.23806, 32.92643], [-117.23687, 32.92535], [-117.23652, 32.92509], [-117.23616, 32.92486], [-117.23596, 32.92475], [-117.23567, 32.92463], [-117.23523, 32.92447], [-117.23458, 32.92429], [-117.23457, 32.9238], [-117.23428, 32.92379], [-117.23427, 32.92337], [-117.23444, 32.92337], [-117.23459, 32.92331], [-117.23469, 32.9232], [-117.23476, 32.92333], [-117.23477, 32.92351], [-117.23482, 32.92359], [-117.23494, 32.92372], [-117.23505, 32.92379], [-117.23526, 32.92391], [-117.23624, 32.92437], [-117.23655, 32.92456], [-117.23691, 32.92449], [-117.23709, 32.92385], [-117.23703, 32.92364], [-117.23694, 32.92348], [-117.2368, 32.92341], [-117.23654, 32.92336], [-117.23654, 32.92328], [-117.23662, 32.92315], [-117.23663, 32.92305], [-117.23656, 32.92287], [-117.2365, 32.9226], [-117.23655, 32.92226], [-117.2371, 32.92259], [-117.23764, 32.92268], [-117.23795, 32.92337], [-117.2379, 32.9237], [-117.23796, 32.92388], [-117.23815, 32.92398], [-117.23831, 32.92446], [-117.23795, 32.92496], [-117.23825, 32.92579], [-117.23864, 32.92632]]]} | Open Access 1 | 503 | Torrey Hills Open Space | 26471 | 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 | 14.814 | Torrey Hills OS | 0 | Local Recreation Area 3 | 4 | |
15994 | 15994 | 15993 | {"type": "Polygon", "coordinates": [[[-117.16556, 32.97451], [-117.16556, 32.97866], [-117.16552, 32.98475], [-117.16546, 32.98475], [-117.16541, 32.98473], [-117.1654, 32.9847], [-117.16542, 32.9821], [-117.16532, 32.98209], [-117.16514, 32.98174], [-117.16518, 32.98138], [-117.16514, 32.9809], [-117.16506, 32.98077], [-117.16491, 32.98058], [-117.16551, 32.98008], [-117.16548, 32.97961], [-117.16516, 32.97967], [-117.16508, 32.97979], [-117.16475, 32.98], [-117.16438, 32.98015], [-117.16375, 32.98012], [-117.16375, 32.98036], [-117.16396, 32.98045], [-117.16429, 32.98083], [-117.16439, 32.98088], [-117.16465, 32.98076], [-117.16496, 32.98097], [-117.16498, 32.98137], [-117.16494, 32.98177], [-117.16499, 32.98186], [-117.16487, 32.98195], [-117.16501, 32.98209], [-117.16466, 32.9821], [-117.16435, 32.9825], [-117.16448, 32.98258], [-117.16432, 32.98287], [-117.16419, 32.98317], [-117.1641, 32.98354], [-117.16402, 32.98406], [-117.16377, 32.98397], [-117.16375, 32.984], [-117.16401, 32.98413], [-117.16399, 32.98434], [-117.16396, 32.98443], [-117.16389, 32.98457], [-117.16381, 32.98468], [-117.16365, 32.98481], [-117.16288, 32.98524], [-117.16278, 32.98512], [-117.1627, 32.9851], [-117.16244, 32.98556], [-117.16245, 32.98569], [-117.16197, 32.98572], [-117.16183, 32.9857], [-117.16218, 32.98523], [-117.16288, 32.98474], [-117.16306, 32.98465], [-117.16322, 32.98453], [-117.16341, 32.98424], [-117.16351, 32.98391], [-117.16353, 32.98378], [-117.16347, 32.98362], [-117.16328, 32.98321], [-117.16372, 32.9829], [-117.16409, 32.98247], [-117.16432, 32.98201], [-117.16453, 32.98185], [-117.16464, 32.98161], [-117.16465, 32.9812], [-117.16457, 32.9811], [-117.16478, 32.98101], [-117.16478, 32.98099], [-117.16475, 32.98096], [-117.16454, 32.98106], [-117.16445, 32.98094], [-117.16417, 32.9808], [-117.16355, 32.98085], [-117.16333, 32.98094], [-117.16323, 32.98132], [-117.16285, 32.98129], [-117.16141, 32.98173], [-117.16138, 32.98169], [-117.16082, 32.98166], [-117.16049, 32.98175], [-117.16, 32.98192], [-117.15945, 32.9813], [-117.15916, 32.98109], [-117.15937, 32.98087], [-117.1596, 32.98037], [-117.16, 32.9804], [-117.16031, 32.98029], [-117.16054, 32.98012], [-117.16114, 32.9798], [-117.16182, 32.97945], [-117.16197, 32.97887], [-117.16174, 32.9786], [-117.16148, 32.97846], [-117.16121, 32.97836], [-117.16104, 32.97818], [-117.16138, 32.97809], [-117.16138, 32.97804], [-117.16094, 32.97796], [-117.16097, 32.9779], [-117.16125, 32.97768], [-117.16141, 32.97766], [-117.16141, 32.97753], [-117.16342, 32.9775], [-117.16351, 32.97712], [-117.16332, 32.97654], [-117.16228, 32.97606], [-117.16171, 32.97586], [-117.16066, 32.9759], [-117.16012, 32.97608], [-117.15985, 32.97635], [-117.15962, 32.97639], [-117.15915, 32.97601], [-117.159, 32.97596], [-117.15836, 32.97618], [-117.15828, 32.97654], [-117.15802, 32.97661], [-117.15787, 32.97643], [-117.15709, 32.97633], [-117.15522, 32.97674], [-117.15479, 32.97712], [-117.15468, 32.97706], [-117.15456, 32.97698], [-117.15446, 32.97688], [-117.15438, 32.97676], [-117.15409, 32.97588], [-117.15413, 32.97567], [-117.15447, 32.97565], [-117.15487, 32.97543], [-117.15617, 32.97516], [-117.15718, 32.97467], [-117.15775, 32.97417], [-117.15853, 32.97386], [-117.15901, 32.97417], [-117.15957, 32.9746], [-117.16025, 32.97458], [-117.16133, 32.97423], [-117.16189, 32.9742], [-117.16242, 32.97401], [-117.16302, 32.97374], [-117.16322, 32.97339], [-117.16342, 32.97324], [-117.16395, 32.97391], [-117.1645, 32.97406], [-117.16499, 32.97412], [-117.16556, 32.97451]]]} | Open Access 1 | 930 | Torrey Highlands Open Space | 10619 | 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 | 113.331 | Torrey Highlands OS | 0 | Local Recreation Area 3 | 4 | |
16010 | 16010 | 16009 | {"type": "Polygon", "coordinates": [[[-117.15282, 32.96061], [-117.15281, 32.96064], [-117.15278, 32.96063], [-117.15275, 32.96076], [-117.15258, 32.96073], [-117.15252, 32.96074], [-117.1522, 32.96084], [-117.15188, 32.96087], [-117.15171, 32.96095], [-117.15163, 32.96106], [-117.15162, 32.96111], [-117.15151, 32.96124], [-117.15136, 32.9615], [-117.1513, 32.96146], [-117.15119, 32.96127], [-117.15114, 32.96097], [-117.15113, 32.96071], [-117.15108, 32.96065], [-117.15099, 32.96062], [-117.15095, 32.96052], [-117.15093, 32.96021], [-117.15098, 32.96011], [-117.15118, 32.95994], [-117.15127, 32.95991], [-117.15172, 32.96017], [-117.15204, 32.96021], [-117.15235, 32.96028], [-117.15264, 32.96043], [-117.15277, 32.96057], [-117.15279, 32.9606], [-117.15282, 32.96061]]]} | Open Access 1 | 1760 | Torrey Highlands Open Space | 10619 | 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.557 | Torrey Highlands 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]);