superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
200 rows where MNG_AG_TYP = 15 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
MNG_AGENCY >30
- Woodbridge Village Association 31
- 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
- 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
- …
ACCESS_TYP 2
MNG_AG_TYP 1
- Home Owners Association · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14373 | 14373 | 14372 | {"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.05429], [-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.23703, 34.04703], [-117.23706, 34.04698], [-117.23708, 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 | Unnamed Park - Mission Trails HOA | 33179 | 7032 | Mission Trails HOA 763 | Private 7 | Home Owners Association 15 | https://www.facebook.com/pg/missiontrailshoa/about/?ref=page_internal | Private 14 | 2.938 | |||
13766 | 13766 | 13765 | {"type": "Polygon", "coordinates": [[[-121.24324, 37.83763], [-121.24319, 37.83766], [-121.24315, 37.83772], [-121.24315, 37.83793], [-121.24308, 37.83812], [-121.24299, 37.83831], [-121.24285, 37.83848], [-121.24261, 37.83871], [-121.24241, 37.83883], [-121.24207, 37.83897], [-121.24171, 37.83906], [-121.24133, 37.83908], [-121.24108, 37.83906], [-121.24072, 37.83897], [-121.24039, 37.83883], [-121.2401, 37.83863], [-121.23987, 37.83839], [-121.23976, 37.83821], [-121.23968, 37.83802], [-121.23965, 37.8379], [-121.23966, 37.8378], [-121.23969, 37.83779], [-121.23969, 37.83771], [-121.23966, 37.83766], [-121.23958, 37.8376], [-121.23959, 37.83758], [-121.24321, 37.83759], [-121.24324, 37.83763]]]} | Restricted Access 2 | Liberty Park | 31274 | 6116 | Del Webb 825 | Private 7 | Home Owners Association 15 | https://www.delwebb.com | Private 14 | 10.142 | Liberty Park | ||
14404 | 14404 | 14403 | {"type": "Polygon", "coordinates": [[[-116.9052, 33.74329], [-116.90501, 33.7433], [-116.905, 33.74348], [-116.90478, 33.74342], [-116.90428, 33.74342], [-116.90426, 33.74343], [-116.90382, 33.74341], [-116.9038, 33.74359], [-116.90363, 33.74359], [-116.90362, 33.74341], [-116.9023, 33.74342], [-116.90203, 33.74347], [-116.90203, 33.74298], [-116.90225, 33.74307], [-116.90248, 33.74307], [-116.90266, 33.74299], [-116.90283, 33.74306], [-116.90306, 33.74306], [-116.90324, 33.74299], [-116.90342, 33.74306], [-116.90364, 33.74306], [-116.90383, 33.74298], [-116.90401, 33.74306], [-116.90423, 33.74306], [-116.90442, 33.74298], [-116.90459, 33.74306], [-116.90482, 33.74305], [-116.905, 33.74298], [-116.90501, 33.74326], [-116.9052, 33.74326], [-116.9052, 33.74329]]]} | Restricted Access 2 | Unknown park - Briarcliff Homeowners Association | 33654 | 6137 | Briarcliff Homeowners Association 792 | Private 7 | Home Owners Association 15 | https://www.briarcliff.org/ | Private 14 | 3.012 | |||
344 | 344 | 343 | {"type": "Polygon", "coordinates": [[[-117.83408, 33.651], [-117.83362, 33.651], [-117.83331, 33.65102], [-117.83307, 33.64997], [-117.83264, 33.6497], [-117.83288, 33.64942], [-117.83293, 33.6494], [-117.83317, 33.64923], [-117.8334, 33.64915], [-117.83344, 33.64971], [-117.83354, 33.64988], [-117.83368, 33.64988], [-117.83376, 33.64984], [-117.83397, 33.64984], [-117.83398, 33.65004], [-117.83404, 33.65009], [-117.83408, 33.651]]]} | Restricted Access 2 | Cornell Commons Park | 31960 | 6024 | Town Center Association 1021 | Private 7 | Home Owners Association 15 | https://towncenterhoa.org/ | Private 14 | 3.538 | Cornell Commons Park | ||
1480 | 1480 | 1479 | {"type": "Polygon", "coordinates": [[[-117.84324, 33.65578], [-117.84284, 33.65609], [-117.84263, 33.65654], [-117.84197, 33.65673], [-117.84155, 33.65621], [-117.84168, 33.65594], [-117.84179, 33.65597], [-117.8419, 33.65597], [-117.84197, 33.65594], [-117.84206, 33.65586], [-117.84211, 33.65566], [-117.84219, 33.65547], [-117.84324, 33.65578]]]} | Restricted Access 2 | Princeton Park | 32226 | 6024 | Town Center Association 1021 | Private 7 | Home Owners Association 15 | https://towncenterhoa.org/ | Private 14 | 2.814 | Princeton Park | ||
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-117.84345, 33.65432], [-117.8429, 33.65483], [-117.84252, 33.65469], [-117.84249, 33.65462], [-117.84244, 33.65456], [-117.84225, 33.65444], [-117.842, 33.65425], [-117.8419, 33.65414], [-117.84175, 33.65389], [-117.84252, 33.65359], [-117.84271, 33.6537], [-117.84345, 33.65432]]]} | Restricted Access 2 | Stanford Park | 32362 | 6024 | Town Center Association 1021 | Private 7 | Home Owners Association 15 | https://towncenterhoa.org/ | Private 14 | 2.85 | Stanford Park | ||
6993 | 6993 | 6992 | {"type": "Polygon", "coordinates": [[[-117.82983, 33.65173], [-117.8298, 33.65175], [-117.82974, 33.65173], [-117.82967, 33.65173], [-117.82944, 33.65181], [-117.82863, 33.65198], [-117.8286, 33.652], [-117.82833, 33.65114], [-117.82954, 33.65086], [-117.82956, 33.65092], [-117.82962, 33.65099], [-117.82968, 33.65102], [-117.82979, 33.65103], [-117.8298, 33.65165], [-117.82983, 33.65173]]]} | Restricted Access 2 | Columbia Court Park | 32341 | 6024 | Town Center Association 1021 | Private 7 | Home Owners Association 15 | https://towncenterhoa.org/ | Private 14 | 3.002 | Columbia Court Park | ||
8672 | 8672 | 8671 | {"type": "Polygon", "coordinates": [[[-121.2702, 38.87251], [-121.27019, 38.87295], [-121.27017, 38.87318], [-121.27014, 38.87322], [-121.27008, 38.87325], [-121.26912, 38.87324], [-121.26904, 38.8732], [-121.26902, 38.87311], [-121.26902, 38.87278], [-121.26904, 38.87252], [-121.26907, 38.87246], [-121.26913, 38.87245], [-121.27011, 38.87244], [-121.27017, 38.87246], [-121.2702, 38.87251]]]} | Restricted Access 2 | Stone House Park | 33691 | 6139 | Sun City Lincoln Hills Community Association 877 | Private 7 | Home Owners Association 15 | https://suncity-lincolnhills.org/ | Private 14 | 2.188 | Stone House Park | ||
4835 | 4835 | 4834 | {"type": "Polygon", "coordinates": [[[-122.08071, 37.59307], [-122.07961, 37.59322], [-122.07977, 37.59352], [-122.07935, 37.59373], [-122.07905, 37.59335], [-122.07908, 37.5932], [-122.07915, 37.59302], [-122.07949, 37.59264], [-122.08002, 37.5929], [-122.08024, 37.59296], [-122.08035, 37.59295], [-122.08046, 37.59291], [-122.08056, 37.59281], [-122.0806, 37.59269], [-122.08068, 37.59269], [-122.08071, 37.59307]]]} | Restricted Access 2 | Liberty Park | 33640 | 6135 | Liberty Park Homeowners Association 405 | Private 7 | Home Owners Association 15 | https://libertyparkportal.com/ | Private 14 | 1.868 | Liberty Park | ||
355 | 355 | 354 | {"type": "Polygon", "coordinates": [[[-117.63243, 33.6395], [-117.63242, 33.63969], [-117.63224, 33.63966], [-117.63221, 33.63963], [-117.63113, 33.63928], [-117.63111, 33.63923], [-117.63108, 33.63922], [-117.63075, 33.63926], [-117.63074, 33.63921], [-117.63068, 33.63917], [-117.63063, 33.63915], [-117.63056, 33.63915], [-117.63049, 33.63879], [-117.63071, 33.63856], [-117.63067, 33.63851], [-117.63127, 33.6381], [-117.63149, 33.638], [-117.63173, 33.63792], [-117.63178, 33.63792], [-117.63181, 33.63794], [-117.63226, 33.63891], [-117.63234, 33.63913], [-117.63243, 33.6395]]]} | Restricted Access 2 | HOA Community Park | 31969 | 6048 | Canyon Estates Homeowners Association 1046 | Private 7 | Home Owners Association 15 | https://community.associawebsites.com/sites/CanyonEstatesHomeownersAssn/Pages/AcwDefault.aspx | Private 14 | 5.102 | HOA Community Park | ||
228 | 228 | 227 | {"type": "MultiPolygon", "coordinates": [[[[-117.79757, 33.68517], [-117.79737, 33.68538], [-117.7968, 33.68499], [-117.797, 33.68478], [-117.79757, 33.68517]]], [[[-117.79923, 33.69094], [-117.79815, 33.69104], [-117.79804, 33.69013], [-117.79871, 33.69009], [-117.79915, 33.69018], [-117.79923, 33.69094]]]]} | Restricted Access 2 | HOA Community Park | 31874 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.944 | HOA Community Park | ||
1448 | 1448 | 1447 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.596 | Woodspring Pool | ||
1587 | 1587 | 1586 | {"type": "Polygon", "coordinates": [[[-117.79989, 33.68697], [-117.79927, 33.6872], [-117.79887, 33.68726], [-117.79854, 33.68729], [-117.79849, 33.68702], [-117.79851, 33.68686], [-117.79845, 33.68645], [-117.79837, 33.68625], [-117.79871, 33.68622], [-117.79873, 33.68615], [-117.79871, 33.68595], [-117.79882, 33.68594], [-117.79893, 33.68597], [-117.79882, 33.68623], [-117.79989, 33.68697]]]} | Restricted Access 2 | Arrowhead Park | 15607 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.521 | Arrowhead Park | ||
1638 | 1638 | 1637 | {"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 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.01 | Ashwood Park | ||
2033 | 2033 | 2032 | {"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 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.997 | Birdsong 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 | ||
2241 | 2241 | 2240 | {"type": "Polygon", "coordinates": [[[-117.7966, 33.66983], [-117.79631, 33.67068], [-117.79544, 33.67047], [-117.79574, 33.66964], [-117.79578, 33.66962], [-117.7966, 33.66983]]]} | Restricted Access 2 | Briarglen Park | 16371 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.016 | Briarglen Park | ||
3027 | 3027 | 3026 | {"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 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.0 | Clearbrook Park | ||
3321 | 3321 | 3320 | {"type": "Polygon", "coordinates": [[[-117.78826, 33.67677], [-117.78752, 33.67755], [-117.78658, 33.67687], [-117.78681, 33.67669], [-117.78706, 33.67673], [-117.78726, 33.67673], [-117.78759, 33.67667], [-117.78789, 33.67665], [-117.78817, 33.67669], [-117.78825, 33.67673], [-117.78826, 33.67677]]]} | Restricted Access 2 | Crestbrook Park | 17805 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.068 | Crestbrook Park | ||
3469 | 3469 | 3468 | {"type": "Polygon", "coordinates": [[[-117.81073, 33.67563], [-117.81009, 33.67625], [-117.80942, 33.67578], [-117.8094, 33.67575], [-117.80941, 33.67571], [-117.81, 33.67513], [-117.81073, 33.67563]]]} | Restricted Access 2 | Daybreak Park | 17962 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.95 | Daybreak 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]);