superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
226 rows where LAYER = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Woodbridge Village Association 29
- Home Owners Association - Unknown Name 18
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Private Landowner 5
- 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
- Wildlands Inc 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- Oak Creek Village Maintenance Association 2
- Broadmoor Campus View Community Association 2
- MJM Management Group 2
- Big League Dreams 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Northpark Square Maintenance Association 2
- Woodbury Community Association 2
- Park Paseo Homeowners Association 2
- American Golf 2
- Petco Park Owner 1
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- …
MNG_AG_TYP 5
ACCESS_TYP 4
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1447 | 1447 | 1446 | {"type": "Polygon", "coordinates": [[[-117.81721, 33.65306], [-117.81715, 33.65322], [-117.81711, 33.65346], [-117.81628, 33.65352], [-117.81625, 33.65318], [-117.81665, 33.65315], [-117.81677, 33.65309], [-117.81721, 33.65306]]]} | Restricted Access 2 | HOA Community Park | 32224 | 6031 | Vista Community Association 1038 | Private 7 | Home Owners Association 15 | Private 14 | 0.832 | HOA Community Park | |||
12046 | 12046 | 12045 | {"type": "Polygon", "coordinates": [[[-117.0031, 32.62517], [-117.00301, 32.62553], [-117.00297, 32.62555], [-117.00229, 32.62541], [-117.00226, 32.62538], [-117.00235, 32.62501], [-117.00239, 32.62499], [-117.00308, 32.62513], [-117.0031, 32.62517]]]} | Restricted Access 2 | Orchard Park | 33354 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.846 | Orchard Park | |||
14041 | 14041 | 14040 | {"type": "Polygon", "coordinates": [[[-116.9567, 32.66503], [-116.95654, 32.66512], [-116.95638, 32.66517], [-116.95606, 32.66524], [-116.95601, 32.66487], [-116.95602, 32.66467], [-116.95616, 32.66437], [-116.95618, 32.66437], [-116.95629, 32.66455], [-116.95631, 32.66456], [-116.95642, 32.66473], [-116.95646, 32.66474], [-116.9567, 32.66503]]]} | Restricted Access 2 | Magnolia Hill Park | 33356 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.848 | Magnolia Hill Park | |||
13064 | 13064 | 13063 | {"type": "Polygon", "coordinates": [[[-116.99018, 32.63505], [-116.99014, 32.63512], [-116.98962, 32.63527], [-116.98954, 32.63523], [-116.98938, 32.63482], [-116.99002, 32.63464], [-116.99018, 32.63505]]]} | Restricted Access 2 | Alcala Park | 33366 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.849 | Alcala Park | |||
13028 | 13028 | 13027 | {"type": "Polygon", "coordinates": [[[-116.99842, 32.62091], [-116.9984, 32.62094], [-116.99795, 32.62104], [-116.99791, 32.62102], [-116.99774, 32.62046], [-116.99776, 32.62042], [-116.99821, 32.62033], [-116.99825, 32.62035], [-116.99842, 32.62091]]]} | Restricted Access 2 | Wisteria Park | 33350 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.857 | Wisteria Park | |||
13034 | 13034 | 13033 | {"type": "Polygon", "coordinates": [[[-116.98144, 32.61519], [-116.98142, 32.61521], [-116.9809, 32.61533], [-116.98087, 32.61531], [-116.98071, 32.6148], [-116.98073, 32.61478], [-116.98126, 32.61466], [-116.98128, 32.61468], [-116.98144, 32.61519]]]} | Restricted Access 2 | Mulberry Park | 33359 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.858 | Mulberry Park | |||
1264 | 1264 | 1263 | {"type": "Polygon", "coordinates": [[[-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], [-117.29988, 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]]]} | Restricted Access 2 | Sunshine Park | http://summerlyhomes.com/explore/ | 32927 | 7028 | Summerly Homes 184 | Private 7 | Home Owners Association 15 | http://summerlyhomes.com/explore/ | Private 14 | 0.866 | Sunshine Park | |
12320 | 12320 | 12319 | {"type": "MultiPolygon", "coordinates": [[[[-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.79241, 33.68938], [-117.79322, 33.68995], [-117.79325, 33.69]]], [[[-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.69038], [-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 | HOA Community Park | 32364 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 0.87 | HOA Community Park | ||
12338 | 12338 | 12337 | {"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.69695], [-117.79323, 33.69685], [-117.7933, 33.69679], [-117.79334, 33.69666], [-117.79299, 33.69636], [-117.79367, 33.69628]]]} | Restricted Access 2 | Woodrush Park | 32388 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 0.949 | Woodrush Park | ||
591 | 591 | 590 | {"type": "Polygon", "coordinates": [[[-117.96092, 33.88396], [-117.9602, 33.88594], [-117.96003, 33.88589], [-117.96075, 33.88391], [-117.96092, 33.88396]]]} | Restricted Access 2 | Burdorf Park | 16516 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | http://www.amerigeheights.org/ | Private 14 | 0.954 | Burdorf Park | ||
6500 | 6500 | 6499 | {"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 | Mackey Neighborhood Park | 21637 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | http://www.amerigeheights.org/ | Private 14 | 0.97 | Mackey Neighborhood Park | ||
12340 | 12340 | 12339 | {"type": "Polygon", "coordinates": [[[-117.79882, 33.68189], [-117.7987, 33.68209], [-117.79851, 33.68228], [-117.79844, 33.68228], [-117.79798, 33.68197], [-117.79784, 33.68182], [-117.7983, 33.68154], [-117.79882, 33.68189]]]} | Restricted Access 2 | Springvale Park | 32390 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.993 | Springvale Park | ||
12336 | 12336 | 12335 | {"type": "Polygon", "coordinates": [[[-117.79819, 33.68454], [-117.79776, 33.68497], [-117.79759, 33.68481], [-117.79737, 33.68467], [-117.79719, 33.68459], [-117.7975, 33.68427], [-117.79758, 33.68423], [-117.79763, 33.68416], [-117.79819, 33.68454]]]} | Restricted Access 2 | Arbor Park | 32386 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.002 | Arbor Park | ||
13356 | 13356 | 13355 | {"type": "Polygon", "coordinates": [[[-117.67538, 33.65539], [-117.67533, 33.65576], [-117.67474, 33.65577], [-117.67473, 33.65562], [-117.67443, 33.65555], [-117.67445, 33.6555], [-117.67473, 33.65554], [-117.67473, 33.65508], [-117.67517, 33.65514], [-117.67538, 33.65539]]]} | Restricted Access 2 | HOA Community Park | 32367 | 6045 | Meadowood Community Association 1031 | Private 7 | Home Owners Association 15 | Private 14 | 1.017 | HOA Community Park | |||
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.82281, 33.64763], [-117.82244, 33.64779], [-117.82239, 33.64787], [-117.82225, 33.64791], [-117.82208, 33.64809], [-117.82193, 33.64822], [-117.82178, 33.64802], [-117.82131, 33.64815], [-117.82078, 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 | HOA Community Park | 32337 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Private 14 | 1.027 | HOA Community Park | |||
9855 | 9855 | 9854 | {"type": "Polygon", "coordinates": [[[-117.79238, 33.66725], [-117.79237, 33.66731], [-117.79218, 33.66751], [-117.79216, 33.6676], [-117.79219, 33.66769], [-117.79215, 33.66773], [-117.79143, 33.66723], [-117.7918, 33.66686], [-117.792, 33.667], [-117.79215, 33.66702], [-117.7922, 33.66712], [-117.79238, 33.66725]]]} | Restricted Access 2 | Springbrook Park | 25745 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.033 | Springbrook Park | ||
1265 | 1265 | 1264 | {"type": "Polygon", "coordinates": [[[-117.29977, 33.64866], [-117.29973, 33.64878], [-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], [-117.29964, 33.64847], [-117.29974, 33.64855], [-117.29977, 33.64866]]]} | Restricted Access 2 | Spirit Park | http://summerlyhomes.com/explore/ | 32928 | 7028 | Summerly Homes 184 | Private 7 | Home Owners Association 15 | http://summerlyhomes.com/explore/ | Private 14 | 1.063 | Spirit Park | |
2074 | 2074 | 2073 | {"type": "Polygon", "coordinates": [[[-117.80159, 33.68926], [-117.80114, 33.68972], [-117.80084, 33.68974], [-117.80076, 33.68915], [-117.80078, 33.68909], [-117.80112, 33.68894], [-117.80159, 33.68926]]]} | Restricted Access 2 | Blue Jay Park | 16177 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.076 | Blue Jay Park | ||
8553 | 8553 | 8552 | {"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 | Reiswig Park | 24286 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | http://www.amerigeheights.org/ | Private 14 | 1.083 | Reiswig Park | ||
12339 | 12339 | 12338 | {"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.79329, 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 | Deer Spring Park | 32389 | 6006 | Deerfield Community Association 656 | Private 7 | Home Owners Association 15 | http://www.accellpmassoc.com/Deerfield/ | Private 14 | 1.168 | Deer Spring Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);