Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");