Street_Tree_List

Data source: data.sfgov.org

8,305 rows where qSpecies = 11

View and edit SQL

Suggested facets: qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
18 96369 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 168 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2011 12:00:00 AM 24 3x3 Permit Number 767919 6001162.44444 2121276.45677 37.8046852096195 -122.44023153767799 (37.8046852096195, -122.440231537678)
24 22346 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 5280 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/27/2014 12:00:00 AM 3 3x3   6014341.487000001 2093641.8617 37.7295482207565 -122.39268941982701 (37.7295482207565, -122.392689419827)
32 10933 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1359 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
38 192589 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
39 3558 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 101 Cargo Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2017 05:52:00 PM 6 3X3   6018773.865780001 2097541.9761 37.7405023461002 -122.377636624239 (37.7405023461002, -122.377636624239)
41 192590 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
48 3528 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 38 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
64 138748 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1614 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000643.1477 2114229.9232 37.7853077023438 -122.441522641665 (37.7853077023438, -122.441522641665)
101 192592 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
108 192593 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
112 9896 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1800X Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
126 228560 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
137 228561 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006199.77605 2105468.2728 37.7615653191939 -122.42167583577299 (37.7615653191939, -122.421675835773)
170 48827 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 435 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2002 12:00:00 AM 5 3x3 Permit Number 46051 6011929.23024 2118387.60951 37.79736024144329 -122.402768502565 (37.7973602414433, -122.402768502565)
176 24515 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2030 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2016 07:40:00 AM 3 3X3   5997710.2902 2109583.0289 37.772381016672895 -122.45133412385 (37.7723810166729, -122.45133412385)
268 46773 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 35 San Juan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2017 12:00:00 AM 3   Permit Number 779460 6001741.72526 2092006.08473 37.7243489150655 -122.43613098976101 (37.7243489150655, -122.436130989761)
281 9686 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 300X Gough St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6005996.09112 2110833.49174 37.7762854431535 -122.42276159987499 (37.7762854431535, -122.422761599875)
292 9421 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 701X Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/08/2011 12:00:00 AM 12 3x3 Permit Number 767203 6006076.0707 2112433.28351 37.7806825946662 -122.42259863641199 (37.7806825946662, -122.422598636412)
317 7957 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1800 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/22/2016 03:18:00 PM 3 3X3   6005720.43568 2116275.48789 37.791212266380896 -122.424102272302 (37.7912122663809, -122.424102272302)
348 229175 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 795 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 3ft   6006285.87907 2104987.97511 37.7602513890079 -122.421343931093 (37.7602513890079, -122.421343931093)
359 22941 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 413 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/2017 12:00:00 AM 6 3X3   6006166.67617 2107189.14794 37.766288570288204 -122.421912561635 (37.7662885702882, -122.421912561635)
366 22992 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 670 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/2017 12:00:00 AM 18 3X3   6006180.5496 2105697.57647 37.7621938490894 -122.42175862016501 (37.7621938490894, -122.421758620165)
369 192563 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
372 251291 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
374 117614 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 345 Stockton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2016 12:00:00 AM 3 5x5   6010658.32467 2115339.45675 37.788919706525704 -122.406951233227 (37.7889197065257, -122.406951233227)
376 229176 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 793 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 Width 3ft   6006285.11873 2105008.6290700003 37.7603080570896 -122.42134802750601 (37.7603080570896, -122.421348027506)
379 122497 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 31X 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
381 122664 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
382 228870 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 132 Church St 1 : 4 Tree 1 Private 1   11/03/2006 12:00:00 AM 2 Width 4ft Permit Number 49185 6004081.45763 2108139.41942 37.768779966653106 -122.42919270218599 (37.7687799666531, -122.429192702186)
395 249557 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 3 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
400 251289 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
404 249555 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 1 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
406 249556 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 2 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
411 154366 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 411 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6006164.37856 2107202.76015 37.7663258166161 -122.42192147568899 (37.7663258166161, -122.421921475689)
412 251290 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
413 249558 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 4 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
416 192564 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
417 229177 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 789 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 Width 3ft   6006284.79968 2105036.34994 37.7603841541343 -122.42135109956699 (37.7603841541343, -122.421351099567)
424 122666 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
445 251285 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1299x Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
456 23112 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1448 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/26/1992 12:00:00 AM 20 3X3 Permit Number 779902 6006436.396269999 2101132.22455 37.74967287242389 -122.42054965793899 (37.7496728724239, -122.420549657939)
471 10470 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1614 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/19/2015 08:11:00 AM 3 3x3   5998358.4613 2108632.1531 37.76980724742621 -122.449023538308 (37.7698072474262, -122.449023538308)
501 251171 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:21:00 AM 3              
506 4706 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 950 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 09:29:00 PM 3 4x4   6008667.8262 2120581.3066 37.8032009492885 -122.414209123056 (37.8032009492885, -122.414209123056)
520 4707 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 968 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 09:15:00 PM 3 5x5   6008654.9315 2120594.2013 37.8032356306012 -122.414254658567 (37.8032356306012, -122.414254658567)
524 4705 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 940 Columbus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 09:01:00 PM 3 3X3   6008689.9314 2120561.6575 37.8031482394038 -122.414131236147 (37.8031482394038, -122.414131236147)
600 229041 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1398 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/15/1990 12:00:00 AM 10 Width 3ft   6004493.077930001 2100786.6559900003 37.7486143110022 -122.427245115077 (37.7486143110022, -122.427245115077)
609 13247 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 2372X Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1994 12:00:00 AM 40 4x4   6001031.9779 2119351.2951 37.7993917986357 -122.44054486433201 (37.7993917986357, -122.440544864332)
619 244248 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 02:55:00 PM 3 Width 0ft   6005671.5367 2110041.0199 37.7740911903854 -122.42382796196699 (37.7740911903854, -122.423827961967)
620 244252 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:09:00 PM 3 Width 0ft   6005662.3712 2110108.233 37.7742752238868 -122.423864447369 (37.7742752238868, -122.423864447369)
636 244251 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:04:00 PM 3 Width 0ft   6005664.6626 2110090.6659 37.7742271182357 -122.423855271591 (37.7742271182357, -122.423855271591)
648 244249 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:00:00 PM 3 Width 0ft   6005669.2453 2110057.8231 37.774137198555 -122.423837083382 (37.774137198555, -122.423837083382)
650 11111 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 2015 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2012 12:00:00 AM 5 3x3   6007199.704059999 2119289.07559 37.7995702354477 -122.419197895967 (37.7995702354477, -122.419197895967)
710 1291 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3990 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/17/2017 01:08:00 PM 3 3x3   5992151.4222 2087298.4709 37.7108734249293 -122.468940594456 (37.7108734249293, -122.468940594456)
790 216490 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 800x Bosworth St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 Width 3ft   6001788.93125 2095501.57158 37.7339494063362 -122.436217839104 (37.7339494063362, -122.436217839104)
807 208295 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 720 Bosworth St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/1994 12:00:00 AM 7 Width 3ft   6001977.00756 2095485.3679900002 37.7339155990291 -122.435566443955 (37.7339155990291, -122.435566443955)
875 192615 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1500 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/2013 12:00:00 AM 3 Width 3ft   6007534.31232 2110058.9232900003 37.774245331079996 -122.417385549806 (37.77424533108, -122.417385549806)
876 192614 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1500 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2016 12:00:00 AM 4 Width 3ft   6007548.67256 2110072.64933 37.774283827466896 -122.417336847918 (37.7742838274669, -122.417336847918)
912 137817 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2001 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6004275.6077 2115310.8412 37.7884819087987 -122.429032528237 (37.7884819087987, -122.429032528237)
959 83601 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/22/2008 12:00:00 AM 5     6009088.96788 2112689.1650900003 37.7815547005346 -122.41219362785499 (37.7815547005346, -122.412193627855)
960 229022 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 383 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/1994 12:00:00 AM 10 Width 3ft   6006155.35301 2107408.62146 37.7668905539726 -122.421967318656 (37.7668905539726, -122.421967318656)
965 130085 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 600 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 4ft   6006282.409 2112253.58537 37.7802008260541 -122.421872043567 (37.7802008260541, -122.421872043567)
968 129976 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 90x Jones St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 4ft   6009114.5006 2112815.4856 37.781902979173005 -122.41211422669399 (37.781902979173, -122.412114226694)
969 229181 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 701 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006262.86833 2105467.84413 37.7615676997051 -122.421457594595 (37.7615676997051, -122.421457594595)
981 191653 Private 5 Lophostemon confertus :: Brisbane Box 11 149 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6012146.38303 2114300.35662 37.786149737060796 -122.40172965521799 (37.7861497370608, -122.401729655218)
1036 200488 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2585 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 4ft   6015927.44102 2103090.66004 37.7555806376415 -122.38786561392901 (37.7555806376415, -122.387865613929)
1045 21995 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2585 03rd St 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/05/2013 12:00:00 AM 3 3x3   6015907.79348 2103393.10685 37.75641000413321 -122.38795466567801 (37.7564100041332, -122.387954665678)
1047 200448 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2585 03rd St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6015917.22039 2103323.37431 37.7562190555923 -122.387917198143 (37.7562190555923, -122.387917198143)
1051 129953 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 746 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/2016 12:00:00 AM 7 Width 4ft   6008786.570230001 2115169.45222 37.7883479993951 -122.413415244417 (37.7883479993951, -122.413415244417)
1053 21992 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 2585 03rd St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2013 12:00:00 AM 2 3x3   6015915.41358 2103336.7634099997 37.756255719130394 -122.387924381009 (37.7562557191304, -122.387924381009)
1056 29156 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 450 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/19/2005 12:00:00 AM 6 3x3   6008935.09888 2114132.4123400003 37.7855088765704 -122.41282801050501 (37.7855088765704, -122.412828010505)
1078 2333 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2321 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/26/1990 12:00:00 AM 18 5X5   6009703.8951 2103811.21237 37.7572123783538 -122.40943952063299 (37.7572123783538, -122.409439520633)
1106 251445 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 300 Beale St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6014884.877230001 2114997.01321 37.7882150346369 -122.39230385636002 (37.7882150346369, -122.39230385636)
1111 3698 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 401X Cargo Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/03/2017 11:57:00 AM 3 3X3   6016408.29218 2099351.9279400003 37.745341482920296 -122.385942065688 (37.7453414829203, -122.385942065688)
1149 19194 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 150 Sanchez St 1 Median : Cutout 11 Tree 1 DPW 2     25 3X3   6003510.8594 2107438.4604 37.7668229855288 -122.43111632094801 (37.7668229855288, -122.431116320948)
1205 200814 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 4706 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6014979.4823 2095765.9955 37.7354160755771 -122.390632161008 (37.7354160755771, -122.390632161008)
1224 59196 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 272 09th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/1980 12:00:00 AM 8   Permit Number 779761 6009046.37885 2109959.18695 37.7740564365968 -122.41214796834998 (37.7740564365968, -122.41214796835)
1257 197452 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 668 Natoma St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6009185.76341 2111038.87777 37.7770288335587 -122.41174211691799 (37.7770288335587, -122.411742116918)
1279 245833 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 451 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 0ft   6005191.6007 2110574.0246 37.775527586454004 -122.425526086229 (37.775527586454, -122.425526086229)
1293 87727 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2238X Van Ness Ave 5 Median : Cutout 11 Tree 1 DPW 2   01/25/2008 12:00:00 AM 3 3x3   6005927.4039 2118140.07713 37.7963436433 -122.42351878677799 (37.7963436433, -122.423518786778)
1355 29680 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1900X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     3     6006072.343230001 2117086.04016 37.7934577026643 -122.422942314134 (37.7934577026643, -122.422942314134)
1388 251519 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1392 29683 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1900X Van Ness Ave 6 Median : Cutout 11 Tree 1 DPW 2   02/11/2012 12:00:00 AM 5     6006051.34304 2117188.93929 37.793739052873704 -122.423022293545 (37.7937390528737, -122.423022293545)
1401 251523 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1405 228661 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   03/07/1990 12:00:00 AM 13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943)
1413 246406 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1414 251524 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1416 251521 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1420 228662 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   03/07/1990 12:00:00 AM 16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999)
1421 228663 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 4235 19th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639)
1425 251522 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1433 251520 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1496 110536 Private 5 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 05/29/2015 02:12:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1565 29772 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1329 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2006 12:00:00 AM 8 3x3   6007229.90871 2121805.15578 37.8064804551638 -122.419271958731 (37.8064804551638, -122.419271958731)
1569 29756 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 990 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6008576.3352 2120666.0433 37.8034284755503 -122.414531731143 (37.8034284755503, -122.414531731143)
1578 143015 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 968 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/13/2016 07:32:00 AM 16 Width 0ft   6008678.8788 2120570.254 37.8031712224349 -122.41417009265301 (37.8031712224349, -122.414170092653)
1587 4703 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 930 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/19/1984 12:00:00 AM 36 5x6   6008724.3173 2120532.798 37.8030709297568 -122.41401019958 (37.8030709297568, -122.41401019958)
1610 7740 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 345 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/07/1995 12:00:00 AM 12 3X3   6006360.17596 2111335.26582 37.777683728843996 -122.42153777275101 (37.777683728844, -122.421537772751)
1679 13267 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2460 Lombard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/22/2016 02:09:00 PM 3 3X3   6000572.6787 2119285.0637 37.7991837803388 -122.44212944000601 (37.7991837803388, -122.442129440006)
1690 6935 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 528 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004882.44233 2110586.3122400003 37.775543852304004 -122.426596415205 (37.775543852304, -122.426596415205)

Next page

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