trees
420 rows where qSpecies_id = 116 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98496 | 198004 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 920x Jamestown Ave | 12 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 6014389.31588 | 2089371.37328 | 37.7178249676301 | -122.392225518194 | (37.7178249676301, -122.392225518194) | 10 | 3 | 8 | 58 | 1 | |||
172443 | 198003 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 920x Jamestown Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) | 10 | 3 | 8 | 58 | 1 | |||
2655 | 197996 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014434.42252 | 2089286.69966 | 37.7175949749992 | -122.392063685205 | (37.7175949749992, -122.392063685205) | 10 | 3 | 8 | 58 | 1 | |||
16424 | 197993 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014330.76175 | 2089346.27019 | 37.7177527880479 | -122.392426160549 | (37.7177527880479, -122.392426160549) | 10 | 3 | 8 | 58 | 1 | |||
40052 | 197997 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014474.56871 | 2089262.00767 | 37.7175294045238 | -122.391923191299 | (37.7175294045238, -122.391923191299) | 10 | 3 | 8 | 58 | 1 | |||
54730 | 197998 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014511.88744 | 2089238.18256 | 37.7174660572017 | -122.391792531525 | (37.7174660572017, -122.391792531525) | 10 | 3 | 8 | 58 | 1 | |||
69421 | 197992 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014311.92 | 2089359.19845 | 37.7177872401718 | -122.392492192366 | (37.7177872401718, -122.392492192366) | 10 | 3 | 8 | 58 | 1 | |||
79635 | 197994 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014370.9162 | 2089321.9827 | 37.7176883291426 | -122.392285665748 | (37.7176883291426, -122.392285665748) | 10 | 3 | 8 | 58 | 1 | |||
124610 | 197995 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014417.48937 | 2089293.51791 | 37.717612756412 | -122.392122692435 | (37.717612756412, -122.392122692435) | 10 | 3 | 8 | 58 | 1 | |||
24028 | 84127 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 88 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50980 | 6010360.09243836 | 2089687.02520781 | 37.7184671339256 | -122.406175049692 | (37.7184671339256, -122.406175049692) | 10 | 7 | 8 | 309 | 39 | ||
62710 | 198002 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 860x Jamestown Ave | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 6014610.54339 | 2089241.61494 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | 10 | 3 | 8 | 58 | 1 | |||
74589 | 198001 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 860x Jamestown Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | Width 5ft | 6014795.93259 | 2089063.22643 | 37.7170014260431 | -122.390798490171 | (37.7170014260431, -122.390798490171) | 10 | 3 | 8 | 58 | 1 | |||
150856 | 114917 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 86 Carr St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 8 | Permit 774770 | 6012955.87899 | 2090602.59506 | 37.7211259588891 | -122.397266597771 | (37.7211259588891, -122.397266597771) | 10 | 3 | 8 | 58 | 1 | ||
169945 | 179965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 86 Arago St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999606.18552 | 2093002.38033 | 37.7269629528551 | -122.443584762453 | (37.7269629528551, -122.443584762453) | 9 | 7 | 6 | 28861 | 25 | ||||
46615 | 179964 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002952.82685 | 2087126.87824 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | 9 | 7 | 6 | 28861 | 5 | |||
117066 | 179963 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | 9 | 7 | 6 | 28861 | 5 | |||
102201 | 40735 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41714 | 6009129.35799057 | 2096983.96477733 | 37.7384340613324 | -122.410944305546 | (37.7384340613324, -122.410944305546) | 10 | 7 | 7 | 28859 | 2 | ||
40469 | 198000 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 828x Jamestown Ave | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6014844.30096 | 2089001.46751 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | 10 | 3 | 8 | 58 | 1 | |||
97492 | 197999 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 828 Jamestown Ave | 1 | : | Tree | Private 2 | 10 | Width 5ft | 6014890.34253 | 2088931.57147 | 37.7166451650195 | -122.390462963914 | (37.7166451650195, -122.390462963914) | 10 | 3 | 8 | 58 | 1 | |||
193495 | 197988 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 82 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012221.12319 | 2107462.35445 | 37.7673783228879 | -122.40099044576 | (37.7673783228879, -122.40099044576) | 14 | 3 | 8 | 28856 | 20 | |||
2544 | 49162 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
50033 | 49161 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
28989 | 247209 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001860.51527 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | 15 | 5 | 5 | 29492 | 9 | |||
129198 | 247212 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001824.51541 | 2108284.91798 | 37.7690514458872 | -122.437009703838 | (37.7690514458872, -122.437009703838) | 15 | 5 | 5 | 29492 | 9 | |||
48118 | 179956 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5998852.53516 | 2088480.84158 | 37.7145048379104 | -122.44586505734 | (37.7145048379104, -122.44586505734) | 9 | 7 | 6 | 28861 | 25 | |||
84902 | 179955 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5998862.1125 | 2088471.16796 | 37.7144788232093 | -122.445831259031 | (37.7144788232093, -122.445831259031) | 9 | 7 | 6 | 28861 | 25 | |||
111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
115633 | 16314 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
158182 | 16313 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
176905 | 16312 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
20297 | 246216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) | 15 | 5 | 11 | 29492 | 9 | |||
68174 | 179967 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | 9 | 7 | 6 | 309 | 5 | |||
120616 | 179966 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005255.40982 | 2092462.48384 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | 9 | 7 | 6 | 309 | 5 | |||
30420 | 52305 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
53968 | 52306 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
39753 | 30020 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 710X San Jose Ave | 12 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.422880130575 | (37.7437931149581, -122.422880130575) | 2 | 7 | 5 | 28859 | 22 | ||
53767 | 30021 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 710X San Jose Ave | 13 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.422880130575 | (37.7437931149581, -122.422880130575) | 2 | 7 | 5 | 28859 | 22 | ||
54851 | 16285 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
57490 | 16286 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
96877 | 16284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
81429 | 39859 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
116024 | 39860 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
157346 | 39861 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
164560 | 62050 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120 | 2108416 | 37.7697671862008 | -122.415243219817 | (37.7697671862008, -122.415243219817) | 8 | 2 | 9 | 28853 | 19 | ||
87387 | 241193 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.76354 | 2105082.07302 | 37.7607268479899 | -122.407987146983 | (37.7607268479899, -122.407987146983) | 10 | 4 | 8 | 28859 | 19 | |||
96325 | 241195 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.31923 | 2105113.84294 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | 10 | 4 | 8 | 28859 | 19 | |||
104918 | 241194 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010150.13435 | 2105098.12881 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | 10 | 4 | 8 | 28859 | 19 | |||
62921 | 16273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
151718 | 28415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
103790 | 179968 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6005852.39602 | 2093589.23287 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | 9 | 7 | 6 | 28861 | 5 | |||
51586 | 215436 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | 9 | 7 | 4 | 59 | 40 | |||
61309 | 67821 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 669 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1993 12:00:00 AM | Permit Number 31477 | 6014155.20534869 | 2104021.00071857 | 37.7580368157249 | -122.394059730987 | (37.7580368157249, -122.394059730987) | 10 | 3 | 8 | 28856 | 29 | ||
130970 | 197985 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 669 Mississippi St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014155.898 | 2104063.80675 | 37.758154390328 | -122.394060332116 | (37.758154390328, -122.394060332116) | 10 | 3 | 8 | 28856 | 29 | |||
164294 | 123216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.467062678343 | (37.7760886204879, -122.467062678343) | 11 | 6 | 2 | 54 | 11 | |||
176157 | 63531 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.415620410353 | (37.7581133535123, -122.415620410353) | 2 | 4 | 7 | 28859 | 19 | ||
63135 | 179969 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 623 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781359 | 6010613.39722 | 2091824.02196 | 37.7243490517445 | -122.405449895106 | (37.7243490517445, -122.405449895106) | 10 | 3 | 7 | 309 | 28 |
193666 | 50830 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | 15 | 5 | 11 | 29492 | 16 | ||
44111 | 30003 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 610X San Jose Ave | 15 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.567294 | 37.7462324634173 | -122.421863690264 | (37.7462324634173, -122.421863690264) | 2 | 7 | 5 | 28859 | 22 | ||
181533 | 30004 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 610X San Jose Ave | 16 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.567294 | 37.7462324634173 | -122.421863690264 | (37.7462324634173, -122.421863690264) | 2 | 7 | 5 | 28859 | 22 | ||
35270 | 197979 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 601 Wisconsin St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012714.26642 | 2104668.82572 | 37.7597354092797 | -122.399088616146 | (37.7597354092797, -122.399088616146) | 10 | 3 | 8 | 28856 | 29 | |||
35412 | 197981 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 601 Wisconsin St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6012726.35291 | 2104657.30852 | 37.7597044591158 | -122.39904600628 | (37.7597044591158, -122.39904600628) | 10 | 3 | 8 | 28856 | 29 | |||
48922 | 197980 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 601 Wisconsin St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012727.89488 | 2104659.33214 | 37.7597101014582 | -122.399040815374 | (37.7597101014582, -122.399040815374) | 10 | 3 | 8 | 28856 | 29 | |||
179594 | 197982 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 601 Wisconsin St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012729.113 | 2104654.63686 | 37.7596972771322 | -122.39903627291 | (37.7596972771322, -122.39903627291) | 10 | 3 | 8 | 28856 | 29 | |||
145108 | 28414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 600X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | 9 | 7 | 4 | 59 | 40 | ||
112628 | 83941 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 60 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.414608304259 | (37.7696248364946, -122.414608304259) | 8 | 4 | 9 | 28853 | 19 | ||
88237 | 67807 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | 2 | 4 | 5 | 28862 | 22 | ||
91363 | 241216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000321.631 | 2101619.05614 | 37.7506630907493 | -122.441729618453 | (37.7506630907493, -122.441729618453) | 2 | 4 | 5 | 28862 | 22 | |||
524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
97236 | 47561 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
147565 | 47560 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
48943 | 16228 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
81686 | 16227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
61533 | 106452 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 56 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2014 12:00:00 AM | 3 | Permit Number 772906 | 6014092.7 | 2093830.3 | 37.7300518134974 | -122.393562691323 | (37.7300518134974, -122.393562691323) | 10 | 3 | 8 | 58 | 1 | ||
130826 | 115632 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6012114 | 2107494 | 37.7674592382642 | -122.40136319642 | (37.7674592382642, -122.40136319642) | 14 | 3 | 8 | 28856 | 20 | ||||
123424 | 67713 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.7824330740175 | -122.392684800601 | (37.7824330740175, -122.392684800601) | 6 | 2 | 9 | 28856 | 6 | ||
21711 | 35380 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 528 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/14/2015 12:00:00 AM | 4 | Permit Number 775347 | 6011191.99901 | 2105854.03053 | 37.7629047676749 | -122.404436841188 | (37.7629047676749, -122.404436841188) | 8 | 3 | 8 | 28856 | 29 | |
136147 | 119965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 518 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5987217.06494 | 2112373.1551 | 37.7794354929176 | -122.487835733288 | (37.7794354929176, -122.487835733288) | 11 | 6 | 2 | 55 | 26 | |||
13617 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | 9 | 3 | 7 | 309 | 28 | |||
173273 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6007547 | 2093670 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | 9 | 3 | 7 | 309 | 28 | |||||
46226 | 16202 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
171394 | 16201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
129318 | 197986 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 498 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014051.93568 | 2104880.86729 | 37.7603920825505 | -122.394477092339 | (37.7603920825505, -122.394477092339) | 10 | 3 | 8 | 28856 | 29 | |||
39945 | 215415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 484 Faxon Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994798.18805 | 2091784.91271 | 37.7233446951982 | -122.460117638125 | (37.7233446951982, -122.460117638125) | 9 | 8 | 4 | 28861 | 24 | |||
108310 | 63197 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 472 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 14 | Permit Number 23738 | 5984415.83341 | 2112620.01213 | 37.7799494956437 | -122.497544458973 | (37.7799494956437, -122.497544458973) | 11 | 6 | 2 | 55 | 26 | |
152907 | 50801 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | 9 | 7 | 4 | 28861 | 40 | ||
26688 | 88372 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306 | 2109414 | 37.7725740445577 | -122.411211370961 | (37.7725740445577, -122.411211370961) | 8 | 2 | 9 | 28853 | 34 | ||
91808 | 88373 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306 | 2109414 | 37.7725740445577 | -122.411211370961 | (37.7725740445577, -122.411211370961) | 8 | 2 | 9 | 28853 | 34 | ||
157496 | 51920 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009316.82358159 | 2109402.74774996 | 37.7725437555109 | -122.411173135945 | (37.7725437555109, -122.411173135945) | 8 | 2 | 9 | 28853 | 34 | ||
36520 | 241186 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6006573.70754 | 2106363.42565 | 37.7640442779462 | -122.420446098324 | (37.7640442779462, -122.420446098324) | 8 | 4 | 7 | 28859 | 19 |
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) );