units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
203 rows where MNG_AG_TYP = 15 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, ACRES, LABEL_NAME, GAP_STS
MNG_AGENCY 89
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Amerige Heights Community Association 7
- 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
- Quail Hill Community Association 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- Oak Creek Village Maintenance Association 2
- Broadmoor Campus View Community Association 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- Park Paseo Homeowners Association 2
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- Turtle Rock Ridge Association 1
- Parkside Community Association 1
- Wagon Wheel Canyon Community Association 1
- L F Maintenance Corporation 1
- Serrano Park Community Association 1
- Trailwood Maintenance Association 1
- Los Ranchos Community Association 1
- Paseo del Sol Master Association 1
- Mission Trails HOA 1
- Briarcliff Homeowners Association 1
- Harlan Ranch Community Association 1
- Westridge Homeowners Association 1
- Del Webb 1
- Lincoln Village Home Association 1
- Marcella Renaissance Owners Association 1
- Portola Valley Ranch Home Owners Association 1
- Lakeshore Homes Association 1
- Sun City Lincoln Hills Community Association 1
- Comstock South LLC 1
- Hilltop LLC 1
- Bixby Village Home Owner Association 1
- Park Place Homeowners Association 1
- Rice Ranch Ventures LLC 1
- Summit at Turtle Ridge Community Association 1
- Park Fort Washington Association 1
- Kelsey Lane Maintenance Association 1
- Woodside-Irvine Homeowners Association 1
- Village Park Community Association 1
- Colony Club Community Association 1
- Greentree Homes Association 1
- Turtle Rock Glen Community Association 1
- Palm Gardens Community Association 1
- Jasmine Creek Community Association 1
- Briosa Owners Association 1
- Culverdale Community Association 1
- Canyon Creek Homeowners Association 1
- Meadowood Community Association 1
- Laguna Village Owners Association Inc 1
- Newport Ridge North Maintenance Association 1
- Crestwood Estates Homeowners Association 1
- Moulton Ranch III Homeowners Association 1
- University Community Association 1
- Lake Mission Viejo Association 1
- Vista Community Association 1
- Golden Rain Foundation of Laguna Woods 1
- Eastbluff Homeowners Community Association 1
- Lido Isle Community Association 1
- Crystal Cove Community Association 1
- Heritage Park Community Association 1
- Lake Forest Drive Association 1
- Broadmoor Sea View Community Association 1
- Canyon Estates Homeowners Association 1
- Pinecrest Community Association 1
- Bonita Canyon Maintenance Association 1
- Newport Coast Community Association 1
- Painted Trails Community Association 1
- Sun Ridge Community Association 1
- Shady Canyon Community Association 1
- Green Valley Homeowners Recreation Association 1
- Arroyo Maintenance Corporation 1
- Laguna Niguel Rolling Hills Community Association 1
- Paloma del Sol Homeowners Association 1
- Winchester Owners Association 1
- CZ Master Association 1
DES_TP 9
- Private Recreation or Education 185
- Private Conservation 11
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Home Owners Association · 203 ✖
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 | ||
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 | |||
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 | |
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 | |
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 | |
1646 | 1646 | 1645 | {"type": "Polygon", "coordinates": [[[-117.81063, 33.67059], [-117.81046, 33.67171], [-117.80973, 33.67181], [-117.80991, 33.67052], [-117.81063, 33.67059]]]} | Restricted Access 2 | 12487 | Meadow Park | 22076 | 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.231 | Meadow Park | 0 | Private Recreation or Education 65 | 4 | |
1665 | 1665 | 1664 | {"type": "Polygon", "coordinates": [[[-117.78817, 33.666], [-117.78729, 33.66687], [-117.78636, 33.66624], [-117.78725, 33.66535], [-117.78817, 33.666]]]} | Restricted Access 2 | 12583 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 3.524 | Royal Oak Park | 0 | Private Recreation or Education 65 | 4 | ||
1680 | 1680 | 1679 | {"type": "Polygon", "coordinates": [[[-117.81746, 33.6734], [-117.81707, 33.67379], [-117.81593, 33.67299], [-117.8157, 33.67287], [-117.81568, 33.67285], [-117.81568, 33.67278], [-117.81649, 33.67272], [-117.81746, 33.6734]]]} | Restricted Access 2 | 12685 | Timber Run Park | 26369 | 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.05 | Timber Run Park | 0 | Private Recreation or Education 65 | 4 | |
1690 | 1690 | 1689 | {"type": "Polygon", "coordinates": [[[-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293], [-117.77074, 33.643], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.6436], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64305], [-117.76951, 33.64304], [-117.7695, 33.643]]]} | Restricted Access 2 | 12733 | Valley View Park | 26809 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 2.461 | Valley View Park | 0 | Private Recreation or Education 65 | 4 | |
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | 12755 | Wildwood Park | 27526 | 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.939 | Wildwood 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]);