units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
528 rows where AGNCY_NAME = 4 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP 22
- Local Park 257
- Local Recreation Area 209
- Local Other or Unknown 15
- Local Conservation Area 9
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 4
- City Agency 505
- Commercial 1
- Non Profit - Other 1
- Other 1
MNG_AGENCY 4
ACCESS_TYP 4
- Open Access 479
- No Public Access 18
- Restricted Access 10
- Unknown Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
106 | 106 | 105 | {"type": "Polygon", "coordinates": [[[-117.10318, 32.90156], [-117.10307, 32.9016], [-117.10187, 32.90144], [-117.10218, 32.90092], [-117.10229, 32.90072], [-117.10315, 32.90065], [-117.1031, 32.90102], [-117.10311, 32.90134], [-117.10318, 32.90156]]]} | Open Access 1 | 293 | Aviary Neighborhood Park | 30137 | 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.256 | Aviary Neighborhood Park | 0 | Local Park 2 | 4 | |
123 | 123 | 122 | {"type": "Polygon", "coordinates": [[[-117.0714, 32.91778], [-117.07127, 32.91799], [-117.07094, 32.91786], [-117.07093, 32.91726], [-117.07111, 32.91751], [-117.0714, 32.91778]]]} | Open Access 1 | 311 | Semillon Mini Park | 25294 | 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.437 | Semillon MP | 0 | Local Park 2 | 4 | |
124 | 124 | 123 | {"type": "MultiPolygon", "coordinates": [[[[-117.26548, 32.84333], [-117.26547, 32.84364], [-117.2652, 32.8437], [-117.26511, 32.84366], [-117.26499, 32.84366], [-117.2649, 32.84372], [-117.26487, 32.84377], [-117.26422, 32.84393], [-117.2641, 32.84393], [-117.26406, 32.84397], [-117.26369, 32.84406], [-117.26355, 32.84406], [-117.26353, 32.84403], [-117.26343, 32.84399], [-117.26317, 32.84393], [-117.26309, 32.84393], [-117.26294, 32.84381], [-117.26284, 32.84379], [-117.26275, 32.84388], [-117.26274, 32.84395], [-117.26275, 32.84399], [-117.2628, 32.84402], [-117.26294, 32.84404], [-117.26305, 32.84407], [-117.26322, 32.84416], [-117.26071, 32.84475], [-117.26029, 32.84487], [-117.26016, 32.84487], [-117.25892, 32.84516], [-117.25842, 32.84358], [-117.25809, 32.84261], [-117.25941, 32.84228], [-117.26273, 32.8415], [-117.26283, 32.84162], [-117.26297, 32.84201], [-117.26303, 32.84209], [-117.26319, 32.84221], [-117.26407, 32.84242], [-117.26441, 32.84253], [-117.26443, 32.84256], [-117.2646, 32.84263], [-117.26461, 32.84265], [-117.26475, 32.84275], [-117.2653, 32.84321], [-117.26548, 32.84333]]], [[[-117.26349, 32.84409], [-117.26328, 32.84414], [-117.26311, 32.84404], [-117.26296, 32.84399], [-117.26281, 32.84397], [-117.26279, 32.84394], [-117.2628, 32.8439], [-117.26287, 32.84384], [-117.26292, 32.84386], [-117.26304, 32.84397], [-117.26308, 32.84398], [-117.26349, 32.84409]]], [[[-117.264, 32.8423], [-117.26331, 32.84213], [-117.2632, 32.84207], [-117.26312, 32.842], [-117.26308, 32.84195], [-117.26297, 32.84161], [-117.26288, 32.84147], [-117.2632, 32.84139], [-117.264, 32.8423]]]]} | Open Access 1 | 314 | La Jolla Heights Natural Park | 20764 | 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 | 41.0 | La Jolla Heights Natural Park | 0 | Local Park 2 | 4 | |
130 | 130 | 129 | {"type": "Polygon", "coordinates": [[[-117.25801, 32.85566], [-117.25562, 32.85961], [-117.25539, 32.8596], [-117.25546, 32.85849], [-117.25734, 32.85536], [-117.25801, 32.85566]]]} | Open Access 1 | 324 | Kellogg Park | 20584 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/kelloggpark | San Diego 4 | 7.979 | Kellogg Park | 0 | Local Park 2 | 4 |
131 | 131 | 130 | {"type": "Polygon", "coordinates": [[[-117.24598, 32.8585], [-117.24408, 32.85853], [-117.24395, 32.85841], [-117.24382, 32.85852], [-117.24358, 32.85817], [-117.24351, 32.85816], [-117.2435, 32.85814], [-117.24337, 32.85812], [-117.24332, 32.85797], [-117.24311, 32.85789], [-117.24304, 32.85789], [-117.24305, 32.85752], [-117.24302, 32.85751], [-117.24302, 32.85746], [-117.24284, 32.85737], [-117.24296, 32.85717], [-117.243, 32.85707], [-117.24302, 32.85694], [-117.243, 32.85678], [-117.24526, 32.85678], [-117.2453, 32.85708], [-117.24538, 32.85735], [-117.24554, 32.85763], [-117.24584, 32.85798], [-117.24589, 32.85807], [-117.24596, 32.85827], [-117.24598, 32.8585]]]} | Open Access 1 | 325 | Cliffridge Neighborhood Park | 30160 | 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 | 10.738 | Cliffridge Neighborhood Park | 0 | Local Park 2 | 4 | |
132 | 132 | 131 | {"type": "MultiPolygon", "coordinates": [[[[-117.21165, 32.84902], [-117.21112, 32.84923], [-117.21114, 32.85113], [-117.21083, 32.85129], [-117.21059, 32.85144], [-117.20911, 32.85244], [-117.20909, 32.85009], [-117.20923, 32.85007], [-117.20987, 32.84839], [-117.20982, 32.84806], [-117.20947, 32.8476], [-117.2096, 32.84703], [-117.20975, 32.84697], [-117.20987, 32.84689], [-117.20987, 32.84729], [-117.21033, 32.8473], [-117.21088, 32.84801], [-117.21144, 32.84826], [-117.21135, 32.8485], [-117.21141, 32.84871], [-117.21165, 32.84902]]], [[[-117.20987, 32.84664], [-117.20968, 32.84681], [-117.20958, 32.84686], [-117.20943, 32.8464], [-117.20915, 32.84622], [-117.20986, 32.84594], [-117.20987, 32.84664]]]]} | Open Access 1 | 336 | Standley Community Park | 25784 | 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 | 20.703 | Standley Community Park | 0 | Local Park 2 | 4 | |
141 | 141 | 140 | {"type": "Polygon", "coordinates": [[[-117.23261, 32.94159], [-117.23242, 32.94201], [-117.23235, 32.9423], [-117.23231, 32.94232], [-117.23227, 32.94233], [-117.23102, 32.94217], [-117.23099, 32.94216], [-117.23098, 32.94214], [-117.23101, 32.94172], [-117.23101, 32.94134], [-117.23261, 32.94159]]]} | Open Access 1 | 445 | Carmel Grove Neighborhood Park | 30152 | 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.028 | Carmel Grove Neighborhood Park | 0 | Local Park 2 | 4 | |
157 | 157 | 156 | {"type": "Polygon", "coordinates": [[[-117.2072, 32.92664], [-117.20718, 32.92667], [-117.20702, 32.92675], [-117.20665, 32.92691], [-117.20627, 32.92702], [-117.20576, 32.9271], [-117.20546, 32.92712], [-117.20412, 32.92709], [-117.20242, 32.92702], [-117.20267, 32.9264], [-117.20319, 32.92654], [-117.20435, 32.92653], [-117.20436, 32.92598], [-117.20466, 32.92571], [-117.20468, 32.92565], [-117.2049, 32.92567], [-117.20504, 32.92552], [-117.20586, 32.92558], [-117.20608, 32.92564], [-117.20638, 32.92577], [-117.20651, 32.92585], [-117.20669, 32.92602], [-117.20719, 32.9266], [-117.2072, 32.92664]]]} | Open Access 1 | 498 | Sage Canyon Neighborhood Park | 24781 | 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 | 11.544 | Sage Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
169 | 169 | 168 | {"type": "Polygon", "coordinates": [[[-117.22951, 32.94051], [-117.22941, 32.94054], [-117.22942, 32.94052], [-117.22937, 32.94039], [-117.22922, 32.94033], [-117.22916, 32.94027], [-117.22905, 32.94019], [-117.22877, 32.9401], [-117.22873, 32.94012], [-117.2286, 32.94032], [-117.22857, 32.94039], [-117.22857, 32.94046], [-117.22834, 32.94055], [-117.22821, 32.94046], [-117.22795, 32.9404], [-117.2279, 32.94042], [-117.2278, 32.94057], [-117.22776, 32.94064], [-117.22775, 32.94075], [-117.22777, 32.94082], [-117.2278, 32.94086], [-117.22785, 32.94089], [-117.22783, 32.94095], [-117.22791, 32.94096], [-117.22791, 32.94093], [-117.22811, 32.94103], [-117.22831, 32.94111], [-117.22868, 32.94123], [-117.22874, 32.94117], [-117.22892, 32.9411], [-117.22892, 32.94108], [-117.22898, 32.94104], [-117.22922, 32.94106], [-117.22931, 32.94104], [-117.22937, 32.94097], [-117.2294, 32.94082], [-117.22943, 32.94081], [-117.22945, 32.94081], [-117.22946, 32.94084], [-117.2294, 32.94102], [-117.22931, 32.94117], [-117.22873, 32.94187], [-117.22785, 32.94149], [-117.22745, 32.94126], [-117.22708, 32.9413], [-117.22682, 32.9412], [-117.2262, 32.9412], [-117.22622, 32.94109], [-117.22645, 32.94086], [-117.22653, 32.9406], [-117.22645, 32.94035], [-117.22613, 32.93992], [-117.22789, 32.9393], [-117.22818, 32.93927], [-117.22838, 32.93927], [-117.22869, 32.93934], [-117.2289, 32.93945], [-117.22903, 32.93955], [-117.22914, 32.93966], [-117.22923, 32.93977], [-117.22927, 32.93985], [-117.22944, 32.94023], [-117.22951, 32.94051]]]} | Open Access 1 | 451 | Carmel Del Mar Neighborhood Park | 30150 | 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 | 12.077 | Carmel Del Mar Neighborhood Park | 0 | Local Park 2 | 4 | |
176 | 176 | 175 | {"type": "Polygon", "coordinates": [[[-117.04021, 32.58356], [-117.04017, 32.58359], [-117.03877, 32.5836], [-117.03826, 32.58321], [-117.03819, 32.58213], [-117.03821, 32.58198], [-117.03938, 32.58198], [-117.03947, 32.5819], [-117.03954, 32.58193], [-117.03961, 32.58194], [-117.04018, 32.58193], [-117.04021, 32.58198], [-117.04021, 32.58356]]]} | Open Access 1 | 484 | Palm Ridge Neighborhood Park | 30073 | 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 | 8.09 | Palm Ridge Neighborhood Park | 0 | Local Park 2 | 4 | |
306 | 306 | 305 | {"type": "Polygon", "coordinates": [[[-117.09493, 32.57468], [-117.09492, 32.57638], [-117.093, 32.57635], [-117.09294, 32.57631], [-117.09293, 32.57625], [-117.09288, 32.57625], [-117.09287, 32.57478], [-117.09288, 32.57477], [-117.09289, 32.57468], [-117.09493, 32.57468]]]} | Open Access 1 | 1043 | Robert Egger Sr., South Bay Community Park | 30049 | 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 | 8.871 | Robert Egger Sr., South Bay Community Park | 0 | Local Park 2 | 4 | |
335 | 335 | 334 | {"type": "Polygon", "coordinates": [[[-117.26243, 32.81163], [-117.26192, 32.81174], [-117.26174, 32.81106], [-117.26223, 32.81095], [-117.26243, 32.81163]]]} | Open Access 1 | 914 | Bird Rock Neighborhood Park | 30091 | 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.929 | Bird Rock Neighborhood Park | 0 | Local Park 2 | 4 | |
342 | 342 | 341 | {"type": "Polygon", "coordinates": [[[-117.07324, 32.98201], [-117.073, 32.98257], [-117.07296, 32.98296], [-117.07307, 32.98326], [-117.07181, 32.98294], [-117.07129, 32.98252], [-117.07232, 32.98157], [-117.07242, 32.98166], [-117.07244, 32.98178], [-117.07248, 32.98182], [-117.07253, 32.98184], [-117.07257, 32.98183], [-117.07268, 32.98173], [-117.07299, 32.9819], [-117.07324, 32.98201]]]} | Open Access 1 | 935 | Highland Ranch Neighborhood Park | 30148 | 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 | 4.765 | Highland Ranch Neighborhood Park | 0 | Local Park 2 | 4 | |
505 | 505 | 504 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 2045 | 30th Street Mini Park | 15192 | 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.23 | 30th Street MP | 0 | Local Park 2 | 4 | |
570 | 570 | 569 | {"type": "Polygon", "coordinates": [[[-117.02663, 32.70575], [-117.02499, 32.70624], [-117.025, 32.70631], [-117.02418, 32.70653], [-117.02401, 32.70607], [-117.02397, 32.70564], [-117.02424, 32.70496], [-117.02449, 32.70465], [-117.02481, 32.70438], [-117.02511, 32.70441], [-117.02539, 32.70428], [-117.02552, 32.70446], [-117.02558, 32.70449], [-117.02567, 32.70452], [-117.02577, 32.70451], [-117.02616, 32.70434], [-117.02628, 32.70461], [-117.02663, 32.70575]]]} | Open Access 1 | 1890 | Skyline Hills Community Park | 30048 | 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 | 10.181 | Skyline Hills Community Park | 0 | Local Park 2 | 4 | |
573 | 573 | 572 | {"type": "Polygon", "coordinates": [[[-117.07921, 32.69788], [-117.079, 32.69789], [-117.07891, 32.69768], [-117.0791, 32.69765], [-117.07915, 32.69766], [-117.07919, 32.6977], [-117.07921, 32.69788]]]} | Open Access 1 | 1899 | Santa Isabel Mini-Park | 25092 | 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.144 | Santa Isabel Mini-Park | 0 | Local Park 2 | 4 | |
586 | 586 | 585 | {"type": "Polygon", "coordinates": [[[-117.05847, 32.68889], [-117.05758, 32.68888], [-117.05677, 32.68879], [-117.05662, 32.68874], [-117.0561, 32.68868], [-117.05602, 32.68869], [-117.05598, 32.6886], [-117.05581, 32.68856], [-117.0558, 32.68857], [-117.05581, 32.68861], [-117.0553, 32.68855], [-117.05489, 32.68853], [-117.05403, 32.68843], [-117.05344, 32.68833], [-117.05332, 32.68836], [-117.05316, 32.68834], [-117.05284, 32.6882], [-117.05276, 32.6882], [-117.05247, 32.6881], [-117.0521, 32.68795], [-117.05193, 32.68791], [-117.0518, 32.68786], [-117.05179, 32.68787], [-117.0518, 32.68793], [-117.05145, 32.68784], [-117.05143, 32.68775], [-117.05095, 32.68768], [-117.05049, 32.68767], [-117.04992, 32.68772], [-117.04949, 32.68782], [-117.04922, 32.68791], [-117.04903, 32.68793], [-117.04888, 32.68785], [-117.04882, 32.68776], [-117.04881, 32.68768], [-117.04889, 32.68711], [-117.04902, 32.68664], [-117.04914, 32.68637], [-117.04929, 32.68613], [-117.04944, 32.68593], [-117.04977, 32.6856], [-117.04999, 32.68542], [-117.05025, 32.68526], [-117.05069, 32.68503], [-117.05069, 32.68502], [-117.05058, 32.68495], [-117.05072, 32.68489], [-117.05064, 32.68479], [-117.05079, 32.68472], [-117.05112, 32.685], [-117.05122, 32.68513], [-117.0513, 32.68526], [-117.05137, 32.68548], [-117.05155, 32.68639], [-117.05241, 32.68638], [-117.05391, 32.68659], [-117.054, 32.68659], [-117.05413, 32.68662], [-117.05453, 32.68668], [-117.05615, 32.68622], [-117.05652, 32.68613], [-117.0573, 32.6859], [-117.05847, 32.68889]], [[-117.05627, 32.68683], [-117.05628, 32.68682], [-117.05607, 32.68631], [-117.05509, 32.68658], [-117.05529, 32.68711], [-117.05627, 32.68683]]]} | Open Access 1 | 1961 | Paradise Hills Community Park | 23403 | 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 | 48.328 | Paradise Hills Community Park | 0 | Local Park 2 | 4 | |
591 | 591 | 590 | {"type": "Polygon", "coordinates": [[[-117.16091, 32.71066], [-117.16057, 32.71067], [-117.16057, 32.71053], [-117.16091, 32.71052], [-117.16091, 32.71066]]]} | Open Access 1 | 2008 | Davis House Mini Park | 17950 | 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.118 | Davis House MP | 0 | Local Park 2 | 4 | |
597 | 597 | 596 | {"type": "MultiPolygon", "coordinates": [[[[-117.10527, 32.72898], [-117.10513, 32.7292], [-117.1051, 32.72946], [-117.1051, 32.72965], [-117.10505, 32.72965], [-117.10505, 32.72986], [-117.10494, 32.73037], [-117.10481, 32.73069], [-117.10462, 32.73105], [-117.10448, 32.73123], [-117.10413, 32.73162], [-117.10403, 32.73171], [-117.10346, 32.73208], [-117.10328, 32.73223], [-117.10314, 32.73236], [-117.10299, 32.73255], [-117.10288, 32.73276], [-117.10276, 32.73303], [-117.10266, 32.73451], [-117.1027, 32.73459], [-117.10284, 32.73474], [-117.10299, 32.73482], [-117.10314, 32.73485], [-117.10325, 32.7349], [-117.10339, 32.73501], [-117.10317, 32.73521], [-117.1031, 32.73515], [-117.10298, 32.73509], [-117.10263, 32.73508], [-117.10249, 32.7351], [-117.10196, 32.73527], [-117.10194, 32.73519], [-117.10208, 32.73501], [-117.10213, 32.7349], [-117.10215, 32.73479], [-117.10212, 32.73463], [-117.10199, 32.73439], [-117.10209, 32.73438], [-117.10212, 32.73434], [-117.10215, 32.73326], [-117.10213, 32.73323], [-117.10204, 32.7332], [-117.10219, 32.73294], [-117.10224, 32.73278], [-117.10229, 32.7323], [-117.10251, 32.73231], [-117.10279, 32.73198], [-117.10356, 32.73134], [-117.10389, 32.73088], [-117.10405, 32.73056], [-117.10417, 32.73019], [-117.10423, 32.72985], [-117.10424, 32.72966], [-117.1042, 32.72966], [-117.10419, 32.72823], [-117.10494, 32.72859], [-117.10527, 32.72898]]], [[[-117.10398, 32.73575], [-117.10375, 32.73595], [-117.10343, 32.73572], [-117.10326, 32.73548], [-117.10322, 32.73536], [-117.10347, 32.73513], [-117.10357, 32.7354], [-117.10364, 32.73548], [-117.10398, 32.73575]]]]} | Open Access 1 | 2035 | Hollywood Neighborhood Park | 30108 | 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.261 | Hollywood Neighborhood Park | 0 | Local Park 2 | 4 | |
602 | 602 | 601 | {"type": "Polygon", "coordinates": [[[-117.08928, 32.71686], [-117.08823, 32.71686], [-117.08825, 32.7151], [-117.08928, 32.71511], [-117.08928, 32.71686]]]} | Open Access 1 | 2059 | Gompers Neighborhood Park | 30060 | 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 | 4.712 | Gompers Neighborhood Park | 0 | 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]);