superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 288
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4722 | 4722 | 4721 | {"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 | La Paloma Park | 20781 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.411 | La Paloma Park | ||
4746 | 4746 | 4745 | {"type": "Polygon", "coordinates": [[[-118.33331, 33.83428], [-118.33231, 33.83429], [-118.3323, 33.83292], [-118.33329, 33.83291], [-118.33331, 33.83428]]]} | Open Access 1 | Greenwood Park | 19489 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 3.436 | Greenwood Park | ||
4766 | 4766 | 4765 | {"type": "Polygon", "coordinates": [[[-118.3567, 33.80956], [-118.3567, 33.81116], [-118.35667, 33.81117], [-118.35664, 33.81117], [-118.35623, 33.81114], [-118.35604, 33.81109], [-118.35597, 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 | Lago Seco Park | 20840 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 14.638 | Lago Seco Park | ||
4817 | 4817 | 4816 | {"type": "Polygon", "coordinates": [[[-118.31349, 33.86923], [-118.31348, 33.86925], [-118.31348, 33.8706], [-118.31239, 33.8706], [-118.3124, 33.86963], [-118.31224, 33.86961], [-118.31223, 33.86931], [-118.31239, 33.86929], [-118.3124, 33.86778], [-118.31349, 33.86779], [-118.31349, 33.86923]]]} | Open Access 1 | Guenser Park | 19562 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 7.932 | Guenser Park | ||
5102 | 5102 | 5101 | {"type": "Polygon", "coordinates": [[[-118.33649, 33.81859], [-118.33616, 33.81859], [-118.33615, 33.81847], [-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 | Hickory Park | 19897 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.808 | Hickory Park | ||
5800 | 5800 | 5799 | {"type": "Polygon", "coordinates": [[[-118.31564, 33.86189], [-118.31348, 33.86189], [-118.31348, 33.86097], [-118.31564, 33.86182], [-118.31564, 33.86189]]]} | Open Access 1 | La Carretera Park | 20746 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.717 | La Carretera Park | ||
5834 | 5834 | 5833 | {"type": "Polygon", "coordinates": [[[-118.36269, 33.85367], [-118.36202, 33.8541], [-118.36103, 33.85437], [-118.36055, 33.85448], [-118.36054, 33.85447], [-118.36051, 33.85428], [-118.36051, 33.85332], [-118.36125, 33.85332], [-118.36126, 33.85297], [-118.36158, 33.85299], [-118.36165, 33.85297], [-118.36168, 33.85295], [-118.36183, 33.85298], [-118.36216, 33.85288], [-118.36233, 33.85316], [-118.36261, 33.85354], [-118.36269, 33.85367]]]} | Open Access 1 | La Romeria Park | 20805 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.595 | La Romeria Park | ||
6409 | 6409 | 6408 | {"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 | Los Arboles Park | 21503 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.305 | Los Arboles Park | ||
6850 | 6850 | 6849 | {"type": "Polygon", "coordinates": [[[-118.33735, 33.8727], [-118.33529, 33.8727], [-118.33524, 33.87266], [-118.33523, 33.87243], [-118.33565, 33.87242], [-118.33573, 33.87236], [-118.33573, 33.87175], [-118.33523, 33.87173], [-118.33524, 33.87142], [-118.33645, 33.87142], [-118.33648, 33.87123], [-118.33735, 33.87123], [-118.33735, 33.8727]]]} | Open Access 1 | McMaster Park | 22057 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.478 | McMaster Park | ||
7042 | 7042 | 7041 | {"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 | Miramar Park | 22286 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.05 | Miramar Park | ||
7775 | 7775 | 7774 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.87548], [-118.3447, 33.8756], [-118.34443, 33.87557], [-118.34446, 33.87536], [-118.3445, 33.87534], [-118.34463, 33.87538], [-118.3448, 33.87548]]]} | Open Access 1 | Osage Park | 23231 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.164 | Osage Park | ||
7935 | 7935 | 7934 | {"type": "Polygon", "coordinates": [[[-118.36568, 33.83592], [-118.36562, 33.83595], [-118.36377, 33.83595], [-118.3636, 33.83502], [-118.36567, 33.83503], [-118.36568, 33.83592]]]} | Open Access 1 | Paradise Park | 23405 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.67 | Paradise Park | ||
8086 | 8086 | 8085 | {"type": "Polygon", "coordinates": [[[-118.34927, 33.86776], [-118.34859, 33.86777], [-118.34859, 33.86737], [-118.34913, 33.86737], [-118.34911, 33.86744], [-118.34914, 33.86747], [-118.3492, 33.86748], [-118.34926, 33.86746], [-118.34927, 33.86776]]]} | Open Access 1 | Pequeno Park | 23603 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.641 | Pequeno Park | ||
8811 | 8811 | 8810 | {"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 | Riviera Park | 24471 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.372 | Riviera Park | ||
9306 | 9306 | 9305 | {"type": "Polygon", "coordinates": [[[-118.36495, 33.84316], [-118.36345, 33.84316], [-118.36344, 33.84143], [-118.36494, 33.84143], [-118.36495, 33.84316]]]} | Open Access 1 | Victor Park | 27071 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 6.597 | Victor Park | ||
9437 | 9437 | 9436 | {"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 | Walteria Park | 27248 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.41 | Walteria Park | ||
10093 | 10093 | 10092 | {"type": "Polygon", "coordinates": [[[-118.37514, 33.85038], [-118.37394, 33.85055], [-118.37358, 33.8487], [-118.37437, 33.84871], [-118.37488, 33.84878], [-118.37492, 33.84881], [-118.37489, 33.84901], [-118.37489, 33.84913], [-118.37514, 33.85038]]]} | Open Access 1 | Sunnyglen Park | 26006 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 5.482 | Sunnyglen Park | ||
10143 | 10143 | 10142 | {"type": "Polygon", "coordinates": [[[-118.3144, 33.81056], [-118.3144, 33.81122], [-118.3118, 33.81121], [-118.31181, 33.80991], [-118.31183, 33.80989], [-118.3134, 33.80989], [-118.31341, 33.81019], [-118.31394, 33.81019], [-118.31394, 33.81023], [-118.31394, 33.81048], [-118.31341, 33.81048], [-118.3134, 33.81055], [-118.3144, 33.81056]]]} | Open Access 1 | Sur La Brea Park | 26075 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 7.427 | Sur La Brea Park | ||
10400 | 10400 | 10399 | {"type": "Polygon", "coordinates": [[[-118.39238, 33.80932], [-118.39214, 33.81043], [-118.39191, 33.81038], [-118.39196, 33.81012], [-118.39199, 33.81009], [-118.39203, 33.81009], [-118.39212, 33.80992], [-118.39225, 33.80948], [-118.39233, 33.8093], [-118.39238, 33.80932]]]} | Open Access 1 | Torrance County Beach | 26414 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.424 | Torrance County Beach | ||
10401 | 10401 | 10400 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.82141], [-118.37442, 33.82234], [-118.37432, 33.82233], [-118.37398, 33.82192], [-118.37365, 33.822], [-118.37358, 33.82193], [-118.37359, 33.82188], [-118.37374, 33.82172], [-118.37401, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.742 | Torrance holding 11 |
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]);