units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
91 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 91 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
695 | 695 | 694 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | 5236 | McNees Park | 22064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.604 | McNees Park | 0 | Local Park 2 | 4 | |
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
931 | 931 | 930 | {"type": "Polygon", "coordinates": [[[-118.0711, 34.1307], [-118.0711, 34.13084], [-118.07107, 34.13097], [-118.07101, 34.13109], [-118.0709, 34.13121], [-118.07078, 34.1313], [-118.07065, 34.13137], [-118.07052, 34.13141], [-118.07035, 34.13143], [-118.07018, 34.13143], [-118.07004, 34.1314], [-118.06991, 34.13135], [-118.06977, 34.13128], [-118.06965, 34.13117], [-118.06958, 34.13108], [-118.06952, 34.13097], [-118.06949, 34.13082], [-118.0711, 34.1307]]]} | Open Access 1 | 5345 | Michillinda Park | 22201 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.162 | Michillinda Park | 0 | Local Park 2 | 4 | |
4413 | 4413 | 4412 | {"type": "Polygon", "coordinates": [[[-117.92209, 33.97404], [-117.9218, 33.97523], [-117.9216, 33.97518], [-117.92132, 33.97508], [-117.92083, 33.97478], [-117.92109, 33.9745], [-117.92144, 33.97416], [-117.92158, 33.974], [-117.92181, 33.97364], [-117.92189, 33.97331], [-117.92205, 33.97332], [-117.92199, 33.97395], [-117.92209, 33.97404]]]} | Open Access 1 | 46293 | Trailview Park | 29585 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Trailview_Park | Los Angeles 6 | 2.717 | Trailview Park | 0 | Local Park 2 | 4 |
4422 | 4422 | 4421 | {"type": "Polygon", "coordinates": [[[-117.95901, 34.54284], [-117.95831, 34.54284], [-117.95827, 34.54281], [-117.95826, 34.54126], [-117.95829, 34.54122], [-117.95901, 34.54121], [-117.95901, 34.54284]]]} | Open Access 1 | 46290 | Mattie M. Primmer Park | 29583 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.034 | Mattie M. Primmer Park | 0 | Local Park 2 | 4 | |
4973 | 4973 | 4972 | {"type": "Polygon", "coordinates": [[[-118.60043, 34.03928], [-118.59866, 34.03936], [-118.59704, 34.03949], [-118.59696, 34.03894], [-118.59729, 34.03892], [-118.59789, 34.03909], [-118.59841, 34.03915], [-118.59889, 34.03908], [-118.59909, 34.03891], [-118.60041, 34.039], [-118.60043, 34.03928]]]} | Open Access 1 | 3710 | Las Tunas County Beach | 21070 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.146 | Las Tunas County Beach | 0 | Local Park 2 | 4 | |
16431 | 16431 | 16430 | {"type": "Polygon", "coordinates": [[[-117.83973, 34.08948], [-117.83939, 34.08989], [-117.83876, 34.08965], [-117.83843, 34.08942], [-117.83824, 34.08936], [-117.83808, 34.08936], [-117.83791, 34.08941], [-117.83777, 34.08951], [-117.8376, 34.08971], [-117.83744, 34.08977], [-117.83718, 34.0898], [-117.83699, 34.08985], [-117.83687, 34.08962], [-117.83699, 34.08957], [-117.83757, 34.08887], [-117.83804, 34.08872], [-117.83842, 34.08887], [-117.83904, 34.08915], [-117.83954, 34.08911], [-117.83973, 34.08948]]]} | Open Access 1 | 46301 | Walnut Creek Community Regional Park | 29589 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Walnut_Creek_Community_Regional_Park | Los Angeles 6 | 4.239 | Walnut Creek Community RP | 0 | Local Park 2 | 4 |
3900 | 3900 | 3899 | {"type": "Polygon", "coordinates": [[[-118.31984, 34.69203], [-118.31779, 34.69204], [-118.31778, 34.69113], [-118.31984, 34.69112], [-118.31984, 34.69203]]]} | Open Access 1 | 45862 | Pioneer Park | 28909 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 4.685 | Pioneer Park | 0 | Local Park 2 | 4 | |
11929 | 11929 | 11928 | {"type": "Polygon", "coordinates": [[[-118.13737, 34.01264], [-118.13716, 34.01417], [-118.13712, 34.01418], [-118.13681, 34.01413], [-118.13624, 34.01402], [-118.13596, 34.01395], [-118.13599, 34.01394], [-118.13601, 34.01391], [-118.13619, 34.01249], [-118.13617, 34.01244], [-118.13612, 34.0124], [-118.13644, 34.01245], [-118.13649, 34.01244], [-118.13729, 34.01256], [-118.13734, 34.01259], [-118.13737, 34.01264]]]} | Open Access 1 | 24536 | Saybrook Park | 29342 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Saybrook_Park | Los Angeles 6 | 4.805 | Saybrook Park | 0 | Local Park 2 | 4 |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
742 | 742 | 741 | {"type": "Polygon", "coordinates": [[[-117.98692, 34.00896], [-117.98596, 34.01059], [-117.98499, 34.01019], [-117.98594, 34.00856], [-117.98692, 34.00896]]]} | Open Access 1 | 4789 | Los Robles County Park | 21532 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Los_Robles_Park | Los Angeles 6 | 4.992 | Los Robles County Park | 0 | Local Park 2 | 4 |
15237 | 15237 | 15236 | {"type": "Polygon", "coordinates": [[[-118.37777, 34.01479], [-118.37753, 34.0148], [-118.37747, 34.01477], [-118.37741, 34.01476], [-118.37599, 34.0148], [-118.37598, 34.01451], [-118.37593, 34.01451], [-118.37619, 34.01404], [-118.37647, 34.01384], [-118.37662, 34.01349], [-118.37761, 34.01347], [-118.37774, 34.01366], [-118.37777, 34.01479]]]} | Open Access 1 | 46287 | Stoneview Park | 29580 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.017 | Stoneview Park | 2017 | Local Park 2 | 4 | |
1198 | 1198 | 1197 | {"type": "Polygon", "coordinates": [[[-117.94417, 33.99296], [-117.94358, 33.99312], [-117.94315, 33.99321], [-117.94258, 33.9933], [-117.94209, 33.99335], [-117.94199, 33.99239], [-117.94203, 33.99236], [-117.94252, 33.99232], [-117.94272, 33.99228], [-117.94343, 33.99205], [-117.94387, 33.99201], [-117.94393, 33.99239], [-117.94417, 33.99296]]]} | Open Access 1 | 8300 | Pepperbrook Park | 23596 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.118 | Pepperbrook Park | 0 | Local Park 2 | 4 | |
4027 | 4027 | 4026 | {"type": "Polygon", "coordinates": [[[-117.88249, 34.12031], [-117.88152, 34.12031], [-117.88149, 34.11967], [-117.8815, 34.11823], [-117.88152, 34.11821], [-117.88248, 34.11821], [-117.88249, 34.12031]]]} | Open Access 1 | 44271 | Dalton Park | 17899 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.245 | Dalton Park | 0 | Local Park 2 | 4 | |
3382 | 3382 | 3381 | {"type": "Polygon", "coordinates": [[[-118.62106, 34.45164], [-118.62107, 34.45184], [-118.62102, 34.45201], [-118.62092, 34.45216], [-118.62076, 34.45229], [-118.62003, 34.45265], [-118.61979, 34.45275], [-118.61957, 34.45281], [-118.61934, 34.45285], [-118.61898, 34.45287], [-118.61899, 34.45259], [-118.61893, 34.45157], [-118.61917, 34.45156], [-118.61924, 34.45151], [-118.61933, 34.45155], [-118.61943, 34.45152], [-118.61948, 34.45157], [-118.62007, 34.45154], [-118.62014, 34.45147], [-118.62025, 34.4515], [-118.62029, 34.45158], [-118.62069, 34.45167], [-118.62071, 34.45165], [-118.62106, 34.45164]]]} | Open Access 1 | 24535 | Hasley Canyon Park | 19731 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.363 | Hasley Canyon Park | 0 | Local Park 2 | 4 | |
1068 | 1068 | 1067 | {"type": "Polygon", "coordinates": [[[-118.1536, 34.18804], [-118.1534, 34.18862], [-118.15355, 34.18868], [-118.15335, 34.18924], [-118.15158, 34.18867], [-118.15198, 34.18752], [-118.1536, 34.18804]]]} | Open Access 1 | 6964 | Charles White Park | 17143 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.474 | Charles White Park | 0 | Local Park 2 | 4 | |
2157 | 2157 | 2156 | {"type": "Polygon", "coordinates": [[[-118.35905, 33.9381], [-118.35751, 33.93811], [-118.3575, 33.93775], [-118.35755, 33.93774], [-118.35756, 33.93669], [-118.35858, 33.93669], [-118.3586, 33.93651], [-118.35905, 33.93651], [-118.35905, 33.9381]]]} | Open Access 1 | 6183 | Lennox Park | 21163 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.629 | Lennox Park | 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]);