units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 288
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1934 | 1934 | 1933 | {"type": "Polygon", "coordinates": [[[-118.39088, 33.81466], [-118.39079, 33.81519], [-118.39061, 33.81519], [-118.38994, 33.81511], [-118.38992, 33.8151], [-118.38992, 33.81505], [-118.38996, 33.81502], [-118.39011, 33.81484], [-118.39026, 33.8146], [-118.39088, 33.81466]]]} | Open Access 1 | 5985 | Miramar Park | 22286 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.05 | Miramar Park | 0 | Local Park 2 | 4 | |
1937 | 1937 | 1936 | {"type": "Polygon", "coordinates": [[[-118.3711, 33.8099], [-118.36954, 33.8099], [-118.37004, 33.80894], [-118.37004, 33.80833], [-118.37013, 33.80831], [-118.37022, 33.80824], [-118.37028, 33.80807], [-118.3705, 33.80774], [-118.37061, 33.80762], [-118.37075, 33.8075], [-118.37089, 33.80741], [-118.37103, 33.80758], [-118.37109, 33.80758], [-118.37111, 33.80984], [-118.3711, 33.8099]]]} | Open Access 1 | 5994 | Los Arboles Park | 21503 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 6.305 | Los Arboles Park | 0 | Local Park 2 | 4 | |
1938 | 1938 | 1937 | {"type": "Polygon", "coordinates": [[[-118.3567, 33.80956], [-118.3567, 33.81116], [-118.35667, 33.81117], [-118.35664, 33.81117], [-118.35623, 33.81114], [-118.35603, 33.81109], [-118.35596, 33.81109], [-118.35585, 33.81114], [-118.35579, 33.8112], [-118.35577, 33.81125], [-118.35577, 33.81132], [-118.35583, 33.81149], [-118.3558, 33.8127], [-118.35574, 33.81272], [-118.35453, 33.81271], [-118.35451, 33.81269], [-118.35453, 33.80923], [-118.35462, 33.80922], [-118.3547, 33.80924], [-118.35501, 33.80939], [-118.35519, 33.80942], [-118.35668, 33.80954], [-118.3567, 33.80956]]]} | Open Access 1 | 5995 | Lago Seco Park | 20840 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 14.638 | Lago Seco Park | 0 | Local Park 2 | 4 | |
1939 | 1939 | 1938 | {"type": "Polygon", "coordinates": [[[-118.35435, 33.80454], [-118.35435, 33.80563], [-118.35277, 33.80551], [-118.35278, 33.80441], [-118.35435, 33.80454]]]} | Open Access 1 | 5997 | Walteria Park | 27248 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.411 | Walteria Park | 0 | Local Park 2 | 4 | |
1940 | 1940 | 1939 | {"type": "Polygon", "coordinates": [[[-118.34494, 33.79301], [-118.34492, 33.79305], [-118.34466, 33.79321], [-118.34429, 33.79334], [-118.3441, 33.79344], [-118.34397, 33.79361], [-118.34392, 33.79376], [-118.34393, 33.79384], [-118.34395, 33.79393], [-118.34402, 33.79406], [-118.3446, 33.79461], [-118.34474, 33.79472], [-118.34486, 33.79478], [-118.34466, 33.79513], [-118.34181, 33.794], [-118.34202, 33.79363], [-118.34212, 33.79361], [-118.34222, 33.79352], [-118.34229, 33.79333], [-118.34243, 33.79307], [-118.34273, 33.79255], [-118.34284, 33.79243], [-118.34288, 33.79237], [-118.34289, 33.79229], [-118.34284, 33.7922], [-118.343, 33.79194], [-118.34397, 33.79233], [-118.34433, 33.79251], [-118.34452, 33.79264], [-118.34474, 33.79281], [-118.34493, 33.79296], [-118.34494, 33.79301]]]} | Open Access 1 | 5999 | De Portola Park | 17975 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 12.592 | De Portola Park | 0 | Local Park 2 | 4 | |
1944 | 1944 | 1943 | {"type": "Polygon", "coordinates": [[[-118.33649, 33.81859], [-118.33616, 33.81859], [-118.33615, 33.81848], [-118.3343, 33.81811], [-118.33447, 33.81796], [-118.33452, 33.81789], [-118.33492, 33.8171], [-118.33494, 33.81708], [-118.33522, 33.81714], [-118.33555, 33.81718], [-118.3358, 33.81716], [-118.33611, 33.81713], [-118.33647, 33.81713], [-118.33649, 33.81715], [-118.33649, 33.81718], [-118.33649, 33.81859]]]} | Open Access 1 | 6000 | Hickory Park | 19897 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.807 | Hickory Park | 0 | Local Park 2 | 4 | |
3453 | 3453 | 3452 | {"type": "Polygon", "coordinates": [[[-118.3784, 33.80865], [-118.37822, 33.80858], [-118.3782, 33.80855], [-118.37821, 33.80851], [-118.37825, 33.80849], [-118.37843, 33.80846], [-118.37849, 33.80847], [-118.37851, 33.80851], [-118.37849, 33.80863], [-118.37845, 33.80865], [-118.3784, 33.80865]]]} | Open Access 1 | 35560 | Grass Median Calle Miramar and Calle Aragon | 29164 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.108 | Grass Median Calle Miramar and Calle Aragon | None 284 | |||
3455 | 3455 | 3454 | {"type": "Polygon", "coordinates": [[[-118.37003, 33.80894], [-118.36954, 33.8099], [-118.36765, 33.8085], [-118.36743, 33.8087], [-118.36706, 33.80844], [-118.36605, 33.80806], [-118.36594, 33.808], [-118.36527, 33.8074], [-118.36503, 33.80742], [-118.36472, 33.80731], [-118.36486, 33.80704], [-118.36484, 33.80699], [-118.36492, 33.80694], [-118.36495, 33.80685], [-118.36494, 33.8068], [-118.36491, 33.80676], [-118.36471, 33.80663], [-118.36482, 33.80641], [-118.36514, 33.80657], [-118.36525, 33.80649], [-118.3653, 33.80593], [-118.36552, 33.8061], [-118.3655, 33.80627], [-118.36542, 33.80635], [-118.3654, 33.80639], [-118.3654, 33.80644], [-118.36542, 33.80648], [-118.36546, 33.80652], [-118.36553, 33.80654], [-118.3656, 33.80653], [-118.36565, 33.8065], [-118.36617, 33.8068], [-118.36613, 33.80682], [-118.36614, 33.80686], [-118.36596, 33.80689], [-118.36595, 33.8069], [-118.36646, 33.80748], [-118.3679, 33.80801], [-118.37003, 33.80894]]]} | No Public Access 3 | 35563 | Slope-Via Corona | 29195 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 11.822 | Slope-Via Corona | None 285 | |||
3456 | 3456 | 3455 | {"type": "Polygon", "coordinates": [[[-118.35732, 33.82927], [-118.35581, 33.8299], [-118.35559, 33.82945], [-118.35543, 33.82904], [-118.35529, 33.82863], [-118.35518, 33.8282], [-118.35509, 33.82777], [-118.35503, 33.82734], [-118.35501, 33.82703], [-118.35669, 33.82717], [-118.3568, 33.82782], [-118.35691, 33.82827], [-118.35706, 33.8287], [-118.35732, 33.82927]]]} | No Public Access 3 | 35566 | Ocean Sump | 29194 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 10.918 | Ocean Sump | None 286 | |||
3479 | 3479 | 3478 | {"type": "Polygon", "coordinates": [[[-118.3629, 33.80569], [-118.36283, 33.80599], [-118.36103, 33.80567], [-118.35987, 33.80555], [-118.35986, 33.8054], [-118.3629, 33.80569]]]} | Open Access 1 | 35829 | Slope-Vista Largo | 29177 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.571 | Slope-Vista Largo | None 290 | |||
3580 | 3580 | 3579 | {"type": "Polygon", "coordinates": [[[-118.36897, 33.80456], [-118.36893, 33.80458], [-118.36878, 33.80431], [-118.36871, 33.80428], [-118.36847, 33.80438], [-118.36821, 33.80455], [-118.36778, 33.80419], [-118.3688, 33.8042], [-118.36897, 33.80456]]]} | Open Access 1 | 36686 | Torrance holding 28 | 26435 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.536 | Torrance holding 28 | 0 | Local Other or Unknown 14 | 4 | |
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
3898 | 3898 | 3897 | {"type": "Polygon", "coordinates": [[[-118.33191, 33.83843], [-118.33118, 33.83844], [-118.33117, 33.83735], [-118.33189, 33.83735], [-118.33191, 33.83843]]]} | No Public Access 3 | 35859 | Elm Tree Water Yard | 29081 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 2.0 | Elm Tree Water Yard | None 333 | |||
3901 | 3901 | 3900 | {"type": "Polygon", "coordinates": [[[-118.36997, 33.85242], [-118.36984, 33.85268], [-118.3688, 33.85252], [-118.36836, 33.85236], [-118.36835, 33.85206], [-118.36887, 33.85225], [-118.36997, 33.85242]]]} | No Public Access 3 | 35902 | Entradero Swale 1 | 29125 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.121 | Entradero Swale 1 | None 335 | |||
4356 | 4356 | 4355 | {"type": "Polygon", "coordinates": [[[-118.34726, 33.86193], [-118.344, 33.86193], [-118.34399, 33.8613], [-118.3466, 33.8613], [-118.3466, 33.85844], [-118.34725, 33.85844], [-118.34726, 33.85838], [-118.34726, 33.86193]]]} | Open Access 1 | 45709 | Columbia Park | 17547 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 10.024 | Columbia Park | 0 | Local Park 2 | 4 | |
6900 | 6900 | 6899 | {"type": "Polygon", "coordinates": [[[-118.38336, 33.81195], [-118.38333, 33.81228], [-118.3833, 33.81233], [-118.38323, 33.81233], [-118.38281, 33.81199], [-118.38282, 33.81194], [-118.38286, 33.81192], [-118.38333, 33.81192], [-118.38336, 33.81195]]]} | Open Access 1 | 5988 | Riviera Park | 24471 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.372 | Riviera Park | 0 | Local Park 2 | 4 | |
6946 | 6946 | 6945 | {"type": "Polygon", "coordinates": [[[-118.35427, 33.82352], [-118.35426, 33.82376], [-118.35369, 33.82371], [-118.35368, 33.82345], [-118.35424, 33.82349], [-118.35427, 33.82352]]]} | Open Access 1 | 6004 | Discovery Park | 18166 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.395 | Discovery Park | 0 | Local Park 2 | 4 | |
7002 | 7002 | 7001 | {"type": "Polygon", "coordinates": [[[-118.33348, 33.78451], [-118.33347, 33.78464], [-118.333, 33.78463], [-118.33301, 33.78506], [-118.33137, 33.78506], [-118.33136, 33.78393], [-118.3318, 33.78349], [-118.333, 33.78404], [-118.33302, 33.78448], [-118.33348, 33.78451]]]} | Open Access 1 | 5977 | Alta Loma Park | 15416 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.65 | Alta Loma Park | 0 | Local Park 2 | 4 | |
7033 | 7033 | 7032 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.82554], [-118.3448, 33.82767], [-118.34478, 33.828], [-118.34478, 33.82911], [-118.34473, 33.82916], [-118.3444, 33.82916], [-118.3439, 33.82912], [-118.34363, 33.82907], [-118.34337, 33.829], [-118.34312, 33.82892], [-118.34283, 33.82878], [-118.34251, 33.8286], [-118.34055, 33.82731], [-118.34005, 33.82708], [-118.34004, 33.82705], [-118.34003, 33.82566], [-118.34, 33.82542], [-118.33991, 33.82492], [-118.33989, 33.82465], [-118.33991, 33.82444], [-118.33994, 33.82441], [-118.34001, 33.8244], [-118.34081, 33.82457], [-118.34161, 33.8247], [-118.34336, 33.82506], [-118.34421, 33.82514], [-118.34421, 33.82554], [-118.3448, 33.82554]]]} | Open Access 1 | 6005 | Madrona Marsh Preserve | 29331 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 42.371 | Madrona Marsh Preserve | 0 | Local Conservation Area 4 | 2 | |
7034 | 7034 | 7033 | {"type": "Polygon", "coordinates": [[[-118.35936, 33.81965], [-118.35935, 33.82005], [-118.35857, 33.81965], [-118.35904, 33.81964], [-118.35936, 33.81965]]]} | Open Access 1 | 6006 | La Paloma Park | 20781 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.411 | La Paloma Park | 0 | Local Park 2 | 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]);