home / trees

Street_Tree_List

Data source: data.sfgov.org

26 rows where qSpecies = 84

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
490 100543 Undocumented 3 Acer spp :: Maple 84 290X Tehama St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x4                      
496 100549 Undocumented 3 Acer spp :: Maple 84 290X Tehama St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x4                      
5811 106681 Undocumented 3 Acer spp :: Maple 84 272 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6002031.2 2104270.9 37.758041678013605 -122.436007529668 (37.7580416780136, -122.436007529668) 2 4 5 28862 3
5812 106682 Undocumented 3 Acer spp :: Maple 84 212 COLLINGWOOD ST   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6002028.5 2104520.8 37.7587276896571 -122.436034749265 (37.7587276896571, -122.436034749265) 2 4 5 28862 3
10699 112248 DPW Maintained 1 Acer spp :: Maple 84 1799X TAYLOR ST 1 Unaccepted Street : Yard 13 Tree 1 DPW 1     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702) 5 1 10 308 21
20173 122799 DPW Maintained 1 Acer spp :: Maple 84 182 Arguello Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3X3   5995585.03649 2114951.3980400003 37.786999211311205 -122.459074312759 (37.7869992113112, -122.459074312759) 11 6 1 54 31
22951 125419 DPW Maintained 1 Acer spp :: Maple 84 2122 Broderick St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 4ft   6000404.99268 2115981.33663 37.790103057869 -122.442472370315 (37.790103057869, -122.442472370315) 13 6 1 29490 27
74542 20325 DPW Maintained 1 Acer spp :: Maple 84 101X Sunset Blvd 13 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 60                      
74747 203438 DPW Maintained 1 Acer spp :: Maple 84 714 Detroit St 13 Side Yard : Yard 27 Tree 1 Private 2     6     5999448.55059 2095428.3134400002 37.73361500690729 -122.44430396017401 (37.7336150069073, -122.444303960174) 9 7 4 63 40
109407 23723 Permitted Site 2 Acer spp :: Maple 84 802X Webster St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/21/2008 12:00:00 AM 3 4X4   6003990.015324599 2111477.493419 37.7779403234669 -122.429747112563 (37.7779403234669, -122.429747112563) 7 9 11 28852 41
116864 245365 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 3 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001863.1078 2108862.114 37.770638476744296 -122.436917542168 (37.7706384767443, -122.436917542168) 15 5 11 29492 9
117450 245906 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 2 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001865.9151 2108842.8634 37.7705857789269 -122.436906453346 (37.7705857789269, -122.436906453346) 15 5 11 29492 9
117452 245908 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 1 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001868.7225 2108822.4097 37.7705297776993 -122.436895278053 (37.7705297776993, -122.436895278053) 15 5 11 29492 9
117456 245911 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 6 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001845.0604 2108986.0395 37.770977719652706 -122.43698884174499 (37.7709777196527, -122.436988841745) 15 5 11 29492 9
117457 245912 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 7 Median : Cutout 1 Tree 1 DPW 1     4 Width 0ft   6001842.253 2109004.087 37.771027114039 -122.436999844882 (37.771027114039, -122.436999844882) 15 5 11 29492 9
117458 245913 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 8 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001839.4456 2109021.7333 37.771075406828295 -122.437010819306 (37.7710754068283, -122.437010819306) 15 5 11 29492 9
117461 245916 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 5 Median : Cutout 1 Tree 1 DPW 1     3 Width 0ft   6001847.8677 2108968.7942 37.7709305279013 -122.43697789640801 (37.7709305279013, -122.436977896408) 15 5 11 29492 9
117463 245918 DPW Maintained 1 Acer spp :: Maple 84 200x Divisadero St 4 Median : Cutout 1 Tree 1 DPW 1     4 Width 0ft   6001860.7014 2108879.7604 37.770686792610604 -122.43692712942499 (37.7706867926106, -122.436927129425) 15 5 11 29492 9
123196 251816 DPW Maintained 1 Acer spp :: Maple 84 1800 Ellis St 1 Front Yard : Yard 4 Tree 1 Private 2       3x3   6002197.0 2113045.0 37.782142606902205 -122.436061972283 (37.7821426069022, -122.436061972283) 15 5 11 29490 41
131739 31146 DPW Maintained 1 Acer spp :: Maple 84 500 Hearst Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/21/1995 12:00:00 AM 3   Permit Number 34853 5998061.9745 2094408.9527900002 37.73073687780529 -122.44902432803002 (37.7307368778053, -122.44902432803) 9 7 4 59 40
138679 3752 DPW Maintained 1 Acer spp :: Maple 84 1000 Carolina St 1 Median : Cutout 1 Tree 1 DPW 1     12 18   6012438.0377853 2103297.9664682 37.755955933673 -122.399947693157 (37.755955933673, -122.399947693157) 10 3 8 28856 29
148934 47041 Permitted Site 2 Acer spp :: Maple 84 50 Webster St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/02/2002 12:00:00 AM 1 3x3 Permit Number 45032 6004340.5553933 2108752.14114491 37.7704770161634 -122.428340177957 (37.7704770161634, -122.428340177957) 7 9 11 28852 10
161407 58664 Permitted Site 2 Acer spp :: Maple 84 1177 Stanyan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/14/2010 12:00:00 AM   3x3 Permit Number 53728 5997356.04409087 2106085.73086087 37.7627580410745 -122.452307083545 (37.7627580410745, -122.452307083545) 15 5 11 29492 12
164851 61909 Permitted Site 2 Acer spp :: Maple 84 440 14th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/16/2014 12:00:00 AM 18 4x4 Permit Number 773023 6005831.34530489 2107876.05968072 37.768155749319504 -122.423121239386 (37.7681557493195, -122.423121239386) 8 4 5 28853 19
166801 6371 DPW Maintained 1 Acer spp :: Maple 84 2101 Ellis St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/11/1992 12:00:00 AM 6 3X3   6000750.81979 2112712.53473 37.781147476730105 -122.441041230886 (37.7811474767301, -122.441041230886) 15 5 1 29490 41
183697 91267 Permitted Site 2 Acer spp :: Maple 84 1169 Tennessee St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/11/2009 12:00:00 AM   3x3 Permit Number 52050 6015590.0 2103554.0 37.7568341715918 -122.389064949913 (37.7568341715918, -122.389064949913) 10 3 8 28856 29

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 23.345ms · Data source: data.sfgov.org