units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, COUNTY = 6, DES_TP = 3, LAYER = 4 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY 6
MNG_AG_TYP 1
- City Agency · 7 ✖
DES_TP 1
- Local Recreation Area · 7 ✖
ACCESS_TYP 1
- Open Access · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
11436 | 11436 | 11435 | {"type": "Polygon", "coordinates": [[[-117.97437, 34.13762], [-117.97437, 34.13876], [-117.97364, 34.13876], [-117.97363, 34.13856], [-117.9732, 34.13856], [-117.97319, 34.13882], [-117.97203, 34.13883], [-117.97202, 34.13765], [-117.97437, 34.13762]]]} | Open Access 1 | 48129 | Montgomery Fields | 32649 | 2316 | Duarte Unified School District 978 | Special District 4 | School District 14 | http://www.duarte.k12.ca.us/ | Special District 4 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 6.662 | Montgomery Fields | 0 | Local Recreation Area 3 | 4 | |
12087 | 12087 | 12086 | {"type": "MultiPolygon", "coordinates": [[[[-118.41597, 33.98684], [-118.41682, 33.98637], [-118.4172, 33.9861], [-118.42424, 33.98091], [-118.42423, 33.98089], [-118.42749, 33.97856], [-118.42905, 33.97752], [-118.43012, 33.97684], [-118.43162, 33.97594], [-118.4325, 33.97537], [-118.43253, 33.97541], [-118.43245, 33.97547], [-118.4325, 33.97555], [-118.43243, 33.97558], [-118.4323, 33.9756], [-118.43172, 33.97596], [-118.43135, 33.97616], [-118.43008, 33.97693], [-118.42908, 33.97756], [-118.42733, 33.97874], [-118.42729, 33.97875], [-118.42705, 33.97891], [-118.4252, 33.98023], [-118.42496, 33.98044], [-118.42282, 33.98202], [-118.42282, 33.98203], [-118.42297, 33.98218], [-118.42288, 33.98224], [-118.42275, 33.98209], [-118.42269, 33.98213], [-118.41929, 33.9846], [-118.41722, 33.98613], [-118.41612, 33.98697], [-118.41605, 33.98692], [-118.41584, 33.98705], [-118.41533, 33.98744], [-118.41532, 33.98748], [-118.41257, 33.98955], [-118.4119, 33.98993], [-118.41174, 33.99009], [-118.4118, 33.99018], [-118.41172, 33.9902], [-118.40635, 33.99335], [-118.40617, 33.99349], [-118.40518, 33.99448], [-118.40502, 33.99457], [-118.405, 33.99449], [-118.40512, 33.99441], [-118.40631, 33.99332], [-118.41069, 33.99074], [-118.41186, 33.98988], [-118.41254, 33.98952], [-118.41525, 33.98747], [-118.41575, 33.98698], [-118.41597, 33.98684]]], [[[-118.40476, 33.9948], [-118.40448, 33.99506], [-118.40385, 33.99577], [-118.40371, 33.99594], [-118.403, 33.99677], [-118.40288, 33.99699], [-118.40277, 33.99766], [-118.40238, 33.99838], [-118.40239, 33.99842], [-118.4016, 33.9998], [-118.40152, 33.99976], [-118.40198, 33.99897], [-118.40229, 33.99853], [-118.40229, 33.99852], [-118.40137, 33.99966], [-118.40126, 33.99987], [-118.4012, 33.99986], [-118.40137, 33.99952], [-118.40229, 33.99834], [-118.40271, 33.99759], [-118.40282, 33.99697], [-118.40295, 33.99674], [-118.4036, 33.996], [-118.40378, 33.99575], [-118.40399, 33.99553], [-118.40442, 33.99499], [-118.4045, 33.99491], [-118.40476, 33.9948]]], [[[-118.40076, 34.00143], [-118.40066, 34.00171], [-118.40048, 34.00221], [-118.40042, 34.00218], [-118.40059, 34.00163], [-118.40068, 34.00143], [-118.40076, 34.00143]]], [[[-118.37695, 34.02689], [-118.37693, 34.02697], [-118.37689, 34.02697], [-118.37687, 34.02699], [-118.37674, 34.02699], [-118.37649, 34.02765], [-118.3765, 34.02765], [-118.37664, 34.02745], [-118.3768, 34.02705], [-118.37687, 34.02701], [-118.37669, 34.02745], [-118.37653, 34.0277], [-118.3764, 34.02785], [-118.37638, 34.0279], [-118.37635, 34.02789], [-118.37669, 34.02699], [-118.37625, 34.02698], [-118.37626, 34.02689], [-118.37623, 34.02686], [-118.37627, 34.02684], [-118.37632, 34.02687], [-118.37672, 34.02687], [-118.37681, 34.02654], [-118.37689, 34.02614], [-118.37694, 34.02617], [-118.37688, 34.02654], [-118.37678, 34.02687], [-118.37692, 34.02687], [-118.37692, 34.02688], [-118.37695, 34.02689]]]]} | Open Access 1 | 46847 | Ballona Creek Trail and Bike Path | 30330 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 7.103 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
12179 | 12179 | 12178 | {"type": "MultiPolygon", "coordinates": [[[[-118.38534, 34.02767], [-118.38533, 34.02775], [-118.38316, 34.02755], [-118.38313, 34.02751], [-118.38309, 34.0275], [-118.38298, 34.02753], [-118.38198, 34.02744], [-118.38195, 34.02739], [-118.38189, 34.02736], [-118.38182, 34.02738], [-118.38178, 34.02742], [-118.38094, 34.02734], [-118.38089, 34.02732], [-118.38082, 34.02733], [-118.38001, 34.02726], [-118.3797, 34.02726], [-118.37928, 34.02722], [-118.37927, 34.02723], [-118.37835, 34.02715], [-118.37835, 34.0271], [-118.37701, 34.02698], [-118.37683, 34.02711], [-118.37688, 34.02697], [-118.37693, 34.02697], [-118.37696, 34.02687], [-118.37985, 34.02713], [-118.38058, 34.02722], [-118.38187, 34.02732], [-118.38261, 34.02742], [-118.38439, 34.0276], [-118.38534, 34.02767]]], [[[-118.37843, 34.02209], [-118.37823, 34.02223], [-118.37792, 34.02253], [-118.37772, 34.02278], [-118.37754, 34.0231], [-118.37743, 34.02339], [-118.37735, 34.02373], [-118.37719, 34.02459], [-118.37694, 34.02617], [-118.37689, 34.02614], [-118.37706, 34.02505], [-118.37732, 34.02354], [-118.37746, 34.02312], [-118.37759, 34.02288], [-118.37777, 34.02264], [-118.37802, 34.02233], [-118.37831, 34.02207], [-118.37843, 34.02209]]], [[[-118.3894, 34.01753], [-118.38804, 34.01937], [-118.38793, 34.0195], [-118.3877, 34.01973], [-118.38746, 34.01993], [-118.38719, 34.02011], [-118.38689, 34.02028], [-118.38683, 34.02025], [-118.38618, 34.02045], [-118.38437, 34.02073], [-118.38192, 34.02117], [-118.38012, 34.02145], [-118.37941, 34.02159], [-118.37886, 34.02181], [-118.3786, 34.02198], [-118.37848, 34.02196], [-118.37891, 34.02172], [-118.37924, 34.02159], [-118.37958, 34.02149], [-118.37995, 34.02141], [-118.38256, 34.021], [-118.38282, 34.02093], [-118.38381, 34.02079], [-118.38605, 34.02043], [-118.38691, 34.02013], [-118.38744, 34.0198], [-118.38767, 34.01961], [-118.38797, 34.01929], [-118.38927, 34.01747], [-118.3894, 34.01753]]], [[[-118.39626, 34.00748], [-118.39489, 34.00787], [-118.39486, 34.00782], [-118.39472, 34.00783], [-118.39467, 34.00785], [-118.39467, 34.00787], [-118.39449, 34.00792], [-118.39447, 34.00791], [-118.3943, 34.00795], [-118.39392, 34.00807], [-118.39372, 34.00814], [-118.39342, 34.00828], [-118.39314, 34.00844], [-118.39311, 34.00842], [-118.39299, 34.00851], [-118.39295, 34.00854], [-118.39297, 34.00856], [-118.39284, 34.00866], [-118.39282, 34.00865], [-118.39262, 34.00883], [-118.39236, 34.00915], [-118.39222, 34.00938], [-118.39211, 34.00962], [-118.39203, 34.00987], [-118.39197, 34.01026], [-118.39197, 34.01111], [-118.392, 34.01112], [-118.39205, 34.01123], [-118.392, 34.01128], [-118.392, 34.01136], [-118.39205, 34.01142], [-118.39214, 34.01256], [-118.39142, 34.01421], [-118.39072, 34.01513], [-118.39064, 34.01526], [-118.39061, 34.01536], [-118.3904, 34.01569], [-118.39004, 34.0162], [-118.39001, 34.0163], [-118.38976, 34.01679], [-118.38968, 34.01708], [-118.38946, 34.01743], [-118.3893, 34.01735], [-118.39002, 34.01615], [-118.39057, 34.01534], [-118.39061, 34.01523], [-118.39138, 34.01422], [-118.39175, 34.01334], [-118.39194, 34.01259], [-118.39199, 34.01209], [-118.392, 34.01137], [-118.39195, 34.01131], [-118.39197, 34.01112], [-118.39192, 34.01109], [-118.39192, 34.01039], [-118.39193, 34.01012], [-118.39198, 34.00986], [-118.39206, 34.00961], [-118.39218, 34.00936], [-118.39232, 34.00912], [-118.3925, 34.0089], [-118.3928, 34.00861], [-118.39311, 34.00838], [-118.39338, 34.00823], [-118.39386, 34.00805], [-118.39482, 34.00775], [-118.39482, 34.00772], [-118.39611, 34.00728], [-118.39626, 34.00748]]], [[[-118.40046, 34.0022], [-118.39956, 34.00495], [-118.39937, 34.00545], [-118.39916, 34.00583], [-118.39902, 34.00601], [-118.39899, 34.006], [-118.39878, 34.00623], [-118.39844, 34.00653], [-118.39818, 34.0067], [-118.3979, 34.00686], [-118.39739, 34.00708], [-118.39641, 34.00737], [-118.39631, 34.00723], [-118.39746, 34.00699], [-118.39765, 34.00694], [-118.398, 34.00676], [-118.39838, 34.0065], [-118.39877, 34.00616], [-118.39901, 34.00588], [-118.39842, 34.00569], [-118.39834, 34.0057], [-118.39795, 34.00605], [-118.39791, 34.00603], [-118.39823, 34.0057], [-118.39835, 34.00555], [-118.39848, 34.00532], [-118.39858, 34.00535], [-118.39845, 34.00565], [-118.39904, 34.00584], [-118.39907, 34.00582], [-118.39922, 34.00559], [-118.3999, 34.00373], [-118.40042, 34.00218], [-118.40046, 34.0022]]], [[[-118.40141, 34.00002], [-118.40121, 34.00039], [-118.40123, 34.00041], [-118.40094, 34.00091], [-118.40074, 34.00142], [-118.40068, 34.00143], [-118.4012, 33.99986], [-118.40126, 33.99987], [-118.40106, 34.00058], [-118.40138, 34.0], [-118.40141, 34.00002]]], [[[-118.40502, 33.99457], [-118.40495, 33.99462], [-118.40476, 33.9948], [-118.4045, 33.99491], [-118.40491, 33.99456], [-118.405, 33.99449], [-118.40502, 33.99457]]]]} | Open Access 1 | 46848 | Ballona Creek Trail and Bike Path | 30331 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 9.968 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
15245 | 15245 | 15244 | {"type": "MultiPolygon", "coordinates": [[[[-118.11714, 33.88168], [-118.11705, 33.88172], [-118.11518, 33.88074], [-118.11387, 33.87997], [-118.10923, 33.87712], [-118.10987, 33.87717], [-118.11517, 33.88042], [-118.11714, 33.88145], [-118.11714, 33.88168]]], [[[-118.12513, 33.88586], [-118.11962, 33.88303], [-118.11818, 33.88229], [-118.11864, 33.88221], [-118.12292, 33.8844], [-118.12415, 33.88503], [-118.1244, 33.88538], [-118.12513, 33.88572], [-118.12513, 33.88586]]], [[[-118.13228, 33.8892], [-118.13165, 33.8892], [-118.12539, 33.88599], [-118.12539, 33.88567], [-118.13228, 33.8892]]], [[[-118.13385, 33.89032], [-118.13216, 33.88946], [-118.13216, 33.88942], [-118.1327, 33.88942], [-118.13384, 33.89], [-118.13385, 33.89032]]], [[[-118.14254, 33.89477], [-118.13411, 33.89046], [-118.13411, 33.89013], [-118.14254, 33.89445], [-118.14254, 33.89477]]]]} | Open Access 1 | 46283 | Bellflower Bike Trail | 29575 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 24.976 | Bellflower Bike Trail | 0 | Local Recreation Area 3 | 4 | |
15247 | 15247 | 15246 | {"type": "MultiPolygon", "coordinates": [[[[-118.49458, 34.3588], [-118.49075, 34.36144], [-118.48897, 34.36142], [-118.4889, 34.35963], [-118.48493, 34.35958], [-118.48502, 34.35379], [-118.49356, 34.35386], [-118.49458, 34.3588]]], [[[-118.49593, 34.3615], [-118.49593, 34.3615], [-118.49243, 34.36146], [-118.49569, 34.35921], [-118.49573, 34.35941], [-118.49593, 34.3615]]], [[[-118.50276, 34.35978], [-118.50268, 34.36302], [-118.50179, 34.36301], [-118.4977, 34.36262], [-118.49766, 34.36153], [-118.49695, 34.36151], [-118.49677, 34.35971], [-118.50065, 34.35975], [-118.50113, 34.35577], [-118.50123, 34.35577], [-118.50186, 34.35977], [-118.50276, 34.35978]]], [[[-118.50605, 34.35776], [-118.5061, 34.35822], [-118.50589, 34.35954], [-118.50557, 34.36001], [-118.50551, 34.36061], [-118.50407, 34.36097], [-118.50435, 34.35233], [-118.50448, 34.35247], [-118.50466, 34.35309], [-118.50466, 34.35327], [-118.50481, 34.35353], [-118.50561, 34.35585], [-118.50562, 34.35644], [-118.50588, 34.35693], [-118.50596, 34.35778], [-118.50605, 34.35776]]]]} | Open Access 1 | 46278 | Whitney Elsmere Open Space | 29563 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 233.794 | Whitney Elsmere OS | 0 | Local Recreation Area 3 | 4 | |
15250 | 15250 | 15249 | {"type": "Polygon", "coordinates": [[[-118.10916, 33.88013], [-118.10866, 33.88013], [-118.10864, 33.87975], [-118.10856, 33.87932], [-118.10854, 33.87735], [-118.10858, 33.87736], [-118.10899, 33.87907], [-118.10911, 33.8796], [-118.10916, 33.88013]]]} | Open Access 1 | 46307 | Bellflower Skate Park | 29599 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.328 | Bellflower Skate Park | 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]);