units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 8 sorted by AGNCY_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5313 | 5313 | 5312 | {"type": "Polygon", "coordinates": [[[-122.40596, 37.71374], [-122.40581, 37.71398], [-122.40589, 37.71402], [-122.40573, 37.71427], [-122.4055, 37.71418], [-122.40565, 37.71394], [-122.40558, 37.7139], [-122.40573, 37.71365], [-122.40596, 37.71374]]]} | Open Access 1 | 6024 | Reis Tract Lots - Arleta I | 24283 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.348 | Reis Tract Lots - Arleta I | 0 | Local Other or Unknown 14 | 4 | |
6832 | 6832 | 6831 | {"type": "MultiPolygon", "coordinates": [[[[-122.40617, 37.71487], [-122.40605, 37.71513], [-122.40573, 37.71504], [-122.40583, 37.71478], [-122.40549, 37.71466], [-122.40564, 37.71442], [-122.40582, 37.71449], [-122.40603, 37.71454], [-122.40593, 37.7148], [-122.40617, 37.71487]]], [[[-122.40653, 37.71572], [-122.40641, 37.71598], [-122.40609, 37.71589], [-122.4062, 37.71564], [-122.40612, 37.71561], [-122.40624, 37.71535], [-122.40639, 37.7154], [-122.40629, 37.71566], [-122.40653, 37.71572]]], [[[-122.40689, 37.71658], [-122.40678, 37.71684], [-122.40645, 37.71675], [-122.40656, 37.71649], [-122.40632, 37.71642], [-122.40643, 37.71616], [-122.40676, 37.71625], [-122.40665, 37.71651], [-122.40689, 37.71658]]]]} | Open Access 1 | 5446 | Reis Tract Lots - Tucker | 24285 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 1.334 | Reis Tract Lots - Tucker | 0 | Local Other or Unknown 14 | 4 | |
6833 | 6833 | 6832 | {"type": "MultiPolygon", "coordinates": [[[[-122.4062, 37.71304], [-122.40605, 37.71328], [-122.40613, 37.71332], [-122.40597, 37.71356], [-122.40582, 37.7135], [-122.40597, 37.71327], [-122.40589, 37.71323], [-122.40605, 37.71298], [-122.4062, 37.71304]]], [[[-122.40652, 37.71237], [-122.40637, 37.71261], [-122.40644, 37.71265], [-122.40629, 37.71289], [-122.40614, 37.71283], [-122.40628, 37.7126], [-122.40621, 37.71256], [-122.40636, 37.71231], [-122.40652, 37.71237]]]]} | Open Access 1 | 5452 | Reis Tract Lots - Arleta Ii | 24284 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.462 | Reis Tract Lots - Arleta Ii | 0 | Local Other or Unknown 14 | 4 | |
4167 | 4167 | 4166 | {"type": "Polygon", "coordinates": [[[-118.20389, 33.83208], [-118.20324, 33.83744], [-118.20316, 33.83872], [-118.20316, 33.83917], [-118.20311, 33.8393], [-118.20288, 33.84212], [-118.20281, 33.84232], [-118.20272, 33.84362], [-118.20264, 33.84403], [-118.20264, 33.84624], [-118.20261, 33.84653], [-118.20155, 33.84653], [-118.20155, 33.84626], [-118.20186, 33.84297], [-118.20215, 33.83915], [-118.20219, 33.83906], [-118.2025, 33.83476], [-118.2025, 33.83437], [-118.20269, 33.83211], [-118.20269, 33.83186], [-118.20277, 33.83168], [-118.20294, 33.83065], [-118.20296, 33.83039], [-118.20389, 33.83208]]]} | Open Access 1 | 48292 | Dominguez Gap Wetlands | 32867 | 375 | Los Angeles Department of Public Works, County of 729 | County 3 | County Agency - Other 9 | http://dpw.lacounty.gov/ | County 3 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 39.283 | Dominguez Gap Wetlands | 2008 | Local Conservation Area 4 | 2 | |
11149 | 11149 | 11148 | {"type": "Polygon", "coordinates": [[[-118.74257, 34.03285], [-118.74156, 34.03296], [-118.73843, 34.03315], [-118.73603, 34.03334], [-118.73257, 34.03315], [-118.73256, 34.03316], [-118.73223, 34.0332], [-118.7308, 34.03308], [-118.72999, 34.033], [-118.73003, 34.03274], [-118.72998, 34.03271], [-118.72974, 34.03268], [-118.72822, 34.03245], [-118.72662, 34.03222], [-118.72427, 34.03197], [-118.72278, 34.03177], [-118.7223, 34.03172], [-118.7215, 34.03167], [-118.72061, 34.03152], [-118.71938, 34.03135], [-118.71848, 34.0314], [-118.71785, 34.03146], [-118.71648, 34.03156], [-118.71599, 34.03156], [-118.71554, 34.03158], [-118.71503, 34.03154], [-118.71434, 34.03147], [-118.71321, 34.03118], [-118.71225, 34.03096], [-118.71116, 34.03074], [-118.7102, 34.03048], [-118.7093, 34.03026], [-118.70891, 34.03019], [-118.70841, 34.03002], [-118.70794, 34.02989], [-118.70726, 34.02975], [-118.70682, 34.02968], [-118.70661, 34.02967], [-118.70651, 34.02923], [-118.70685, 34.02927], [-118.70751, 34.02941], [-118.70787, 34.02954], [-118.70806, 34.02966], [-118.70854, 34.02981], [-118.70941, 34.03004], [-118.70977, 34.03009], [-118.71028, 34.03011], [-118.71096, 34.03028], [-118.7112, 34.03038], [-118.7117, 34.0305], [-118.71225, 34.03059], [-118.7125, 34.03066], [-118.71291, 34.03088], [-118.71325, 34.03102], [-118.71349, 34.03114], [-118.71434, 34.03135], [-118.71464, 34.03139], [-118.71488, 34.03138], [-118.71514, 34.03142], [-118.71541, 34.03136], [-118.71581, 34.03141], [-118.7162, 34.03143], [-118.71653, 34.03138], [-118.71692, 34.03138], [-118.71766, 34.03127], [-118.71866, 34.03109], [-118.71905, 34.03098], [-118.71935, 34.03093], [-118.71968, 34.03097], [-118.71994, 34.03107], [-118.7203, 34.03111], [-118.7224, 34.03144], [-118.72307, 34.03166], [-118.72372, 34.03175], [-118.72519, 34.03187], [-118.72521, 34.03182], [-118.72546, 34.03187], [-118.7275, 34.03214], [-118.72806, 34.03228], [-118.72847, 34.03231], [-118.72882, 34.03239], [-118.73039, 34.0325], [-118.73173, 34.03267], [-118.73322, 34.03281], [-118.73401, 34.03287], [-118.73542, 34.03301], [-118.7359, 34.03304], [-118.73608, 34.03301], [-118.73625, 34.033], [-118.73651, 34.03307], [-118.737, 34.03305], [-118.73735, 34.03309], [-118.73764, 34.0331], [-118.73798, 34.03308], [-118.73897, 34.03295], [-118.73966, 34.03291], [-118.74017, 34.03286], [-118.74111, 34.03282], [-118.74171, 34.03275], [-118.74224, 34.03264], [-118.74252, 34.03255], [-118.74257, 34.03285]]]} | Open Access 1 | 47988 | Puerco Beach | 32408 | 378 | Los Angeles County Department of Beaches and Harbors, County of 966 | County 3 | County Agency - Other 9 | http://dpw.lacounty.gov/dbh/ | County 3 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | Los Angeles 6 | 24.244 | Puerco Beach | 0 | Local Park 2 | 4 | |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 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]);