units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, DES_TP = 3, LAYER = 3 and MNG_AGENCY = 273
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 6 ✖
DES_TP 1
- Local Recreation Area · 6 ✖
ACCESS_TYP 1
- Open Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7171 | 7171 | 7170 | {"type": "Polygon", "coordinates": [[[-118.35661, 33.997], [-118.35664, 33.99732], [-118.3566, 33.99764], [-118.35649, 33.99812], [-118.35562, 33.99999], [-118.35552, 34.0001], [-118.35507, 33.99981], [-118.35523, 33.99961], [-118.35538, 33.99937], [-118.35616, 33.99787], [-118.35624, 33.99763], [-118.35627, 33.99744], [-118.35627, 33.99713], [-118.35625, 33.99705], [-118.35661, 33.997]]]} | Open Access 1 | 6300 | Ruben Ingold Parkway | 32500 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 3.496 | Ruben Ingold Parkway | 0 | Local Recreation Area 3 | 4 | |
11446 | 11446 | 11445 | {"type": "Polygon", "coordinates": [[[-118.49983, 34.28887], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49983, 34.28865], [-118.49987, 34.28867], [-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49983, 34.28885], [-118.49983, 34.28887]]]} | Open Access 1 | 48139 | Knollwood Pool | 32669 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-pool/ | Los Angeles 6 | 0.141 | Knollwood Pool | 0 | Local Recreation Area 3 | 4 |
15073 | 15073 | 15072 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 45852 | 72nd Street Equestrian Park | 32687 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/72nd-street-equestrian-park/ | Los Angeles 6 | 2.957 | 72nd Street Equestrian Park | 0 | Local Recreation Area 3 | 4 |
15075 | 15075 | 15074 | {"type": "MultiPolygon", "coordinates": [[[[-118.25097, 33.92044], [-118.25063, 33.92044], [-118.24952, 33.91637], [-118.24986, 33.91637], [-118.25097, 33.92044]]], [[[-118.25181, 33.92354], [-118.25148, 33.92354], [-118.25064, 33.92046], [-118.25098, 33.92046], [-118.25181, 33.92354]]]]} | Open Access 1 | 45854 | Compton Creek Walking Path | 32466 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.121 | Compton Creek Walking Path | 0 | Local Recreation Area 3 | 4 | |
16496 | 16496 | 16495 | {"type": "MultiPolygon", "coordinates": [[[[-118.25943, 33.9168], [-118.25939, 33.91821], [-118.25786, 33.9182], [-118.25785, 33.91879], [-118.25783, 33.91879], [-118.25779, 33.91871], [-118.2577, 33.91867], [-118.25747, 33.9187], [-118.25637, 33.9187], [-118.25635, 33.91868], [-118.25636, 33.91772], [-118.25639, 33.91758], [-118.2566, 33.91695], [-118.25662, 33.91684], [-118.25663, 33.91652], [-118.25665, 33.9165], [-118.25937, 33.91649], [-118.25942, 33.91654], [-118.25943, 33.9168]]], [[[-118.26507, 33.9181], [-118.26506, 33.92099], [-118.26088, 33.92099], [-118.26086, 33.92364], [-118.25652, 33.92364], [-118.25651, 33.92361], [-118.25612, 33.92361], [-118.25612, 33.92103], [-118.25635, 33.92102], [-118.25636, 33.92093], [-118.25939, 33.92093], [-118.2594, 33.92099], [-118.25955, 33.92099], [-118.25957, 33.91649], [-118.26343, 33.91649], [-118.26343, 33.9181], [-118.26507, 33.9181]]]]} | Open Access 1 | 6229 | Earvin 'Magic' Johnson Recreation Area | 32475 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 102.9 | Earvin 'Magic' Johnson Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16650 | 16650 | 16649 | {"type": "MultiPolygon", "coordinates": [[[[-118.3635, 33.99303], [-118.36256, 33.99326], [-118.36252, 33.98969], [-118.36336, 33.9897], [-118.36341, 33.99002], [-118.36343, 33.99252], [-118.36347, 33.99289], [-118.3635, 33.99303]]], [[[-118.36747, 33.98969], [-118.36744, 33.9912], [-118.36611, 33.99122], [-118.36538, 33.99193], [-118.36505, 33.99297], [-118.36486, 33.9932], [-118.36386, 33.9933], [-118.36376, 33.99312], [-118.36369, 33.99286], [-118.36367, 33.98994], [-118.36363, 33.98972], [-118.36747, 33.98969]]]]} | Open Access 1 | 6299 | Kenneth Hahn State Recreation Area | 32640 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 30.796 | Kenneth Hahn SRA | 0 | Local Recreation Area 3 | 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]);