units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where DES_TP = 2 and MNG_AG_TYP = 14 sorted by COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7022 | 7022 | 7021 | {"type": "Polygon", "coordinates": [[[-118.2842, 33.74996], [-118.28396, 33.75], [-118.28374, 33.75009], [-118.28364, 33.75019], [-118.28346, 33.75047], [-118.28311, 33.75031], [-118.28295, 33.75006], [-118.28377, 33.74976], [-118.28397, 33.74971], [-118.28417, 33.74968], [-118.2842, 33.74996]]]} | Open Access 1 | 5970 | Knoll Hill Dog Park | 29113 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | Los Angeles 6 | 1.1 | Knoll Hill Dog Park | 0 | Local Park 2 | 4 | |
15341 | 15341 | 15340 | {"type": "Polygon", "coordinates": [[[-118.27845, 33.7717], [-118.27842, 33.77173], [-118.27628, 33.77185], [-118.27622, 33.77118], [-118.27493, 33.77125], [-118.27471, 33.77127], [-118.27476, 33.77189], [-118.27471, 33.77193], [-118.2677, 33.77232], [-118.26765, 33.77179], [-118.26713, 33.77182], [-118.26707, 33.77111], [-118.26709, 33.77108], [-118.26712, 33.77107], [-118.27804, 33.77047], [-118.27817, 33.7705], [-118.27844, 33.77049], [-118.27848, 33.7705], [-118.2785, 33.77054], [-118.27845, 33.7717]]]} | Open Access 1 | 46523 | Wilmington Waterfront Park | 29811 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | https://www.portoflosangeles.org/recreation/wwpark.asp | Los Angeles 6 | 33.444 | Wilmington Waterfront Park | 0 | Local Park 2 | 4 |
5460 | 5460 | 5459 | {"type": "Polygon", "coordinates": [[[-122.38986, 37.7765], [-122.38982, 37.77659], [-122.38764, 37.77675], [-122.38752, 37.77674], [-122.38739, 37.77668], [-122.38733, 37.77661], [-122.38731, 37.77656], [-122.3873, 37.77609], [-122.38762, 37.77606], [-122.38765, 37.77631], [-122.38769, 37.77639], [-122.38774, 37.77644], [-122.38981, 37.77634], [-122.38986, 37.7765]]]} | Open Access 1 | 6265 | Willie Mccovey Park | 27569 | 2198 | San Francisco, Port of 807 | Special District 4 | Port/Harbor District 15 | http://www.sfport.com/index.aspx?page=60 | Special District 4 | 2198 | San Francisco, Port of 786 | Special District 4 | Port/Harbor District 14 | San Francisco 13 | 1.981 | Willie Mccovey Park | 0 | Local Park 2 | 4 | |
11203 | 11203 | 11202 | {"type": "Polygon", "coordinates": [[[-122.37626, 37.73978], [-122.37529, 37.74023], [-122.37485, 37.73989], [-122.3739, 37.73956], [-122.37326, 37.73843], [-122.3721, 37.73819], [-122.37101, 37.73817], [-122.36935, 37.7382], [-122.36848, 37.73836], [-122.36751, 37.73834], [-122.36779, 37.73814], [-122.36894, 37.73792], [-122.3698, 37.73767], [-122.37124, 37.73722], [-122.37185, 37.73715], [-122.37283, 37.73711], [-122.37388, 37.7373], [-122.37441, 37.73815], [-122.37558, 37.73862], [-122.37528, 37.73937], [-122.37626, 37.73978]]]} | Open Access 1 | 21501 | Heron's Head Park | 19877 | 2198 | San Francisco, Port of 807 | Special District 4 | Port/Harbor District 15 | http://www.sfport.com/index.aspx?page=60 | Special District 4 | 2198 | San Francisco, Port of 786 | Special District 4 | Port/Harbor District 14 | San Francisco 13 | 19.513 | Heron's Head 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]);