units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
193 rows where DES_TP = 65 and LAYER = 14 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, 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
- Private Landowner 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community 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
- Petco Park Owner 1
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- San Francisco Parks Alliance 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
- …
MNG_AG_TYP 6
ACCESS_TYP 3
DES_TP 1
- Private Recreation or Education · 193 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-117.15178, 32.71015], [-117.15154, 32.71016], [-117.15154, 32.71036], [-117.15114, 32.71036], [-117.15113, 32.70953], [-117.15178, 32.70953], [-117.15178, 32.71015]]]} | Open Access 1 | 48832 | Fault Line Park | 33551 | 6133 | Pinnacle International Development, Inc 701 | Private 7 | Commercial 20 | http://www.pinnacleinternational.ca/resume | Private 14 | 6133 | Pinnacle International Development, Inc 689 | Private 7 | Commercial 18 | San Diego 4 | 1.249 | Fault Line Park | 0 | Private Recreation or Education 65 | 4 | |
6070 | 6070 | 6069 | {"type": "Polygon", "coordinates": [[[-117.1791, 32.70172], [-117.17896, 32.70196], [-117.17873, 32.70185], [-117.17887, 32.70163], [-117.1791, 32.70172]]]} | Open Access 1 | 808 | Bayview Park | 33708 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 6076 | San Diego Gas and Electric 805 | Private 7 | Utility 29 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3801835 | San Diego 4 | 0.176 | Bayview Park | 0 | Private Recreation or Education 65 | 4 |
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
14017 | 14017 | 14016 | {"type": "Polygon", "coordinates": [[[-118.47347, 34.03122], [-118.47281, 34.03175], [-118.47275, 34.03178], [-118.47267, 34.03175], [-118.47203, 34.03124], [-118.47296, 34.03049], [-118.4734, 34.03086], [-118.47336, 34.03089], [-118.47335, 34.03112], [-118.47347, 34.03122]]]} | Open Access 1 | 46587 | Colorado Center Park | 29890 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.516 | Colorado Ctr. Park | 0 | Private Recreation or Education 65 | 4 | ||
14630 | 14630 | 14629 | {"type": "Polygon", "coordinates": [[[-122.25647, 37.85554], [-122.25626, 37.85557], [-122.25622, 37.85524], [-122.25641, 37.85523], [-122.25647, 37.85554]]]} | Open Access 1 | 47647 | Bateman Park | 31391 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Alameda 17 | 0.16 | Bateman Park | 0 | Private Recreation or Education 65 | 4 | ||
705 | 705 | 704 | {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} | Restricted Access 2 | 3955 | Lemongrass Park | 21155 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.759 | Lemongrass Park | 0 | Private Recreation or Education 65 | 4 | |
779 | 779 | 778 | {"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 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
801 | 801 | 800 | {"type": "Polygon", "coordinates": [[[-117.96358, 33.88243], [-117.96358, 33.8825], [-117.96344, 33.88286], [-117.96216, 33.88253], [-117.96201, 33.8825], [-117.96195, 33.88252], [-117.96179, 33.88286], [-117.96169, 33.88291], [-117.96154, 33.8829], [-117.96146, 33.88298], [-117.9612, 33.8838], [-117.96112, 33.88384], [-117.9608, 33.88378], [-117.96076, 33.88375], [-117.96074, 33.8837], [-117.96106, 33.88283], [-117.96104, 33.8828], [-117.96086, 33.88272], [-117.96083, 33.88261], [-117.96097, 33.88214], [-117.96093, 33.88209], [-117.96088, 33.88205], [-117.95971, 33.88173], [-117.95964, 33.88171], [-117.95962, 33.88168], [-117.95968, 33.88149], [-117.95974, 33.88142], [-117.95979, 33.8814], [-117.96346, 33.88234], [-117.96354, 33.88238], [-117.96358, 33.88243]]]} | Restricted Access 2 | 5203 | McDermont Park | 22019 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 7.049 | McDermont Park | 0 | Private Recreation or Education 65 | 4 | |
840 | 840 | 839 | {"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 | 4941 | Mackey Neighborhood Park | 21637 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 0.97 | Mackey Neighborhood Park | 0 | Private Recreation or Education 65 | 4 | |
1118 | 1118 | 1117 | {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} | Restricted Access 2 | 47585 | The Park at Petco Park | 31312 | 6117 | Petco Park Owner 322 | Private 7 | Commercial 20 | http://www.petcoparkinsider.com/park-at-the-park | Private 14 | 6117 | Petco Park Owner 319 | Private 7 | Commercial 18 | http://www.petcoparkinsider.com/park-at-the-park | San Diego 4 | 2.17 | The Park at Petco Park | 0 | Private Recreation or Education 65 | 4 |
1455 | 1455 | 1454 | {"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 | 9773 | Reiswig Park | 24286 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 1.084 | Reiswig Park | 0 | Private Recreation or Education 65 | 4 | |
1592 | 1592 | 1591 | {"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 | 12155 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.011 | Ashwood Park | 0 | Private Recreation or Education 65 | 4 | |
1604 | 1604 | 1603 | {"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 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook 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 | |
1646 | 1646 | 1645 | {"type": "Polygon", "coordinates": [[[-117.81063, 33.67059], [-117.81046, 33.67171], [-117.80973, 33.67181], [-117.80991, 33.67052], [-117.81063, 33.67059]]]} | Restricted Access 2 | 12487 | Meadow Park | 22076 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.231 | Meadow Park | 0 | Private Recreation or Education 65 | 4 | |
1665 | 1665 | 1664 | {"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 | 12583 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 3.524 | Royal Oak Park | 0 | Private Recreation or Education 65 | 4 | ||
1680 | 1680 | 1679 | {"type": "Polygon", "coordinates": [[[-117.81746, 33.6734], [-117.81707, 33.67379], [-117.81593, 33.67299], [-117.8157, 33.67287], [-117.81568, 33.67285], [-117.81568, 33.67278], [-117.81649, 33.67272], [-117.81746, 33.6734]]]} | Restricted Access 2 | 12685 | Timber Run Park | 26369 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.05 | Timber Run Park | 0 | Private Recreation or Education 65 | 4 | |
1690 | 1690 | 1689 | {"type": "Polygon", "coordinates": [[[-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293], [-117.77074, 33.643], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.6436], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64305], [-117.76951, 33.64304], [-117.7695, 33.643]]]} | Restricted Access 2 | 12733 | Valley View Park | 26809 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 2.461 | Valley View Park | 0 | Private Recreation or Education 65 | 4 | |
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | 12755 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.939 | Wildwood Park | 0 | Private Recreation or Education 65 | 4 | |
1699 | 1699 | 1698 | {"type": "Polygon", "coordinates": [[[-122.08071, 37.59307], [-122.0796, 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 | 48918 | Liberty Park | 33640 | 6135 | Liberty Park Homeowners Association 411 | Private 7 | Home Owners Association 16 | https://libertyparkportal.com/ | Private 14 | 6135 | Liberty Park Homeowners Association 405 | Private 7 | Home Owners Association 15 | Alameda 17 | 1.864 | Liberty 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]);