units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 272
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 11
ACCESS_TYP 1
- Open Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
876 | 876 | 875 | {"type": "Polygon", "coordinates": [[[-118.36225, 33.96855], [-118.36199, 33.96877], [-118.3617, 33.96878], [-118.3617, 33.96902], [-118.3608, 33.96978], [-118.35917, 33.96897], [-118.35922, 33.96886], [-118.35924, 33.96886], [-118.35955, 33.96848], [-118.35954, 33.96836], [-118.35907, 33.96893], [-118.35885, 33.96881], [-118.35884, 33.96808], [-118.3594, 33.96695], [-118.36169, 33.96828], [-118.36209, 33.96849], [-118.36225, 33.96855]]]} | Open Access 1 | 6290 | Rogers Park | 24561 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 12.808 | Rogers Park | 0 | Local Park 2 | 4 | |
877 | 877 | 876 | {"type": "Polygon", "coordinates": [[[-118.36875, 33.95782], [-118.36872, 33.95811], [-118.36872, 33.95829], [-118.36868, 33.95861], [-118.36851, 33.95933], [-118.36833, 33.9606], [-118.36829, 33.95783], [-118.36875, 33.95782]]]} | Open Access 1 | 6291 | Ashwood Park | 15657 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.68 | Ashwood Park | 0 | Local Park 2 | 4 | |
878 | 878 | 877 | {"type": "Polygon", "coordinates": [[[-118.34509, 33.96217], [-118.34509, 33.96257], [-118.34443, 33.96258], [-118.34443, 33.96178], [-118.34493, 33.96177], [-118.34492, 33.96216], [-118.34509, 33.96217]]]} | Open Access 1 | 6292 | Queen Park | 24062 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.18 | Queen Park | 0 | Local Park 2 | 4 | |
879 | 879 | 878 | {"type": "Polygon", "coordinates": [[[-118.36408, 33.94814], [-118.36392, 33.94814], [-118.36391, 33.94821], [-118.36359, 33.94821], [-118.36358, 33.94849], [-118.36351, 33.94847], [-118.36351, 33.94805], [-118.36144, 33.94805], [-118.36144, 33.9478], [-118.36408, 33.9478], [-118.36408, 33.94814]]]} | Open Access 1 | 6293 | Siminski Park | 25508 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.934 | Siminski Park | 0 | Local Park 2 | 4 | |
1014 | 1014 | 1013 | {"type": "Polygon", "coordinates": [[[-118.33732, 33.93475], [-118.33652, 33.93476], [-118.33652, 33.93461], [-118.33636, 33.9346], [-118.33636, 33.93393], [-118.33732, 33.93393], [-118.33732, 33.93475]]]} | Open Access 1 | 6286 | Center Park | 17037 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.945 | Ctr. Park | 0 | Local Park 2 | 4 | |
1018 | 1018 | 1017 | {"type": "MultiPolygon", "coordinates": [[[[-118.34823, 33.97142], [-118.34633, 33.97248], [-118.34403, 33.97374], [-118.34402, 33.97333], [-118.34404, 33.97312], [-118.34403, 33.97217], [-118.34405, 33.97163], [-118.344, 33.9716], [-118.3472, 33.9701], [-118.34823, 33.97142]]], [[[-118.344, 33.97165], [-118.34398, 33.97217], [-118.34399, 33.97312], [-118.34396, 33.97333], [-118.34398, 33.97377], [-118.34396, 33.97379], [-118.34395, 33.97549], [-118.34233, 33.97551], [-118.34231, 33.97592], [-118.34171, 33.97593], [-118.34101, 33.97615], [-118.34058, 33.97617], [-118.34056, 33.97553], [-118.33999, 33.97552], [-118.34, 33.97349], [-118.34396, 33.97163], [-118.344, 33.97165]]]]} | Open Access 1 | 6288 | Vincent Park | 27127 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 50.732 | Vincent Park | 0 | Local Park 2 | 4 | |
2486 | 2486 | 2485 | {"type": "MultiPolygon", "coordinates": [[[[-118.35476, 33.96038], [-118.35458, 33.96037], [-118.35456, 33.95959], [-118.35472, 33.95959], [-118.35476, 33.96038]]], [[[-118.35495, 33.96159], [-118.35464, 33.96161], [-118.35461, 33.96062], [-118.35489, 33.96062], [-118.35495, 33.96159]]]]} | Open Access 1 | 6279 | Grevillea Park | 19503 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.073 | Grevillea Park | 0 | Local Park 2 | 4 | |
2487 | 2487 | 2486 | {"type": "Polygon", "coordinates": [[[-118.32256, 33.96368], [-118.32254, 33.96376], [-118.3225, 33.96384], [-118.32239, 33.96394], [-118.32231, 33.96399], [-118.32221, 33.96402], [-118.32203, 33.96402], [-118.32191, 33.96399], [-118.32176, 33.96388], [-118.32168, 33.96374], [-118.32166, 33.96364], [-118.32171, 33.96349], [-118.32181, 33.96337], [-118.32189, 33.96333], [-118.322, 33.96329], [-118.32216, 33.96328], [-118.32225, 33.9633], [-118.32234, 33.96333], [-118.32248, 33.96344], [-118.32255, 33.96356], [-118.32256, 33.96368]]]} | Open Access 1 | 6280 | Circle Park | 17264 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.316 | Circle Park | 0 | Local Park 2 | 4 | |
2488 | 2488 | 2487 | {"type": "Polygon", "coordinates": [[[-118.33084, 33.9561], [-118.32917, 33.95611], [-118.32915, 33.95528], [-118.32933, 33.95527], [-118.32933, 33.95245], [-118.32973, 33.95246], [-118.32978, 33.95248], [-118.33084, 33.95274], [-118.33084, 33.9561]]]} | Open Access 1 | 6281 | Darby Park | 17925 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 13.903 | Darby Park | 0 | Local Park 2 | 4 | |
7162 | 7162 | 7161 | {"type": "Polygon", "coordinates": [[[-118.37282, 33.96765], [-118.37236, 33.96799], [-118.3721, 33.96783], [-118.37205, 33.96776], [-118.37192, 33.96739], [-118.37247, 33.96718], [-118.37256, 33.96732], [-118.37282, 33.96765]]]} | Open Access 1 | 6284 | Centinela Adobe Park | 17043 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.077 | Centinela Adobe Park | 0 | Local Park 2 | 4 | |
7164 | 7164 | 7163 | {"type": "Polygon", "coordinates": [[[-118.34826, 33.98043], [-118.34743, 33.98044], [-118.34742, 33.97934], [-118.34824, 33.97933], [-118.34826, 33.98043]]]} | Open Access 1 | 6289 | North Park | 22840 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 2.308 | North 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]);