home / trees

Street_Tree_List

Data source: data.sfgov.org

53 rows where qSpecies = 32

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, 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
109 100102 Undocumented 3 Ficus carica :: Edible Fig 32 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
8015 109114 Undocumented 3 Ficus carica :: Edible Fig 32 3301x 19TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6007480.0 2104949.0 37.760211624256 -122.41721125604201 (37.760211624256, -122.417211256042) 2 4 7 28859 19
8158 109254 Undocumented 3 Ficus carica :: Edible Fig 32 1533 PINE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/2015 12:00:00 AM 3 3x3   6006572.5 2115603.9 37.78941632368 -122.421106442083 (37.78941632368, -122.421106442083) 13 9 10 28858 21
24241 126610 DPW Maintained 1 Ficus carica :: Edible Fig 32 2843 Larkin St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 5ft   6006456.53687 2121049.16702 37.8043611182251 -122.42189462196501 (37.8043611182251, -122.421894621965) 5 9 1 28858 32
24242 126611 DPW Maintained 1 Ficus carica :: Edible Fig 32 45 Havens St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9     6007634.20371 2119389.7439599996 37.799871105414 -122.417701505917 (37.799871105414, -122.417701505917) 5 1 1 28858 32
24243 126612 DPW Maintained 1 Ficus carica :: Edible Fig 32 71 MacOndray Ln 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10     6008351.9449 2119129.87084 37.7991979215137 -122.41519943911699 (37.7991979215137, -122.415199439117) 5 1 10 308 32
24244 126613 DPW Maintained 1 Ficus carica :: Edible Fig 32 680 Beach St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 Width 2ft   6006953.4231900005 2121924.22216 37.8067918058547 -122.42023724517999 (37.8067918058547, -122.42023724518) 5 1 1 308 32
42761 14838 DPW Maintained 1 Ficus carica :: Edible Fig 32 1315X McAllister St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 4x4   6002861.06587 2111639.14836 37.7783201948721 -122.43366409969101 (37.7783201948721, -122.433664099691) 15 5 11 29492 41
47511 176397 DPW Maintained 1 Ficus carica :: Edible Fig 32 78 Seminole Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 5ft   5999084.20064 2090244.12215 37.7193596292322 -122.44519102713899 (37.7193596292322, -122.445191027139) 9 7 6 28861 25
47512 176398 DPW Maintained 1 Ficus carica :: Edible Fig 32 716 Peru Ave 9 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 2ft   6005277.37254 2092448.27671 37.725763317517206 -122.42394017129999 (37.7257633175172, -122.4239401713) 9 7 6 309 5
47513 176399 DPW Maintained 1 Ficus carica :: Edible Fig 32 202 University St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 4ft   6008036.052069999 2092909.69402 37.727185629512704 -122.41443622767 (37.7271856295127, -122.41443622767) 9 3 7 309 28
56777 18561 DPW Maintained 1 Ficus carica :: Edible Fig 32 1700X Quesada Ave 16 Median : Cutout 1 Tree 1 DPW 1     30 19   6014529.14736 2095157.7057700001 37.7337208418243 -122.392146622477 (37.7337208418243, -122.392146622477) 10 3 8 58 1
58772 187591 DPW Maintained 1 Ficus carica :: Edible Fig 32 700 Goettingen St 2 Front Yard : Yard 4 Tree 1 Private 2     3     6010706.42139 2091370.7733200002 37.7231097257218 -122.40509642196301 (37.7231097257218, -122.405096421963) 10 3 7 309 28
70856 199418 DPW Maintained 1 Ficus carica :: Edible Fig 32 600 Illinois St 5 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     9 Width 3ft   6015946.150769999 2106178.35791 37.7640598335051 -122.388016366372 (37.7640598335051, -122.388016366372) 14 3 8 28856 29
70857 199419 DPW Maintained 1 Ficus carica :: Edible Fig 32 800 19th St 10 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 10ft   6015051.02595 2105341.2079 37.761711568757796 -122.391053849976 (37.7617115687578, -122.391053849976) 10 3 8 28856 29
70859 199420 DPW Maintained 1 Ficus carica :: Edible Fig 32 800 19th St 14 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 10ft   6015014.04418 2105339.34196 37.7617043930642 -122.39118162565501 (37.7617043930642, -122.391181625655) 10 3 8 28856 29
70860 199421 DPW Maintained 1 Ficus carica :: Edible Fig 32 1902 23rd St 1 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     2 Width 4ft   6012718.992319999 2102873.6867 37.7548066136499 -122.398946275964 (37.7548066136499, -122.398946275964) 10 3 8 28856 29
70861 199422 DPW Maintained 1 Ficus carica :: Edible Fig 32 760 San Bruno Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8     6010966.90517 2104732.3303900003 37.759812249162 -122.405136377945 (37.759812249162, -122.405136377945) 10 3 8 28856 29
70862 199423 DPW Maintained 1 Ficus carica :: Edible Fig 32 1750 22nd St 4 Side Yard : Yard 27 Tree 1 Private 2     3     6012840.75546 2103801.40949 37.7573607224353 -122.398590280219 (37.7573607224353, -122.398590280219) 10 3 8 28856 29
70863 199424 DPW Maintained 1 Ficus carica :: Edible Fig 32 1700 Armstrong Ave 6 Side Yard : Yard 27 Tree 1 Private 2     8     6013888.74548 2092884.8334599999 37.7274444193079 -122.394201625513 (37.7274444193079, -122.394201625513) 10 3 8 58 1
70864 199425 DPW Maintained 1 Ficus carica :: Edible Fig 32 981 Le Conte Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5     6013195.96321 2089497.3406 37.7181045146991 -122.396359261865 (37.7181045146991, -122.396359261865) 10 3 8 58 1
70865 199426 DPW Maintained 1 Ficus carica :: Edible Fig 32 720 Mendell St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   6016063.7205300005 2096868.3595900002 37.7385030371809 -122.386960368021 (37.7385030371809, -122.386960368021) 10 3 8 58 1
71714 200197 DPW Maintained 1 Ficus carica :: Edible Fig 32 3125 Jennings St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2 Width 0ft   6013691.9188 2090266.6644 37.720244510901296 -122.39469879008699 (37.7202445109013, -122.394698790087) 10 3 8 58 1
71716 200199 DPW Maintained 1 Ficus carica :: Edible Fig 32 3125 Jennings St 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7 Width 0ft   6013712.0206 2090295.7773 37.7203255667293 -122.39463134193501 (37.7203255667293, -122.394631341935) 10 3 8 58 1
71718 200200 DPW Maintained 1 Ficus carica :: Edible Fig 32 3125 Jennings St 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     3 Width 0ft   6013737.6677 2090326.2765 37.7204107373071 -122.39454482221201 (37.7204107373071, -122.394544822212) 10 3 8 58 1
72873 201290 DPW Maintained 1 Ficus carica :: Edible Fig 32 76 Lydia Ave 1 : 14 Tree 1 Private 2     1 Width 2ft   6012638.30332 2093004.00556 37.7277020579784 -122.39853279554501 (37.7277020579784, -122.398532795545) 10 3 8 58 1
72874 201291 DPW Maintained 1 Ficus carica :: Edible Fig 32 78 Lydia Ave 1 : 14 Tree 1 Private 2     8 Width 2ft   6012632.17098 2093009.59576 37.7277170658827 -122.39855438738701 (37.7277170658827, -122.398554387387) 10 3 8 58 1
73487 201918 DPW Maintained 1 Ficus carica :: Edible Fig 32 251 Elmira St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   6011265.63064 2095268.88122 37.7338443646257 -122.403437444384 (37.7338443646257, -122.403437444384) 10 3 8 58 1
73608 202067 DPW Maintained 1 Ficus carica :: Edible Fig 32 1 Hwy 101 S On Ramp 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 9ft   6013024.681059999 2090205.86512 37.720040448378704 -122.397000965021 (37.7200404483787, -122.397000965021) 10 3 8 58 1
89511 218799 DPW Maintained 1 Ficus carica :: Edible Fig 32 245 Santa Clara Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 10ft   5993126.9598 2096381.9374099998 37.7358707242547 -122.46622863125499 (37.7358707242547, -122.466228631255) 1 8 4 59 40
89514 218800 DPW Maintained 1 Ficus carica :: Edible Fig 32 165 Ashton Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 6ft   5994131.57121 2091005.5207 37.7211663078633 -122.462365488175 (37.7211663078633, -122.462365488175) 9 8 6 28861 24
95640 224468 DPW Maintained 1 Ficus carica :: Edible Fig 32 150 Coso Ave 6 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     6007429.170080001 2099622.33879 37.7455829652936 -122.417009632297 (37.7455829652936, -122.417009632297) 2 7 7 28859 2
95641 224469 DPW Maintained 1 Ficus carica :: Edible Fig 32 400 Prospect Ave 17 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6     6006200.61902 2097593.19015 37.7399421943761 -122.42111372622499 (37.7399421943761, -122.421113726225) 2 7 7 28859 2
95642 224470 DPW Maintained 1 Ficus carica :: Edible Fig 32 1099 Alabama St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10 Width 2ft   6009222.2963 2102800.34882 37.754409778801 -122.41103368406601 (37.754409778801, -122.411033684066) 2 4 7 28859 19
95643 224471 DPW Maintained 1 Ficus carica :: Edible Fig 32 627 Precita Ave 1 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     11 Width 3ft   6009784.7997 2100421.88863 37.7479105825135 -122.408920592022 (37.7479105825135, -122.408920592022) 2 7 7 28859 2
95644 224472 DPW Maintained 1 Ficus carica :: Edible Fig 32 3315 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 4ft   6007450.24001 2104978.31857 37.7602904519748 -122.41731625975599 (37.7602904519748, -122.417316259756) 2 4 7 28859 19
95645 224473 DPW Maintained 1 Ficus carica :: Edible Fig 32 1637 Diamond St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 10ft   6002068.79375 2099252.08873 37.7442633522761 -122.435518484014 (37.7442633522761, -122.435518484014) 2 7 5 63 22
95646 224474 DPW Maintained 1 Ficus carica :: Edible Fig 32 338 Hoffman Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 3ft   6000612.128380001 2101784.39225 37.751133611540396 -122.44073691528901 (37.7511336115404, -122.440736915289) 2 4 5 28862 22
95647 224475 DPW Maintained 1 Ficus carica :: Edible Fig 32 859 Elizabeth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 4ft   6000869.492219999 2101983.48815 37.7516949341823 -122.43986119955 (37.7516949341823, -122.43986119955) 2 4 5 28862 22
95648 224476 DPW Maintained 1 Ficus carica :: Edible Fig 32 3900 22nd St 1 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     5 Width 4ft   6002426.58546 2102995.56923 37.7545623793656 -122.434548932106 (37.7545623793656, -122.434548932106) 2 4 5 28862 22
95649 224477 DPW Maintained 1 Ficus carica :: Edible Fig 32 23 Penny Ln 1 Back Yard : Yard 6 Tree 1 Private 2     7 Width 2ft   6002584.32363 2096230.7970099999 37.735996851473296 -122.43352002314501 (37.7359968514733, -122.433520023145) 2 7 5 63 7
116591 245116 DPW Maintained 1 Ficus carica :: Edible Fig 32 114 Lyon St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 0ft   6000340.3477 2109437.7149 37.772132265905 -122.44222610033701 (37.772132265905, -122.442226100337) 15 5 11 29492 9
119708 248052 DPW Maintained 1 Ficus carica :: Edible Fig 32 19 Rutledge St 1 Front Yard : Yard 4 Tree 1 Private 2     14     6010613.31023 2099368.8774099997 37.7450656176979 -122.405981455594 (37.7450656176979, -122.405981455594) 2 7 7 28859 2
120275 248580 DPW Maintained 1 Ficus carica :: Edible Fig 32 790 Clayton St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   5998640.4941 2107685.72 37.7672247081746 -122.447979846575 (37.7672247081746, -122.447979846575) 15 5 11 29492 9
121395 249980 DPW Maintained 1 Ficus carica :: Edible Fig 32 224 Filbert St 1 Front Yard : Yard 4 Tree 1 Private 2     6 Width 0ft   6011664.253830001 2120117.28296 37.8020947070772 -122.40380716737499 (37.8020947070772, -122.403807167375) 3 1 10 308 23
121413 249997 DPW Maintained 1 Ficus carica :: Edible Fig 32 39 Darrell Pl 1 Back Yard : Yard 6 Tree 1 Private 2     20 Width 0ft   6011507.582230001 2120247.7373900004 37.802444149427 -122.40435851653 (37.802444149427, -122.40435851653) 3 1 10 308 23
121414 249998 DPW Maintained 1 Ficus carica :: Edible Fig 32 39 Darrell Pl 2 Back Yard : Yard 6 Tree 1 Private 2     18 Width 0ft   6011504.54206 2120237.90093 37.8024169710215 -122.40436834431699 (37.8024169710215, -122.404368344317) 3 1 10 308 23
121415 249999 DPW Maintained 1 Ficus carica :: Edible Fig 32 39 Darrell Pl 3 Back Yard : Yard 6 Tree 1 Private 2     121 Width 0ft   6011509.9435 2120224.2158 37.8023796968334 -122.404348688764 (37.8023796968334, -122.404348688764) 3 1 10 308 23
121656 250220 DPW Maintained 1 Ficus carica :: Edible Fig 32 312 Filbert St 1 Side Yard : Yard 27 Tree 1 Private 2     11 Width 0ft   6011282.86826 2120079.66018 37.8019700907042 -122.405124300067 (37.8019700907042, -122.405124300067) 3 1 10 308 23
123698 253366 Significant Tree 4 Ficus carica :: Edible Fig 32 20 Laussat St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004582.0 2109434.0 37.772362894278395 -122.427553605007 (37.7723628942784, -122.427553605007) 7 9 11 28852 10
125229 255622 DPW Maintained 1 Ficus carica :: Edible Fig 32 372 San Carlos St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006691.0 2103946.0 37.757413199431504 -122.419868866239 (37.7574131994315, -122.419868866239) 2 4 7 28859 19
169831 66572 DPW Maintained 1 Ficus carica :: Edible Fig 32 145 Congdon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/25/2008 12:00:00 AM 3 3x3 Permit Number 51752 6004706.15432 2094089.03232 37.7302362036282 -122.426031579819 (37.7302362036282, -122.426031579819) 9 7 6 28861 5
184409 92073 Permitted Site 2 Ficus carica :: Edible Fig 32 2944 23rd St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/18/2009 12:00:00 AM   3x3 Permit Number 52189 6009219.0 2102774.0 37.7543372460114 -122.411043222573 (37.7543372460114, -122.411043222573) 2 4 7 28859 19

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