units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, AGNCY_LEV = 4, MNG_AGENCY = 443 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME
DES_TP 2
MNG_AG_TYP 1
- City Agency · 4 ✖
MNG_AGENCY 1
- Bellflower, City of · 4 ✖
ACCESS_TYP 1
- Open Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4425 | 4425 | 4424 | {"type": "MultiPolygon", "coordinates": [[[[-118.10901, 33.88199], [-118.10866, 33.88199], [-118.10866, 33.88024], [-118.109, 33.88024], [-118.10901, 33.88199]]], [[[-118.10903, 33.88235], [-118.109, 33.88308], [-118.10866, 33.88309], [-118.10866, 33.88235], [-118.10903, 33.88235]]], [[[-118.10901, 33.8838], [-118.10866, 33.8838], [-118.10866, 33.88327], [-118.109, 33.88327], [-118.10899, 33.88344], [-118.10901, 33.8838]]], [[[-118.10904, 33.88598], [-118.10883, 33.88598], [-118.10867, 33.88576], [-118.10866, 33.88416], [-118.10901, 33.88416], [-118.10904, 33.88598]]], [[[-118.10902, 33.88748], [-118.10884, 33.88749], [-118.10874, 33.88743], [-118.10869, 33.88737], [-118.10868, 33.88706], [-118.10902, 33.88706], [-118.10902, 33.88748]]]]} | Open Access 1 | 46310 | Caruthers Park North | 29601 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 4.548 | Caruthers Park North | 0 | Local Park 2 | 4 |
15228 | 15228 | 15227 | {"type": "Polygon", "coordinates": [[[-118.11833, 33.88205], [-118.11787, 33.88208], [-118.11777, 33.88205], [-118.11754, 33.88194], [-118.11747, 33.88184], [-118.11747, 33.88161], [-118.11833, 33.88205]]]} | Open Access 1 | 46284 | Bellflower Bike Trail Plaza | 29576 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.44 | Bellflower Bike Trail Plaza | 0 | Local Park 2 | 4 | |
15245 | 15245 | 15244 | {"type": "MultiPolygon", "coordinates": [[[[-118.11714, 33.88168], [-118.11705, 33.88172], [-118.11518, 33.88074], [-118.11387, 33.87997], [-118.10923, 33.87712], [-118.10987, 33.87717], [-118.11517, 33.88042], [-118.11714, 33.88145], [-118.11714, 33.88168]]], [[[-118.12513, 33.88586], [-118.11962, 33.88303], [-118.11818, 33.88229], [-118.11864, 33.88221], [-118.12292, 33.8844], [-118.12415, 33.88503], [-118.1244, 33.88538], [-118.12513, 33.88572], [-118.12513, 33.88586]]], [[[-118.13228, 33.8892], [-118.13165, 33.8892], [-118.12539, 33.88599], [-118.12539, 33.88567], [-118.13228, 33.8892]]], [[[-118.13385, 33.89032], [-118.13216, 33.88946], [-118.13216, 33.88942], [-118.1327, 33.88942], [-118.13384, 33.89], [-118.13385, 33.89032]]], [[[-118.14254, 33.89477], [-118.13411, 33.89046], [-118.13411, 33.89013], [-118.14254, 33.89445], [-118.14254, 33.89477]]]]} | Open Access 1 | 46283 | Bellflower Bike Trail | 29575 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 24.976 | Bellflower Bike Trail | 0 | Local Recreation Area 3 | 4 | |
15250 | 15250 | 15249 | {"type": "Polygon", "coordinates": [[[-118.10916, 33.88013], [-118.10866, 33.88013], [-118.10864, 33.87975], [-118.10856, 33.87932], [-118.10854, 33.87735], [-118.10858, 33.87736], [-118.10899, 33.87907], [-118.10911, 33.8796], [-118.10916, 33.88013]]]} | Open Access 1 | 46307 | Bellflower Skate Park | 29599 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.328 | Bellflower Skate Park | 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]);