superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

20 rows where ACCESS_TYP = 3, MNG_AGENCY = 288 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 20 ✖

MNG_AGENCY 1

  • Torrance, City of · 20 ✖

ACCESS_TYP 1

  • No Public Access · 20 ✖
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
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  
12114 12114 12113 {"type": "Polygon", "coordinates": [[[-118.3507, 33.84601], [-118.34892, 33.84601], [-118.34892, 33.84506], [-118.3507, 33.84506], [-118.3507, 33.84601]]]} No Public Access 3 Amie Sump   29076 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 4.268 Amie Sump  
12117 12117 12116 {"type": "Polygon", "coordinates": [[[-118.37164, 33.83617], [-118.37117, 33.83684], [-118.36977, 33.83684], [-118.36976, 33.83423], [-118.37087, 33.83423], [-118.37163, 33.8351], [-118.37164, 33.83617]]]} No Public Access 3 Bishop Montgomery Sump   29080 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 11.206 Bishop Montgomery Sump  
12118 12118 12117 {"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 Elm Tree Water Yard   29081 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 1.999 Elm Tree Water Yard  
12119 12119 12118 {"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 Empty Lot 237th and Vine   29082 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.419 Empty Lot 237th and Vine  
12152 12152 12151 {"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 Entradero Swale 1   29125 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 1.121 Entradero Swale 1  
12153 12153 12152 {"type": "Polygon", "coordinates": [[[-118.36816, 33.85229], [-118.36737, 33.85201], [-118.36714, 33.85196], [-118.36699, 33.85194], [-118.36552, 33.85194], [-118.36523, 33.85193], [-118.36523, 33.85167], [-118.367, 33.85167], [-118.36731, 33.85171], [-118.3675, 33.85176], [-118.36815, 33.85199], [-118.36816, 33.85229]]]} No Public Access 3 Entradero Swale 2   29126 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 2.072 Entradero Swale 2  
12154 12154 12153 {"type": "Polygon", "coordinates": [[[-118.36523, 33.85193], [-118.36463, 33.85189], [-118.36301, 33.85189], [-118.36254, 33.85186], [-118.36247, 33.85167], [-118.36523, 33.85167], [-118.36523, 33.85193]]]} No Public Access 3 Entradero Swale 3   29127 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 1.524 Entradero Swale 3  
12172 12172 12171 {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} No Public Access 3 Entradero Swale 4   29148 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.181 Entradero Swale 4  
12182 12182 12181 {"type": "Polygon", "coordinates": [[[-118.36169, 33.85181], [-118.35893, 33.85181], [-118.35893, 33.85167], [-118.36169, 33.85167], [-118.36169, 33.85181]]]} No Public Access 3 Entradero Swale 5   29162 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.957 Entradero Swale 5  
12183 12183 12182 {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} No Public Access 3 Entradero Swale 6   29163 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.421 Entradero Swale 6  
12189 12189 12188 {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36666, 33.81576], [-118.36681, 33.81599]]]} No Public Access 3 Greenbelt SE Bindewald SE Calle Mayor   29168 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.159 Greenbelt SE Bindewald SE Calle Mayor  
12190 12190 12189 {"type": "Polygon", "coordinates": [[[-118.37216, 33.84447], [-118.37209, 33.84464], [-118.37153, 33.84466], [-118.37154, 33.84487], [-118.37204, 33.84487], [-118.37204, 33.84613], [-118.37186, 33.8462], [-118.37123, 33.8462], [-118.37122, 33.8461], [-118.37115, 33.84609], [-118.37115, 33.84447], [-118.37216, 33.84447]]]} No Public Access 3 Henrietta Sump North   29169 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 3.614 Henrietta Sump North  
12191 12191 12190 {"type": "Polygon", "coordinates": [[[-118.37272, 33.8438], [-118.37216, 33.84447], [-118.37115, 33.84447], [-118.37115, 33.84344], [-118.37191, 33.84344], [-118.37272, 33.8438]]]} No Public Access 3 Henrietta Sump South   29170 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 3.258 Henrietta Sump South  
12194 12194 12193 {"type": "Polygon", "coordinates": [[[-118.34089, 33.83497], [-118.3401, 33.83496], [-118.3401, 33.83442], [-118.34015, 33.8344], [-118.34087, 33.8344], [-118.34089, 33.83443], [-118.34089, 33.83497]]]} No Public Access 3 Maple Sump   29173 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 1.131 Maple Sump  
12196 12196 12195 {"type": "Polygon", "coordinates": [[[-118.3468, 33.85338], [-118.34613, 33.85338], [-118.34586, 33.85311], [-118.34562, 33.85279], [-118.34549, 33.85255], [-118.34549, 33.85235], [-118.34525, 33.85217], [-118.34549, 33.85211], [-118.3468, 33.85259], [-118.3468, 33.85338]]]} No Public Access 3 Retention Basin N Del Amo and Prairie   29175 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 2.92 Retention Basin N Del Amo and Prairie  
12197 12197 12196 {"type": "Polygon", "coordinates": [[[-118.35344, 33.79965], [-118.35314, 33.79985], [-118.35296, 33.79967], [-118.35259, 33.79991], [-118.35249, 33.7998], [-118.3532, 33.79933], [-118.3534, 33.79955], [-118.35338, 33.79959], [-118.35344, 33.79965]]]} No Public Access 3 Slope-Via Valmonte   29176 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.564 Slope-Via Valmonte  
12213 12213 12212 {"type": "MultiPolygon", "coordinates": [[[[-118.35671, 33.81401], [-118.3545, 33.81401], [-118.3545, 33.8139], [-118.3567, 33.8139], [-118.35671, 33.81401]]], [[[-118.35725, 33.81401], [-118.35689, 33.81401], [-118.35688, 33.8139], [-118.35723, 33.8139], [-118.35725, 33.81401]]], [[[-118.35768, 33.8139], [-118.35768, 33.81401], [-118.35731, 33.81401], [-118.3573, 33.8139], [-118.35768, 33.8139]]], [[[-118.35838, 33.8139], [-118.35837, 33.81401], [-118.35801, 33.81404], [-118.35801, 33.81391], [-118.35838, 33.8139]]], [[[-118.3588, 33.81385], [-118.3588, 33.81396], [-118.35843, 33.814], [-118.35845, 33.81389], [-118.3588, 33.81385]]], [[[-118.36202, 33.8137], [-118.36202, 33.81381], [-118.36034, 33.81381], [-118.35899, 33.81395], [-118.35901, 33.81383], [-118.36033, 33.8137], [-118.36202, 33.8137]]]]} No Public Access 3 Drain to Walteria Lake   29193 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 1.877 Drain to Walteria Lake  
12214 12214 12213 {"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 Ocean Sump   29194 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 10.918 Ocean Sump  
12215 12215 12214 {"type": "Polygon", "coordinates": [[[-118.37003, 33.80894], [-118.36954, 33.8099], [-118.36766, 33.80851], [-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.36597, 33.80689], [-118.36596, 33.8069], [-118.36646, 33.80748], [-118.3679, 33.80801], [-118.37003, 33.80894]]]} No Public Access 3 Slope-Via Corona   29195 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 11.829 Slope-Via Corona  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);