trees
161 rows where qSpecies_id = 253 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132222 | 183673 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1267 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5984268.1791 | 2106557.6883 | 37.7632954325476 | -122.497607531112 | (37.7632954325476, -122.497607531112) | 1 | 8 | 3 | 56 | 35 | |||
| 51665 | 118192 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 870 34th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5985454.65215 | 2109961.46121 | 37.7727107105884 | -122.493754809078 | (37.7727107105884, -122.493754809078) | 11 | 6 | 2 | 55 | 26 | |||
| 156726 | 119928 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3750 Anza St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 5986949.49746 | 2111884.49036 | 37.7780781472848 | -122.488725421171 | (37.7780781472848, -122.488725421171) | 11 | 6 | 2 | 55 | 26 | |||
| 148894 | 182042 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1329 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987076.1241 | 2106191.7238 | 37.7624547889055 | -122.487869010507 | (37.7624547889055, -122.487869010507) | 1 | 8 | 3 | 56 | 35 | |||
| 10941 | 45069 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2342 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 1 | Permit Number 43950 | 5987976.058 | 2099354.9145 | 37.7437352024597 | -122.484255080791 | (37.7437352024597, -122.484255080791) | 1 | 8 | 3 | 29491 | 35 | |
| 127778 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
| 156777 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
| 91742 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
| 161250 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
| 167270 | 175563 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988277.07749 | 2089797.21556 | 37.7175097453622 | -122.482514046798 | (37.7175097453622, -122.482514046798) | 1 | 8 | 4 | 64 | 14 | ||||
| 42572 | 91234 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 829 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52047: Correct address is 829: Replanted w/ Birch | 5988302.4 | 2089565.8 | 37.7168758094884 | -122.482409573013 | (37.7168758094884, -122.482409573013) | 1 | 8 | 4 | 64 | 14 | ||
| 34411 | 114369 | Undocumented 4 | Betula pendula :: European White Birch 253 | 823 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988303 | 2089566 | 37.7168763935413 | -122.482407513776 | (37.7168763935413, -122.482407513776) | 1 | 8 | 4 | 64 | 14 | ||||
| 175304 | 182707 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1825 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988600.9285 | 2103724.0215 | 37.7557679721196 | -122.482414516683 | (37.7557679721196, -122.482414516683) | 1 | 8 | 3 | 56 | 35 | |||
| 94097 | 43784 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 266 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/2010 12:00:00 AM | 3 | Permit Number 53371 | 5989347.17578 | 2113582.51161 | 37.7828800673234 | -122.480555416149 | (37.7828800673234, -122.480555416149) | 11 | 6 | 2 | 55 | 26 | |
| 76411 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 317 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 164611 | 205619 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1410 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991815.90489 | 2105796.1223 | 37.7616439109643 | -122.471447180367 | (37.7616439109643, -122.471447180367) | 1 | 8 | 4 | 56 | 12 | |||
| 31900 | 122925 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5992432.25878 | 2114882.38324 | 37.7866279691571 | -122.469977088017 | (37.7866279691571, -122.469977088017) | 11 | 6 | 1 | 54 | 11 | |||
| 52150 | 122926 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992433.41557 | 2114874.23335 | 37.7866056586788 | -122.469972492217 | (37.7866056586788, -122.469972492217) | 11 | 6 | 1 | 54 | 11 | |||
| 52249 | 122927 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992434.41445 | 2114867.59859 | 37.7865874992007 | -122.469968553103 | (37.7865874992007, -122.469968553103) | 11 | 6 | 1 | 54 | 11 | |||
| 20328 | 205620 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1660 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 5993426.51718 | 2104186.7083 | 37.7573179210136 | -122.465759834445 | (37.7573179210136, -122.465759834445) | 1 | 8 | 4 | 56 | 12 | |||
| 86473 | 205621 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1660 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 11 | Width 6ft | 5993426.57707 | 2104172.11837 | 37.7572778643028 | -122.46575856731 | (37.7572778643028, -122.46575856731) | 1 | 8 | 4 | 56 | 12 | |||
| 105117 | 205622 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1664 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | Width 6ft | 5993427.02591 | 2104158.61423 | 37.7572408113254 | -122.465756033933 | (37.7572408113254, -122.465756033933) | 1 | 8 | 4 | 56 | 12 | |||
| 140451 | 205623 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1664 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 6ft | 5993427.80245 | 2104143.27983 | 37.7571987518308 | -122.46575223428 | (37.7571987518308, -122.46575223428) | 1 | 8 | 4 | 56 | 12 | |||
| 30904 | 68057 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 1660 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31794 | 5993428.97285668 | 2104187.65738883 | 37.7573206686158 | -122.465751410774 | (37.7573206686158, -122.465751410774) | 1 | 8 | 4 | 56 | 12 | ||
| 182478 | 56295 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 135 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 5 | Permit Number 12424 | 5993944.56899 | 2114612.22651 | 37.7859734975152 | -122.46472527724 | (37.7859734975152, -122.46472527724) | 11 | 6 | 2 | 54 | 11 | ||
| 136797 | 205628 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 45 Linares Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993975.22744 | 2102175.9193 | 37.7518284466452 | -122.463716253701 | (37.7518284466452, -122.463716253701) | 1 | 8 | 4 | 29491 | 40 | |||
| 124342 | 205627 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 55 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993995.91474 | 2102156.22392 | 37.7517755602042 | -122.463643285426 | (37.7517755602042, -122.463643285426) | 1 | 8 | 4 | 29491 | 40 | |||
| 22998 | 205624 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 76 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994666.36348 | 2093043.17057 | 37.726791984541 | -122.460664466391 | (37.726791984541, -122.460664466391) | 9 | 8 | 4 | 28861 | 40 | |||
| 64362 | 98509 | Undocumented 4 | Betula pendula :: European White Birch 253 | 1194 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995108.2 | 2091844.9 | 37.7235272322276 | -122.459050333572 | (37.7235272322276, -122.459050333572) | 9 | 8 | 4 | 28861 | 24 | ||||
| 91282 | 98508 | Undocumented 4 | Betula pendula :: European White Birch 253 | 1194 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995108.2 | 2091844.9 | 37.7235272322276 | -122.459050333572 | (37.7235272322276, -122.459050333572) | 9 | 8 | 4 | 28861 | 24 | ||||
| 111554 | 165644 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 50 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781268 | 5996156.88176 | 2099849.37335 | 37.7455658035362 | -122.45600365705 | (37.7455658035362, -122.45600365705) | 1 | 5 | 4 | 59 | 40 |
| 99968 | 205630 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 617 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5997440.96339 | 2095398.84681 | 37.7334193540061 | -122.451242612865 | (37.7334193540061, -122.451242612865) | 9 | 7 | 4 | 59 | 40 | ||||
| 119947 | 205631 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 575 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997625.37586 | 2095236.46508 | 37.732984049775 | -122.450593347312 | (37.732984049775, -122.450593347312) | 9 | 7 | 4 | 59 | 40 | ||||
| 31033 | 139003 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2099 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997824 | 2110223 | 37.774144722636 | -122.450986949191 | (37.774144722636, -122.450986949191) | 15 | 5 | 11 | 29492 | 16 | |||
| 122014 | 205632 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 317 Staples Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998051.80428 | 2093774.07528 | 37.7289930725494 | -122.449013770869 | (37.7289930725494, -122.449013770869) | 9 | 7 | 4 | 28861 | 40 | |||
| 168523 | 205634 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 270 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998287.7402 | 2093571.27681 | 37.7284497264672 | -122.448183529344 | (37.7284497264672, -122.448183529344) | 9 | 7 | 4 | 28861 | 40 | ||||
| 41001 | 205633 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 270 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998290.08774 | 2093572.00221 | 37.7284518524477 | -122.448175466027 | (37.7284518524477, -122.448175466027) | 9 | 7 | 4 | 28861 | 40 | ||||
| 161877 | 175562 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1665 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5998346.15362 | 2088865.15778 | 37.7155311550278 | -122.447642956778 | (37.7155311550278, -122.447642956778) | 9 | 7 | 6 | 28861 | 25 | |||
| 61743 | 221232 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 959 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999208.20061 | 2106764.45721 | 37.7647275864428 | -122.445949972229 | (37.7647275864428, -122.445949972229) | 15 | 5 | 11 | 29492 | 9 | |||
| 176041 | 221233 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 959 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999213.29336 | 2106736.99218 | 37.7646524651563 | -122.445930382297 | (37.7646524651563, -122.445930382297) | 15 | 5 | 11 | 29492 | 9 | |||
| 121280 | 205629 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 714 Detroit St | 18 | Side Yard : Yard | Tree | Private 2 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | 9 | 7 | 4 | 63 | 40 | ||||
| 3488 | 221257 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999509.60101 | 2106150.92789 | 37.7630601939071 | -122.444863405022 | (37.7630601939071, -122.444863405022) | 15 | 5 | 5 | 29492 | 3 | |||
| 135879 | 125717 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2640 Baker St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999646.03344 | 2117962.09601 | 37.7954984109675 | -122.445240769556 | (37.7954984109675, -122.445240769556) | 13 | 9 | 1 | 57 | 17 | |||
| 126582 | 125718 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2640 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999647.29192 | 2117942.60515 | 37.7954449660715 | -122.445235012993 | (37.7954449660715, -122.445235012993) | 13 | 9 | 1 | 57 | 17 | |||
| 66104 | 125719 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3633 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 780396 | 5999650.86982 | 2121041.96427 | 37.8039551813501 | -122.445445600958 | (37.8039551813501, -122.445445600958) | 13 | 9 | 1 | 57 | 17 | ||
| 22263 | 125720 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2550 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 5999688.77588 | 2117636.86185 | 37.7946078438183 | -122.445069481073 | (37.7946078438183, -122.445069481073) | 13 | 9 | 1 | 57 | 27 | |||
| 84486 | 249692 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 24 | Front Yard : Yard | Tree | Private 2 | 4 | 5999712.04694 | 2117251.89075 | 37.7935521431604 | -122.44496127284 | (37.7935521431604, -122.44496127284) | 13 | 9 | 1 | 57 | 27 | ||||
| 172364 | 249669 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 5999737.17484 | 2117101.84949 | 37.7931416035487 | -122.44486353812 | (37.7931416035487, -122.44486353812) | 13 | 9 | 1 | 57 | 27 | ||||
| 92400 | 249670 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 5999738.32822 | 2117112.31021 | 37.7931703917478 | -122.444860299664 | (37.7931703917478, -122.444860299664) | 13 | 9 | 1 | 57 | 27 | ||||
| 168521 | 249672 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999740.71389 | 2117125.7737 | 37.7932074950865 | -122.444853013365 | (37.7932074950865, -122.444853013365) | 13 | 9 | 1 | 57 | 27 | ||||
| 137020 | 249673 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 5999744.88786 | 2117135.23947 | 37.7932337237968 | -122.444839251946 | (37.7932337237968, -122.444839251946) | 13 | 9 | 1 | 57 | 27 | ||||
| 104817 | 249671 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 5999749.22169 | 2117118.60729 | 37.7931883035453 | -122.444823060562 | (37.7931883035453, -122.444823060562) | 13 | 9 | 1 | 57 | 27 | ||||
| 171506 | 221235 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 112 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999837.49365 | 2106933.69543 | 37.7652281859523 | -122.443785579252 | (37.7652281859523, -122.443785579252) | 15 | 5 | 5 | 29492 | 9 | |||
| 30579 | 221234 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 100 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999851.08678 | 2106942.56431 | 37.7652533130011 | -122.443739201223 | (37.7652533130011, -122.443739201223) | 15 | 5 | 5 | 29492 | 9 | |||
| 30968 | 205626 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 218 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999958.48633 | 2094391.54606 | 37.7307973661877 | -122.442466560705 | (37.7307973661877, -122.442466560705) | 9 | 7 | 4 | 63 | 40 | ||||
| 70578 | 221259 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 415 Roosevelt Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000035.50507 | 2106652.66281 | 37.7644678325525 | -122.443080522454 | (37.7644678325525, -122.443080522454) | 15 | 5 | 5 | 28862 | 3 | |||
| 59463 | 221258 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 415 Roosevelt Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000035.96501 | 2106651.69719 | 37.7644652074247 | -122.443078862299 | (37.7644652074247, -122.443078862299) | 15 | 5 | 5 | 28862 | 3 | |||
| 104572 | 125721 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2652 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000166.83929 | 2117732.47906 | 37.7948976575576 | -122.443422196501 | (37.7948976575576, -122.443422196501) | 13 | 9 | 1 | 57 | 27 | |||
| 191700 | 16060 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2002 12:00:00 AM | 6 | 3x3 | 6000534.94715 | 2094624.24061 | 37.7314691327835 | -122.440490331957 | (37.7314691327835, -122.440490331957) | 9 | 7 | 4 | 63 | 40 | ||
| 96736 | 43034 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2488 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42894 | 6000712.8749 | 2114163.5032 | 37.7851293023636 | -122.441276640017 | (37.7851293023636, -122.441276640017) | 15 | 6 | 1 | 29490 | 27 | ||
| 111681 | 221252 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 16 | Front Yard : Yard | Tree | Private 2 | 43 | Width 3ft | 6000796.34064 | 2105302.63259 | 37.7608043335649 | -122.440352180822 | (37.7608043335649, -122.440352180822) | 15 | 4 | 5 | 28862 | 3 | |||
| 94533 | 205625 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 59 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6000816.9826 | 2094321.3971 | 37.7306536500496 | -122.439493582774 | (37.7306536500496, -122.439493582774) | 9 | 7 | 4 | 63 | 40 | |||
| 80432 | 221253 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 23 | Front Yard : Yard | Tree | Private 2 | 39 | Width 3ft | 6000832.84262 | 2105336.18629 | 37.7608985420563 | -122.44022834328 | (37.7608985420563, -122.44022834328) | 15 | 4 | 5 | 28862 | 3 | |||
| 86453 | 221254 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 24 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6000848.02687 | 2105351.68108 | 37.7609419514342 | -122.440176938936 | (37.7609419514342, -122.440176938936) | 15 | 4 | 5 | 28862 | 3 | |||
| 141873 | 221255 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 25 | Front Yard : Yard | Tree | Private 2 | 38 | Width 3ft | 6000864.19638 | 2105365.81027 | 37.7609816672784 | -122.440122029029 | (37.7609816672784, -122.440122029029) | 15 | 4 | 5 | 28862 | 3 | |||
| 178846 | 221248 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 43 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6000867.48492 | 2104298.6748 | 37.7580517614839 | -122.440034134675 | (37.7580517614839, -122.440034134675) | 2 | 4 | 5 | 28862 | 38 | |||
| 68379 | 221249 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 43 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000871.77064 | 2104299.24068 | 37.7580535592295 | -122.440019353436 | (37.7580535592295, -122.440019353436) | 2 | 4 | 5 | 28862 | 38 | |||
| 57572 | 221256 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 26 | Front Yard : Yard | Tree | Private 2 | 31 | Width 3ft | 6000877.58761 | 2105376.29663 | 37.7610112226138 | -122.440076466682 | (37.7610112226138, -122.440076466682) | 15 | 4 | 5 | 28862 | 3 | |||
| 104638 | 175564 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 86 San Gabriel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000983.71045 | 2093588.28288 | 37.7286501745611 | -122.438864664381 | (37.7286501745611, -122.438864664381) | 9 | 7 | 6 | 28861 | 25 | ||||
| 78030 | 221247 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001129.57838 | 2104882.27953 | 37.7596691148559 | -122.439169533648 | (37.7596691148559, -122.439169533648) | 2 | 4 | 5 | 28862 | 3 | |||
| 155599 | 221246 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 233 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001130.70274 | 2104859.07812 | 37.759605473426 | -122.439163982134 | (37.759605473426, -122.439163982134) | 2 | 4 | 5 | 28862 | 3 | |||
| 108473 | 221240 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 4428 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001150.87294 | 2101161.43289 | 37.7494537804789 | -122.438829247299 | (37.7494537804789, -122.438829247299) | 2 | 4 | 5 | 28862 | 22 | |||
| 87522 | 221250 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 382 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001780.48006 | 2103636.43597 | 37.756285346418 | -122.43682920632 | (37.756285346418, -122.43682920632) | 2 | 4 | 5 | 28862 | 3 | |||
| 107556 | 221241 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 4239 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002260.12391 | 2101180.90395 | 37.7495702894512 | -122.434994824965 | (37.7495702894512, -122.434994824965) | 2 | 4 | 5 | 28862 | 22 | |||
| 57595 | 221229 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 469 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002951.50241 | 2098587.87741 | 37.742489676962 | -122.432418838363 | (37.742489676962, -122.432418838363) | 2 | 7 | 5 | 63 | 22 | |||
| 6203 | 47487 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 126 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45384 | 6003210.40272 | 2094437.85686 | 37.7311093473224 | -122.431227478571 | (37.7311093473224, -122.431227478571) | 9 | 7 | 5 | 28861 | 25 |
| 178706 | 53406 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1911 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1969 12:00:00 AM | 10 | Permit Number 6305 | 6003659.05239 | 2119321.24643 | 37.7994585351485 | -122.431452119331 | (37.7994585351485, -122.431452119331) | 13 | 9 | 1 | 57 | 17 | ||
| 165674 | 221251 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 310 Liberty St | 54 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003815.34133 | 2103923.3524 | 37.757188590406 | -122.429812419609 | (37.757188590406, -122.429812419609) | 2 | 4 | 5 | 28862 | 3 | |||
| 177139 | 221243 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1240 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003838.29098 | 2101086.08552 | 37.7493994227408 | -122.429530711483 | (37.7493994227408, -122.429530711483) | 2 | 4 | 5 | 28862 | 22 | |||
| 70684 | 39511 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 1240 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40963 | 6003838.6793187 | 2101050.95866079 | 37.7493029945716 | -122.429526863798 | (37.7493029945716, -122.429526863798) | 2 | 4 | 5 | 28862 | 22 | ||
| 139051 | 221231 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1415 Sanchez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003960.41369 | 2100001.20175 | 37.7464274979283 | -122.429031067947 | (37.7464274979283, -122.429031067947) | 2 | 7 | 5 | 63 | 22 | |||
| 180198 | 221230 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1415 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003960.53508 | 2099994.15866 | 37.7464081661066 | -122.42903014612 | (37.7464081661066, -122.42903014612) | 2 | 7 | 5 | 63 | 22 | |||
| 19623 | 89284 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103 | 2102285 | 37.7527063460416 | -122.428700795885 | (37.7527063460416, -122.428700795885) | 2 | 4 | 5 | 28862 | 22 | ||
| 35783 | 89282 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103 | 2102285 | 37.7527063460416 | -122.428700795885 | (37.7527063460416, -122.428700795885) | 2 | 4 | 5 | 28862 | 22 | ||
| 114580 | 89285 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103 | 2102285 | 37.7527063460416 | -122.428700795885 | (37.7527063460416, -122.428700795885) | 2 | 4 | 5 | 28862 | 22 | ||
| 160652 | 89283 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103 | 2102285 | 37.7527063460416 | -122.428700795885 | (37.7527063460416, -122.428700795885) | 2 | 4 | 5 | 28862 | 22 | ||
| 13571 | 221244 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004104.16813 | 2101283.01831 | 37.7499552046892 | -122.428625337904 | (37.7499552046892, -122.428625337904) | 2 | 4 | 5 | 28862 | 22 | |||
| 127582 | 61454 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 2099 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004149.19944272 | 2107648.18855863 | 37.7674350001746 | -122.428923361715 | (37.7674350001746, -122.428923361715) | 8 | 4 | 5 | 28862 | 3 | ||
| 90942 | 62831 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 211 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004171.80944378 | 2107611.92188251 | 37.7673367003875 | -122.428842571007 | (37.7673367003875, -122.428842571007) | 8 | 4 | 5 | 28862 | 3 | ||
| 102545 | 82352 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 195 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50648 | 6004202.82726 | 2089290.65992 | 37.7170324715383 | -122.427429950034 | (37.7170324715383, -122.427429950034) | 9 | 7 | 6 | 28861 | 5 | |
| 142212 | 82353 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 195 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 16 | 3x3 | Permit Number 50648 | 6004206.08009 | 2089287.93372 | 37.7170251699614 | -122.427418512461 | (37.7170251699614, -122.427418512461) | 9 | 7 | 6 | 28861 | 5 | |
| 37602 | 221245 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 317 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.06853 | 2102169.26146 | 37.7524012338466 | -122.427917680279 | (37.7524012338466, -122.427917680279) | 2 | 4 | 5 | 28862 | 22 | |||
| 184508 | 175565 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 25 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004860.30584 | 2093398.90796 | 37.7283499862525 | -122.425449562862 | (37.7283499862525, -122.425449562862) | 9 | 7 | 6 | 28861 | 5 | |||
| 24779 | 2604 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1760 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005055.9243 | 2115124.595 | 37.7880146622895 | -122.426319487223 | (37.7880146622895, -122.426319487223) | 13 | 9 | 11 | 28858 | 27 | |||
| 6149 | 175566 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 35 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005107.68038 | 2093296.81097 | 37.7280836241415 | -122.424587117508 | (37.7280836241415, -122.424587117508) | 9 | 7 | 6 | 28861 | 5 | ||||
| 25837 | 125726 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1641 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005125.24797 | 2118479.52215 | 37.7972303640409 | -122.426318596648 | (37.7972303640409, -122.426318596648) | 13 | 9 | 1 | 57 | 17 | |||
| 117007 | 115060 | Undocumented 4 | Betula pendula :: European White Birch 253 | 26 CRESCENT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005316 | 2095906 | 37.735259640844 | -122.424052422112 | (37.735259640844, -122.424052422112) | 2 | 7 | 7 | 28859 | 2 | ||||
| 55236 | 175567 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 11 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005362.50537 | 2093198.294 | 37.7278275062278 | -122.423699176384 | (37.7278275062278, -122.423699176384) | 9 | 7 | 6 | 28861 | 5 | ||||
| 150859 | 221227 | Undocumented 4 | Betula pendula :: European White Birch 253 | 26 Crescent Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6005423.00406 | 2095885.44307 | 37.7352092369163 | -122.42368100828 | (37.7352092369163, -122.42368100828) | 2 | 7 | 7 | 28859 | 2 | |||
| 175345 | 221226 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 88 Crescent Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6005769.38033 | 2095838.80012 | 37.7351007121151 | -122.422480144438 | (37.7351007121151, -122.422480144438) | 2 | 7 | 7 | 28859 | 2 |
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) );