superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 490 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11295 | 11295 | 11294 | {"type": "Polygon", "coordinates": [[[-118.28281, 33.79807], [-118.28277, 33.79811], [-118.28159, 33.79818], [-118.28109, 33.7982], [-118.28103, 33.79816], [-118.28044, 33.79421], [-118.28048, 33.79417], [-118.28222, 33.79408], [-118.28227, 33.79411], [-118.28264, 33.79654], [-118.28281, 33.79807]]]} | Open Access 1 | Wilmington Athletic Complex | 27597 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/ | Special District 4 | 18.852 | Wilmington Athletic Complex | ||
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} | No Public Access 3 | South Coast Park/former Palos Verdes Landfill site | http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ | 29032 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/ | Special District 4 | 30.501 | South Coast Park/former Palos Verdes Landfill site | |
14809 | 14809 | 14808 | {"type": "MultiPolygon", "coordinates": [[[[-118.54153, 34.1232], [-118.54026, 34.1238], [-118.53947, 34.12475], [-118.53884, 34.12578], [-118.53848, 34.12649], [-118.53809, 34.12682], [-118.53673, 34.12774], [-118.53504, 34.12779], [-118.53397, 34.12799], [-118.53231, 34.12799], [-118.53153, 34.12835], [-118.53087, 34.12893], [-118.5307, 34.12926], [-118.52867, 34.12888], [-118.52827, 34.12871], [-118.52785, 34.12858], [-118.52733, 34.12846], [-118.52678, 34.12839], [-118.5262, 34.12835], [-118.52558, 34.12836], [-118.52547, 34.12833], [-118.52528, 34.12834], [-118.52487, 34.12783], [-118.52486, 34.12745], [-118.52448, 34.12688], [-118.52452, 34.12654], [-118.52438, 34.12622], [-118.52443, 34.12596], [-118.5246, 34.12563], [-118.52497, 34.12551], [-118.52529, 34.12499], [-118.52577, 34.1243], [-118.52602, 34.12352], [-118.52583, 34.12319], [-118.52555, 34.1229], [-118.52533, 34.12243], [-118.52513, 34.1221], [-118.52512, 34.12192], [-118.525, 34.12175], [-118.52495, 34.12106], [-118.52483, 34.12038], [-118.52459, 34.12006], [-118.52444, 34.11978], [-118.52436, 34.11978], [-118.52404, 34.11946], [-118.52389, 34.11924], [-118.52385, 34.11913], [-118.52388, 34.11883], [-118.52386, 34.1187], [-118.52379, 34.1186], [-118.52326, 34.11819], [-118.52298, 34.1178], [-118.5229, 34.11762], [-118.52259, 34.11719], [-118.52244, 34.11708], [-118.52231, 34.11703], [-118.52199, 34.11697], [-118.5218, 34.11686], [-118.5215, 34.11663], [-118.52139, 34.11649], [-118.52115, 34.116], [-118.52109, 34.11574], [-118.52117, 34.11526], [-118.52104, 34.11472], [-118.52105, 34.11422], [-118.52094, 34.11377], [-118.52095, 34.11366], [-118.5212, 34.11293], [-118.52119, 34.11266], [-118.52108, 34.11242], [-118.52073, 34.11204], [-118.52051, 34.1117], [-118.52048, 34.11156], [-118.52057, 34.11099], [-118.52077, 34.11059], [-118.52079, 34.11045], [-118.52066, 34.11004], [-118.52062, 34.10981], [-118.52065, 34.10967], [-118.52077, 34.10944], [-118.5211, 34.10702], [-118.52116, 34.10626], [-118.52127, 34.10578], [-118.52132, 34.10547], [-118.52147, 34.10502], [-118.52158, 34.10432], [-118.52152, 34.10394], [-118.52143, 34.10359], [-118.5215, 34.10304], [-118.52146, 34.1019], [-118.52134, 34.10163], [-118.52083, 34.10088], [-118.52077, 34.10063], [-118.52065, 34.09978], [-118.52053, 34.09947], [-118.52019, 34.0991], [-118.51992, 34.0986], [-118.51983, 34.09834], [-118.51979, 34.09795], [-118.5195, 34.09757], [-118.51936, 34.09706], [-118.51927, 34.0965], [-118.51931, 34.09594], [-118.51949, 34.0953], [-118.51944, 34.09493], [-118.51934, 34.09458], [-118.51949, 34.09428], [-118.51953, 34.09399], [-118.51942, 34.09353], [-118.51949, 34.09274], [-118.51933, 34.09219], [-118.51936, 34.09197], [-118.5195, 34.0917], [-118.51953, 34.09151], [-118.51948, 34.09133], [-118.5192, 34.0909], [-118.51929, 34.09069], [-118.51941, 34.09055], [-118.51947, 34.09039], [-118.51947, 34.09013], [-118.51901, 34.08979], [-118.51903, 34.08951], [-118.51924, 34.08904], [-118.51924, 34.08888], [-118.51918, 34.08873], [-118.51875, 34.08827], [-118.51834, 34.08776], [-118.51812, 34.08712], [-118.51781, 34.08667], [-118.51777, 34.08652], [-118.5178, 34.08632], [-118.51768, 34.08581], [-118.5176, 34.0852], [-118.51748, 34.08502], [-118.51732, 34.08487], [-118.51681, 34.08455], [-118.51664, 34.0841], [-118.51655, 34.08285], [-118.51647, 34.08268], [-118.51631, 34.08252], [-118.51568, 34.08215], [-118.51477, 34.0819], [-118.51356, 34.08106], [-118.51607, 34.08105], [-118.51671, 34.0812], [-118.51683, 34.08124], [-118.51699, 34.08133], [-118.51716, 34.08146], [-118.51731, 34.08166], [-118.51738, 34.08182], [-118.51745, 34.08214], [-118.51749, 34.08224], [-118.51757, 34.08233], [-118.51767, 34.0824], [-118.51791, 34.08252], [-118.51802, 34.08259], [-118.51811, 34.08268], [-118.51825, 34.08289], [-118.51835, 34.08297], [-118.51962, 34.08355], [-118.51972, 34.08361], [-118.51976, 34.08366], [-118.51983, 34.08378], [-118.51981, 34.08417], [-118.51988, 34.0843], [-118.51995, 34.08436], [-118.5208, 34.08478], [-118.52097, 34.08481], [-118.52165, 34.08482], [-118.52181, 34.08486], [-118.52195, 34.08492], [-118.5221, 34.08503], [-118.52216, 34.0851], [-118.52237, 34.08544], [-118.52232, 34.08548], [-118.52259, 34.0859], [-118.52269, 34.086], [-118.52284, 34.08611], [-118.523, 34.0862], [-118.52355, 34.08637], [-118.52365, 34.08643], [-118.52405, 34.08675], [-118.52419, 34.08683], [-118.52433, 34.08689], [-118.5245, 34.08693], [-118.52465, 34.08695], [-118.5251, 34.08696], [-118.52523, 34.087], [-118.52535, 34.08707], [-118.52671, 34.08852], [-118.52678, 34.08866], [-118.52729, 34.08995], [-118.5273, 34.09003], [-118.52729, 34.09012], [-118.52717, 34.09046], [-118.52718, 34.09068], [-118.52724, 34.0908], [-118.52732, 34.0909], [-118.52765, 34.09119], [-118.5278, 34.09108], [-118.52787, 34.091], [-118.5279, 34.09092], [-118.5279, 34.09072], [-118.52793, 34.09062], [-118.528, 34.09053], [-118.52815, 34.09045], [-118.52828, 34.09043], [-118.52842, 34.09045], [-118.52896, 34.09069], [-118.52897, 34.09121], [-118.52892, 34.09168], [-118.52887, 34.09195], [-118.5288, 34.09223], [-118.52865, 34.09268], [-118.52828, 34.09362], [-118.52814, 34.09409], [-118.52808, 34.09438], [-118.52803, 34.09487], [-118.52791, 34.09676], [-118.52783, 34.09732], [-118.52774, 34.09773], [-118.52754, 34.09842], [-118.52713, 34.09953], [-118.52698, 34.10011], [-118.52693, 34.10062], [-118.52695, 34.10113], [-118.52701, 34.1015], [-118.52716, 34.10201], [-118.52738, 34.10249], [-118.52893, 34.10526], [-118.52913, 34.10565], [-118.5294, 34.10625], [-118.52956, 34.10666], [-118.52977, 34.10728], [-118.52996, 34.10793], [-118.53019, 34.10851], [-118.5304, 34.10892], [-118.5306, 34.10923], [-118.53077, 34.10946], [-118.53121, 34.10995], [-118.5315, 34.11021], [-118.53188, 34.11051], [-118.53239, 34.11084], [-118.53312, 34.1112], [-118.5348, 34.11185], [-118.53533, 34.1121], [-118.53574, 34.11235], [-118.53613, 34.11262], [-118.53648, 34.11293], [-118.53668, 34.11312], [-118.53698, 34.11346], [-118.53719, 34.11375], [-118.53742, 34.11412], [-118.53758, 34.11444], [-118.53852, 34.11695], [-118.5389, 34.11783], [-118.54004, 34.12028], [-118.54081, 34.1222], [-118.54095, 34.12247], [-118.54118, 34.12281], [-118.54153, 34.1232]]], [[[-118.5255, 34.12357], [-118.52531, 34.12414], [-118.52487, 34.12477], [-118.52461, 34.12519], [-118.52421, 34.12531], [-118.52396, 34.12584], [-118.52387, 34.12624], [-118.52401, 34.12659], [-118.52398, 34.12697], [-118.52436, 34.12757], [-118.52437, 34.12796], [-118.52471, 34.12839], [-118.52466, 34.12839], [-118.52453, 34.12833], [-118.52433, 34.12827], [-118.52261, 34.12799], [-118.52247, 34.12791], [-118.52224, 34.12781], [-118.52206, 34.12777], [-118.52239, 34.12474], [-118.52282, 34.12449], [-118.52367, 34.1244], [-118.52377, 34.12416], [-118.52274, 34.12369], [-118.51879, 34.12367], [-118.51934, 34.12629], [-118.52103, 34.1279], [-118.51927, 34.12865], [-118.51893, 34.12866], [-118.5182, 34.12866], [-118.51801, 34.12862], [-118.51779, 34.12863], [-118.51712, 34.12532], [-118.5168, 34.12193], [-118.51854, 34.1198], [-118.52392, 34.11979], [-118.52414, 34.12026], [-118.52436, 34.12053], [-118.52445, 34.1211], [-118.5245, 34.12188], [-118.52463, 34.12205], [-118.52464, 34.12222], [-118.52488, 34.12259], [-118.52512, 34.12311], [-118.52542, 34.12342], [-118.5255, 34.12357]]], [[[-118.55679, 34.10704], [-118.55662, 34.11055], [-118.55474, 34.11145], [-118.55425, 34.11209], [-118.55391, 34.11221], [-118.55376, 34.11282], [-118.55423, 34.11288], [-118.55435, 34.11342], [-118.55425, 34.11388], [-118.55395, 34.1143], [-118.55393, 34.11468], [-118.55381, 34.1149], [-118.5536, 34.11502], [-118.55367, 34.11525], [-118.55348, 34.11565], [-118.55323, 34.11584], [-118.55313, 34.11633], [-118.55303, 34.11654], [-118.55271, 34.11667], [-118.55283, 34.11694], [-118.55249, 34.1176], [-118.55219, 34.11789], [-118.55169, 34.11794], [-118.55192, 34.11875], [-118.55186, 34.11885], [-118.55132, 34.11909], [-118.55172, 34.11963], [-118.55134, 34.12014], [-118.55127, 34.12062], [-118.55074, 34.12086], [-118.54197, 34.11798], [-118.54135, 34.11834], [-118.54306, 34.12125], [-118.54249, 34.12193], [-118.54211, 34.1227], [-118.54175, 34.12305], [-118.54167, 34.12299], [-118.54137, 34.12266], [-118.54124, 34.12246], [-118.54106, 34.12212], [-118.54029, 34.1202], [-118.53915, 34.11775], [-118.53876, 34.11688], [-118.53786, 34.11444], [-118.53775, 34.11419], [-118.53747, 34.11372], [-118.53714, 34.11327], [-118.53682, 34.11291], [-118.53631, 34.11247], [-118.5359, 34.11218], [-118.53565, 34.11202], [-118.53512, 34.11174], [-118.53468, 34.11155], [-118.53315, 34.11097], [-118.53254, 34.11066], [-118.53237, 34.11056], [-118.53183, 34.11018], [-118.53135, 34.10975], [-118.53111, 34.10948], [-118.53083, 34.10912], [-118.53068, 34.1089], [-118.53044, 34.10844], [-118.53024, 34.10795], [-118.53003, 34.10722], [-118.52981, 34.10659], [-118.52965, 34.10618], [-118.52937, 34.10557], [-118.52916, 34.10517], [-118.52764, 34.10242], [-118.52762, 34.1024], [-118.52746, 34.10207], [-118.5273, 34.1016], [-118.52722, 34.10119], [-118.52719, 34.1007], [-118.52719, 34.10049], [-118.52725, 34.10007], [-118.52736, 34.09966], [-118.52788, 34.09821], [-118.528, 34.09778], [-118.52809, 34.09735], [-118.52817, 34.09677], [-118.5283, 34.0947], [-118.52834, 34.09442], [-118.52842, 34.09405], [-118.52857, 34.09358], [-118.52897, 34.09256], [-118.52913, 34.09196], [-118.52916, 34.09265], [-118.52867, 34.09367], [-118.52872, 34.09667], [-118.52948, 34.09797], [-118.52858, 34.09836], [-118.52846, 34.09896], [-118.5283, 34.09937], [-118.52862, 34.09971], [-118.52828, 34.10015], [-118.52759, 34.10139], [-118.52857, 34.1022], [-118.52885, 34.10259], [-118.52891, 34.10364], [-118.53015, 34.10507], [-118.53049, 34.10562], [-118.53051, 34.10625], [-118.53043, 34.10681], [-118.53085, 34.10814], [-118.53102, 34.10843], [-118.53135, 34.10885], [-118.53176, 34.10918], [-118.53318, 34.11016], [-118.53439, 34.11073], [-118.54135, 34.10781], [-118.55126, 34.10807], [-118.55255, 34.10749], [-118.55189, 34.10543], [-118.5532, 34.10513], [-118.55484, 34.10598], [-118.55541, 34.10586], [-118.55679, 34.10704]]]]} | Open Access 1 | L.A. County Sanitation District Open Space | 11624 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/ | Special District 4 | 1888.142 | L.A. County Sanitation District OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);