units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where LAYER = 14 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Valley-Wide Recreation and Park District 7
- Amerige Heights Community Association 7
- Bellflower, City of 6
- San Clemente, City of 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Irvine, City of 3
- Quail Hill Community Association 3
- Private Landowner 3
- Wildlands Inc 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- San Jacinto, City of 2
- Chino, City of 2
- Paramount, City of 2
- West Hollywood, City of 2
- Oak Creek Village Maintenance Association 2
- King City, City of 2
- Broadmoor Campus View Community Association 2
- McCloud River Railroad Company 2
- Woodbridge Owners Association 2
- …
DES_TP 19
- Private Recreation or Education 193
- Local Park 36
- Private Conservation 16
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- State Recreation Area 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 12
MNG_AG_LEV 6 ✖
- Private 218
- City 36
- Special District 9
- County 1
- State 1
- Non Profit 1
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
498 | 498 | 497 | {"type": "Polygon", "coordinates": [[[-117.29951, 33.64844], [-117.29964, 33.64847], [-117.29974, 33.64855], [-117.29977, 33.64866], [-117.29973, 33.64877], [-117.29926, 33.6492], [-117.29918, 33.64923], [-117.2991, 33.64924], [-117.29902, 33.64922], [-117.29895, 33.64918], [-117.2989, 33.64912], [-117.29887, 33.64906], [-117.29887, 33.64898], [-117.29891, 33.6489], [-117.29934, 33.6485], [-117.29941, 33.64846], [-117.29951, 33.64844]]]} | Restricted Access 2 | 48361 | Spirit Park | 32928 | 7028 | Summerly Homes 188 | Private 7 | Home Owners Association 16 | http://summerlyhomes.com/explore/ | Private 14 | 7028 | Summerly Homes 184 | Private 7 | Home Owners Association 15 | http://summerlyhomes.com/explore/ | Riverside 10 | 1.064 | Spirit Park | None 53 | ||
4797 | 4797 | 4796 | {"type": "MultiPolygon", "coordinates": [[[[-117.23584, 34.05241], [-117.23549, 34.05282], [-117.23539, 34.05282], [-117.23539, 34.05228], [-117.23553, 34.05229], [-117.23564, 34.05231], [-117.23584, 34.05241]]], [[[-117.23799, 34.05321], [-117.23708, 34.05429], [-117.23702, 34.0543], [-117.23669, 34.0541], [-117.23668, 34.05405], [-117.23759, 34.05298], [-117.23765, 34.05297], [-117.23798, 34.05316], [-117.23799, 34.05321]]], [[[-117.23727, 34.04704], [-117.23727, 34.04741], [-117.23683, 34.04741], [-117.23684, 34.04703], [-117.23704, 34.04703], [-117.23706, 34.04698], [-117.23707, 34.04703], [-117.23727, 34.04704]]], [[[-117.23878, 34.0544], [-117.23852, 34.05439], [-117.23842, 34.05435], [-117.2383, 34.05429], [-117.23867, 34.05386], [-117.23878, 34.05386], [-117.23878, 34.0544]]]]} | Restricted Access 2 | 48470 | Unnamed Park - Mission Trails HOA | 33179 | 7032 | Mission Trails HOA 783 | Private 7 | Home Owners Association 16 | https://www.facebook.com/pg/missiontrailshoa/about/?ref=page_internal | Private 14 | 7032 | Mission Trails HOA 763 | Private 7 | Home Owners Association 15 | San Bernardino 22 | 2.938 | None 403 | ||||
6354 | 6354 | 6353 | {"type": "Polygon", "coordinates": [[[-117.29984, 33.64296], [-117.29987, 33.64297], [-117.3003, 33.64324], [-117.30036, 33.64329], [-117.3004, 33.64335], [-117.30041, 33.64343], [-117.30039, 33.6435], [-117.30033, 33.64356], [-117.3002, 33.64362], [-117.30005, 33.64361], [-117.29955, 33.64331], [-117.29954, 33.64328], [-117.29955, 33.64324], [-117.29979, 33.64298], [-117.29984, 33.64296]]]} | Restricted Access 2 | 48362 | Sunshine Park | 32927 | 7028 | Summerly Homes 188 | Private 7 | Home Owners Association 16 | http://summerlyhomes.com/explore/ | Private 14 | 7028 | Summerly Homes 184 | Private 7 | Home Owners Association 15 | http://summerlyhomes.com/explore/ | Riverside 10 | 0.866 | Sunshine Park | None 514 | ||
7386 | 7386 | 7385 | {"type": "Polygon", "coordinates": [[[-117.1774, 34.1103], [-117.17754, 34.11034], [-117.17763, 34.11043], [-117.17765, 34.11049], [-117.17764, 34.11055], [-117.17762, 34.11061], [-117.17757, 34.11066], [-117.17749, 34.1107], [-117.1774, 34.11072], [-117.17703, 34.11072], [-117.17696, 34.11066], [-117.17696, 34.11036], [-117.17703, 34.1103], [-117.1774, 34.1103]]]} | Restricted Access 2 | 48433 | Rose Court Play Area | 33135 | 7031 | East Highlands Ranch MHOA 861 | Private 7 | Home Owners Association 16 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | Private 14 | 7031 | East Highlands Ranch MHOA 839 | Private 7 | Home Owners Association 15 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | San Bernardino 22 | 0.64 | Rose Court Play Area | None 615 | ||
7395 | 7395 | 7394 | {"type": "Polygon", "coordinates": [[[-117.17059, 34.11122], [-117.17054, 34.11131], [-117.17047, 34.11137], [-117.17038, 34.1114], [-117.17029, 34.11142], [-117.17021, 34.11141], [-117.17011, 34.11137], [-117.17005, 34.11132], [-117.17, 34.11124], [-117.17006, 34.11117], [-117.17052, 34.11115], [-117.17059, 34.11122]]]} | Restricted Access 2 | 48435 | Palm View Park | 33136 | 7031 | East Highlands Ranch MHOA 861 | Private 7 | Home Owners Association 16 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | Private 14 | 7031 | East Highlands Ranch MHOA 839 | Private 7 | Home Owners Association 15 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | San Bernardino 22 | 0.29 | Palm View Park | None 616 | ||
7396 | 7396 | 7395 | {"type": "Polygon", "coordinates": [[[-117.16667, 34.11042], [-117.16688, 34.11042], [-117.16695, 34.11045], [-117.167, 34.1105], [-117.16704, 34.11056], [-117.16705, 34.11063], [-117.16703, 34.1107], [-117.16698, 34.11076], [-117.16686, 34.11082], [-117.16666, 34.11083], [-117.16656, 34.1108], [-117.16648, 34.11074], [-117.16643, 34.11064], [-117.16645, 34.11053], [-117.16654, 34.11045], [-117.16667, 34.11042]]]} | Restricted Access 2 | 48436 | Garden Grove Park | 33137 | 7031 | East Highlands Ranch MHOA 861 | Private 7 | Home Owners Association 16 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | Private 14 | 7031 | East Highlands Ranch MHOA 839 | Private 7 | Home Owners Association 15 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | San Bernardino 22 | 0.523 | Garden Grove Park | None 617 | ||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-117.31508, 33.26166], [-117.31432, 33.26259], [-117.31428, 33.26186], [-117.31404, 33.26172], [-117.31338, 33.26127], [-117.31266, 33.2613], [-117.31162, 33.26213], [-117.3132, 33.26337], [-117.31094, 33.26441], [-117.30968, 33.26347], [-117.30968, 33.26342], [-117.30855, 33.26259], [-117.30882, 33.2621], [-117.31085, 33.25891], [-117.31091, 33.25884], [-117.31117, 33.25856], [-117.31145, 33.25829], [-117.31228, 33.25764], [-117.31243, 33.25778], [-117.31258, 33.25767], [-117.31258, 33.25766], [-117.31243, 33.25752], [-117.3135, 33.25671], [-117.31355, 33.2567], [-117.31361, 33.25671], [-117.31372, 33.25681], [-117.31374, 33.25685], [-117.31373, 33.25691], [-117.31385, 33.25702], [-117.31403, 33.25689], [-117.3142, 33.25705], [-117.31396, 33.25708], [-117.31349, 33.26035], [-117.31401, 33.2604], [-117.31487, 33.26041], [-117.31508, 33.26166]]]} | No Public Access 3 | 47673 | Foss Lake Preserve | 31414 | 7016 | Foss Lake Conservation LP 877 | Private 7 | Mitigation Bank 29 | Private 14 | 7016 | Foss Lake Conservation LP 854 | Private 7 | Mitigation Bank 28 | San Diego 4 | 58.822 | Foss Lake Preserve | None 648 | ||||
10049 | 10049 | 10048 | {"type": "MultiPolygon", "coordinates": [[[[-117.26914, 33.02902], [-117.26913, 33.0296], [-117.26899, 33.02991], [-117.26909, 33.03022], [-117.26885, 33.03029], [-117.26858, 33.03041], [-117.26855, 33.0298], [-117.26856, 33.02948], [-117.26853, 33.02912], [-117.26808, 33.02913], [-117.26785, 33.02908], [-117.26768, 33.02914], [-117.26749, 33.02914], [-117.26738, 33.02924], [-117.26729, 33.02924], [-117.26718, 33.02911], [-117.26658, 33.02911], [-117.26658, 33.02901], [-117.26914, 33.02902]]], [[[-117.27508, 33.02965], [-117.27472, 33.03002], [-117.27367, 33.0309], [-117.27329, 33.03127], [-117.27321, 33.03137], [-117.27294, 33.03116], [-117.2722, 33.03112], [-117.27168, 33.03165], [-117.27127, 33.03162], [-117.271, 33.03162], [-117.27071, 33.03162], [-117.27045, 33.03165], [-117.27047, 33.03186], [-117.27026, 33.03188], [-117.26999, 33.03194], [-117.26886, 33.0323], [-117.26868, 33.03235], [-117.26842, 33.03169], [-117.26847, 33.03152], [-117.26853, 33.03152], [-117.26857, 33.03149], [-117.26863, 33.03154], [-117.26886, 33.03151], [-117.26888, 33.0314], [-117.26876, 33.03097], [-117.26869, 33.03054], [-117.26905, 33.0304], [-117.26924, 33.03035], [-117.26949, 33.03033], [-117.26952, 33.03055], [-117.27029, 33.03053], [-117.2716, 33.03039], [-117.27158, 33.03018], [-117.27179, 33.03015], [-117.27186, 33.03036], [-117.27204, 33.03032], [-117.27231, 33.03016], [-117.2725, 33.02996], [-117.27266, 33.02969], [-117.27314, 33.02973], [-117.27368, 33.02972], [-117.27382, 33.02962], [-117.2738, 33.02902], [-117.27506, 33.02901], [-117.27508, 33.02965]]]]} | Restricted Access 2 | 17378 | Park Place Open Space Preserve | 31476 | 7019 | Park Place Homeowners Association 942 | Private 7 | Home Owners Association 16 | http://parkplace.ebmcportals.net/ | Private 14 | 7019 | Park Place Homeowners Association 914 | Private 7 | Home Owners Association 15 | San Diego 4 | 24.41 | Park Place OSP | None 866 | |||
15241 | 15241 | 15240 | {"type": "Polygon", "coordinates": [[[-118.80402, 34.15821], [-118.80393, 34.1583], [-118.80387, 34.15842], [-118.80381, 34.15871], [-118.80377, 34.15881], [-118.80366, 34.15893], [-118.8035, 34.15902], [-118.80338, 34.15904], [-118.80325, 34.15905], [-118.80295, 34.15896], [-118.80283, 34.15895], [-118.80265, 34.15898], [-118.80239, 34.1591], [-118.80168, 34.15911], [-118.80137, 34.15909], [-118.7998, 34.1592], [-118.79979, 34.15928], [-118.79974, 34.15937], [-118.79964, 34.15932], [-118.79925, 34.15923], [-118.79916, 34.15926], [-118.79903, 34.15945], [-118.79877, 34.15969], [-118.79873, 34.15978], [-118.79858, 34.15987], [-118.79858, 34.15971], [-118.79856, 34.15966], [-118.79855, 34.15954], [-118.7986, 34.15944], [-118.79863, 34.15932], [-118.79853, 34.15919], [-118.79848, 34.15905], [-118.79692, 34.15895], [-118.79668, 34.15897], [-118.79662, 34.15895], [-118.79661, 34.15783], [-118.79666, 34.15777], [-118.79677, 34.15778], [-118.79707, 34.15702], [-118.7976, 34.15723], [-118.79816, 34.1574], [-118.79873, 34.15752], [-118.79932, 34.15758], [-118.79972, 34.15759], [-118.80012, 34.15757], [-118.80379, 34.15729], [-118.80389, 34.15823], [-118.80402, 34.15821]]]} | Open Access 1 | 46239 | Westlake Village Community Park and YMCA | 29517 | 6100 | Westlake Canyon Oaks Homeowners Association 1143 | Private 7 | Home Owners Association 16 | http://westlakecanyonoakshoa.com/ | Private 14 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?NID=378 | Los Angeles 6 | 30.797 | Westlake Village Community Park and YMCA | None 1338 | ||
15246 | 15246 | 15245 | {"type": "Polygon", "coordinates": [[[-117.84926, 34.08602], [-117.84835, 34.08657], [-117.84776, 34.08715], [-117.84678, 34.08702], [-117.8469, 34.08751], [-117.84639, 34.08764], [-117.84612, 34.0873], [-117.8453, 34.08752], [-117.84539, 34.08772], [-117.84528, 34.08799], [-117.84507, 34.08831], [-117.84442, 34.08851], [-117.84404, 34.08774], [-117.84443, 34.08765], [-117.84478, 34.08726], [-117.84618, 34.08684], [-117.84717, 34.08673], [-117.84857, 34.08591], [-117.84917, 34.08485], [-117.84905, 34.08586], [-117.84926, 34.08602]]]} | Open Access 1 | 46289 | Lyman Staging Area | 29581 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3DDMwNDfQLsh0VASikIj4!/ | Los Angeles 6 | 8.522 | Lyman Staging Area | None 1341 | |||
705 | 705 | 704 | {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} | Restricted Access 2 | 3955 | Lemongrass Park | 21155 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.759 | Lemongrass Park | 0 | Private Recreation or Education 65 | 4 | |
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} | Restricted Access 2 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
801 | 801 | 800 | {"type": "Polygon", "coordinates": [[[-117.96358, 33.88243], [-117.96358, 33.8825], [-117.96344, 33.88286], [-117.96216, 33.88253], [-117.96201, 33.8825], [-117.96195, 33.88252], [-117.96179, 33.88286], [-117.96169, 33.88291], [-117.96154, 33.8829], [-117.96146, 33.88298], [-117.9612, 33.8838], [-117.96112, 33.88384], [-117.9608, 33.88378], [-117.96076, 33.88375], [-117.96074, 33.8837], [-117.96106, 33.88283], [-117.96104, 33.8828], [-117.96086, 33.88272], [-117.96083, 33.88261], [-117.96097, 33.88214], [-117.96093, 33.88209], [-117.96088, 33.88205], [-117.95971, 33.88173], [-117.95964, 33.88171], [-117.95962, 33.88168], [-117.95968, 33.88149], [-117.95974, 33.88142], [-117.95979, 33.8814], [-117.96346, 33.88234], [-117.96354, 33.88238], [-117.96358, 33.88243]]]} | Restricted Access 2 | 5203 | McDermont Park | 22019 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 7.049 | McDermont Park | 0 | Private Recreation or Education 65 | 4 | |
840 | 840 | 839 | {"type": "Polygon", "coordinates": [[[-117.95755, 33.88747], [-117.95754, 33.88755], [-117.95748, 33.88761], [-117.95743, 33.88762], [-117.9565, 33.88761], [-117.95641, 33.88756], [-117.95633, 33.88746], [-117.95631, 33.88741], [-117.95629, 33.88728], [-117.9563, 33.88721], [-117.95632, 33.88719], [-117.9564, 33.88717], [-117.95751, 33.88743], [-117.95755, 33.88747]]]} | Restricted Access 2 | 4941 | Mackey Neighborhood Park | 21637 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 0.97 | Mackey Neighborhood Park | 0 | Private Recreation or Education 65 | 4 | |
1118 | 1118 | 1117 | {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} | Restricted Access 2 | 47585 | The Park at Petco Park | 31312 | 6117 | Petco Park Owner 322 | Private 7 | Commercial 20 | http://www.petcoparkinsider.com/park-at-the-park | Private 14 | 6117 | Petco Park Owner 319 | Private 7 | Commercial 18 | http://www.petcoparkinsider.com/park-at-the-park | San Diego 4 | 2.17 | The Park at Petco Park | 0 | Private Recreation or Education 65 | 4 |
1455 | 1455 | 1454 | {"type": "Polygon", "coordinates": [[[-117.96503, 33.88478], [-117.96434, 33.88483], [-117.96427, 33.88423], [-117.96499, 33.88417], [-117.96503, 33.88478]]]} | Restricted Access 2 | 9773 | Reiswig Park | 24286 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 1.084 | Reiswig Park | 0 | Private Recreation or Education 65 | 4 | |
1592 | 1592 | 1591 | {"type": "Polygon", "coordinates": [[[-117.78781, 33.67973], [-117.78686, 33.68064], [-117.78636, 33.68028], [-117.7873, 33.67937], [-117.78781, 33.67973]]]} | Restricted Access 2 | 12155 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.011 | Ashwood Park | 0 | Private Recreation or Education 65 | 4 | |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-117.81184, 33.66673], [-117.81155, 33.66748], [-117.81149, 33.66751], [-117.81146, 33.66746], [-117.81132, 33.66739], [-117.81062, 33.66726], [-117.81077, 33.66651], [-117.81184, 33.66673]]]} | Restricted Access 2 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook Park | 0 | Private Recreation or Education 65 | 4 | |
1607 | 1607 | 1606 | {"type": "Polygon", "coordinates": [[[-117.79116, 33.71292], [-117.79129, 33.71293], [-117.79145, 33.71298], [-117.79158, 33.71304], [-117.79169, 33.71312], [-117.79176, 33.71321], [-117.79182, 33.71332], [-117.79186, 33.71344], [-117.79186, 33.71356], [-117.79184, 33.71366], [-117.79179, 33.71378], [-117.79173, 33.71387], [-117.79161, 33.71397], [-117.79149, 33.71404], [-117.79138, 33.71409], [-117.79123, 33.71411], [-117.79109, 33.71412], [-117.79096, 33.7141], [-117.79082, 33.71405], [-117.79071, 33.714], [-117.79061, 33.71391], [-117.79052, 33.71381], [-117.79046, 33.7137], [-117.79043, 33.71357], [-117.79043, 33.71347], [-117.79046, 33.71335], [-117.79052, 33.71324], [-117.79058, 33.71315], [-117.79068, 33.71306], [-117.79081, 33.71299], [-117.79092, 33.71295], [-117.79116, 33.71292]]]} | Restricted Access 2 | 12278 | Colorado Park | 17543 | 6008 | Harvard Square Maintenance Association 393 | Private 7 | Home Owners Association 16 | http://www.progressivecm.com/harvardsquare/ | Private 14 | 6008 | Harvard Square Maintenance Association 387 | Private 7 | Home Owners Association 15 | Orange 3 | 3.401 | Colorado Park | 0 | Private Recreation or Education 65 | 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]);