units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
194 rows where ACCESS_TYP = 2 and DES_TP = 65 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV, COUNTY
MNG_AGENCY >30
- Woodbridge Village Association 30
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- 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
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community Association 2
- Mountains Restoration Trust 2
- Truckee Donner Land Trust 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
- Petco Park Owner 1
- Arroyos and Foothills Conservancy 1
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- Friends of the Dunes 1
- Turtle Rock Ridge Association 1
- Parkside Community Association 1
- Wagon Wheel Canyon Community Association 1
- …
MNG_AG_TYP 7
DES_TP 1
- Private Recreation or Education · 194 ✖
ACCESS_TYP 1
- Restricted Access · 194 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1490 | 1490 | 1489 | {"type": "Polygon", "coordinates": [[[-117.68588, 34.45141], [-117.68154, 34.45142], [-117.68152, 34.44779], [-117.68587, 34.4478], [-117.68588, 34.45141]]]} | Restricted Access 2 | 12700 | Antelope Valley Open Space | 29491 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 39.642 | Antelope Valley OS | 0 | Private Recreation or Education 65 | 4 | |
5405 | 5405 | 5404 | {"type": "MultiPolygon", "coordinates": [[[[-118.80651, 34.10388], [-118.80206, 34.10385], [-118.80208, 34.1003], [-118.80389, 34.10029], [-118.80386, 34.10035], [-118.8038, 34.10034], [-118.80373, 34.10046], [-118.80366, 34.10048], [-118.80356, 34.10055], [-118.80348, 34.10068], [-118.80348, 34.10081], [-118.80355, 34.10093], [-118.80369, 34.10102], [-118.80381, 34.10105], [-118.80395, 34.10104], [-118.80408, 34.10098], [-118.80413, 34.10093], [-118.80433, 34.10065], [-118.80438, 34.1006], [-118.80463, 34.1005], [-118.80488, 34.10029], [-118.8065, 34.10029], [-118.80651, 34.10388]]], [[[-118.80415, 34.10058], [-118.80398, 34.10082], [-118.80393, 34.10087], [-118.80386, 34.10089], [-118.80378, 34.10088], [-118.8037, 34.10083], [-118.80368, 34.10079], [-118.80368, 34.1007], [-118.80374, 34.10063], [-118.80384, 34.10061], [-118.80403, 34.10062], [-118.80415, 34.10058]]]]} | Restricted Access 2 | 12497 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 38.733 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16969 | 16969 | 16968 | {"type": "Polygon", "coordinates": [[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62367, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]]} | Restricted Access 2 | 12501 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.053 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
15724 | 15724 | 15723 | {"type": "Polygon", "coordinates": [[[-120.15979, 39.35605], [-120.15917, 39.35687], [-120.15867, 39.35761], [-120.15837, 39.35812], [-120.15809, 39.35864], [-120.15766, 39.35956], [-120.15084, 39.35953], [-120.14169, 39.35945], [-120.1417, 39.35904], [-120.14249, 39.35866], [-120.1432, 39.35835], [-120.14388, 39.35799], [-120.14467, 39.3575], [-120.14541, 39.35696], [-120.14578, 39.35665], [-120.1489, 39.35367], [-120.15846, 39.34589], [-120.15693, 39.3498], [-120.15755, 39.3498], [-120.15794, 39.34996], [-120.15825, 39.35026], [-120.15839, 39.35056], [-120.15794, 39.3547], [-120.15803, 39.35493], [-120.15833, 39.3553], [-120.15979, 39.35605]]]} | Restricted Access 2 | 44736 | Old Greenwood Golf Course | 33108 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 258.402 | Old Greenwood GC | 0 | Private Recreation or Education 65 | 4 | |
15725 | 15725 | 15724 | {"type": "MultiPolygon", "coordinates": [[[[-120.16777, 39.32371], [-120.16732, 39.32424], [-120.16563, 39.32376], [-120.16561, 39.32386], [-120.16581, 39.3241], [-120.16572, 39.32418], [-120.1656, 39.32411], [-120.16508, 39.32443], [-120.16493, 39.32458], [-120.16286, 39.32477], [-120.16153, 39.32476], [-120.16136, 39.32504], [-120.16135, 39.32548], [-120.16125, 39.32555], [-120.16113, 39.32561], [-120.161, 39.32564], [-120.16081, 39.32566], [-120.16081, 39.32247], [-120.16499, 39.32236], [-120.16777, 39.32371]]], [[[-120.17072, 39.32608], [-120.17051, 39.32637], [-120.17011, 39.32617], [-120.1701, 39.32604], [-120.16081, 39.32611], [-120.16081, 39.32583], [-120.1611, 39.3258], [-120.16131, 39.32572], [-120.16138, 39.32581], [-120.16245, 39.32571], [-120.16317, 39.32559], [-120.1645, 39.32524], [-120.16475, 39.32561], [-120.16713, 39.325], [-120.16742, 39.32482], [-120.16718, 39.32458], [-120.16732, 39.32449], [-120.16745, 39.32437], [-120.16794, 39.32379], [-120.17013, 39.32486], [-120.17072, 39.32608]]]]} | Restricted Access 2 | 44739 | Ponderosa Golf Course | 33109 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 52.893 | Ponderosa GC | 0 | Private Recreation or Education 65 | 4 | |
3318 | 3318 | 3317 | {"type": "Polygon", "coordinates": [[[-124.16888, 40.85809], [-124.16824, 40.85924], [-124.16227, 40.85914], [-124.16173, 40.85708], [-124.16234, 40.85708], [-124.16253, 40.8578], [-124.16325, 40.85769], [-124.16427, 40.85767], [-124.16438, 40.85809], [-124.16888, 40.85809]]]} | Restricted Access 2 | 29680 | Humboldt Coastal Nature Center | 20144 | 3127 | Friends of the Dunes 617 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofthedunes.org/ | Non Governmental Organization 10 | 3127 | Friends of the Dunes 606 | Non Profit 6 | Non Profit - Conservation 12 | Humboldt 45 | 19.441 | Humboldt Coastal Nature Ctr. | 0 | Private Recreation or Education 65 | 4 | |
5753 | 5753 | 5752 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | 3683 | Kingsburg Historical Park | 32675 | 3138 | Kingsburg Historical Society 817 | Non Profit 6 | Non Profit - Other 22 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://kingsburghistoricalpark.org/ | Fresno 9 | 4.887 | Kingsburg Historical Park | 0 | Private Recreation or Education 65 | 4 |
3843 | 3843 | 3842 | {"type": "Polygon", "coordinates": [[[-117.82217, 33.64995], [-117.82193, 33.64998], [-117.82124, 33.65], [-117.82125, 33.6497], [-117.8212, 33.64969], [-117.82123, 33.64946], [-117.8212, 33.64942], [-117.82123, 33.6492], [-117.82123, 33.64892], [-117.82118, 33.64891], [-117.82121, 33.64871], [-117.82121, 33.64864], [-117.82141, 33.64862], [-117.82155, 33.64859], [-117.82174, 33.64887], [-117.82151, 33.649], [-117.82152, 33.64906], [-117.82168, 33.64925], [-117.82175, 33.64926], [-117.82188, 33.64941], [-117.82183, 33.64946], [-117.82217, 33.64995]]]} | Restricted Access 2 | 35490 | Paseo Park | 32335 | 6001 | Broadmoor Campus View Community Association 691 | Private 7 | Home Owners Association 16 | Private 14 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Orange 3 | 2.01 | Paseo Park | 0 | Private Recreation or Education 65 | 4 | ||
14798 | 14798 | 14797 | {"type": "Polygon", "coordinates": [[[-117.82281, 33.64763], [-117.82244, 33.64779], [-117.82239, 33.64787], [-117.82226, 33.6479], [-117.82208, 33.64809], [-117.82193, 33.64822], [-117.82179, 33.64802], [-117.82131, 33.64815], [-117.82077, 33.64819], [-117.82075, 33.6484], [-117.82014, 33.64812], [-117.81988, 33.64803], [-117.81985, 33.64799], [-117.81986, 33.64794], [-117.82032, 33.64809], [-117.82039, 33.6481], [-117.82078, 33.64809], [-117.82113, 33.64806], [-117.82148, 33.648], [-117.82195, 33.64788], [-117.8223, 33.64776], [-117.82276, 33.64756], [-117.82281, 33.64763]]]} | Restricted Access 2 | 47981 | HOA Community Park | 32337 | 6001 | Broadmoor Campus View Community Association 691 | Private 7 | Home Owners Association 16 | Private 14 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Orange 3 | 1.023 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
14127 | 14127 | 14126 | {"type": "Polygon", "coordinates": [[[-117.75409, 33.72128], [-117.75404, 33.72147], [-117.75388, 33.72142], [-117.7531, 33.72153], [-117.75267, 33.72164], [-117.75228, 33.72157], [-117.75231, 33.72142], [-117.75246, 33.72142], [-117.75253, 33.72139], [-117.75258, 33.72133], [-117.7527, 33.72104], [-117.75279, 33.72089], [-117.75298, 33.72067], [-117.75324, 33.72082], [-117.75332, 33.72092], [-117.75356, 33.72104], [-117.75365, 33.72099], [-117.75373, 33.72104], [-117.75372, 33.72113], [-117.75396, 33.72125], [-117.75409, 33.72128]]]} | Restricted Access 2 | 43029 | HOA Community Park | 31872 | 6002 | Canyon Creek Homeowners Association 1074 | Private 7 | Home Owners Association 16 | http://www.canyoncreekhomeowners.com/ | Private 14 | 6002 | Canyon Creek Homeowners Association 1030 | Private 7 | Home Owners Association 15 | Orange 3 | 2.164 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | |
13442 | 13442 | 13441 | {"type": "Polygon", "coordinates": [[[-117.79103, 33.71118], [-117.79089, 33.71133], [-117.78842, 33.71195], [-117.7883, 33.71185], [-117.78831, 33.71182], [-117.78964, 33.71049], [-117.78969, 33.7105], [-117.79087, 33.71132], [-117.79102, 33.71117], [-117.79103, 33.71118]]]} | Restricted Access 2 | 35617 | Colony Park | 32256 | 6003 | Colony Club Community Association 1055 | Private 7 | Home Owners Association 16 | http://www.colonyirvine.com/ | Private 14 | 6003 | Colony Club Community Association 1014 | Private 7 | Home Owners Association 15 | Orange 3 | 4.08 | Colony Park | 0 | Private Recreation or Education 65 | 4 | |
14143 | 14143 | 14142 | {"type": "Polygon", "coordinates": [[[-117.76932, 33.72264], [-117.76906, 33.72289], [-117.76853, 33.72254], [-117.76869, 33.72237], [-117.76868, 33.72231], [-117.7688, 33.72228], [-117.76932, 33.72264]]]} | Restricted Access 2 | 43037 | HOA Community Park | 32339 | 6004 | Crestwood Estates Homeowners Association 1078 | Private 7 | Home Owners Association 16 | Private 14 | 6004 | Crestwood Estates Homeowners Association 1034 | Private 7 | Home Owners Association 15 | Orange 3 | 0.594 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
13723 | 13723 | 13722 | {"type": "Polygon", "coordinates": [[[-117.82529, 33.67215], [-117.8251, 33.67255], [-117.82503, 33.67255], [-117.82494, 33.67261], [-117.82493, 33.67271], [-117.82497, 33.67277], [-117.8247, 33.67331], [-117.8246, 33.67328], [-117.82449, 33.67349], [-117.82452, 33.67353], [-117.82445, 33.67361], [-117.82445, 33.67369], [-117.82438, 33.6737], [-117.82418, 33.67412], [-117.82366, 33.67394], [-117.82386, 33.67353], [-117.82384, 33.67349], [-117.8239, 33.67347], [-117.82394, 33.67342], [-117.82394, 33.67337], [-117.82392, 33.67333], [-117.82396, 33.67331], [-117.82406, 33.67311], [-117.82394, 33.67305], [-117.82417, 33.67256], [-117.82428, 33.67258], [-117.82434, 33.67254], [-117.82438, 33.6725], [-117.82439, 33.67243], [-117.82436, 33.67239], [-117.82445, 33.67236], [-117.82461, 33.67194], [-117.82529, 33.67215]]]} | Restricted Access 2 | 36165 | WestPark Village One Association Park | 31985 | 6005 | Culverdale Community Association 1066 | Private 7 | Home Owners Association 16 | http://www.westparkvillageone.org/ | Private 14 | 6005 | Culverdale Community Association 1024 | Private 7 | Home Owners Association 15 | Orange 3 | 3.686 | WestPark Village One Association Park | 0 | Private Recreation or Education 65 | 4 | |
3645 | 3645 | 3644 | {"type": "Polygon", "coordinates": [[[-117.79483, 33.69375], [-117.79469, 33.69392], [-117.79427, 33.6937], [-117.79404, 33.69368], [-117.79394, 33.69373], [-117.79388, 33.69369], [-117.79382, 33.69366], [-117.7934, 33.69365], [-117.79317, 33.69361], [-117.79308, 33.69363], [-117.79302, 33.69354], [-117.79273, 33.69351], [-117.79275, 33.69331], [-117.79295, 33.69313], [-117.7933, 33.69336], [-117.79337, 33.6933], [-117.79342, 33.69335], [-117.79353, 33.69337], [-117.79356, 33.69347], [-117.79397, 33.69357], [-117.79436, 33.69362], [-117.79461, 33.69359], [-117.79483, 33.69375]]]} | Restricted Access 2 | 43072 | Deer Spring Park | 32389 | 6006 | Deerfield Community Association 668 | Private 7 | Home Owners Association 16 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | Orange 3 | 1.165 | Deer Spring Park | 0 | Private Recreation or Education 65 | 4 | |
13460 | 13460 | 13459 | {"type": "Polygon", "coordinates": [[[-117.78998, 33.69383], [-117.7898, 33.69401], [-117.78983, 33.69409], [-117.78978, 33.69412], [-117.78975, 33.69417], [-117.78965, 33.69415], [-117.7893, 33.69452], [-117.78931, 33.69466], [-117.78927, 33.69474], [-117.78918, 33.69474], [-117.78902, 33.69491], [-117.78915, 33.69501], [-117.78885, 33.69531], [-117.7882, 33.69485], [-117.7885, 33.69455], [-117.78863, 33.69463], [-117.78881, 33.69445], [-117.7889, 33.69444], [-117.78897, 33.69438], [-117.78909, 33.69436], [-117.78927, 33.69419], [-117.78926, 33.69418], [-117.78941, 33.69403], [-117.78939, 33.6939], [-117.78943, 33.69387], [-117.78945, 33.69383], [-117.78954, 33.69384], [-117.78973, 33.69365], [-117.78998, 33.69383]]]} | Restricted Access 2 | 35677 | Rock Springs Park | 32305 | 6006 | Deerfield Community Association 668 | Private 7 | Home Owners Association 16 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | Orange 3 | 2.158 | Rock Springs Park | 0 | Private Recreation or Education 65 | 4 | |
13717 | 13717 | 13716 | {"type": "Polygon", "coordinates": [[[-117.79367, 33.69628], [-117.7937, 33.69669], [-117.7937, 33.69681], [-117.79363, 33.69698], [-117.79351, 33.69709], [-117.79334, 33.69718], [-117.79322, 33.69721], [-117.79305, 33.69722], [-117.79334, 33.69694], [-117.79323, 33.69685], [-117.7933, 33.69679], [-117.79335, 33.69665], [-117.79299, 33.69636], [-117.79367, 33.69628]]]} | Restricted Access 2 | 36124 | Woodrush Park | 32388 | 6006 | Deerfield Community Association 668 | Private 7 | Home Owners Association 16 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | Orange 3 | 0.945 | Woodrush Park | 0 | Private Recreation or Education 65 | 4 | |
14128 | 14128 | 14127 | {"type": "MultiPolygon", "coordinates": [[[[-117.79247, 33.68943], [-117.79241, 33.68938], [-117.79322, 33.68995], [-117.79325, 33.69], [-117.79323, 33.69005], [-117.79314, 33.69012], [-117.79307, 33.69009], [-117.79292, 33.68997], [-117.7926, 33.68956], [-117.79247, 33.68943]]], [[[-117.79541, 33.6918], [-117.79505, 33.69157], [-117.79489, 33.69143], [-117.79474, 33.69128], [-117.79454, 33.691], [-117.79433, 33.69082], [-117.79413, 33.69069], [-117.79348, 33.69037], [-117.79338, 33.6903], [-117.79339, 33.69026], [-117.79348, 33.69018], [-117.79356, 33.69018], [-117.79399, 33.6905], [-117.7944, 33.69083], [-117.79472, 33.69112], [-117.79541, 33.6918]]]]} | Restricted Access 2 | 43032 | HOA Community Park | 32364 | 6006 | Deerfield Community Association 668 | Private 7 | Home Owners Association 16 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | Orange 3 | 0.868 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | |
13449 | 13449 | 13448 | {"type": "Polygon", "coordinates": [[[-117.78838, 33.69919], [-117.78817, 33.6994], [-117.78814, 33.69939], [-117.78729, 33.70025], [-117.78751, 33.70042], [-117.7871, 33.70083], [-117.78706, 33.70081], [-117.78639, 33.70148], [-117.78633, 33.70145], [-117.78593, 33.70186], [-117.78583, 33.70171], [-117.78575, 33.70167], [-117.78565, 33.70168], [-117.78559, 33.70175], [-117.7856, 33.70184], [-117.78515, 33.70228], [-117.78482, 33.70205], [-117.78527, 33.7016], [-117.78536, 33.7016], [-117.78542, 33.70157], [-117.78544, 33.70151], [-117.78543, 33.70144], [-117.78539, 33.70139], [-117.78532, 33.70136], [-117.78567, 33.701], [-117.78564, 33.70096], [-117.78631, 33.70029], [-117.78634, 33.7003], [-117.78654, 33.7001], [-117.78657, 33.70011], [-117.78677, 33.69991], [-117.78714, 33.70016], [-117.78779, 33.69951], [-117.78777, 33.69948], [-117.78819, 33.69906], [-117.78838, 33.69919]]]} | Restricted Access 2 | 35658 | HOA Community Park | 31966 | 6007 | Greentree Homes Association 1057 | Private 7 | Home Owners Association 16 | http://www.progressivecm.com/greentree/ | Private 14 | 6007 | Greentree Homes Association 1016 | Private 7 | Home Owners Association 15 | Orange 3 | 6.096 | HOA Community 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 | |
14155 | 14155 | 14154 | {"type": "Polygon", "coordinates": [[[-117.77552, 33.69751], [-117.77551, 33.69754], [-117.77545, 33.69761], [-117.7753, 33.69773], [-117.77491, 33.69792], [-117.77485, 33.698], [-117.77484, 33.6981], [-117.77487, 33.69816], [-117.77481, 33.69819], [-117.77475, 33.69812], [-117.77464, 33.69816], [-117.7742, 33.69747], [-117.77466, 33.69699], [-117.77457, 33.69692], [-117.77462, 33.69687], [-117.77548, 33.69747], [-117.77552, 33.69751]]]} | Restricted Access 2 | 43049 | HOA Community Park | 32387 | 6009 | Heritage Park Community Association 1087 | Private 7 | Home Owners Association 16 | http://www.hpoa.biz/ | Private 14 | 6009 | Heritage Park Community Association 1043 | Private 7 | Home Owners Association 15 | Orange 3 | 2.166 | HOA Community 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]);