units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, LAYER = 9 and MNG_AGENCY = 273
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16649 | 16649 | 16648 | {"type": "MultiPolygon", "coordinates": [[[[-118.34831, 34.00313], [-118.34773, 34.00358], [-118.3476, 34.00373], [-118.34747, 34.00393], [-118.3474, 34.0041], [-118.34731, 34.00446], [-118.34727, 34.0045], [-118.34641, 34.00439], [-118.34582, 34.00436], [-118.3424, 34.00438], [-118.34203, 34.00442], [-118.34175, 34.00448], [-118.3417, 34.00434], [-118.34169, 34.00402], [-118.34342, 34.00384], [-118.34413, 34.00379], [-118.34579, 34.00333], [-118.34655, 34.0035], [-118.34712, 34.0035], [-118.34815, 34.00291], [-118.34831, 34.00313]]], [[[-118.35757, 33.99682], [-118.35756, 33.99689], [-118.35692, 33.99745], [-118.35673, 33.99772], [-118.35663, 33.99797], [-118.35659, 33.99814], [-118.35638, 33.99942], [-118.35633, 33.99965], [-118.35627, 33.99982], [-118.3561, 34.00016], [-118.35594, 34.0004], [-118.35561, 34.00076], [-118.35538, 34.00096], [-118.3546, 34.00146], [-118.35408, 34.00186], [-118.35375, 34.00217], [-118.35199, 34.00392], [-118.35175, 34.00413], [-118.35132, 34.00443], [-118.35113, 34.00452], [-118.35079, 34.00466], [-118.35042, 34.00476], [-118.35005, 34.00483], [-118.34983, 34.00485], [-118.34945, 34.00485], [-118.34902, 34.00481], [-118.34755, 34.00456], [-118.34751, 34.00452], [-118.34751, 34.00448], [-118.34758, 34.00419], [-118.34768, 34.00395], [-118.34776, 34.00384], [-118.34786, 34.00371], [-118.34801, 34.00357], [-118.34838, 34.0033], [-118.34859, 34.00348], [-118.34836, 34.00366], [-118.34859, 34.00376], [-118.34853, 34.00386], [-118.34927, 34.00403], [-118.35055, 34.00383], [-118.35158, 34.00351], [-118.35234, 34.00286], [-118.3527, 34.0022], [-118.35302, 34.00192], [-118.35409, 34.001], [-118.35517, 34.00047], [-118.35562, 34.0], [-118.35649, 33.99812], [-118.3566, 33.99764], [-118.35664, 33.99732], [-118.35661, 33.997], [-118.35729, 33.99636], [-118.35757, 33.99682]]], [[[-118.35787, 34.00675], [-118.35897, 34.00314], [-118.35972, 34.00328], [-118.36002, 34.00231], [-118.35926, 34.00215], [-118.35934, 34.00188], [-118.35937, 34.00168], [-118.35937, 34.00136], [-118.35931, 34.00106], [-118.35917, 34.00073], [-118.35898, 34.00045], [-118.35864, 33.99978], [-118.35847, 33.99934], [-118.35835, 33.99888], [-118.35823, 33.99812], [-118.35823, 33.99798], [-118.35813, 33.99742], [-118.35813, 33.99736], [-118.35817, 33.9973], [-118.3583, 33.99719], [-118.35839, 33.99715], [-118.35883, 33.99703], [-118.35919, 33.99777], [-118.35965, 33.99887], [-118.3597, 33.9989], [-118.35995, 33.99936], [-118.36004, 33.99933], [-118.3601, 33.999], [-118.36013, 33.99897], [-118.36028, 33.99899], [-118.3606, 33.99918], [-118.36063, 33.99924], [-118.36063, 33.99934], [-118.36063, 33.99945], [-118.3606, 33.99957], [-118.36053, 33.99973], [-118.36041, 33.99977], [-118.36034, 33.99984], [-118.36032, 33.9999], [-118.36032, 33.99998], [-118.36038, 34.00007], [-118.36042, 34.00011], [-118.36051, 34.00013], [-118.36052, 34.00016], [-118.36105, 34.00019], [-118.36114, 34.00035], [-118.36114, 34.00042], [-118.3611, 34.00048], [-118.36082, 34.00057], [-118.36092, 34.00077], [-118.36153, 34.00056], [-118.36155, 34.00062], [-118.36145, 34.0008], [-118.36142, 34.00091], [-118.3613, 34.00108], [-118.3613, 34.00114], [-118.36135, 34.00121], [-118.36178, 34.00149], [-118.36212, 34.00184], [-118.3623, 34.00174], [-118.36223, 34.00166], [-118.36225, 34.00157], [-118.36228, 34.00154], [-118.36235, 34.00154], [-118.36278, 34.0017], [-118.36278, 34.00298], [-118.36273, 34.00313], [-118.36273, 34.00359], [-118.36275, 34.00364], [-118.3628, 34.00367], [-118.3631, 34.00368], [-118.36316, 34.0037], [-118.36319, 34.00374], [-118.36323, 34.00383], [-118.36324, 34.00399], [-118.36319, 34.00413], [-118.3631, 34.00423], [-118.36282, 34.00437], [-118.36276, 34.00446], [-118.36273, 34.00547], [-118.36302, 34.00544], [-118.36328, 34.00596], [-118.36435, 34.00558], [-118.36468, 34.00566], [-118.36502, 34.00555], [-118.36533, 34.00575], [-118.36572, 34.00574], [-118.36598, 34.00579], [-118.36632, 34.0058], [-118.36631, 34.006], [-118.36636, 34.00605], [-118.36648, 34.00606], [-118.36656, 34.00613], [-118.36689, 34.00614], [-118.36671, 34.00951], [-118.36649, 34.00944], [-118.36567, 34.00934], [-118.36566, 34.00941], [-118.36559, 34.00955], [-118.36551, 34.00967], [-118.36542, 34.00976], [-118.3658, 34.01021], [-118.36576, 34.01079], [-118.3647, 34.01095], [-118.36353, 34.01238], [-118.36301, 34.01239], [-118.36265, 34.00988], [-118.36257, 34.00983], [-118.3624, 34.00969], [-118.36234, 34.00961], [-118.36226, 34.00946], [-118.36221, 34.00929], [-118.36216, 34.0086], [-118.36176, 34.00861], [-118.36139, 34.00885], [-118.36069, 34.00903], [-118.36059, 34.00947], [-118.36081, 34.01031], [-118.36081, 34.01046], [-118.36079, 34.01051], [-118.36071, 34.01051], [-118.36066, 34.01048], [-118.36064, 34.01035], [-118.36061, 34.0103], [-118.36053, 34.01022], [-118.36016, 34.01048], [-118.35993, 34.01057], [-118.35958, 34.01057], [-118.35944, 34.01133], [-118.35888, 34.01123], [-118.35872, 34.01176], [-118.35801, 34.01162], [-118.35746, 34.01135], [-118.35713, 34.01164], [-118.35676, 34.01253], [-118.35625, 34.01245], [-118.35572, 34.01241], [-118.3558, 34.01214], [-118.35597, 34.01181], [-118.35611, 34.01161], [-118.35636, 34.01132], [-118.35706, 34.01063], [-118.3573, 34.01034], [-118.35742, 34.01017], [-118.35752, 34.00999], [-118.35767, 34.00966], [-118.35777, 34.0093], [-118.35866, 34.00922], [-118.36114, 34.00859], [-118.36145, 34.00849], [-118.36143, 34.00833], [-118.35861, 34.00905], [-118.3578, 34.00913], [-118.35782, 34.00868], [-118.3577, 34.00777], [-118.35772, 34.00736], [-118.35787, 34.00675]], [[-118.36462, 34.00779], [-118.36456, 34.0074], [-118.36387, 34.0075], [-118.36414, 34.00882], [-118.36479, 34.00874], [-118.36462, 34.00779]], [[-118.36192, 34.0073], [-118.36187, 34.00715], [-118.36148, 34.00725], [-118.36159, 34.00757], [-118.36198, 34.00748], [-118.36197, 34.00729], [-118.36192, 34.0073]]], [[[-118.37393, 34.01466], [-118.37395, 34.01485], [-118.37394, 34.0152], [-118.37391, 34.01541], [-118.37382, 34.01581], [-118.3737, 34.01614], [-118.37359, 34.0164], [-118.37276, 34.01791], [-118.37253, 34.01802], [-118.37256, 34.01751], [-118.37183, 34.01748], [-118.3712, 34.01725], [-118.37128, 34.01706], [-118.37118, 34.01685], [-118.37109, 34.01682], [-118.37133, 34.01636], [-118.37063, 34.01611], [-118.37026, 34.01593], [-118.37033, 34.01575], [-118.36672, 34.01562], [-118.36689, 34.0123], [-118.36709, 34.01102], [-118.36736, 34.00572], [-118.36938, 34.0058], [-118.36948, 34.00592], [-118.37003, 34.00645], [-118.37011, 34.00668], [-118.37023, 34.00718], [-118.37035, 34.00732], [-118.37056, 34.00747], [-118.37077, 34.00767], [-118.37082, 34.00774], [-118.37117, 34.00874], [-118.3715, 34.00958], [-118.3719, 34.0107], [-118.37209, 34.01116], [-118.37206, 34.01121], [-118.37215, 34.01131], [-118.37228, 34.01135], [-118.37248, 34.01135], [-118.37279, 34.01143], [-118.37287, 34.01141], [-118.37285, 34.01163], [-118.37286, 34.01191], [-118.37288, 34.01215], [-118.37293, 34.01231], [-118.37293, 34.01239], [-118.37288, 34.01247], [-118.37277, 34.01254], [-118.37284, 34.01268], [-118.37296, 34.01267], [-118.37308, 34.01274], [-118.3732, 34.01294], [-118.37353, 34.01338], [-118.37362, 34.01353], [-118.37369, 34.01368], [-118.37376, 34.01387], [-118.37393, 34.01466]]], [[[-118.38515, 34.01768], [-118.38493, 34.01795], [-118.38487, 34.01797], [-118.38488, 34.01808], [-118.38482, 34.01861], [-118.38479, 34.01875], [-118.38468, 34.01905], [-118.38463, 34.01912], [-118.38483, 34.01923], [-118.38433, 34.01942], [-118.38449, 34.0198], [-118.38271, 34.02031], [-118.38222, 34.02043], [-118.38131, 34.02057], [-118.38089, 34.02012], [-118.38051, 34.01986], [-118.37953, 34.01922], [-118.3791, 34.01929], [-118.37905, 34.01924], [-118.37943, 34.01918], [-118.37944, 34.01917], [-118.37876, 34.01873], [-118.37798, 34.01802], [-118.37914, 34.0173], [-118.37917, 34.01717], [-118.37924, 34.01718], [-118.37942, 34.01713], [-118.38069, 34.01635], [-118.38063, 34.01624], [-118.38053, 34.01615], [-118.38065, 34.01613], [-118.38061, 34.01581], [-118.38068, 34.01557], [-118.38064, 34.01526], [-118.38028, 34.01448], [-118.38298, 34.01585], [-118.38295, 34.01592], [-118.38465, 34.01689], [-118.38437, 34.01723], [-118.38515, 34.01768]], [[-118.38399, 34.01729], [-118.384, 34.01727], [-118.38397, 34.01715], [-118.38387, 34.017], [-118.38379, 34.01693], [-118.38372, 34.01689], [-118.38355, 34.01685], [-118.38334, 34.01686], [-118.38317, 34.01694], [-118.38303, 34.01707], [-118.38297, 34.01723], [-118.38298, 34.01737], [-118.38304, 34.0175], [-118.38312, 34.01758], [-118.38322, 34.01764], [-118.3834, 34.0177], [-118.38362, 34.01769], [-118.38369, 34.01767], [-118.38381, 34.0176], [-118.38395, 34.01746], [-118.38399, 34.01735], [-118.38399, 34.01729]]]]} | Open Access 1 | 6297 | Kenneth Hahn State Recreation Area | 32640 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 396.851 | Kenneth Hahn SRA | 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]);