superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where MNG_AGENCY = 272 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1637 | 1637 | 1636 | {"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 | Ashwood Park | 15657 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.68 | Ashwood Park | ||
2050 | 2050 | 2049 | {"type": "Polygon", "coordinates": [[[-118.33732, 33.93475], [-118.33652, 33.93476], [-118.33651, 33.93461], [-118.33636, 33.9346], [-118.33636, 33.93393], [-118.33732, 33.93393], [-118.33732, 33.93475]]]} | Open Access 1 | Center Park | 17037 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.945 | Ctr. Park | ||
2759 | 2759 | 2758 | {"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 | Centinela Adobe Park | 17043 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.077 | Centinela Adobe Park | ||
2947 | 2947 | 2946 | {"type": "Polygon", "coordinates": [[[-118.32256, 33.96368], [-118.32254, 33.96376], [-118.3225, 33.96384], [-118.32239, 33.96395], [-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.32167, 33.96364], [-118.32171, 33.96349], [-118.32181, 33.96337], [-118.32189, 33.96333], [-118.32199, 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 | Circle Park | 17264 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.316 | Circle Park | ||
3439 | 3439 | 3438 | {"type": "Polygon", "coordinates": [[[-118.33084, 33.9561], [-118.32917, 33.95611], [-118.32915, 33.95528], [-118.32933, 33.95526], [-118.32933, 33.95245], [-118.32973, 33.95246], [-118.32978, 33.95248], [-118.33084, 33.95274], [-118.33084, 33.9561]]]} | Open Access 1 | Darby Park | 17925 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 13.903 | Darby Park | ||
4750 | 4750 | 4749 | {"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 | Grevillea Park | 19503 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.072 | Grevillea Park | ||
6324 | 6324 | 6323 | {"type": "Polygon", "coordinates": [[[-118.33984, 33.93393], [-118.33983, 33.93417], [-118.33942, 33.93417], [-118.33943, 33.93394], [-118.33984, 33.93393]]]} | Open Access 1 | Lockhaven Center Playground | 21396 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 0.244 | Lockhaven Ctr. Playground | ||
7448 | 7448 | 7447 | {"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 | North Park | 22840 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 2.307 | North Park | ||
7508 | 7508 | 7507 | {"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.35954, 33.96848], [-118.35954, 33.96837], [-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 | Rogers Park | 24561 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 12.818 | Rogers Park | ||
8451 | 8451 | 8450 | {"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.96215], [-118.34509, 33.96217]]]} | Open Access 1 | Queen Park | 24062 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.182 | Queen Park | ||
9694 | 9694 | 9693 | {"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.3635, 33.94805], [-118.36144, 33.94805], [-118.36144, 33.9478], [-118.36408, 33.9478], [-118.36408, 33.94814]]]} | Open Access 1 | Siminski Park | 25508 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.941 | Siminski Park | ||
10901 | 10901 | 10900 | {"type": "MultiPolygon", "coordinates": [[[[-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]]], [[[-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.97164], [-118.344, 33.9716], [-118.3472, 33.9701], [-118.34823, 33.97142]]]]} | Open Access 1 | Vincent Park | 27127 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 50.74 | Vincent Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);