units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "Ballona Creek Trail and Bike Path"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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]);