units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where COUNTY = 6, MNG_AGENCY = 367 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1466 | 1466 | 1465 | {"type": "Polygon", "coordinates": [[[-118.09447, 34.01042], [-118.09429, 34.01062], [-118.09427, 34.01069], [-118.09221, 34.01287], [-118.09202, 34.0127], [-118.09188, 34.01265], [-118.09183, 34.01261], [-118.09107, 34.01192], [-118.09119, 34.01189], [-118.0913, 34.01175], [-118.09139, 34.01177], [-118.0916, 34.01011], [-118.0923, 34.01017], [-118.09229, 34.0103], [-118.09281, 34.01035], [-118.09318, 34.01031], [-118.09333, 34.01032], [-118.09447, 34.01042]]]} | Open Access 1 | 10022 | Rio Hondo Park | 24382 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 12.354 | Rio Hondo Park | 0 | Local Park 2 | 4 | |
1478 | 1478 | 1477 | {"type": "Polygon", "coordinates": [[[-118.09908, 33.96287], [-118.09833, 33.9645], [-118.09521, 33.96352], [-118.09589, 33.96184], [-118.09908, 33.96287]]]} | Open Access 1 | 10117 | Rivera Park | 24433 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 15.038 | Rivera Park | 0 | Local Park 2 | 4 | |
1784 | 1784 | 1783 | {"type": "Polygon", "coordinates": [[[-118.09194, 33.99028], [-118.09158, 33.99068], [-118.09111, 33.99112], [-118.09076, 33.99139], [-118.09001, 33.99191], [-118.08922, 33.99134], [-118.08882, 33.99108], [-118.08832, 33.99081], [-118.08776, 33.99055], [-118.08879, 33.98888], [-118.09194, 33.99028]]]} | Open Access 1 | 15383 | William A Smith Park | 27536 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 16.478 | William A Smith Park | 0 | Local Park 2 | 4 | |
7294 | 7294 | 7293 | {"type": "Polygon", "coordinates": [[[-118.07409, 34.02003], [-118.07253, 34.02084], [-118.06905, 34.02101], [-118.06903, 34.02046], [-118.06945, 34.01932], [-118.06976, 34.01935], [-118.0698, 34.01927], [-118.07064, 34.01943], [-118.07024, 34.02012], [-118.0702, 34.02012], [-118.07003, 34.02041], [-118.07017, 34.02048], [-118.0708, 34.01943], [-118.07409, 34.02003]]]} | Open Access 1 | 6573 | Streamland Park | 32518 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 14.075 | Streamland Park | 0 | Local Park 2 | 4 | |
7763 | 7763 | 7762 | {"type": "Polygon", "coordinates": [[[-118.0756, 34.00659], [-118.07496, 34.00854], [-118.07171, 34.00752], [-118.07238, 34.00712], [-118.07255, 34.00699], [-118.07267, 34.00686], [-118.07276, 34.00674], [-118.07282, 34.00664], [-118.07288, 34.00648], [-118.0756, 34.00659]]]} | Open Access 1 | 8456 | Pico Park | 23655 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 12.201 | Pico Park | 0 | Local Park 2 | 4 | |
10836 | 10836 | 10835 | {"type": "Polygon", "coordinates": [[[-118.09569, 33.9919], [-118.09396, 33.99214], [-118.09371, 33.9911], [-118.09448, 33.991], [-118.0946, 33.99087], [-118.09522, 33.99079], [-118.0953, 33.99135], [-118.09558, 33.99133], [-118.09569, 33.9919]]]} | Open Access 1 | 20612 | Rio Vista Park | 24388 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 4.629 | Rio Vista Park | 0 | Local Park 2 | 4 | |
11921 | 11921 | 11920 | {"type": "Polygon", "coordinates": [[[-118.0623, 34.01805], [-118.06224, 34.01811], [-118.06185, 34.01825], [-118.06179, 34.01823], [-118.0613, 34.01727], [-118.0612, 34.01714], [-118.06107, 34.01702], [-118.06106, 34.01701], [-118.06116, 34.01685], [-118.06111, 34.017], [-118.06138, 34.01708], [-118.06136, 34.01714], [-118.06136, 34.0172], [-118.06143, 34.01729], [-118.06191, 34.01745], [-118.06202, 34.01753], [-118.0623, 34.01805]]]} | Open Access 1 | 24523 | Obregon Park | 23044 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 1.31 | Obregon Park | 0 | Local Park 2 | 4 | |
15356 | 15356 | 15355 | {"type": "Polygon", "coordinates": [[[-118.07871, 34.00112], [-118.07866, 34.00128], [-118.07717, 34.00072], [-118.07722, 34.00056], [-118.07871, 34.00112]]]} | Open Access 1 | 46545 | Veterans & Ladies Auxiliary Park | 29842 | 1250 | Pico Rivera, City of 372 | City 2 | City Agency 2 | http://www.ci.pico-rivera.ca.us/depts/parks/default.asp | City 2 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 0.681 | Veterans & Ladies Auxiliary Park | 0 | Local Park 2 | 4 | |
15358 | 15358 | 15357 | {"type": "Polygon", "coordinates": [[[-118.08395, 34.01292], [-118.0835, 34.01349], [-118.08385, 34.01371], [-118.08368, 34.0139], [-118.08365, 34.01392], [-118.08362, 34.01391], [-118.08245, 34.01323], [-118.08312, 34.01244], [-118.08395, 34.01292]]]} | Restricted Access 2 | 46547 | Pio Pico Playground | 31638 | 2369 | El Rancho Unified School District 1156 | Special District 4 | School District 14 | http://www.erusd.org/ | Special District 4 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 2.817 | Pio Pico Playground | 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]);