trees
8,659 rows where qSpecies_id = 11 sorted by Zip Codes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46966 | 87694 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010413.19181 | 2085847.77235 | 37.707928294454 | -122.405721229244 | (37.707928294454, -122.405721229244) | 28588 | |||||||
| 132310 | 87691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010453.75722 | 2085956.27314 | 37.7082284842795 | -122.40558866725 | (37.7082284842795, -122.40558866725) | 28588 | |||||||
| 171870 | 87692 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010446.60881 | 2085937.89343 | 37.708177617555 | -122.405612079416 | (37.708177617555, -122.405612079416) | 28588 | |||||||
| 236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
| 240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
| 496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
| 633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
| 2514 | 130116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008620.49903 | 2113131.73284 | 37.782743588087 | -122.413845626693 | (37.782743588087, -122.413845626693) | 7 | 10 | 9 | 28852 | 36 | |||
| 2747 | 129970 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 245 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009400.62978 | 2113906.25304 | 37.7849140164063 | -122.411201422913 | (37.7849140164063, -122.411201422913) | 14 | 10 | 9 | 28852 | 36 | |||
| 2844 | 45194 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2001 12:00:00 AM | 6 | Permit Number 44039 | 6008463.06426 | 2114024.06162 | 37.7851848652278 | -122.414453446982 | (37.7851848652278, -122.414453446982) | 7 | 10 | 9 | 28852 | 36 | |
| 3797 | 260871 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
| 4947 | 6953 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 609 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004373.4958 | 2110460.1271 | 37.7751685930556 | -122.428347988839 | (37.7751685930556, -122.428347988839) | 7 | 9 | 11 | 28852 | 10 | ||
| 5118 | 169123 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009469.52117 | 2113800.26568 | 37.7846268637924 | -122.410955591431 | (37.7846268637924, -122.410955591431) | 14 | 10 | 9 | 28852 | 36 | ||
| 5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
| 5686 | 129917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004089.66416 | 2110540.0338 | 37.7753719324971 | -122.429335525339 | (37.7753719324971, -122.429335525339) | 7 | 9 | 11 | 28852 | 10 | |||
| 5899 | 228878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004644.50049 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | 7 | 9 | 11 | 28852 | 10 | |||
| 5944 | 130091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 740 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005787.47808 | 2112322.76962 | 37.780362864998 | -122.423589158734 | (37.780362864998, -122.423589158734) | 7 | 9 | 11 | 28852 | 41 | |||
| 6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
| 6520 | 73325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 141 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6008557.19392 | 2112976.99217 | 37.7823151519537 | -122.414053685727 | (37.7823151519537, -122.414053685727) | 7 | 10 | 9 | 28852 | 36 | |||
| 6830 | 260679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
| 7107 | 9706 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6005904.98118 | 2111477.12508 | 37.7780475630877 | -122.423122534696 | (37.7780475630877, -122.423122534696) | 7 | 9 | 11 | 28852 | 10 | |||
| 7339 | 130136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 520 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005895.11777 | 2111561.87287 | 37.7782797032844 | -122.423162681334 | (37.7782797032844, -122.423162681334) | 7 | 9 | 11 | 28852 | 10 | |||
| 7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 7718 | 129913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 514 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004072.23496 | 2110659.68324 | 37.7756994736965 | -122.429404351323 | (37.7756994736965, -122.429404351323) | 7 | 9 | 11 | 28852 | 10 | |||
| 7977 | 63890 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.7738794203064 | -122.423454911884 | (37.7738794203064, -122.423454911884) | 7 | 9 | 11 | 28852 | 10 | ||
| 8182 | 130186 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005950.50335 | 2111126.42384 | 37.7770871914573 | -122.422940125193 | (37.7770871914573, -122.422940125193) | 7 | 9 | 11 | 28852 | 10 | |||
| 8336 | 75176 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 288 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009077.63424 | 2113593.69297 | 37.7840376819271 | -122.412296788176 | (37.7840376819271, -122.412296788176) | 14 | 10 | 9 | 28852 | 36 | |||
| 8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
| 8972 | 23214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006727.4886023 | 2112541.6876005 | 37.7810169750537 | -122.42035276087 | (37.7810169750537, -122.42035276087) | 7 | 9 | 9 | 28852 | 36 | ||
| 9369 | 130083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 633 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 11:15:00 AM | 2 | Width 4ft | 6006236.08792 | 2112182.41564 | 37.7800027989227 | -122.422027232369 | (37.7800027989227, -122.422027232369) | 7 | 9 | 11 | 28852 | 41 | ||
| 9706 | 260678 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9750 | 169122 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009478.56357 | 2113738.5186 | 37.7844578281201 | -122.410919945006 | (37.7844578281201, -122.410919945006) | 14 | 10 | 9 | 28852 | 36 | ||
| 9875 | 23182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006776.0786915 | 2112192.9314348 | 37.7800621132124 | -122.42015990463 | (37.7800621132124, -122.42015990463) | 7 | 9 | 9 | 28852 | 36 | ||
| 9891 | 53917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 308 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1988 12:00:00 AM | 16 | Permit Number 25579 | 6008884.50238 | 2113564.96808 | 37.783947970966 | -122.412962925017 | (37.783947970966, -122.412962925017) | 7 | 10 | 9 | 28852 | 36 | |
| 9895 | 130101 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 01:58:00 PM | 2 | Width 4ft | 6008550.81103 | 2113028.31881 | 37.7824557240915 | -122.414079400045 | (37.7824557240915, -122.414079400045) | 7 | 10 | 9 | 28852 | 36 | ||
| 9927 | 83681 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009001.7145 | 2113646.06927 | 37.7841772342254 | -122.412563147579 | (37.7841772342254, -122.412563147579) | 14 | 10 | 9 | 28852 | 36 | |||
| 10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
| 10415 | 43967 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43534 | 6006999.24602912 | 2112908.87547401 | 37.7820404937398 | -122.419438672428 | (37.7820404937398, -122.419438672428) | 7 | 9 | 9 | 28852 | 36 | |||
| 10479 | 30512 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 340 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1995 12:00:00 AM | 12 | Permit Number 34525 | 6008741.77827 | 2113543.53334 | 37.7838811036663 | -122.413455183303 | (37.7838811036663, -122.413455183303) | 7 | 10 | 9 | 28852 | 36 | ||
| 10746 | 130121 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 711 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6006217.81711 | 2112104.31895 | 37.7797873339463 | -122.422084889732 | (37.7797873339463, -122.422084889732) | 7 | 9 | 11 | 28852 | 10 | |||
| 10853 | 14629 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166 | (37.7800133326755, -122.42137953166) | 7 | 9 | 11 | 28852 | 41 | |||
| 10962 | 39426 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.7733943405421 | -122.42743561187 | (37.7733943405421, -122.42743561187) | 7 | 9 | 11 | 28852 | 10 | |||
| 11195 | 110472 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542 | 2111298 | 37.7775352389463 | -122.424365474196 | (37.7775352389463, -122.424365474196) | 7 | 9 | 11 | 28852 | 10 | ||
| 11471 | 260869 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
| 11789 | 130145 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2017 12:00:00 AM | 3 | Width 4ft | 6005854.49037 | 2111843.71105 | 37.7790512694499 | -122.42332326697 | (37.7790512694499, -122.42332326697) | 7 | 9 | 11 | 28852 | 10 | ||
| 12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
| 12085 | 9686 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.422761599875 | (37.7762854431535, -122.422761599875) | 7 | 9 | 11 | 28852 | 10 | |||
| 12452 | 130093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 70 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008660.01542 | 2112613.42872 | 37.7813226682591 | -122.413672244582 | (37.7813226682591, -122.413672244582) | 7 | 10 | 9 | 28852 | 36 | |||
| 12524 | 29159 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 532 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 8 | 3x3 | 6008904.683107 | 2114354.7787345 | 37.7861177338401 | -122.412948968266 | (37.7861177338401, -122.412948968266) | 5 | 10 | 9 | 28852 | 36 | ||
| 12710 | 130149 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006347.46727 | 2111403.63239 | 37.7778707302976 | -122.421586593341 | (37.7778707302976, -122.421586593341) | 7 | 9 | 11 | 28852 | 10 | |||
| 12801 | 30518 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 409 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1995 12:00:00 AM | 5 | Permit Number 34527 | 6008424.27484 | 2113452.85192 | 37.7836142820115 | -122.41454721209 | (37.7836142820115, -122.41454721209) | 7 | 10 | 9 | 28852 | 36 | |
| 12907 | 57882 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 285 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1991 12:00:00 AM | Permit Number 16832 | 6008642.54194369 | 2113136.6674883 | 37.7827583753423 | -122.413769716445 | (37.7827583753423, -122.413769716445) | 7 | 10 | 9 | 28852 | 36 | ||
| 13320 | 130154 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 155 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006852.76549 | 2111067.6012 | 37.7769765487554 | -122.419814736462 | (37.7769765487554, -122.419814736462) | 7 | 9 | 11 | 28852 | 10 | |||
| 13704 | 9704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6005878.26798 | 2111295.24256 | 37.7775466504055 | -122.423202013315 | (37.7775466504055, -122.423202013315) | 7 | 9 | 11 | 28852 | 10 | ||
| 13730 | 260870 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
| 14092 | 23172 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 214 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006926.9126711 | 2111261.9734357 | 37.7775144249112 | -122.419572031751 | (37.7775144249112, -122.419572031751) | 7 | 9 | 9 | 28852 | 36 | |||
| 14102 | 10249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 115 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 20 | 3X3 | 6005554.00593 | 2109582.93221 | 37.7728267566811 | -122.424201936088 | (37.7728267566811, -122.424201936088) | 7 | 9 | 11 | 28852 | 10 | ||
| 14651 | 260677 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
| 14875 | 130179 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006655.87102 | 2110834.54234 | 37.7763255313215 | -122.420479309383 | (37.7763255313215, -122.420479309383) | 7 | 9 | 11 | 28852 | 10 | |||
| 14967 | 108631 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 501 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008465.6 | 2113811.6 | 37.7846016393538 | -122.4144296353 | (37.7846016393538, -122.4144296353) | 7 | 10 | 9 | 28852 | 36 | ||||
| 15004 | 82837 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 604 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004044.4214 | 2110838.57135 | 37.7761890816952 | -122.429513325784 | (37.7761890816952, -122.429513325784) | 7 | 9 | 11 | 28852 | 10 | |||
| 15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 15930 | 69139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 573 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1994 12:00:00 AM | Permit Number 33171 | 6008555.67489002 | 2114162.36008798 | 37.7855698016133 | -122.4141428296 | (37.7855698016133, -122.4141428296) | 7 | 10 | 9 | 28852 | 36 | ||
| 15954 | 79175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005975.99544 | 2111376.30995 | 37.777774756444 | -122.422869703793 | (37.777774756444, -122.422869703793) | 7 | 9 | 11 | 28852 | 10 | |||
| 16006 | 130042 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 575 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6008550.22536 | 2114161.85269 | 37.7855681023292 | -122.414161647536 | (37.7855681023292, -122.414161647536) | 7 | 10 | 9 | 28852 | 36 | |||
| 16121 | 130125 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006275.72072 | 2111955.4764 | 37.7793819141766 | -122.421873999612 | (37.7793819141766, -122.421873999612) | 7 | 9 | 11 | 28852 | 10 | |||
| 16711 | 249324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007004.56067 | 2110712.36336 | 37.7760097011293 | -122.419264423336 | (37.7760097011293, -122.419264423336) | 7 | 9 | 9 | 28852 | 36 | |||
| 16728 | 7806 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 699X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767203 | 6006206.38282 | 2112399.17738 | 37.780596298426 | -122.422145399717 | (37.780596298426, -122.422145399717) | 7 | 9 | 11 | 28852 | 41 | |
| 16777 | 228898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Haight St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005584.45074 | 2109588.27771 | 37.7728431531072 | -122.424097004096 | (37.7728431531072, -122.424097004096) | 7 | 9 | 11 | 28852 | 10 | |||
| 16866 | 130096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 129 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008965.481 | 2112829.85819 | 37.7819340804439 | -122.412630783808 | (37.7819340804439, -122.412630783808) | 7 | 10 | 9 | 28852 | 36 | |||
| 17114 | 29134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 60 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2015 12:00:00 AM | 3 | 3x3 | 6008669.2299 | 2112549.0897 | 37.7811465261229 | -122.413635814866 | (37.7811465261229, -122.413635814866) | 7 | 10 | 9 | 28852 | 36 | ||
| 17539 | 9421 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.422598636412 | (37.7806825946662, -122.422598636412) | 7 | 9 | 11 | 28852 | 41 | |
| 17583 | 6884 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 259 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6006188.5681 | 2110693.92394 | 37.7759130816021 | -122.422085850442 | (37.7759130816021, -122.422085850442) | 7 | 9 | 11 | 28852 | 10 | ||
| 17676 | 130067 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 820 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005741.65967 | 2112631.11422 | 37.7812069173917 | -122.423769596899 | (37.7812069173917, -122.423769596899) | 7 | 9 | 11 | 28852 | 41 | |||
| 17775 | 73335 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 240 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6008418.7478 | 2112810.19773 | 37.7818493975717 | -122.414520843074 | (37.7818493975717, -122.414520843074) | 7 | 10 | 9 | 28852 | 36 | |||
| 18233 | 130102 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 161 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008076.49844 | 2112975.72629 | 37.782284665857 | -122.41571659427 | (37.782284665857, -122.41571659427) | 7 | 10 | 9 | 28852 | 36 | |||
| 18377 | 79432 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005955.30397 | 2111373.13166 | 37.7777648621077 | -122.422941056882 | (37.7777648621077, -122.422941056882) | 7 | 9 | 11 | 28852 | 10 | |||
| 18437 | 260868 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
| 18865 | 9713 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 3 | 4X4 | 6005848.49792 | 2111505.90882 | 37.7781234086211 | -122.423319977441 | (37.7781234086211, -122.423319977441) | 7 | 9 | 11 | 28852 | 10 | ||
| 19273 | 27325 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 324 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2013 04:12:00 PM | 30 | 4x4 | 6004570.65008 | 2109631.91786 | 37.7729056865905 | -122.427606968753 | (37.7729056865905, -122.427606968753) | 7 | 9 | 11 | 28852 | 10 | ||
| 19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 20226 | 14645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | 4x4 | 6006263.6652094 | 2112113.7657972 | 37.7798158584752 | -122.421926952026 | (37.7798158584752, -122.421926952026) | 7 | 9 | 11 | 28852 | 10 | |||
| 20557 | 228770 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 261 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006199.76937 | 2110713.18294 | 37.7759665939245 | -122.422048470765 | (37.7759665939245, -122.422048470765) | 7 | 9 | 11 | 28852 | 10 | |||
| 20687 | 130079 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006638.95897 | 2112585.46441 | 37.781132186441 | -122.420662137964 | (37.781132186441, -122.420662137964) | 7 | 9 | 11 | 28852 | 41 | |||
| 20807 | 130070 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 311 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006024.24376 | 2112615.00773 | 37.7811786409295 | -122.422790849428 | (37.7811786409295, -122.422790849428) | 7 | 9 | 11 | 28852 | 41 | |||
| 20838 | 130128 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006287.88119 | 2111885.61701 | 37.7791907830552 | -122.42182696776 | (37.7791907830552, -122.42182696776) | 7 | 9 | 11 | 28852 | 10 | |||
| 20923 | 9411 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 601X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1999 12:00:00 AM | 6 | 3X3 | 6006553.11457 | 2112551.33182 | 37.7810336281325 | -122.420956693216 | (37.7810336281325, -122.420956693216) | 7 | 9 | 11 | 28852 | 41 | ||
| 21336 | 130187 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 414 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005945.62483 | 2111174.41084 | 37.7772186768345 | -122.422960412995 | (37.7772186768345, -122.422960412995) | 7 | 9 | 11 | 28852 | 10 | |||
| 21505 | 40126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | 6 | Permit Number 43924 | 6009321.01562 | 2113925.96914 | 37.7849636868553 | -122.411478256742 | (37.7849636868553, -122.411478256742) | 14 | 10 | 9 | 28852 | 36 | ||
| 22049 | 14663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 660X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005833.92671 | 2111981.65022 | 37.77942885617 | -122.423404213855 | (37.77942885617, -122.423404213855) | 7 | 9 | 11 | 28852 | 10 | |||
| 22101 | 130190 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 440 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005924.06375 | 2111323.77009 | 37.7776275644082 | -122.423045618364 | (37.7776275644082, -122.423045618364) | 7 | 9 | 11 | 28852 | 10 | |||
| 22621 | 130054 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 639 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008702.06176 | 2114530.64649 | 37.7865892483359 | -122.413662430293 | (37.7865892483359, -122.413662430293) | 5 | 1 | 9 | 28852 | 36 | |||
| 22743 | 29147 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008932.73484 | 2113804.52524 | 37.7846084447553 | -122.412812999913 | (37.7846084447553, -122.412812999913) | 7 | 10 | 9 | 28852 | 36 | ||
| 22912 | 228771 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 241 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006281.15263 | 2110725.29619 | 37.7760044436862 | -122.421767804961 | (37.7760044436862, -122.421767804961) | 7 | 9 | 11 | 28852 | 10 | |||
| 22963 | 14634 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 610X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006291.3344 | 2112208.29318 | 37.7800769680727 | -122.42183794834 | (37.7800769680727, -122.42183794834) | 7 | 9 | 11 | 28852 | 41 | |||
| 23292 | 12276 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004876.20262 | 2111410.73747 | 37.777807169502 | -122.426676721228 | (37.777807169502, -122.426676721228) | 7 | 9 | 11 | 28852 | 10 | |||
| 23524 | 130066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 820 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005746.45036 | 2112612.6258 | 37.7811564231596 | -122.423751708487 | (37.7811564231596, -122.423751708487) | 7 | 9 | 11 | 28852 | 41 | |||
| 23621 | 129918 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004090.45623 | 2110518.14063 | 37.7753118640728 | -122.429331223855 | (37.7753118640728, -122.429331223855) | 7 | 9 | 11 | 28852 | 10 | |||
| 23788 | 130094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 70 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008652.39355 | 2112664.78131 | 37.7814632421824 | -122.413702245957 | (37.7814632421824, -122.413702245957) | 7 | 10 | 9 | 28852 | 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );