superunits_with_maps

Table actions

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

72 rows where MNG_AGENCY = 288 and MNG_AG_TYP = 2 sorted by map descending

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 72 ✖

MNG_AGENCY 1

  • Torrance, City of · 72 ✖
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
14583 14583 14582 {"type": "Polygon", "coordinates": [[[-118.36766, 33.8205], [-118.36765, 33.82168], [-118.36593, 33.82168], [-118.36593, 33.82131], [-118.36641, 33.8213], [-118.36641, 33.82088], [-118.36594, 33.82085], [-118.36594, 33.82049], [-118.36766, 33.8205]]]} Restricted Access 2 Sea-Aire Golf Course   33004 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 4.637 Sea-Aire GC  

Next page

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