superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where ACCESS_TYP = 1 and MNG_AGENCY = 288 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
3921 | 3921 | 3920 | {"type": "Polygon", "coordinates": [[[-118.37986, 33.81559], [-118.37947, 33.8157], [-118.37941, 33.81576], [-118.37708, 33.81546], [-118.37702, 33.81542], [-118.37673, 33.81482], [-118.37681, 33.81477], [-118.37702, 33.81473], [-118.37726, 33.8147], [-118.37777, 33.8147], [-118.3781, 33.81476], [-118.37848, 33.81488], [-118.37879, 33.81503], [-118.37914, 33.81529], [-118.37933, 33.81549], [-118.37968, 33.81529], [-118.37975, 33.81538], [-118.37986, 33.81559]]]} | Open Access 1 | El Retiro Park | 18536 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 4.788 | El Retiro Park | ||
12184 | 12184 | 12183 | {"type": "Polygon", "coordinates": [[[-118.37851, 33.80851], [-118.37849, 33.80863], [-118.37845, 33.80865], [-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]]]} | Open Access 1 | Grass Median Calle Miramar and Calle Aragon | 29164 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.108 | Grass Median Calle Miramar and Calle Aragon | ||
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 | ||
10404 | 10404 | 10403 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.81802], [-118.37442, 33.81909], [-118.37381, 33.81909], [-118.37372, 33.81908], [-118.37354, 33.819], [-118.37335, 33.81885], [-118.37326, 33.81869], [-118.37325, 33.81846], [-118.3733, 33.81831], [-118.37343, 33.81815], [-118.37363, 33.81804], [-118.37383, 33.81799], [-118.37443, 33.81799], [-118.37443, 33.81802]]]} | Open Access 1 | Torrance holding 23 | 26430 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 2.9 | Torrance holding 23 | ||
4043 | 4043 | 4042 | {"type": "Polygon", "coordinates": [[[-118.37364, 33.85464], [-118.37353, 33.85466], [-118.37302, 33.85512], [-118.37145, 33.85512], [-118.37143, 33.85544], [-118.37125, 33.85545], [-118.37124, 33.85513], [-118.37086, 33.85512], [-118.37055, 33.85389], [-118.36985, 33.85267], [-118.36996, 33.85242], [-118.36996, 33.85174], [-118.37048, 33.85173], [-118.37049, 33.85135], [-118.37067, 33.85135], [-118.37068, 33.85173], [-118.37209, 33.85173], [-118.37254, 33.85199], [-118.37294, 33.85219], [-118.37316, 33.85221], [-118.37364, 33.85464]]]} | Open Access 1 | Entradero Park | 18687 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 25.697 | Entradero Park | ||
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-118.37289, 33.82747], [-118.37259, 33.82737], [-118.37257, 33.82732], [-118.37286, 33.82735], [-118.37289, 33.82747]]]} | Open Access 1 | Torrance holding 6 | 26464 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.06 | Torrance holding 6 | ||
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 | ||
10405 | 10405 | 10404 | {"type": "Polygon", "coordinates": [[[-118.36897, 33.80456], [-118.36893, 33.80458], [-118.36879, 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 | Torrance holding 28 | 26435 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.536 | Torrance holding 28 | ||
12185 | 12185 | 12184 | {"type": "Polygon", "coordinates": [[[-118.36777, 33.81735], [-118.36765, 33.8174], [-118.36727, 33.81683], [-118.36739, 33.81678], [-118.36777, 33.81735]]]} | Open Access 1 | Greenbelt near Bindewald St | 29165 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.215 | Greenbelt near Bindewald St | ||
12188 | 12188 | 12187 | {"type": "Polygon", "coordinates": [[[-118.36643, 33.81533], [-118.36631, 33.81539], [-118.36612, 33.8151], [-118.36624, 33.81505], [-118.36643, 33.81533]]]} | Open Access 1 | Greenbelt SE Bindewald NW Calle Mayor | 29167 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.108 | Greenbelt SE Bindewald NW Calle Mayor | ||
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.36641, 33.82132], [-118.36593, 33.82131], [-118.36594, 33.82085], [-118.36641, 33.82087], [-118.36641, 33.82132]]]} | Open Access 1 | Sea-Aire Parklette | 29333 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.548 | Sea-Aire Parklette | ||
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 | ||
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 | ||
12198 | 12198 | 12197 | {"type": "Polygon", "coordinates": [[[-118.3629, 33.80569], [-118.36282, 33.80599], [-118.36103, 33.80567], [-118.35988, 33.80555], [-118.35986, 33.8054], [-118.3629, 33.80569]]]} | Open Access 1 | Slope-Vista Largo | 29177 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.571 | Slope-Vista Largo | ||
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 | ||
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-118.3621, 33.80422], [-118.36198, 33.80426], [-118.36183, 33.80426], [-118.36171, 33.80424], [-118.36154, 33.80416], [-118.36131, 33.80396], [-118.3611, 33.80383], [-118.36028, 33.80314], [-118.36024, 33.80307], [-118.36032, 33.80301], [-118.36169, 33.80417], [-118.36209, 33.80417], [-118.3621, 33.80422]]]} | Open Access 1 | Torrance holding 16 | 26422 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.591 | Torrance holding 16 | ||
11764 | 11764 | 11763 | {"type": "Polygon", "coordinates": [[[-118.36147, 33.82116], [-118.36147, 33.82149], [-118.36001, 33.82072], [-118.36001, 33.8204], [-118.36147, 33.82116]]]} | Open Access 1 | Seaside Heroes Park | http://www.torranceca.gov/Parks/22840.htm | 28376 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1.202 | Seaside Heroes Park |
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]);