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
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 23
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Town Center Association 4
- Quail Hill Community Association 3
- Paseo Westpark Maintenance 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
- Woodbury Community Association 2
- Park Paseo Homeowners Association 2
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners 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
- …
ACCESS_TYP 2
MNG_AG_TYP 1
- Home Owners Association · 180 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5191 | 5191 | 5190 | {"type": "MultiPolygon", "coordinates": [[[[-121.21955, 38.73498], [-121.2194, 38.7353], [-121.21882, 38.73531], [-121.21882, 38.73514], [-121.21901, 38.73514], [-121.21914, 38.73509], [-121.21941, 38.73486], [-121.21955, 38.73498]]], [[[-121.2206, 38.73383], [-121.22027, 38.73401], [-121.22013, 38.73412], [-121.22002, 38.73428], [-121.21986, 38.73466], [-121.21978, 38.73477], [-121.21968, 38.73487], [-121.21964, 38.73488], [-121.21959, 38.73487], [-121.21943, 38.73473], [-121.21938, 38.73464], [-121.21933, 38.73452], [-121.21963, 38.73452], [-121.21963, 38.73438], [-121.21982, 38.73381], [-121.22002, 38.73385], [-121.22025, 38.73364], [-121.2205, 38.73372], [-121.2206, 38.73383]]], [[[-121.22304, 38.73648], [-121.22298, 38.73654], [-121.22293, 38.73655], [-121.22075, 38.73653], [-121.22075, 38.7364], [-121.22272, 38.73641], [-121.22292, 38.73608], [-121.22284, 38.73589], [-121.22272, 38.73569], [-121.22268, 38.73563], [-121.22259, 38.73565], [-121.22257, 38.73561], [-121.22266, 38.73558], [-121.22273, 38.7356], [-121.22283, 38.73575], [-121.22294, 38.73595], [-121.22301, 38.73616], [-121.22304, 38.73635], [-121.22304, 38.73648]]], [[[-121.2236, 38.73557], [-121.22359, 38.73642], [-121.22337, 38.73642], [-121.2233, 38.73636], [-121.22324, 38.73606], [-121.22313, 38.73577], [-121.2236, 38.73557]]]]} | Restricted Access 2 | HOA Park | 20015 | 6064 | Johnson Ranch Community Association 930 | Private 7 | Home Owners Association 15 | Private 14 | 3.306 | HOA Park | |||
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 | ||
6664 | 6664 | 6663 | {"type": "Polygon", "coordinates": [[[-117.8192, 33.63243], [-117.81917, 33.63249], [-117.81854, 33.6334], [-117.81848, 33.6334], [-117.81807, 33.63318], [-117.81807, 33.63316], [-117.81809, 33.63311], [-117.81839, 33.63259], [-117.8186, 33.63226], [-117.81865, 33.63225], [-117.81894, 33.63233], [-117.81916, 33.6324], [-117.8192, 33.63243]]]} | Restricted Access 2 | Sierra Boca Park | 32318 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Private 14 | 1.696 | Sierra Boca 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 | |||
6949 | 6949 | 6948 | {"type": "Polygon", "coordinates": [[[-117.82217, 33.64995], [-117.82193, 33.64998], [-117.82124, 33.65], [-117.82125, 33.64971], [-117.8212, 33.64969], [-117.82123, 33.64946], [-117.8212, 33.64942], [-117.82123, 33.64919], [-117.82123, 33.64893], [-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.64947], [-117.82217, 33.64995]]]} | Restricted Access 2 | Paseo Park | 32335 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Private 14 | 2.012 | Paseo Park | |||
6950 | 6950 | 6949 | {"type": "MultiPolygon", "coordinates": [[[[-117.83866, 33.62193], [-117.83821, 33.62248], [-117.83803, 33.62277], [-117.83793, 33.62298], [-117.8378, 33.62302], [-117.83765, 33.62296], [-117.8374, 33.62224], [-117.83719, 33.62199], [-117.83782, 33.62201], [-117.83866, 33.62193]]], [[[-117.84043, 33.62701], [-117.83967, 33.62761], [-117.83956, 33.62761], [-117.83949, 33.62756], [-117.83939, 33.62735], [-117.83926, 33.62688], [-117.83913, 33.62654], [-117.83915, 33.6265], [-117.8393, 33.62638], [-117.83969, 33.62666], [-117.83997, 33.62682], [-117.84043, 33.62701]]]]} | Restricted Access 2 | HOA Community Park | 32340 | 6060 | Newport Ridge North Maintenance Association 1033 | Private 7 | Home Owners Association 15 | Private 14 | 3.871 | HOA Community Park | |||
8558 | 8558 | 8557 | {"type": "Polygon", "coordinates": [[[-117.78052, 33.66198], [-117.78052, 33.66204], [-117.78004, 33.66252], [-117.77971, 33.66281], [-117.77938, 33.66301], [-117.77934, 33.66295], [-117.77937, 33.66293], [-117.77939, 33.66289], [-117.77936, 33.66283], [-117.77923, 33.66266], [-117.77886, 33.66229], [-117.7792, 33.66209], [-117.77967, 33.66174], [-117.77987, 33.66157], [-117.77992, 33.66157], [-117.78052, 33.66198]]]} | Restricted Access 2 | Ravencreek Park | 24198 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Private 14 | 2.918 | Ravencreek Park | |||
9040 | 9040 | 9039 | {"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 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Private 14 | 3.523 | Royal Oak Park | |||
9314 | 9314 | 9313 | {"type": "MultiPolygon", "coordinates": [[[[-117.80373, 33.69585], [-117.80368, 33.69586], [-117.80361, 33.69579], [-117.80358, 33.69562], [-117.80356, 33.69525], [-117.80357, 33.69497], [-117.80364, 33.69489], [-117.80369, 33.69489], [-117.80367, 33.69514], [-117.80367, 33.69539], [-117.80369, 33.69561], [-117.80373, 33.69585]]], [[[-117.80489, 33.69297], [-117.80459, 33.69323], [-117.8044, 33.69345], [-117.80424, 33.69367], [-117.80458, 33.69394], [-117.80481, 33.6942], [-117.80478, 33.69444], [-117.80466, 33.69494], [-117.80369, 33.69485], [-117.80369, 33.69479], [-117.80366, 33.69478], [-117.80362, 33.69469], [-117.80377, 33.69422], [-117.80389, 33.694], [-117.80415, 33.69359], [-117.80449, 33.69321], [-117.80476, 33.69296], [-117.80487, 33.69295], [-117.80489, 33.69297]]]]} | Restricted Access 2 | Santa Cruz Park | 25083 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Private 14 | 3.174 | Santa Cruz 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 | |||
12165 | 12165 | 12164 | {"type": "Polygon", "coordinates": [[[-122.22153, 37.36198], [-122.22095, 37.36342], [-122.22116, 37.36353], [-122.22107, 37.36357], [-122.22091, 37.36383], [-122.22031, 37.36425], [-122.21982, 37.36432], [-122.21905, 37.36479], [-122.21859, 37.36468], [-122.21792, 37.36468], [-122.21681, 37.36444], [-122.21663, 37.36458], [-122.21652, 37.36457], [-122.21625, 37.36444], [-122.21573, 37.36435], [-122.21511, 37.36387], [-122.21468, 37.36376], [-122.21411, 37.36345], [-122.21396, 37.36339], [-122.21379, 37.36335], [-122.21362, 37.36334], [-122.21345, 37.36335], [-122.21329, 37.36339], [-122.21312, 37.36346], [-122.21298, 37.36354], [-122.21287, 37.36365], [-122.21278, 37.36376], [-122.21271, 37.36391], [-122.21252, 37.36381], [-122.21233, 37.36377], [-122.21212, 37.36376], [-122.21185, 37.3638], [-122.21156, 37.36357], [-122.21116, 37.36334], [-122.21102, 37.36323], [-122.21199, 37.3621], [-122.21094, 37.36096], [-122.20955, 37.35979], [-122.20929, 37.35959], [-122.20817, 37.3594], [-122.20651, 37.35691], [-122.21042, 37.352], [-122.21243, 37.35403], [-122.21338, 37.35413], [-122.21598, 37.35557], [-122.21904, 37.35912], [-122.22061, 37.36021], [-122.22153, 37.36198]]]} | Restricted Access 2 | Coal Mine Ridge | 33341 | 6127 | Portola Valley Ranch Home Owners Association 869 | Private 7 | Home Owners Association 15 | Private 14 | 244.074 | Coal Mine Ridge | 1964 | ||
12333 | 12333 | 12332 | {"type": "Polygon", "coordinates": [[[-117.62663, 33.59093], [-117.62662, 33.591], [-117.62606, 33.5917], [-117.62547, 33.59254], [-117.62527, 33.59238], [-117.62515, 33.59228], [-117.62488, 33.59227], [-117.62481, 33.59233], [-117.62478, 33.59237], [-117.6247, 33.59236], [-117.62464, 33.59239], [-117.62436, 33.59244], [-117.62411, 33.5927], [-117.62405, 33.59275], [-117.62399, 33.59277], [-117.62389, 33.59271], [-117.62381, 33.59272], [-117.62369, 33.5925], [-117.62358, 33.59244], [-117.62362, 33.59238], [-117.6237, 33.59217], [-117.62368, 33.5921], [-117.62365, 33.59207], [-117.62347, 33.59204], [-117.62344, 33.59205], [-117.62334, 33.59198], [-117.62329, 33.59179], [-117.62307, 33.5917], [-117.62308, 33.59166], [-117.62305, 33.59163], [-117.62323, 33.59136], [-117.62358, 33.59091], [-117.62376, 33.59095], [-117.62418, 33.59107], [-117.62426, 33.59106], [-117.62461, 33.59095], [-117.62472, 33.59087], [-117.62497, 33.59047], [-117.62533, 33.59009], [-117.62588, 33.59031], [-117.62586, 33.59037], [-117.62591, 33.59045], [-117.62609, 33.59052], [-117.62635, 33.59074], [-117.62662, 33.5909], [-117.62663, 33.59093]]]} | Restricted Access 2 | Oak Tree Park | 32384 | 6047 | L F Maintenance Corporation 687 | Private 7 | Home Owners Association 15 | Private 14 | 12.694 | Oak Tree Park | |||
12344 | 12344 | 12343 | {"type": "Polygon", "coordinates": [[[-117.85545, 33.616], [-117.85438, 33.61709], [-117.854, 33.61753], [-117.85358, 33.61808], [-117.85239, 33.61725], [-117.85271, 33.61732], [-117.85285, 33.61733], [-117.85301, 33.61727], [-117.85305, 33.61735], [-117.85358, 33.61759], [-117.85545, 33.616]]]} | Restricted Access 2 | HOA Community Park | 32395 | 6054 | Broadmoor Sea View Community Association 1045 | Private 7 | Home Owners Association 15 | Private 14 | 1.786 | HOA Community Park | |||
12345 | 12345 | 12344 | {"type": "Polygon", "coordinates": [[[-117.81397, 33.68873], [-117.81343, 33.68929], [-117.81316, 33.68912], [-117.81251, 33.68866], [-117.81295, 33.68837], [-117.81303, 33.68829], [-117.81307, 33.68822], [-117.81318, 33.68818], [-117.81397, 33.68873]]]} | Restricted Access 2 | Santa Clara Park | 32396 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Private 14 | 2.033 | Santa Clara Park | |||
13012 | 13012 | 13011 | {"type": "Polygon", "coordinates": [[[-116.95852, 32.65971], [-116.95848, 32.65998], [-116.95841, 32.66002], [-116.95813, 32.66], [-116.95816, 32.65968], [-116.95852, 32.65971]]]} | Restricted Access 2 | Kensington Road Park | 33346 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.287 | Kensington Road Park | |||
13013 | 13013 | 13012 | {"type": "Polygon", "coordinates": [[[-117.00158, 32.64883], [-117.00127, 32.64895], [-117.00104, 32.64919], [-117.00075, 32.64957], [-117.00074, 32.64972], [-117.00066, 32.64986], [-117.00056, 32.64962], [-117.00018, 32.64972], [-117.00016, 32.64965], [-117.00053, 32.64954], [-117.00037, 32.64912], [-117.00095, 32.64895], [-117.00084, 32.64865], [-117.00104, 32.6486], [-117.00118, 32.64862], [-117.00145, 32.6487], [-117.00158, 32.64883]]]} | Restricted Access 2 | Bonitas Haciendas Mini-Park | 33347 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.4 | Bonitas Haciendas Mini-Park | |||
13027 | 13027 | 13026 | {"type": "Polygon", "coordinates": [[[-116.98256, 32.62142], [-116.98251, 32.62145], [-116.98215, 32.62155], [-116.98208, 32.62155], [-116.98189, 32.62107], [-116.98195, 32.62104], [-116.98229, 32.62094], [-116.98237, 32.62094], [-116.98256, 32.62142]]]} | Restricted Access 2 | Hillsborough Park | 33348 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.702 | Hillsborough 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 | |||
13029 | 13029 | 13028 | {"type": "Polygon", "coordinates": [[[-116.9516, 32.63377], [-116.9514, 32.63414], [-116.95109, 32.63446], [-116.95092, 32.63457], [-116.95086, 32.63458], [-116.95074, 32.63445], [-116.95043, 32.63406], [-116.95014, 32.63366], [-116.94988, 32.63325], [-116.95034, 32.63301], [-116.9505, 32.63319], [-116.95068, 32.63332], [-116.95108, 32.63351], [-116.95155, 32.63368], [-116.9516, 32.63377]]]} | Restricted Access 2 | Dolphin Beach Club | 33351 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 3.296 | Dolphin Beach Club | |||
13030 | 13030 | 13029 | {"type": "Polygon", "coordinates": [[[-116.97573, 32.61392], [-116.97559, 32.61421], [-116.97545, 32.61416], [-116.97534, 32.61417], [-116.97525, 32.61422], [-116.9752, 32.6143], [-116.97465, 32.61411], [-116.97466, 32.61409], [-116.97479, 32.61409], [-116.97496, 32.61406], [-116.97549, 32.61389], [-116.97561, 32.61388], [-116.97573, 32.6139], [-116.97573, 32.61392]]]} | Restricted Access 2 | Terracotta Park | 33352 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.546 | Terracotta 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]);