Street_Tree_List

Data source: data.sfgov.org

19 rows where qSiteInfo = 17 and qSpecies = 86 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Side Yard : Yard · 19 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24297 24297 248119 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 9 Side Yard : Yard 17 Tree 1 Private 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
36690 36690 248115 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 5 Side Yard : Yard 17 Tree 1 Private 1     7     6010382.6698900005 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664)
38800 38800 248116 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 6 Side Yard : Yard 17 Tree 1 Private 1     9     6010379.57479 2099419.47211 37.745191464327995 -122.406793240314 (37.745191464328, -122.406793240314)
46620 46620 248114 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 4 Side Yard : Yard 17 Tree 1 Private 1     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902)
54920 54920 248118 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 8 Side Yard : Yard 17 Tree 1 Private 1     6     6010376.970919999 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209)
70123 70123 248111 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 1 Side Yard : Yard 17 Tree 1 Private 1     24     6010383.711069999 2099443.8594400003 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096)
130896 130896 248113 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 3 Side Yard : Yard 17 Tree 1 Private 1     17     6010385.30327 2099441.28079 37.745251666737296 -122.40677496881099 (37.7452516667373, -122.406774968811)
148699 148699 248117 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 7 Side Yard : Yard 17 Tree 1 Private 1     6     6010378.29952 2099414.5285 37.7451778188963 -122.40679730165701 (37.7451778188963, -122.406797301657)
154282 154282 248120 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 10 Side Yard : Yard 17 Tree 1 Private 1     12     6010373.21137 2099395.33781 37.745124840742 -122.40681354343701 (37.745124840742, -122.406813543437)
127197 127197 249899 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 3 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701)
171284 171284 249897 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 5 Side Yard : Yard 17 Tree 1 Private 1     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.40479885070101 (37.8030148322229, -122.404798850701)
39702 39702 195996 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 5 Side Yard : Yard 17 Tree 1 Private 1     14 Width 3ft   6012499.275719999 2097703.95349 37.7405993901482 -122.39934322143101 (37.7405993901482, -122.399343221431)
154008 154008 195993 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 2 Side Yard : Yard 17 Tree 1 Private 1     23 Width 3ft   6012429.27896 2097757.0265 37.7407412159349 -122.399588970171 (37.7407412159349, -122.399588970171)
156951 156951 195995 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 4 Side Yard : Yard 17 Tree 1 Private 1     23 Width 3ft   6012483.54441 2097715.89022 37.7406312890986 -122.399398452383 (37.7406312890986, -122.399398452383)
183132 183132 195994 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 3 Side Yard : Yard 17 Tree 1 Private 1     20 Width 3ft   6012438.11131 2097750.05558 37.74072256758821 -122.39955794174999 (37.7407225675882, -122.39955794175)
41744 41744 248172 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 218 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     12     6007302.01446 2098729.32454 37.74312379432521 -122.41738604353701 (37.7431237943252, -122.417386043537)
56013 56013 248173 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 218 Esmeralda Ave 2 Side Yard : Yard 17 Tree 1 Private 1     6     6007303.951309999 2098726.55555 37.743116300271 -122.41737915022101 (37.743116300271, -122.417379150221)
162455 162455 195979 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 1 Side Yard : Yard 17 Tree 1 Private 1     30 Width 9ft   6014704.25324 2097268.53042 37.739526454869704 -122.39168875963999 (37.7395264548697, -122.39168875964)
165153 165153 195980 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 2 Side Yard : Yard 17 Tree 1 Private 1     24     6014694.29284 2097256.8818599996 37.7394939174204 -122.39172238440399 (37.7394939174204, -122.391722384404)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 520.734ms · Data source: data.sfgov.org