superunits_with_maps

Table actions

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

72 rows where MNG_AGENCY = 288, MNG_AG_LEV = 2 and MNG_AG_TYP = 2

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
1457 1457 1456 {"type": "Polygon", "coordinates": [[[-118.33348, 33.78451], [-118.33347, 33.78464], [-118.33301, 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 Alta Loma Park   15416 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 5.656 Alta Loma Park  
2848 2848 2847 {"type": "Polygon", "coordinates": [[[-118.32837, 33.82753], [-118.3224, 33.82758], [-118.3212, 33.82649], [-118.32164, 33.82648], [-118.32164, 33.82567], [-118.32083, 33.82567], [-118.32011, 33.82549], [-118.31996, 33.82532], [-118.31991, 33.82531], [-118.31954, 33.82496], [-118.31917, 33.82465], [-118.31917, 33.82463], [-118.31928, 33.82473], [-118.31967, 33.82494], [-118.31984, 33.825], [-118.32016, 33.82509], [-118.32045, 33.82512], [-118.32835, 33.82506], [-118.32837, 33.82753]]]} Open Access 1 Charles H. Wilson Park   17139 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 44.168 Charles H. Wilson Park  
3119 3119 3118 {"type": "Polygon", "coordinates": [[[-118.35089, 33.85921], [-118.35089, 33.85978], [-118.35065, 33.8598], [-118.35065, 33.86184], [-118.34815, 33.86185], [-118.34814, 33.86193], [-118.344, 33.86193], [-118.34399, 33.86131], [-118.34388, 33.8613], [-118.34388, 33.85839], [-118.3466, 33.85839], [-118.34661, 33.85844], [-118.34724, 33.85844], [-118.34726, 33.85838], [-118.34769, 33.85838], [-118.34771, 33.85844], [-118.34814, 33.85844], [-118.34814, 33.85921], [-118.35089, 33.85921]], [[-118.34908, 33.86044], [-118.34907, 33.86057], [-118.34919, 33.86057], [-118.34919, 33.86045], [-118.34908, 33.86044]], [[-118.34994, 33.85985], [-118.34995, 33.85955], [-118.34962, 33.85956], [-118.34962, 33.85985], [-118.34994, 33.85985]]]} Open Access 1 Columbia Park   17547 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 54.89 Columbia Park  
3485 3485 3484 {"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.79244], [-118.34287, 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 De Portola Park   17975 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 12.592 De Portola Park  
3546 3546 3545 {"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 Discovery Park   18166 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 0.395 Discovery Park  
3554 3554 3553 {"type": "Polygon", "coordinates": [[[-118.34715, 33.84786], [-118.3454, 33.84786], [-118.34539, 33.8468], [-118.34501, 33.84679], [-118.34499, 33.8467], [-118.34496, 33.84641], [-118.34497, 33.84505], [-118.34606, 33.84505], [-118.34606, 33.84677], [-118.34714, 33.84678], [-118.34715, 33.84786]]]} Open Access 1 Delthorne Park   18078 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 9.599 Delthorne Park  
3581 3581 3580 {"type": "Polygon", "coordinates": [[[-118.32204, 33.87195], [-118.32201, 33.87198], [-118.32196, 33.87198], [-118.32167, 33.87193], [-118.32153, 33.87187], [-118.32076, 33.87146], [-118.32061, 33.87139], [-118.32046, 33.87136], [-118.32045, 33.871], [-118.32204, 33.871], [-118.32204, 33.87195]]]} Open Access 1 Descanso Park   18110 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 2.84 Descanso Park  
3908 3908 3907 {"type": "Polygon", "coordinates": [[[-118.35868, 33.86546], [-118.35684, 33.86546], [-118.35683, 33.86187], [-118.35719, 33.86215], [-118.35746, 33.86238], [-118.3578, 33.86274], [-118.35812, 33.86318], [-118.35831, 33.86354], [-118.35838, 33.86372], [-118.35847, 33.86373], [-118.35855, 33.86395], [-118.35865, 33.8644], [-118.35868, 33.86467], [-118.35868, 33.86546]]]} Open Access 1 El Nido Park   18521 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 12.291 El Nido Park  
3919 3919 3918 {"type": "MultiPolygon", "coordinates": [[[[-118.31874, 33.83299], [-118.3174, 33.83403], [-118.31715, 33.83381], [-118.31849, 33.83277], [-118.31874, 33.83299]]], [[[-118.32028, 33.83181], [-118.31891, 33.83287], [-118.31866, 33.83264], [-118.32004, 33.83159], [-118.32028, 33.83181]]], [[[-118.32091, 33.83125], [-118.32091, 33.83125], [-118.32024, 33.83126], [-118.3206, 33.83097], [-118.32091, 33.83125]]], [[[-118.32096, 33.83147], [-118.32058, 33.83176], [-118.32027, 33.83147], [-118.32027, 33.83147], [-118.32096, 33.83147]]]]} Open Access 1 El Prado Park   18532 1349 Torrance, City of 288 City 2 City Agency 2 http://www.torranceca.gov/ City 2 3.356 El Prado 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  
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  
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  

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