home / trees

Street_Tree_List

Data source: data.sfgov.org

23 rows where qSpecies = 52

View and edit SQL

Suggested facets: qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, 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
229 100229 DPW Maintained 1 Alnus cordata :: Italian Alder 52 701X 39th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/05/2016 12:00:00 AM 3 3x3 Permit Number 778265 5983807.975430001 2110975.7277599997 37.7753991192247 -122.49952572567801 (37.7753991192247, -122.499525725678) 11 6 2 55 26
52870 181967 DPW Maintained 1 Alnus cordata :: Italian Alder 52 2423 32nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 0ft   5986399.1816 2098739.8329 37.7419544119514 -122.48966224523501 (37.7419544119514, -122.489662245235) 1 8 3 29491 35
56026 184872 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1201 Sunset Blvd 61 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 0ft   5984669.9453 2106823.2961 37.7640482591194 -122.496237573009 (37.7640482591194, -122.496237573009) 1 8 3 56 35
59170 187974 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 4ft   6013741.64285 2092638.14431 37.726758883215396 -122.394692895458 (37.7267588832154, -122.394692895458) 10 3 8 58 1
59171 187975 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 5ft   6013720.25954 2092652.55253 37.7267972563783 -122.394767826095 (37.7267972563783, -122.394767826095) 10 3 8 58 1
59172 187976 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 5 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 5ft   6013686.9099 2092676.6751599999 37.726861637932004 -122.39488480448401 (37.726861637932, -122.394884804484) 10 3 8 58 1
59173 187977 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 6 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     12 Width 4ft   6013646.8498 2092708.23202 37.726946059107 -122.395025501647 (37.726946059107, -122.395025501647) 10 3 8 58 1
59174 187978 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 7 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     11 Width 5ft   6013630.25148 2092720.2143700002 37.726978037202 -122.39508372105499 (37.726978037202, -122.395083721055) 10 3 8 58 1
59175 187979 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 8 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     11 Width 5ft   6013615.832 2092731.9970200001 37.7270095881002 -122.395134394263 (37.7270095881002, -122.395134394263) 10 3 8 58 1
59176 187980 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 9 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 5ft   6013594.15592 2092747.34309 37.7270505198448 -122.395210403156 (37.7270505198448, -122.395210403156) 10 3 8 58 1
59177 187981 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 10 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     11 Width 5ft   6013574.181969999 2092762.0333900002 37.7270897455934 -122.395280481931 (37.7270897455934, -122.395280481931) 10 3 8 58 1
59178 187982 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 11 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 5ft   6013557.45285 2092775.26074 37.7271251348046 -122.395339240918 (37.7271251348046, -122.395339240918) 10 3 8 58 1
59179 187983 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 12 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 5ft   6013541.30669 2092786.45742 37.7271549806017 -122.395395842461 (37.7271549806017, -122.395395842461) 10 3 8 58 1
59180 187984 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1740 Bancroft Ave 13 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     11 Width 5ft   6013523.184119999 2092800.1784400002 37.7271916477681 -122.395459453304 (37.7271916477681, -122.395459453304) 10 3 8 58 1
72369 200824 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5300 03rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 0ft   6014267.0455 2093396.2046 37.728869561334704 -122.392929593283 (37.7288695613347, -122.392929593283) 10 3 8 58 1
72370 200825 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5300 03rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 0ft   6014263.6097 2093382.4616 37.728831634987294 -122.392940510044 (37.7288316349873, -122.392940510044) 10 3 8 58 1
72371 200826 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5300 03rd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 0ft   6014262.4645 2093372.7269 37.728804841856295 -122.392943788301 (37.7288048418563, -122.392943788301) 10 3 8 58 1
72372 200827 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5300 03rd St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 0ft   6014256.7382 2093362.9923 37.728777794532704 -122.392962903849 (37.7287777945327, -122.392962903849) 10 3 8 58 1
92963 222008 DPW Maintained 1 Alnus cordata :: Italian Alder 52 22 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     27 Width 4ft   6004062.615180001 2108585.10305 37.7700026390277 -122.429289661699 (37.7700026390277, -122.429289661699) 7 9 5 29492 10
94680 22359 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5330X 03rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/09/1995 12:00:00 AM 3 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
94692 22360 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5330X 03rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
94703 22361 DPW Maintained 1 Alnus cordata :: Italian Alder 52 5330X 03rd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
176016 80467 DPW Maintained 1 Alnus cordata :: Italian Alder 52 1780 Bancroft Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 10     6013451.73876 2092852.71308 37.727331923129896 -122.395710120444 (37.7273319231299, -122.395710120444) 10 3 8 58 1

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