Street_Tree_List

Data source: data.sfgov.org

51 rows where qSiteInfo = 16

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
631 251294 Property Tree 7 :: 54 7126 Geary Blvd 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
903 225889 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 7 Back Yard : Cutout 16 Tree 1 MTA 6     18 Width 8ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
1547 251582 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 691x Ulloa St 1 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
2764 253207 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 89 Woodhaven Ct 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
19725 114507 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 10 LOMBARD ST 2 Back Yard : Cutout 16 Tree 1 Port 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
49605 87302 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 2323 Cesar Chavez St 4 Back Yard : Cutout 16 Tree 1 Private 1     1   Permit Number 50312 6011942.20762 2100900.73993 37.7493460165275 -122.401493976188 (37.7493460165275, -122.401493976188)
51543 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 3 180 Yukon St   Back Yard : Cutout 16 Tree 1 Private 1     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.44240692055901 (37.7570738455347, -122.442406920559)
64868 113526 Undocumented 2 Pinus radiata :: Monterey Pine 3 16x SHELDON TER 1 Back Yard : Cutout 16 Tree 1 Private 1     30 3x3   5991843.0 2103332.0 37.7548796468533 -122.47117393885799 (37.7548796468533, -122.471173938858)
78510 114817 Property Tree 7 Pinus radiata :: Monterey Pine 3 100 RACCOON DR 1 Back Yard : Cutout 16 Tree 1 Private 1           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084)
79581 117011 Undocumented 2 Maytenus boaria :: Mayten 22 457X CASTRO ST 1 Back Yard : Cutout 16 Tree 1 MTA 6 Private 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
84223 108244 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 46 150 Conrad St 1 Back Yard : Cutout 16 Tree 1 Private 1     20     6001768.8 2096480.0 37.7366348009068 -122.43635744032801 (37.7366348009068, -122.436357440328)
85237 113807 Undocumented 2 Pinus radiata :: Monterey Pine 3 70X MALTA DR 1 Back Yard : Cutout 16 Tree 1 Private 1       3x30   5999481.0 2096265.0 37.735914202367894 -122.444251877835 (37.7359142023679, -122.444251877835)
85764 115641 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 7 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
86412 115638 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 4 Back Yard : Cutout 16 Tree 1 DPW 2     7 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
88523 116864 Significant Tree 6 Pinus radiata :: Monterey Pine 3 262X OAK PARK DR 3 Back Yard : Cutout 16 Tree 1 Private 1       10x10   5995091.0 2103085.0 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558)
89465 114506 Undocumented 2 Maytenus boaria :: Mayten 22 10 LOMBARD ST 1 Back Yard : Cutout 16 Tree 1 Port 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
90360 115646 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 12 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
94229 116554 Undocumented 2 Pinus halepensis :: Allepo Pine 164 424x LOS PALMOS DR 1 Back Yard : Cutout 16 Tree 1 Private 1     16 3x3   5997290.0 2095790.0 37.734484721942295 -122.451792740897 (37.7344847219423, -122.451792740897)
95069 115635 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 1 Back Yard : Cutout 16 Tree 1 DPW 2     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
96425 116863 Significant Tree 6 Pinus radiata :: Monterey Pine 3 262X OAK PARK DR 2 Back Yard : Cutout 16 Tree 1 Private 1       10x10   5995091.0 2103085.0 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558)
96699 115645 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 11 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
97160 115639 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 5 Back Yard : Cutout 16 Tree 1 DPW 2     6 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
97425 116862 Significant Tree 6 Pinus radiata :: Monterey Pine 3 262X OAK PARK DR 1 Back Yard : Cutout 16 Tree 1 Private 1       10x10   5995091.0 2103085.0 37.7543887826633 -122.459923632558 (37.7543887826633, -122.459923632558)
99755 115644 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 10 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
100593 115407 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 46 PROSPECT AVE 1 Back Yard : Cutout 16 Tree 1 Private 1     14 3x3   6007068.0 2099193.0 37.7443837739696 -122.41822807190901 (37.7443837739696, -122.418228071909)
102527 115648 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 14 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102675 115649 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 15 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
105499 121242 Significant Tree 6 Pinus radiata :: Monterey Pine 3 701 16th Ave 1 Back Yard : Cutout 16 Tree 1 Private 1     36     5990933.0 2110561.0 37.7746758635803 -122.474848566269 (37.7746758635803, -122.474848566269)
105687 122518 Property Tree 7 Pinus radiata :: Monterey Pine 3 772X Panorama Dr 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996713.0 2102901.0 37.753976715350106 -122.45430108189 (37.7539767153501, -122.45430108189)
108009 115652 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 18 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
108742 110939 Property Tree 7 Pinus radiata :: Monterey Pine 3 38 SAINT CHARLES AVE 1 Back Yard : Cutout 16 Tree 1 Private 1     30 3x3   5992046.0 2088201.0 37.7133454608488 -122.46937060641001 (37.7133454608488, -122.46937060641)
110956 118356 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 100 RACCOON DR 2 Back Yard : Cutout 16 Tree 1 Private 1     48     5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
111875 115636 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 2 Back Yard : Cutout 16 Tree 1 DPW 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
112771 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 96 CRESTA VISTA DR   Back Yard : Cutout 16 Tree 1 Private 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
113407 115650 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 16 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
117016 110120 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 507X JOOST AVE 2 Back Yard : Cutout 16 Tree 1 Private 1     45 3x3   5998608.0 2094933.0 37.7322070010706 -122.44717434081801 (37.7322070010706, -122.447174340818)
118558 115640 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 6 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118995 97217 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 4 Back Yard : Cutout 16 Tree 1 DPW for City Agency 10     18     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
122253 115643 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 9 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124724 115642 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 8 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125004 115653 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 19 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125405 114508 Undocumented 2 Maytenus boaria :: Mayten 22 10 LOMBARD ST 3 Back Yard : Cutout 16 Tree 1 Port 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
127152 115647 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 13 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
128022 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 3 150 Raccoon Dr 1 Back Yard : Cutout 16 Tree 1 Private 1     36 3x3   5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
139401 115654 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 20 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139921 115637 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 3 Back Yard : Cutout 16 Tree 1 DPW 2     14 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
142025 98491 Significant Tree 6 Robinia pseudoacacia :: Black Locust 169 55X Perine Pl 1 Back Yard : Cutout 16 Tree 1 Private 1         Permit Number 768655 6002130.5 2115544.8 37.7890026421633 -122.436471006098 (37.7890026421633, -122.436471006098)
142076 115655 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 21 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
143072 97216 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 3 Back Yard : Cutout 16 Tree 1 DPW for City Agency 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
144101 115651 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 17 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
145924 87273 Permitted Site 1 Pinus radiata :: Monterey Pine 3 4 Miraloma Dr 1 Back Yard : Cutout 16 Tree 1 Private 1   03/12/2008 12:00:00 AM     Permit Number 50295 5995203.0 2097905.0 37.7401722415629 -122.45916124145 (37.7401722415629, -122.45916124145)

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 56.411ms · Data source: data.sfgov.org