units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, AGNCY_LEV = 7, COUNTY = 6 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY 10
MNG_AG_TYP 1
- City Agency 15
DES_TP 1
- Local Park · 15 ✖
ACCESS_TYP 1
- Open Access · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87037], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} | Open Access 1 | 20595 | Constitution Park | 17598 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.156 | Constitution Park | 0 | Local Park 2 | 4 | |
3943 | 3943 | 3942 | {"type": "Polygon", "coordinates": [[[-118.10976, 33.89657], [-118.10921, 33.89657], [-118.10912, 33.88798], [-118.10968, 33.88802], [-118.10976, 33.89657]]]} | Open Access 1 | 46282 | Riverview Park | 24462 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 12.094 | Riverview Park | 0 | Local Park 2 | 4 | |
4172 | 4172 | 4171 | {"type": "Polygon", "coordinates": [[[-118.16946, 33.93806], [-118.16891, 33.93872], [-118.16808, 33.93971], [-118.16762, 33.9386], [-118.1679, 33.93827], [-118.1681, 33.93828], [-118.16864, 33.93763], [-118.16946, 33.93806]]]} | Open Access 1 | 46508 | Circle Park | 29791 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1339 | South Gate, City of 645 | City 2 | City Agency 2 | Los Angeles 6 | 4.401 | Circle Park | 0 | Local Park 2 | 4 | |
4426 | 4426 | 4425 | {"type": "Polygon", "coordinates": [[[-118.10901, 33.88199], [-118.109, 33.88235], [-118.10866, 33.88235], [-118.10866, 33.88199], [-118.10901, 33.88199]]]} | Open Access 1 | 46311 | Caruthers Park North | 29601 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.313 | Caruthers Park North | 0 | Local Park 2 | 4 |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
11164 | 11164 | 11163 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | 47993 | Formosa Park | 32414 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | Los Angeles 6 | 0.105 | Formosa Park | 2008 | Local Park 2 | 4 | |
13127 | 13127 | 13126 | {"type": "Polygon", "coordinates": [[[-118.17428, 33.89646], [-118.17425, 33.89715], [-118.17427, 33.89978], [-118.17318, 33.89977], [-118.17316, 33.89651], [-118.17318, 33.89648], [-118.17322, 33.89647], [-118.17428, 33.89646]]]} | Open Access 1 | 45069 | Salud Park | 29814 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/parks.cfm?task=detail&ID=10 | Los Angeles 6 | 9.17 | Salud Park | 0 | Local Park 2 | 4 |
14346 | 14346 | 14345 | {"type": "Polygon", "coordinates": [[[-118.08266, 34.08809], [-118.08266, 34.08809], [-118.08238, 34.08853], [-118.08229, 34.08817], [-118.08227, 34.08805], [-118.08228, 34.08802], [-118.08232, 34.08799], [-118.08238, 34.08799], [-118.08266, 34.08809]]]} | Open Access 1 | 45594 | Guess Park | 29851 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.28 | Guess Park | 0 | Local Park 2 | 4 | |
15168 | 15168 | 15167 | {"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]} | Open Access 1 | 46018 | Avalon City Park | 29343 | 6013 | Northwood II Community Association 1139 | Private 7 | Home Owners Association 16 | Private 14 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | Los Angeles 6 | 0.445 | Avalon City Park | 0 | Local Park 2 | 4 | ||
15255 | 15255 | 15254 | {"type": "Polygon", "coordinates": [[[-118.12195, 33.89644], [-118.12189, 33.89649], [-118.12166, 33.89649], [-118.12171, 33.89622], [-118.12195, 33.89622], [-118.12195, 33.89644]]]} | Open Access 1 | 46308 | Chevron Pocket Park | 29600 | 6104 | Chevron Pipe Line Company 1145 | Private 7 | Commercial 20 | http://www.chevronpipeline.com/about/ | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.179 | Chevron PP | 0 | Local Park 2 | 4 | |
15256 | 15256 | 15255 | {"type": "MultiPolygon", "coordinates": [[[[-118.109, 33.88327], [-118.10866, 33.88327], [-118.10866, 33.88309], [-118.109, 33.88308], [-118.109, 33.88327]]], [[[-118.10902, 33.88416], [-118.10866, 33.88416], [-118.10866, 33.8838], [-118.10901, 33.8838], [-118.10902, 33.88416]]]]} | Open Access 1 | 46312 | Caruthers Park North | 29601 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.48 | Caruthers Park North | 0 | Local Park 2 | 4 | |
15317 | 15317 | 15316 | {"type": "Polygon", "coordinates": [[[-118.01167, 33.9126], [-118.01104, 33.91346], [-118.01104, 33.91426], [-118.01127, 33.91427], [-118.01118, 33.91432], [-118.01101, 33.91431], [-118.01083, 33.91482], [-118.00994, 33.91503], [-118.01023, 33.91471], [-118.01004, 33.91464], [-118.01004, 33.91461], [-118.01024, 33.91467], [-118.01043, 33.9143], [-118.0105, 33.91395], [-118.01056, 33.9133], [-118.01061, 33.91317], [-118.01081, 33.91298], [-118.01102, 33.91265], [-118.01073, 33.91253], [-118.01074, 33.9125], [-118.01102, 33.9126], [-118.01116, 33.91239], [-118.01149, 33.91179], [-118.01152, 33.91167], [-118.01166, 33.91167], [-118.01166, 33.912], [-118.01157, 33.9121], [-118.01157, 33.91245], [-118.01167, 33.91246], [-118.01167, 33.9126]]]} | Open Access 1 | 46499 | Oak Creek Park | 22960 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 4.296 | Oak Creek Park | 0 | Local Park 2 | 4 | ||
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 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]);