units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where AGNCY_LEV = 4 and MNG_AGENCY = 286
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
943 | 943 | 942 | {"type": "Polygon", "coordinates": [[[-118.27882, 33.74921], [-118.27815, 33.74968], [-118.27802, 33.74974], [-118.27789, 33.74976], [-118.27754, 33.74975], [-118.27741, 33.7497], [-118.27737, 33.74959], [-118.27431, 33.74883], [-118.27439, 33.74872], [-118.27446, 33.74854], [-118.27431, 33.74848], [-118.27435, 33.7484], [-118.2745, 33.74844], [-118.27759, 33.74948], [-118.2778, 33.74945], [-118.27835, 33.74882], [-118.27882, 33.74921]]]} | Open Access 1 | 5961 | Cruise Ship Promenade | 29098 | 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 | http://www.portoflosangeles.org/ | Los Angeles 6 | 3.946 | Cruise Ship Promenade | None 85 | ||
7019 | 7019 | 7018 | {"type": "Polygon", "coordinates": [[[-118.28592, 33.71434], [-118.28588, 33.71469], [-118.28592, 33.71498], [-118.28564, 33.71556], [-118.28542, 33.71631], [-118.28546, 33.71662], [-118.28435, 33.7181], [-118.28417, 33.7184], [-118.28345, 33.71926], [-118.28338, 33.71977], [-118.28316, 33.72016], [-118.28318, 33.72028], [-118.28308, 33.72031], [-118.28345, 33.7209], [-118.28395, 33.72204], [-118.28411, 33.72244], [-118.28426, 33.72301], [-118.28445, 33.7239], [-118.28434, 33.72394], [-118.28389, 33.72397], [-118.28306, 33.72182], [-118.28152, 33.72222], [-118.28118, 33.72129], [-118.28269, 33.72088], [-118.28241, 33.72004], [-118.28248, 33.72002], [-118.28236, 33.71965], [-118.28222, 33.71969], [-118.28216, 33.71947], [-118.28226, 33.71943], [-118.28193, 33.71853], [-118.28185, 33.71854], [-118.28176, 33.71823], [-118.28044, 33.71852], [-118.28044, 33.7186], [-118.28016, 33.71866], [-118.27982, 33.71774], [-118.28155, 33.71727], [-118.28161, 33.71721], [-118.28173, 33.71692], [-118.28178, 33.71669], [-118.2815, 33.71617], [-118.28043, 33.71566], [-118.28029, 33.71561], [-118.2791, 33.71561], [-118.279, 33.71563], [-118.27841, 33.71586], [-118.27837, 33.71586], [-118.27833, 33.71583], [-118.27831, 33.71578], [-118.27832, 33.71575], [-118.2784, 33.7157], [-118.27901, 33.71552], [-118.27912, 33.7155], [-118.28029, 33.71548], [-118.28042, 33.71549], [-118.28159, 33.71607], [-118.2819, 33.71666], [-118.28264, 33.71686], [-118.28323, 33.71682], [-118.28341, 33.71662], [-118.28376, 33.71619], [-118.28391, 33.71596], [-118.28418, 33.71546], [-118.28439, 33.71495], [-118.28448, 33.71454], [-118.2845, 33.71434], [-118.28592, 33.71434]]]} | Open Access 1 | 5954 | Cabrillo Beach Marina and Recreation Complex | 29073 | 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 | Los Angeles 6 | 45.403 | Cabrillo Beach Marina and Rec. Complex | 0 | Local Recreation Area 3 | 4 |
7020 | 7020 | 7019 | {"type": "Polygon", "coordinates": [[[-118.28054, 33.74937], [-118.28035, 33.74943], [-118.28005, 33.74926], [-118.27972, 33.749], [-118.27957, 33.74883], [-118.27934, 33.74842], [-118.27924, 33.74812], [-118.27912, 33.74757], [-118.27911, 33.74733], [-118.27952, 33.74733], [-118.27958, 33.74747], [-118.28053, 33.74908], [-118.28054, 33.74937]]]} | Open Access 1 | 5962 | Gateway Plaza | 29103 | 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 | 3.492 | Gateway Plaza | 0 | Local Park 2 | 4 | |
7021 | 7021 | 7020 | {"type": "Polygon", "coordinates": [[[-118.27952, 33.74733], [-118.2791, 33.74733], [-118.27909, 33.74602], [-118.2791, 33.74184], [-118.2791, 33.74155], [-118.27906, 33.7414], [-118.27932, 33.74155], [-118.2794, 33.74155], [-118.27939, 33.74317], [-118.27943, 33.74318], [-118.27946, 33.74316], [-118.27948, 33.7434], [-118.27939, 33.74341], [-118.27938, 33.74663], [-118.27939, 33.74687], [-118.27944, 33.7471], [-118.27952, 33.74733]]]} | Open Access 1 | 5963 | Harbor Boulevard Parkway | 29110 | 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 | 4.463 | Harbor Boulevard Parkway | 0 | Local Recreation Area 3 | 4 | |
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 |
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]);