trees
8,659 rows where qSpecies_id = 11 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40048 | 130339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 19 Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011530.16856 | 2121106.58416 | 37.8048035945816 | -122.40434084215 | (37.8048035945816, -122.40434084215) | 3 | 1 | 10 | 28860 | 6 | |||
| 40366 | 60874 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/2002 12:00:00 AM | 7 | Permit Number 44657 | 6008963.3966 | 2120062.90728 | 37.8017941518313 | -122.413149610791 | (37.8017941518313, -122.413149610791) | 3 | 1 | 10 | 308 | 32 | |
| 41517 | 37502 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 7 | Permit Number 39966 | 6008740.03897 | 2115504.68539 | 37.7892658555875 | -122.413599955284 | (37.7892658555875, -122.413599955284) | 5 | 1 | 10 | 28858 | 21 | |
| 41598 | 40813 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 920 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 11 | Permit Number 41758 | 6010003.02767 | 2116942.94179 | 37.7932857990441 | -122.409331685627 | (37.7932857990441, -122.409331685627) | 3 | 1 | 10 | 28857 | 4 | ||
| 42172 | 57836 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 653 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1977 12:00:00 AM | 10 | Permit Number 16777 | 6011577.08674 | 2117218.25704 | 37.7941298128031 | -122.403904687166 | (37.7941298128031, -122.403904687166) | 3 | 1 | 10 | 28860 | 4 | ||
| 42328 | 29773 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1323 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007274.40422 | 2121764.03489 | 37.8063700535072 | -122.41911505491 | (37.8063700535072, -122.41911505491) | 5 | 1 | 1 | 28858 | 32 | ||
| 42449 | 130297 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012379.90581 | 2119017.74232 | 37.799115587681 | -122.401253342783 | (37.799115587681, -122.401253342783) | 3 | 1 | 10 | 28860 | 6 | |||
| 42726 | 96806 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 471 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 3x3 | Permit Number 771933 | 6011260.5 | 2118966.4 | 37.7989120989831 | -122.405123270049 | (37.7989120989831, -122.405123270049) | 3 | 1 | 10 | 308 | 23 | ||
| 43058 | 130346 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011487.67306 | 2121147.35061 | 37.8049131544873 | -122.404490774436 | (37.8049131544873, -122.404490774436) | 3 | 1 | 10 | 28860 | 23 | |||
| 43238 | 130213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Priest St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6008335.34786 | 2117068.60071 | 37.7935372512871 | -122.415110887372 | (37.7935372512871, -122.415110887372) | 5 | 1 | 10 | 28858 | 21 | |||
| 43356 | 130393 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013378.91553 | 2117221.99904 | 37.7942405867728 | -122.397670386194 | (37.7942405867728, -122.397670386194) | 4 | 1 | 10 | 28860 | 6 | |||
| 43584 | 29756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008576.3352 | 2120666.0433 | 37.8034284755503 | -122.414531731143 | (37.8034284755503, -122.414531731143) | 3 | 1 | 10 | 308 | 23 | |||
| 43726 | 130292 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1022 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011619.21201 | 2118843.01697 | 37.7985933657503 | -122.403873314323 | (37.7985933657503, -122.403873314323) | 3 | 1 | 10 | 308 | 23 | |||
| 43806 | 129981 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 432 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009793.2127 | 2114945.17066 | 37.787788644484 | -122.409916571395 | (37.787788644484, -122.409916571395) | 5 | 1 | 10 | 28852 | 36 | |||
| 43967 | 130389 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 752 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010078.78963 | 2116386.13916 | 37.7917611981659 | -122.409030237366 | (37.7917611981659, -122.409030237366) | 5 | 1 | 10 | 28857 | 21 | |||
| 44204 | 130334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011603.10457 | 2120820.39092 | 37.80402185349 | -122.404068284619 | (37.80402185349, -122.404068284619) | 3 | 1 | 10 | 28860 | 6 | |||
| 44778 | 129955 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 746 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008778.51569 | 2115210.69757 | 37.7884607968828 | -122.413446030029 | (37.7884607968828, -122.413446030029) | 5 | 1 | 10 | 28858 | 21 | |||
| 45105 | 130264 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007541.98485 | 2122297.32722 | 37.8078494032009 | -122.418226876366 | (37.8078494032009, -122.418226876366) | 5 | 1 | 10 | 308 | 23 | |||
| 45650 | 117616 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010664.75515 | 2115293.88961 | 37.7887949498725 | -122.406925771607 | (37.7887949498725, -122.406925771607) | 5 | 1 | 10 | 28857 | 6 | ||
| 45919 | 130391 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013399.85475 | 2117095.50751 | 37.7938944368446 | -122.397589057796 | (37.7938944368446, -122.397589057796) | 4 | 1 | 10 | 28860 | 6 | |||
| 45954 | 107358 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 227 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x6 | 6009554.7895 | 2121524.1368 | 37.8058395067291 | -122.411206388657 | (37.8058395067291, -122.411206388657) | 3 | 1 | 10 | 308 | 23 | |||
| 46088 | 130216 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1143 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008079.90379 | 2116443.786 | 37.7918073055226 | -122.41595048005 | (37.7918073055226, -122.41595048005) | 5 | 1 | 10 | 28858 | 21 | |||
| 46821 | 43072 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 6 | 3x3 | 6008014.74915 | 2114436.68155 | 37.7862926240458 | -122.416033714098 | (37.7862926240458, -122.416033714098) | 13 | 1 | 9 | 28858 | 36 | |
| 47968 | 107586 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 698 MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x5 | 6009682 | 2115721 | 37.7899126515148 | -122.410356148991 | (37.7899126515148, -122.410356148991) | 5 | 1 | 10 | 28857 | 21 | |||
| 48942 | 130255 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6007588.34652 | 2120300.03904 | 37.8023679660663 | -122.417924753627 | (37.8023679660663, -122.417924753627) | 5 | 1 | 1 | 308 | 32 | |||
| 48972 | 120646 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 780x Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008827 | 2115225 | 37.7885027900531 | -122.413279293156 | (37.7885027900531, -122.413279293156) | 5 | 1 | 10 | 28858 | 21 | ||||
| 49048 | 26542 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 530 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
| 49337 | 249370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 651 Jones St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6008788.37614 | 2114842.41575 | 37.7874501378682 | -122.413385859086 | (37.7874501378682, -122.413385859086) | 5 | 1 | 10 | 28852 | 36 | |||
| 49424 | 129984 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 432 Mason St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009783.80322 | 2115007.09056 | 37.7879581343069 | -122.409953499376 | (37.7879581343069, -122.409953499376) | 5 | 1 | 10 | 28852 | 36 | |||
| 49608 | 130357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011818.27586 | 2120942.36786 | 37.8043687921458 | -122.403332251602 | (37.8043687921458, -122.403332251602) | 3 | 1 | 10 | 28860 | 6 | |||
| 49735 | 33972 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1250 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 50539 | 130332 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6011713.56739 | 2120837.28367 | 37.8040744080582 | -122.403687207699 | (37.8040744080582, -122.403687207699) | 3 | 1 | 10 | 28860 | 6 | |||
| 50610 | 117614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010658.32467 | 2115339.45675 | 37.7889197065257 | -122.406951233227 | (37.7889197065257, -122.406951233227) | 5 | 1 | 10 | 28857 | 6 | ||
| 50743 | 58349 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2016 12:00:00 AM | 3 | Permit Number 17374 | 6010655.85992 | 2115362.95788 | 37.7889840970931 | -122.406961418056 | (37.7889840970931, -122.406961418056) | 5 | 1 | 10 | 28857 | 6 | ||
| 50807 | 83327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1183 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52237 | 6008573.12497 | 2117601.12307 | 37.7950127860746 | -122.414325852977 | (37.7950127860746, -122.414325852977) | 5 | 1 | 10 | 28857 | 21 | |
| 51202 | 100114 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 51289 | 64778 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | Permit Number 25770 | 6011643.76158416 | 2118722.06854887 | 37.7982626421043 | -122.403779849517 | (37.7982626421043, -122.403779849517) | 3 | 1 | 10 | 308 | 23 | ||
| 51926 | 121005 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 770 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | ||||
| 51973 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 773092 | 6006825 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | 5 | 1 | 1 | 28858 | 32 | |||
| 52365 | 115463 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 695x JONES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008737 | 2114865 | 37.787509264052 | -122.413565208574 | (37.787509264052, -122.413565208574) | 5 | 1 | 10 | 28858 | 36 | ||||
| 52599 | 108181 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010686.57825 | 2116924.79472 | 37.7932742451254 | -122.406965263124 | (37.7932742451254, -122.406965263124) | 3 | 1 | 10 | 28857 | 4 | ||||
| 52976 | 130215 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1645 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008326.84802 | 2118151.09734 | 37.7965090421155 | -122.415216960617 | (37.7965090421155, -122.415216960617) | 5 | 1 | 10 | 28858 | 21 | |||
| 53013 | 44361 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
| 53054 | 110664 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 434 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009804.95200969 | 2114873.04035134 | 37.7875912498832 | -122.409870861764 | (37.7875912498832, -122.409870861764) | 5 | 1 | 10 | 28852 | 36 | ||||
| 53543 | 115711 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008089 | 2121871 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | 5 | 1 | 10 | 308 | 23 | ||||
| 54165 | 103294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010967.25176 | 2121426.28761 | 37.8056499492485 | -122.406311424057 | (37.8056499492485, -122.406311424057) | 3 | 1 | 10 | 308 | 23 | |||
| 54537 | 130282 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007436.13705 | 2121979.03934 | 37.8069695074103 | -122.418570604471 | (37.8069695074103, -122.418570604471) | 5 | 1 | 10 | 308 | 23 | |||
| 54856 | 109630 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 998 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 1x1 | Permit Number 775136 | 6007840.9 | 2115211.2 | 37.7884094868041 | -122.416690077626 | (37.7884094868041, -122.416690077626) | 13 | 1 | 10 | 28858 | 21 | |
| 55191 | 44355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
| 55258 | 4601 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 256 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2014 08:46:00 AM | 3 | 3x3 | 6010926.0153976 | 2118519.2711432 | 37.7976656873563 | -122.406249182997 | (37.7976656873563, -122.406249182997) | 3 | 1 | 10 | 308 | 23 | ||
| 56171 | 143015 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2016 07:32:00 AM | 16 | Width 0ft | 6008678.8788 | 2120570.254 | 37.8031712224349 | -122.414170092653 | (37.8031712224349, -122.414170092653) | 3 | 1 | 10 | 308 | 23 | ||
| 56513 | 29750 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1333 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007187.30847 | 2121846.91915 | 37.8065927274426 | -122.419422349675 | (37.8065927274426, -122.419422349675) | 5 | 1 | 1 | 28858 | 32 | ||
| 56722 | 37506 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 6 | Permit Number 39966 | 6008737.12497 | 2115540.18684 | 37.7893631703113 | -122.413612549392 | (37.7893631703113, -122.413612549392) | 5 | 1 | 10 | 28858 | 21 | |
| 57207 | 130288 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007317.8229 | 2122229.78006 | 37.8076513158315 | -122.418997851683 | (37.8076513158315, -122.418997851683) | 5 | 1 | 10 | 308 | 23 | |||
| 58019 | 130363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011809.34098 | 2121067.49936 | 37.804711873607 | -122.40337198005 | (37.804711873607, -122.40337198005) | 3 | 1 | 10 | 28860 | 6 | |||
| 58366 | 129979 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 432 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009797.60495 | 2114898.88732 | 37.7876618077025 | -122.409898106515 | (37.7876618077025, -122.409898106515) | 5 | 1 | 10 | 28852 | 36 | |||
| 60120 | 65418 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 748 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1989 12:00:00 AM | Permit Number 28275 | 6009234.09730746 | 2115498.34646572 | 37.7892761805358 | -122.411890117866 | (37.7892761805358, -122.411890117866) | 5 | 1 | 10 | 28857 | 21 | ||
| 60156 | 4602 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 256 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2013 12:00:00 AM | 3 | 3x3 | 6010926.0153976 | 2118519.2711432 | 37.7976656873563 | -122.406249182997 | (37.7976656873563, -122.406249182997) | 3 | 1 | 10 | 308 | 23 | ||
| 60959 | 130400 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 634 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011433.74707 | 2117200.73697 | 37.7940736977875 | -122.404399426685 | (37.7940736977875, -122.404399426685) | 3 | 1 | 10 | 28860 | 4 | |||
| 61034 | 130359 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6011813.98533 | 2120985.08994 | 37.8044858568979 | -122.403350106723 | (37.8044858568979, -122.403350106723) | 3 | 1 | 10 | 28860 | 6 | |||
| 61094 | 37530 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 808 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 7 | Permit Number 39977 | 6008290.7088 | 2115267.79874 | 37.7885901814508 | -122.415137813984 | (37.7885901814508, -122.415137813984) | 5 | 1 | 10 | 28858 | 21 | |
| 61684 | 100109 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 61812 | 61257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 9 | Permit Number 30068 | 6007758.72791 | 2118741.72508 | 37.7980988141591 | -122.417224659311 | (37.7980988141591, -122.417224659311) | 5 | 1 | 10 | 28858 | 32 | |
| 62212 | 130299 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012383.92078 | 2118988.73973 | 37.7990361775407 | -122.401237410396 | (37.7990361775407, -122.401237410396) | 3 | 1 | 10 | 28860 | 6 | |||
| 62366 | 97194 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 390X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | |||
| 62394 | 39464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 9 | Permit Number 40935 | 6013007.13144 | 2117612.41259 | 37.7952918600786 | -122.398984224639 | (37.7952918600786, -122.398984224639) | 3 | 1 | 10 | 28860 | 6 | ||
| 62640 | 121059 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
| 62641 | 130232 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2013 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782588 | 6007201.62912 | 2119237.06192 | 37.7994275274066 | -122.419187542977 | (37.7994275274066, -122.419187542977) | 5 | 1 | 1 | 28858 | 32 |
| 62910 | 130411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 617 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2018 12:00:00 AM | 3 | Width 3ft | 6012484.57473 | 2118289.95115 | 37.7971230866295 | -122.400839990977 | (37.7971230866295, -122.400839990977) | 3 | 1 | 10 | 28860 | 4 | ||
| 63055 | 11098 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1931 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2014 12:00:00 AM | 3 | 3x3 | 6007242.44584 | 2118954.72532 | 37.7986546005895 | -122.419026265769 | (37.7986546005895, -122.419026265769) | 5 | 1 | 10 | 28858 | 32 | ||
| 63315 | 130251 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2333 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007534.87604 | 2120327.1071 | 37.8024392787168 | -122.418111708292 | (37.8024392787168, -122.418111708292) | 5 | 1 | 1 | 28858 | 32 | |||
| 63375 | 95192 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 723 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769100 | 6009186.21224 | 2115482.95364 | 37.7892312289946 | -122.412054706857 | (37.7892312289946, -122.412054706857) | 5 | 1 | 10 | 28858 | 21 | |
| 63514 | 130310 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 240 Vallejo St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 6012270.9402 | 2119166.66602 | 37.7995184164939 | -122.401640875949 | (37.7995184164939, -122.401640875949) | 3 | 1 | 10 | 28860 | 6 | |||
| 64259 | 87324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009381.28758 | 2116066.77313 | 37.7908451991044 | -122.411421029278 | (37.7908451991044, -122.411421029278) | 5 | 1 | 10 | 28857 | 21 | |||
| 64585 | 65481 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1011 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1991 12:00:00 AM | Permit Number 29935 | 6008648.50646901 | 2115567.22279015 | 37.7894324278925 | -122.413921073544 | (37.7894324278925, -122.413921073544) | 5 | 1 | 10 | 28858 | 21 | ||
| 65009 | 48498 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2312(REVISED) Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45838 | 6007594.14807985 | 2120292.61587813 | 37.8023479104406 | -122.417904150819 | (37.8023479104406, -122.417904150819) | 5 | 1 | 1 | 308 | 32 | |||
| 65116 | 130360 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011811.81302 | 2120998.52887 | 37.8045226355855 | -122.403358570239 | (37.8045226355855, -122.403358570239) | 3 | 1 | 10 | 28860 | 6 | |||
| 65221 | 4645 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 535 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 2 | 3x3 | 6009959.86502 | 2119280.94909 | 37.7997029776381 | -122.409646128867 | (37.7997029776381, -122.409646128867) | 3 | 1 | 10 | 308 | 4 | ||
| 65406 | 130196 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 917 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6008196.96456 | 2115613.59929 | 37.7895343967337 | -122.415486647488 | (37.7895343967337, -122.415486647488) | 13 | 1 | 10 | 28858 | 21 | |||
| 66016 | 110663 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 434 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009804.95200969 | 2114873.04035134 | 37.7875912498832 | -122.409870861764 | (37.7875912498832, -122.409870861764) | 5 | 1 | 10 | 28852 | 36 | ||||
| 66566 | 44080 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2000 12:00:00 AM | 15 | Permit Number 43601 | 6011292.32599 | 2121242.99491 | 37.8051648513333 | -122.405173537038 | (37.8051648513333, -122.405173537038) | 3 | 1 | 10 | 28860 | 23 | ||
| 67021 | 100113 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 67815 | 130397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 632 Commercial St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011629.35252 | 2117227.83447 | 37.794159029964 | -122.403724515176 | (37.794159029964, -122.403724515176) | 3 | 1 | 10 | 28860 | 4 | |||
| 67964 | 100110 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 68742 | 100119 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 69316 | 130327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008134.16526 | 2121736.211 | 37.8063420351113 | -122.416137718899 | (37.8063420351113, -122.416137718899) | 5 | 1 | 10 | 308 | 23 | |||
| 69832 | 130322 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008954.49657 | 2121501.13304 | 37.8057426603468 | -122.41328217354 | (37.8057426603468, -122.41328217354) | 3 | 1 | 10 | 308 | 23 | |||
| 70330 | 130416 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2012 12:00:00 AM | 3 | Width 3ft | 6011265.06206 | 2118222.50739 | 37.7968698051447 | -122.405055076528 | (37.7968698051447, -122.405055076528) | 3 | 1 | 10 | 308 | 4 | ||
| 70391 | 130371 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011762.66559 | 2120992.96718 | 37.8045046194597 | -122.403528258831 | (37.8045046194597, -122.403528258831) | 3 | 1 | 10 | 28860 | 6 | |||
| 70460 | 65407 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28258 | 6008757.61296822 | 2115030.93452602 | 37.7879660374887 | -122.413505631735 | (37.7879660374887, -122.413505631735) | 5 | 1 | 10 | 28858 | 21 | ||
| 70642 | 65420 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 797 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | Permit Number 28278 | 6009687.05789849 | 2115713.05801117 | 37.7898911282605 | -122.410338088046 | (37.7898911282605, -122.410338088046) | 5 | 1 | 10 | 28857 | 21 | ||
| 70949 | 249371 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 651 Jones St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6008791.00522 | 2114822.15821 | 37.7873946631776 | -122.41337532982 | (37.7873946631776, -122.41337532982) | 5 | 1 | 10 | 28852 | 36 | |||
| 71380 | 129910 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005467.67917 | 2121063.89893 | 37.8043457515267 | -122.425317698873 | (37.8043457515267, -122.425317698873) | 13 | 1 | 1 | 28858 | 17 | |||
| 71643 | 121056 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
| 72402 | 129983 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 432 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009785.99842 | 2114993.96448 | 37.7879222162744 | -122.40994497738 | (37.7879222162744, -122.40994497738) | 5 | 1 | 10 | 28852 | 36 | |||
| 72420 | 44354 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | 4 | Permit Number 43731 | 6008055.5377 | 2122018.11955 | 37.8071116632331 | -122.416429805199 | (37.8071116632331, -122.416429805199) | 5 | 1 | 10 | 308 | 23 | ||
| 72575 | 62975 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1835 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 9 | Permit Number 23364 | 6007764.71108 | 2118683.01154 | 37.7979379380364 | -122.417199793054 | (37.7979379380364, -122.417199793054) | 5 | 1 | 10 | 28858 | 32 | |
| 72706 | 11068 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1746 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 3 | 3X3 | 6007372.4344 | 2118377.82139 | 37.7970778858025 | -122.418535532697 | (37.7970778858025, -122.418535532697) | 5 | 1 | 10 | 28858 | 32 | ||
| 73145 | 130384 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1301 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011876.00242 | 2120169.91137 | 37.8022510389059 | -122.403078115778 | (37.8022510389059, -122.403078115778) | 3 | 1 | 10 | 308 | 23 | |||
| 73291 | 130372 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6011765.86565 | 2120974.54458 | 37.8044542142522 | -122.403515887751 | (37.8044542142522, -122.403515887751) | 3 | 1 | 10 | 28860 | 6 |
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) );