units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 299 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7501 | 7501 | 7500 | {"type": "Polygon", "coordinates": [[[-118.06106, 34.12845], [-118.06062, 34.12848], [-118.06059, 34.12846], [-118.06057, 34.1282], [-118.06102, 34.12816], [-118.06106, 34.12845]]]} | Open Access 1 | 7031 | Tripolis Friendship Park | 26548 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 0.338 | Tripolis Friendship Park | 0 | Local Park 2 | 4 | |
7502 | 7502 | 7501 | {"type": "MultiPolygon", "coordinates": [[[[-118.02669, 34.14612], [-118.02669, 34.14614], [-118.02638, 34.14615], [-118.02639, 34.14695], [-118.02597, 34.14598], [-118.02608, 34.14574], [-118.02607, 34.1457], [-118.02629, 34.14579], [-118.0263, 34.14593], [-118.02669, 34.14612]]], [[[-118.02678, 34.14829], [-118.02546, 34.14831], [-118.02542, 34.14582], [-118.02556, 34.14582], [-118.02561, 34.14591], [-118.02569, 34.14601], [-118.02628, 34.14738], [-118.02639, 34.14739], [-118.02678, 34.14829]]]]} | Open Access 1 | 7032 | Eisenhower Memorial Park | 18472 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 5.381 | Eisenhower Memorial Park | 0 | Local Park 2 | 4 | |
15669 | 15669 | 15668 | {"type": "MultiPolygon", "coordinates": [[[[-118.02002, 34.10015], [-118.01922, 34.10279], [-118.01789, 34.10253], [-118.0166, 34.10528], [-118.01621, 34.10549], [-118.01575, 34.10339], [-118.01574, 34.10313], [-118.01578, 34.1029], [-118.0159, 34.10259], [-118.01597, 34.10246], [-118.01711, 34.10129], [-118.01857, 34.10015], [-118.01908, 34.09991], [-118.02002, 34.10015]]], [[[-118.01617, 34.10551], [-118.01607, 34.10557], [-118.01603, 34.10544], [-118.01577, 34.10423], [-118.01587, 34.10418], [-118.01617, 34.10551]]]]} | Restricted Access 2 | 7036 | Arcadia Par-3 Golf Course | 33024 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 25.879 | Arcadia Par-3 GC | 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]);