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 SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14450 | 14450 | 14449 | {"type": "Polygon", "coordinates": [[[-119.76638, 36.87034], [-119.76629, 36.87046], [-119.76407, 36.8694], [-119.76326, 36.86964], [-119.76233, 36.87081], [-119.76208, 36.87074], [-119.7624, 36.87065], [-119.76252, 36.8705], [-119.7625, 36.87038], [-119.76256, 36.87037], [-119.76263, 36.87028], [-119.76271, 36.87026], [-119.7628, 36.87015], [-119.76278, 36.87009], [-119.76285, 36.87007], [-119.76291, 36.87001], [-119.76286, 36.86982], [-119.76309, 36.86977], [-119.76322, 36.86962], [-119.76332, 36.8696], [-119.76338, 36.86952], [-119.76353, 36.86947], [-119.76368, 36.86929], [-119.76359, 36.86895], [-119.76313, 36.86876], [-119.76329, 36.86858], [-119.76333, 36.86848], [-119.76336, 36.86837], [-119.76337, 36.8682], [-119.76329, 36.86781], [-119.76331, 36.86778], [-119.76346, 36.86777], [-119.76382, 36.86776], [-119.76417, 36.86781], [-119.76404, 36.86792], [-119.76406, 36.86877], [-119.7637, 36.86897], [-119.76375, 36.86923], [-119.7638, 36.86933], [-119.76389, 36.86937], [-119.76408, 36.86931], [-119.76411, 36.86937], [-119.76417, 36.8694], [-119.76435, 36.86935], [-119.76442, 36.86951], [-119.76448, 36.8695], [-119.76505, 36.86977], [-119.76509, 36.86975], [-119.76525, 36.86982], [-119.76524, 36.86986], [-119.76555, 36.87001], [-119.76558, 36.86999], [-119.76576, 36.87008], [-119.76574, 36.87013], [-119.76616, 36.87033], [-119.76638, 36.87034]]]} | No Public Access 3 | Floyd Boler Park | 33798 | 6130 | Park Fort Washington Association 988 | Private 7 | Home Owners Association 15 | http://parkfortwashington.com/ | Private 14 | 3.22 | Floyd Boler 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 | ||
14405 | 14405 | 14404 | {"type": "MultiPolygon", "coordinates": [[[[-119.63533, 36.86486], [-119.63533, 36.86486], [-119.63468, 36.86486], [-119.63468, 36.86484], [-119.63503, 36.86465], [-119.63507, 36.86466], [-119.63533, 36.86484], [-119.63533, 36.86486]]], [[[-119.63664, 36.86487], [-119.6357, 36.86487], [-119.63566, 36.86484], [-119.63602, 36.86449], [-119.63664, 36.86487]]], [[[-119.64194, 36.86363], [-119.64191, 36.86365], [-119.6416, 36.86365], [-119.64158, 36.86363], [-119.6416, 36.86306], [-119.64163, 36.86303], [-119.6419, 36.86303], [-119.64193, 36.86306], [-119.64194, 36.86363]]], [[[-119.64596, 36.86344], [-119.64596, 36.86363], [-119.64537, 36.86363], [-119.64537, 36.86344], [-119.64596, 36.86344]]], [[[-119.6463, 36.86046], [-119.6463, 36.86082], [-119.64628, 36.86085], [-119.64624, 36.86087], [-119.6457, 36.86088], [-119.64566, 36.86086], [-119.64564, 36.86083], [-119.64564, 36.86047], [-119.64565, 36.86043], [-119.64569, 36.86041], [-119.64624, 36.86041], [-119.64627, 36.86042], [-119.6463, 36.86046]]]]} | Restricted Access 2 | Unknown park - Harlan Ranch Community Association | 33655 | 6138 | Harlan Ranch Community Association 793 | Private 7 | Home Owners Association 15 | http://www.harlanranchca.com/default.php | Private 14 | 2.17 | |||
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 | |||
6568 | 6568 | 6567 | {"type": "Polygon", "coordinates": [[[-121.33415, 38.0047], [-121.33339, 38.0049], [-121.33335, 38.0049], [-121.33331, 38.00487], [-121.33306, 38.00439], [-121.33306, 38.00436], [-121.33311, 38.00433], [-121.33386, 38.00414], [-121.33415, 38.0047]]]} | Restricted Access 2 | Village Oaks Community Park | https://www.villageoakscommonareasassociation.org/ | 33647 | 6136 | Lincoln Village Home Association 832 | Private 7 | Home Owners Association 15 | Private 14 | 1.255 | Village Oaks Community 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 | ||
429 | 429 | 428 | {"type": "Polygon", "coordinates": [[[-120.42201, 34.85579], [-120.42022, 34.85579], [-120.42022, 34.85534], [-120.42034, 34.85532], [-120.42045, 34.85527], [-120.42053, 34.85519], [-120.42061, 34.85505], [-120.42068, 34.85503], [-120.4209, 34.85517], [-120.42118, 34.85548], [-120.42138, 34.85563], [-120.42154, 34.8557], [-120.42168, 34.85575], [-120.42182, 34.85578], [-120.42201, 34.85579]]]} | Restricted Access 2 | Oak Neighborhood Park | 33495 | 6131 | Rice Ranch Ventures LLC 971 | Private 7 | Home Owners Association 15 | Private 14 | 1.572 | Oak Neighborhood Park | |||
13079 | 13079 | 13078 | {"type": "Polygon", "coordinates": [[[-117.09011, 32.59473], [-117.08972, 32.59469], [-117.08918, 32.59467], [-117.08903, 32.5938], [-117.08962, 32.59389], [-117.08963, 32.59399], [-117.08947, 32.59416], [-117.08978, 32.59441], [-117.08985, 32.5944], [-117.08996, 32.59434], [-117.09002, 32.59442], [-117.09011, 32.59473]]]} | Restricted Access 2 | Swiss Park | 33368 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.422 | Swiss Park | |||
13065 | 13065 | 13064 | {"type": "Polygon", "coordinates": [[[-116.95147, 32.64226], [-116.95151, 32.64236], [-116.95151, 32.64247], [-116.95145, 32.64258], [-116.95133, 32.64266], [-116.95118, 32.64269], [-116.95105, 32.64267], [-116.95093, 32.6426], [-116.95086, 32.6425], [-116.95084, 32.6424], [-116.95087, 32.6423], [-116.95094, 32.64221], [-116.95103, 32.64215], [-116.95116, 32.64212], [-116.95126, 32.64213], [-116.95138, 32.64218], [-116.95147, 32.64226]]]} | Restricted Access 2 | Circle Park | 33367 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.754 | Circle 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 | |||
13051 | 13051 | 13050 | {"type": "Polygon", "coordinates": [[[-116.98239, 32.62449], [-116.98165, 32.62469], [-116.98153, 32.62438], [-116.98226, 32.62417], [-116.98239, 32.62449]]]} | Restricted Access 2 | Sienna Park | 33365 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.67 | Sienna Park | |||
13050 | 13050 | 13049 | {"type": "Polygon", "coordinates": [[[-116.94846, 32.64539], [-116.94839, 32.64551], [-116.94804, 32.64538], [-116.9476, 32.64524], [-116.94727, 32.64516], [-116.94683, 32.64507], [-116.94696, 32.64452], [-116.9465, 32.64443], [-116.94654, 32.64432], [-116.94654, 32.64418], [-116.94627, 32.64341], [-116.94628, 32.6433], [-116.94633, 32.64314], [-116.94659, 32.64328], [-116.94692, 32.6434], [-116.94793, 32.64356], [-116.9478, 32.64414], [-116.9478, 32.64431], [-116.94783, 32.64446], [-116.94788, 32.64461], [-116.94795, 32.64473], [-116.94838, 32.64535], [-116.94846, 32.64539]]]} | Restricted Access 2 | Little League Ballfields | 33364 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 6.313 | Little League Ballfields | |||
13042 | 13042 | 13041 | {"type": "Polygon", "coordinates": [[[-116.95784, 32.6469], [-116.95776, 32.64726], [-116.95776, 32.64742], [-116.95656, 32.64741], [-116.95641, 32.64735], [-116.95632, 32.64703], [-116.95625, 32.64688], [-116.95615, 32.64672], [-116.95619, 32.64666], [-116.95674, 32.64628], [-116.95698, 32.64648], [-116.95726, 32.64666], [-116.95755, 32.64679], [-116.95784, 32.6469]]]} | Restricted Access 2 | Augusta Park | 33363 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 3.216 | Augusta Park | |||
13041 | 13041 | 13040 | {"type": "Polygon", "coordinates": [[[-116.99738, 32.61585], [-116.99737, 32.61587], [-116.99645, 32.61622], [-116.99642, 32.61621], [-116.99622, 32.61584], [-116.99623, 32.61582], [-116.99716, 32.61547], [-116.99719, 32.61548], [-116.99738, 32.61585]]]} | Restricted Access 2 | Jacaranda Park | 33362 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.199 | Jacaranda Park | |||
13040 | 13040 | 13039 | {"type": "Polygon", "coordinates": [[[-116.97964, 32.65322], [-116.97946, 32.65338], [-116.97929, 32.65355], [-116.97916, 32.65372], [-116.97904, 32.65392], [-116.97898, 32.65372], [-116.97898, 32.65359], [-116.979, 32.65344], [-116.97897, 32.65339], [-116.97893, 32.65338], [-116.97888, 32.65338], [-116.97879, 32.65349], [-116.97871, 32.65353], [-116.97847, 32.65357], [-116.97835, 32.65366], [-116.97829, 32.65369], [-116.9782, 32.65371], [-116.97813, 32.65369], [-116.97806, 32.65365], [-116.97801, 32.65358], [-116.97795, 32.6532], [-116.97789, 32.65307], [-116.97778, 32.65297], [-116.97745, 32.65283], [-116.97781, 32.65226], [-116.97964, 32.65319], [-116.97964, 32.65322]]]} | Restricted Access 2 | East Lake Beach Club | 33361 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 4.065 | East Lake Beach Club | |||
13035 | 13035 | 13034 | {"type": "Polygon", "coordinates": [[[-116.97738, 32.65693], [-116.97721, 32.65698], [-116.9771, 32.65706], [-116.97694, 32.65721], [-116.97668, 32.65643], [-116.97706, 32.65643], [-116.97724, 32.65675], [-116.97738, 32.65693]]]} | Restricted Access 2 | Cobblestone Park | 33360 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.726 | Cobblestone 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 | |||
13033 | 13033 | 13032 | {"type": "Polygon", "coordinates": [[[-116.99456, 32.62803], [-116.99407, 32.62875], [-116.99394, 32.62888], [-116.99368, 32.62907], [-116.99364, 32.62907], [-116.99332, 32.62882], [-116.9933, 32.62871], [-116.99399, 32.62774], [-116.99403, 32.62773], [-116.99455, 32.62799], [-116.99456, 32.62803]]]} | Restricted Access 2 | Oak Crest Park | 33358 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 2.168 | Oak Crest Park | |||
13032 | 13032 | 13031 | {"type": "Polygon", "coordinates": [[[-116.97617, 32.63948], [-116.97614, 32.6399], [-116.97612, 32.64006], [-116.9761, 32.64008], [-116.97549, 32.64002], [-116.97527, 32.63998], [-116.97525, 32.63995], [-116.97541, 32.63942], [-116.97545, 32.6394], [-116.97578, 32.63945], [-116.97615, 32.63945], [-116.97617, 32.63948]]]} | Restricted Access 2 | Countryside Park | 33357 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.298 | Countryside 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 |
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]);