units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 2, AGNCY_ID = 305, DES_TP = 3 and MNG_AG_TYP = 7
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency - Parks · 7 ✖
MNG_AGENCY 1
DES_TP 1
- Local Recreation Area · 7 ✖
ACCESS_TYP 1
- Restricted 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3123 | 3123 | 3122 | {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.4166, 34.314], [-118.4166, 34.31401], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31502], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41572, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41317, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.3115], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.31141], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} | Restricted Access 2 | 48023 | El Cariso Golf Course | 32460 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 85.199 | El Cariso GC | 0 | Local Recreation Area 3 | 4 | |
4893 | 4893 | 4892 | {"type": "Polygon", "coordinates": [[[-118.16594, 33.93752], [-118.16221, 33.93558], [-118.16115, 33.93702], [-118.16153, 33.93723], [-118.16126, 33.93762], [-118.165, 33.9395], [-118.16218, 33.94234], [-118.16209, 33.94232], [-118.15913, 33.94078], [-118.16046, 33.93896], [-118.15653, 33.93691], [-118.15822, 33.93461], [-118.15991, 33.93242], [-118.16013, 33.93217], [-118.16097, 33.93257], [-118.16356, 33.93388], [-118.16407, 33.93321], [-118.16436, 33.9333], [-118.16477, 33.93321], [-118.16508, 33.93298], [-118.16609, 33.93537], [-118.16594, 33.93752]]]} | Restricted Access 2 | 45855 | Los Amigos Golf Course | 32491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3D3ANNDPULsh0VAQpfACU!/ | Los Angeles 6 | 120.886 | Los Amigos GC | 0 | Local Recreation Area 3 | 4 |
5764 | 5764 | 5763 | {"type": "Polygon", "coordinates": [[[-118.31393, 33.94717], [-118.31391, 33.94733], [-118.31392, 33.949], [-118.31321, 33.949], [-118.3132, 33.94905], [-118.31299, 33.94906], [-118.31298, 33.949], [-118.31178, 33.94901], [-118.31177, 33.94775], [-118.31161, 33.94728], [-118.3116, 33.94704], [-118.3124, 33.94704], [-118.31241, 33.94717], [-118.3133, 33.94717], [-118.31329, 33.94588], [-118.31393, 33.94588], [-118.31393, 33.94717]]]} | Restricted Access 2 | 6211 | Maggie Hathaway Golf Course | 32489 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 12.466 | Maggie Hathaway GC | 0 | Local Recreation Area 3 | 4 | |
7384 | 7384 | 7383 | {"type": "MultiPolygon", "coordinates": [[[[-117.75565, 34.14631], [-117.75553, 34.14714], [-117.75483, 34.1482], [-117.75272, 34.15092], [-117.75047, 34.15094], [-117.75081, 34.15065], [-117.75101, 34.15053], [-117.75273, 34.14962], [-117.75307, 34.1494], [-117.75341, 34.14911], [-117.7536, 34.14891], [-117.75565, 34.14631]]], [[[-117.75567, 34.14565], [-117.75562, 34.14593], [-117.75555, 34.14608], [-117.75543, 34.1463], [-117.75346, 34.14879], [-117.75329, 34.14898], [-117.75306, 34.14919], [-117.75271, 34.14943], [-117.75105, 34.1503], [-117.75068, 34.15053], [-117.75049, 34.15067], [-117.75008, 34.15106], [-117.74901, 34.1523], [-117.74894, 34.15235], [-117.74876, 34.15247], [-117.74856, 34.15255], [-117.74841, 34.1526], [-117.74818, 34.15264], [-117.74703, 34.15265], [-117.74681, 34.15262], [-117.74662, 34.15256], [-117.74658, 34.15137], [-117.74647, 34.14969], [-117.74586, 34.14597], [-117.75013, 34.14351], [-117.75014, 34.14318], [-117.75037, 34.14309], [-117.75042, 34.14294], [-117.75065, 34.14274], [-117.7508, 34.14274], [-117.75097, 34.14262], [-117.75147, 34.14253], [-117.75189, 34.14258], [-117.75194, 34.14258], [-117.75204, 34.14273], [-117.7528, 34.14244], [-117.75279, 34.14352], [-117.75422, 34.14353], [-117.75379, 34.14549], [-117.75567, 34.14565]]], [[[-117.75033, 34.15136], [-117.74915, 34.15243], [-117.74893, 34.15258], [-117.74874, 34.15267], [-117.74861, 34.15271], [-117.74889, 34.1526], [-117.74919, 34.15238], [-117.75024, 34.15115], [-117.75033, 34.15107], [-117.75033, 34.15136]]]]} | Restricted Access 2 | 6781 | Marshall Canyon Golf Course | 32492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 157.54 | Marshall Canyon GC | 0 | Local Recreation Area 3 | 4 | |
15668 | 15668 | 15667 | {"type": "MultiPolygon", "coordinates": [[[[-118.0811, 34.16216], [-118.08104, 34.16259], [-118.08093, 34.16271], [-118.08087, 34.16287], [-118.08084, 34.16316], [-118.08097, 34.16318], [-118.08058, 34.16641], [-118.08051, 34.16641], [-118.0805, 34.16649], [-118.0805, 34.16684], [-118.08044, 34.16691], [-118.0803, 34.16711], [-118.08014, 34.16749], [-118.08008, 34.16794], [-118.08006, 34.16839], [-118.07996, 34.16874], [-118.07985, 34.16905], [-118.07963, 34.16951], [-118.07945, 34.1698], [-118.07912, 34.17028], [-118.07902, 34.17045], [-118.07896, 34.17062], [-118.07904, 34.17066], [-118.07896, 34.17081], [-118.07893, 34.17095], [-118.07897, 34.17142], [-118.07725, 34.17059], [-118.07677, 34.17044], [-118.07725, 34.1699], [-118.07797, 34.16832], [-118.0781, 34.16829], [-118.07808, 34.16819], [-118.07808, 34.16794], [-118.07801, 34.16776], [-118.07794, 34.16767], [-118.07787, 34.16761], [-118.07781, 34.16756], [-118.07767, 34.1675], [-118.07801, 34.1668], [-118.07807, 34.16683], [-118.0782, 34.16656], [-118.07814, 34.16654], [-118.07852, 34.16519], [-118.07867, 34.16438], [-118.07856, 34.16431], [-118.07863, 34.16427], [-118.07863, 34.16426], [-118.07839, 34.16409], [-118.07851, 34.16358], [-118.07786, 34.16347], [-118.07837, 34.1619], [-118.07982, 34.16188], [-118.07968, 34.16205], [-118.07962, 34.16215], [-118.07954, 34.16241], [-118.07955, 34.16242], [-118.07972, 34.16239], [-118.07977, 34.16221], [-118.07985, 34.16208], [-118.0799, 34.16202], [-118.08007, 34.16188], [-118.08086, 34.16187], [-118.08089, 34.16189], [-118.08089, 34.16192], [-118.08086, 34.16215], [-118.08107, 34.16211], [-118.0811, 34.16216]]], [[[-118.08637, 34.16367], [-118.08296, 34.16371], [-118.08264, 34.16329], [-118.08239, 34.16307], [-118.0822, 34.16294], [-118.08178, 34.1625], [-118.08176, 34.1625], [-118.08174, 34.16273], [-118.08153, 34.16267], [-118.08143, 34.16259], [-118.08137, 34.16259], [-118.0813, 34.16263], [-118.08122, 34.1626], [-118.0812, 34.16255], [-118.08128, 34.16189], [-118.08133, 34.16186], [-118.08539, 34.16181], [-118.08539, 34.16263], [-118.08619, 34.16263], [-118.08637, 34.16367]]]]} | Restricted Access 2 | 6972 | Eaton Canyon Golf Course | 32483 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 72.049 | Eaton Canyon GC | 0 | Local Recreation Area 3 | 4 | |
15670 | 15670 | 15669 | {"type": "MultiPolygon", "coordinates": [[[[-117.82298, 34.00931], [-117.82283, 34.00935], [-117.82285, 34.00942], [-117.82262, 34.00997], [-117.82239, 34.0103], [-117.8221, 34.01066], [-117.82141, 34.01145], [-117.82045, 34.01247], [-117.81939, 34.01369], [-117.81895, 34.01423], [-117.81792, 34.01559], [-117.81716, 34.0165], [-117.81428, 34.01933], [-117.81308, 34.01781], [-117.81286, 34.0177], [-117.81479, 34.01516], [-117.81665, 34.01383], [-117.81651, 34.01257], [-117.81514, 34.01064], [-117.81561, 34.01027], [-117.81631, 34.00983], [-117.82166, 34.00683], [-117.82172, 34.00683], [-117.82176, 34.00685], [-117.82194, 34.0071], [-117.82233, 34.00774], [-117.82252, 34.00813], [-117.82274, 34.00866], [-117.82298, 34.00931]]], [[[-117.82998, 34.00371], [-117.82917, 34.00439], [-117.82774, 34.00547], [-117.82702, 34.00603], [-117.82699, 34.00606], [-117.82701, 34.00608], [-117.82489, 34.00787], [-117.82467, 34.00809], [-117.82428, 34.00843], [-117.82418, 34.00849], [-117.82414, 34.00859], [-117.82372, 34.00894], [-117.82358, 34.00893], [-117.82338, 34.00909], [-117.82333, 34.00903], [-117.82323, 34.0089], [-117.82265, 34.00767], [-117.82228, 34.00704], [-117.82203, 34.00671], [-117.82201, 34.00664], [-117.82205, 34.00659], [-117.82244, 34.00638], [-117.82264, 34.00625], [-117.82287, 34.00606], [-117.82311, 34.00581], [-117.82333, 34.00548], [-117.82391, 34.0044], [-117.82417, 34.00405], [-117.82451, 34.00371], [-117.82484, 34.00346], [-117.825, 34.00336], [-117.82538, 34.00316], [-117.82579, 34.00299], [-117.8264, 34.00283], [-117.82673, 34.00279], [-117.82725, 34.00277], [-117.82757, 34.00278], [-117.82785, 34.00282], [-117.82993, 34.00368], [-117.82998, 34.00371]]]]} | Restricted Access 2 | 7047 | Diamond Bar Golf Course | 32474 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 172.308 | Diamond Bar GC | 0 | Local Recreation Area 3 | 4 | |
15676 | 15676 | 15675 | {"type": "MultiPolygon", "coordinates": [[[[-118.4942, 34.29493], [-118.49415, 34.29507], [-118.49406, 34.29546], [-118.49398, 34.29564], [-118.49388, 34.29576], [-118.49377, 34.29585], [-118.49361, 34.29593], [-118.49356, 34.29593], [-118.49288, 34.29503], [-118.49267, 34.29486], [-118.49254, 34.2948], [-118.49238, 34.29474], [-118.49203, 34.29281], [-118.49207, 34.29277], [-118.49231, 34.29268], [-118.49226, 34.29252], [-118.49245, 34.29228], [-118.49248, 34.29102], [-118.49251, 34.29044], [-118.49302, 34.28836], [-118.4933, 34.2875], [-118.4937, 34.28756], [-118.494, 34.28756], [-118.49381, 34.28959], [-118.49379, 34.28994], [-118.494, 34.29018], [-118.49392, 34.29019], [-118.49391, 34.2902], [-118.4941, 34.29062], [-118.49412, 34.29083], [-118.49405, 34.29088], [-118.49394, 34.29102], [-118.49388, 34.29114], [-118.49387, 34.29127], [-118.49396, 34.29129], [-118.49405, 34.29126], [-118.49376, 34.29298], [-118.49376, 34.29349], [-118.49418, 34.29492], [-118.4942, 34.29493]]], [[[-118.49991, 34.28395], [-118.49999, 34.28414], [-118.50004, 34.28432], [-118.50006, 34.28453], [-118.50005, 34.28472], [-118.49999, 34.28496], [-118.49981, 34.28542], [-118.49976, 34.28561], [-118.49975, 34.28585], [-118.49979, 34.28607], [-118.49963, 34.28617], [-118.49955, 34.28571], [-118.49952, 34.28562], [-118.49945, 34.28549], [-118.49929, 34.28532], [-118.49873, 34.28494], [-118.4988, 34.28434], [-118.49846, 34.28411], [-118.49758, 34.28399], [-118.49621, 34.28343], [-118.49538, 34.28512], [-118.49468, 34.28629], [-118.49379, 34.28742], [-118.49335, 34.28736], [-118.49368, 34.28635], [-118.49478, 34.28437], [-118.49481, 34.28394], [-118.49493, 34.2835], [-118.49507, 34.28331], [-118.49523, 34.28248], [-118.49531, 34.28243], [-118.49546, 34.28253], [-118.49561, 34.28259], [-118.49767, 34.28311], [-118.498, 34.28316], [-118.49919, 34.28318], [-118.49936, 34.28321], [-118.4995, 34.28328], [-118.49963, 34.2834], [-118.49991, 34.28395]]], [[[-118.50165, 34.28881], [-118.5016, 34.28915], [-118.50156, 34.28947], [-118.50144, 34.28946], [-118.50101, 34.28961], [-118.50098, 34.28965], [-118.50098, 34.29018], [-118.50094, 34.29022], [-118.50093, 34.29027], [-118.50125, 34.29157], [-118.50127, 34.29178], [-118.50126, 34.2919], [-118.501, 34.29307], [-118.50096, 34.29311], [-118.50079, 34.29308], [-118.50059, 34.293], [-118.50001, 34.29269], [-118.50024, 34.29217], [-118.50036, 34.29168], [-118.49992, 34.29064], [-118.49946, 34.29044], [-118.4993, 34.2906], [-118.49927, 34.29055], [-118.49903, 34.29075], [-118.49893, 34.29094], [-118.49894, 34.29096], [-118.498, 34.2919], [-118.49834, 34.29256], [-118.49699, 34.29319], [-118.49685, 34.29299], [-118.49632, 34.29308], [-118.496, 34.29255], [-118.49674, 34.29172], [-118.49757, 34.2909], [-118.49736, 34.29063], [-118.49636, 34.29057], [-118.49468, 34.2908], [-118.49463, 34.29009], [-118.49619, 34.28974], [-118.49639, 34.28887], [-118.49662, 34.28872], [-118.49859, 34.28869], [-118.49852, 34.28743], [-118.49882, 34.28581], [-118.499, 34.2853], [-118.49918, 34.28543], [-118.49929, 34.28553], [-118.49936, 34.28564], [-118.4994, 34.28576], [-118.49947, 34.28626], [-118.49953, 34.28639], [-118.49948, 34.28643], [-118.49953, 34.28753], [-118.49965, 34.28818], [-118.49992, 34.28829], [-118.50061, 34.28866], [-118.50107, 34.28884], [-118.50127, 34.28863], [-118.50142, 34.28871], [-118.50161, 34.28876], [-118.50165, 34.28881]], [[-118.49983, 34.28885], [-118.49989, 34.28876], [-118.49989, 34.28871], [-118.49987, 34.28867], [-118.4998, 34.28864], [-118.49971, 34.28866], [-118.4996, 34.28878], [-118.49972, 34.28892], [-118.49978, 34.28895], [-118.49983, 34.28888], [-118.49983, 34.28885]]], [[[-118.5016, 34.30115], [-118.50107, 34.30139], [-118.50004, 34.30151], [-118.49895, 34.30146], [-118.49826, 34.3016], [-118.49776, 34.30181], [-118.49746, 34.30136], [-118.49735, 34.30115], [-118.49704, 34.30032], [-118.49717, 34.30019], [-118.49715, 34.29925], [-118.49684, 34.29855], [-118.49654, 34.29794], [-118.49626, 34.29628], [-118.49639, 34.29519], [-118.49677, 34.29415], [-118.4972, 34.29352], [-118.49706, 34.29331], [-118.49814, 34.2928], [-118.49832, 34.29308], [-118.49839, 34.2934], [-118.49733, 34.29595], [-118.49735, 34.29737], [-118.49816, 34.29904], [-118.49822, 34.2997], [-118.49845, 34.3006], [-118.50031, 34.3008], [-118.5007, 34.30057], [-118.50034, 34.29979], [-118.50069, 34.29969], [-118.50095, 34.29955], [-118.5015, 34.30017], [-118.50163, 34.30069], [-118.5016, 34.30115]]], [[[-118.50112, 34.2985], [-118.50113, 34.29861], [-118.50097, 34.29904], [-118.50112, 34.29926], [-118.50079, 34.29948], [-118.50066, 34.29955], [-118.50046, 34.29962], [-118.50007, 34.2997], [-118.49994, 34.29723], [-118.49966, 34.29668], [-118.49918, 34.29446], [-118.49995, 34.29282], [-118.50054, 34.29314], [-118.50024, 34.29448], [-118.50054, 34.29591], [-118.50097, 34.2972], [-118.5011, 34.29829], [-118.50097, 34.29844], [-118.50096, 34.2985], [-118.50112, 34.2985]]]]} | Restricted Access 2 | 12346 | Knollwood Golf Course | 32668 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-golf-course/ | Los Angeles 6 | 151.317 | Knollwood GC | 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]);