units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where LAYER = 2 and MNG_AGENCY = 243
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
736 | 736 | 735 | {"type": "Polygon", "coordinates": [[[-117.96468, 34.0876], [-117.96463, 34.08765], [-117.96323, 34.08766], [-117.96322, 34.08773], [-117.96265, 34.08773], [-117.96265, 34.08752], [-117.96257, 34.08749], [-117.96255, 34.08746], [-117.96249, 34.08747], [-117.9625, 34.08767], [-117.96159, 34.08768], [-117.96158, 34.08705], [-117.9623, 34.08688], [-117.96253, 34.08686], [-117.96261, 34.08682], [-117.96263, 34.0868], [-117.96263, 34.08668], [-117.96254, 34.08639], [-117.96457, 34.08592], [-117.96465, 34.08597], [-117.96468, 34.0876]]]} | Open Access 1 | 5514 | Morgan Park | 22484 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 9.842 | Morgan Park | 0 | Local Park 2 | 4 | |
2986 | 2986 | 2985 | {"type": "Polygon", "coordinates": [[[-117.95397, 34.08403], [-117.95378, 34.0842], [-117.95385, 34.08426], [-117.95193, 34.08606], [-117.95171, 34.08589], [-117.95372, 34.08401], [-117.95384, 34.08393], [-117.95397, 34.08403]]]} | Open Access 1 | 20567 | Hilda L. Solis Park | 19956 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 1.946 | Hilda L. Solis Park | 0 | Local Park 2 | 4 | |
3001 | 3001 | 3000 | {"type": "Polygon", "coordinates": [[[-117.9786, 34.06336], [-117.97842, 34.06361], [-117.97729, 34.06397], [-117.97717, 34.0639], [-117.978, 34.0631], [-117.9786, 34.06336]]]} | Open Access 1 | 20568 | Syhre | 26146 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 1.365 | Syhre | None 246 | |||
3002 | 3002 | 3001 | {"type": "Polygon", "coordinates": [[[-117.99577, 34.06288], [-117.99574, 34.06354], [-117.99558, 34.06357], [-117.99489, 34.06356], [-117.99464, 34.06367], [-117.99407, 34.06328], [-117.99426, 34.06307], [-117.99333, 34.06245], [-117.99487, 34.06227], [-117.99517, 34.06294], [-117.99577, 34.06288]]]} | Open Access 1 | 20570 | Walnut Creek Nature Park | 27226 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 4.567 | Walnut Creek Nature Park | 0 | Local Park 2 | 4 | |
5735 | 5735 | 5734 | {"type": "Polygon", "coordinates": [[[-117.99994, 34.06769], [-118.00005, 34.06802], [-118.0001, 34.06858], [-118.00009, 34.06938], [-117.99988, 34.07038], [-117.99954, 34.0713], [-117.99921, 34.07123], [-117.99917, 34.07136], [-117.9987, 34.07127], [-117.99966, 34.06802], [-117.99994, 34.06769]]]} | Open Access 1 | 1652 | Barnes Park | 15821 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 6.575 | Barnes 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]);