trees
1,985 rows where qSpecies_id = 83 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
| 328 | 197129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.7412122331485 | -122.387337958305 | (37.7412122331485, -122.387337958305) | 10 | 3 | 8 | 58 | 1 | |||
| 381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
| 670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
| 691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
| 737 | 8938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | 11 | 6 | 2 | 54 | 11 | |||
| 810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
| 971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
| 1044 | 139272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | 7 | 9 | 11 | 28852 | 10 | |||
| 1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
| 1294 | 136237 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | |||
| 1330 | 239316 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | 2 | 4 | 7 | 28859 | 19 | |||
| 1477 | 112866 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
| 1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
| 1758 | 73714 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012133.53509 | 2102840.64813 | 37.7546832563417 | -122.400968639917 | (37.7546832563417, -122.400968639917) | 10 | 3 | 8 | 28856 | 29 | |||
| 1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
| 1933 | 193325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.7543225481714 | -122.389021302106 | (37.7543225481714, -122.389021302106) | 10 | 3 | 8 | 28856 | 29 | |||
| 2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
| 2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
| 2522 | 239885 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007768.4049 | 2096536.44279 | 37.7371288550961 | -122.415618157155 | (37.7371288550961, -122.415618157155) | 2 | 7 | 7 | 28859 | 2 | |||
| 2567 | 239301 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1277 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010336.55809 | 2101801.57143 | 37.7517297793105 | -122.407109863745 | (37.7517297793105, -122.407109863745) | 10 | 4 | 7 | 28859 | 19 | |||
| 2621 | 202038 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Crane St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.399639484201 | (37.7219600944649, -122.399639484201) | 10 | 3 | 8 | 58 | 1 | |||
| 2769 | 81793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.423593274768 | (37.7767477786156, -122.423593274768) | 7 | 9 | 11 | 28852 | 10 | ||
| 2819 | 70680 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | 8 | 4 | 8 | 28853 | 19 | |||
| 3017 | 136252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006854.74284 | 2121556.78092 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | 5 | 1 | 1 | 28858 | 32 | |||
| 3341 | 71320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004289.26563 | 2090538.00218 | 37.7204622897839 | -122.427219973626 | (37.7204622897839, -122.427219973626) | 9 | 7 | 6 | 28861 | 5 | |||
| 3545 | 70593 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | 9 | 7 | 6 | 28861 | 5 | |||
| 3614 | 72128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6012399.20292 | 2102851.6444 | 37.7547282656006 | -122.400050655116 | (37.7547282656006, -122.400050655116) | 10 | 3 | 8 | 28856 | 29 | |||
| 3730 | 120250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | 11 | 6 | 1 | 55 | 33 | |||
| 3969 | 73442 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004223.02083 | 2091452.87155 | 37.7229705736272 | -122.427514104094 | (37.7229705736272, -122.427514104094) | 9 | 7 | 6 | 28861 | 5 | |||
| 4284 | 244079 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998854.6041 | 2109046.905 | 37.7709744135065 | -122.447337256007 | (37.7709744135065, -122.447337256007) | 15 | 5 | 11 | 29492 | 9 | |||
| 4499 | 238850 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007815.26144 | 2096578.28635 | 37.7372463821225 | -122.415459113874 | (37.7372463821225, -122.415459113874) | 2 | 7 | 7 | 28859 | 2 | |||
| 4611 | 238852 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007968.84006 | 2096563.6752 | 37.7372148941494 | -122.414927086625 | (37.7372148941494, -122.414927086625) | 2 | 7 | 7 | 28859 | 2 | |||
| 4783 | 239336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008986.81884 | 2099989.09053 | 37.7466774833742 | -122.411649409412 | (37.7466774833742, -122.411649409412) | 2 | 7 | 7 | 28859 | 2 | |||
| 4805 | 74096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001902.78384 | 2087667.72771 | 37.7124459030227 | -122.435264062185 | (37.7124459030227, -122.435264062185) | 9 | 7 | 6 | 28861 | 5 | |||
| 5043 | 238851 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007952.96662 | 2096564.19788 | 37.7372154373458 | -122.414982005523 | (37.7372154373458, -122.414982005523) | 2 | 7 | 7 | 28859 | 2 | |||
| 5177 | 179302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | 9 | 7 | 6 | 28861 | 5 | |||
| 5553 | 70621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004140.66992 | 2091658.50291 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | 9 | 7 | 6 | 28861 | 5 | |||
| 5604 | 197168 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643 | -122.380355342249 | (37.729608594643, -122.380355342249) | 10 | 3 | 8 | 58 | 1 | |||
| 5677 | 123020 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.78579664693 | -122.464549802121 | (37.78579664693, -122.464549802121) | 11 | 6 | 1 | 54 | 11 | |||
| 5684 | 83143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6016637.51216 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | 10 | 3 | 8 | 58 | 1 | |||
| 5790 | 136106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002236.43409 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | 13 | 9 | 1 | 57 | 17 | |||
| 5861 | 141599 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 30 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998723.6664 | 2110574.4541 | 37.7751611896291 | -122.447900165728 | (37.7751611896291, -122.447900165728) | 15 | 5 | 11 | 29492 | 16 | |||
| 5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
| 5972 | 136242 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | 13 | 9 | 10 | 28858 | 32 | |||
| 6142 | 73715 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | 10 | 3 | 8 | 28856 | 29 | |||
| 6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
| 6265 | 239278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 248 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006484.02549 | 2104654.1559 | 37.7593459686731 | -122.420634937075 | (37.7593459686731, -122.420634937075) | 2 | 4 | 7 | 28859 | 19 | |||
| 6386 | 238848 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007787.51207 | 2096580.63387 | 37.7372512681409 | -122.415555222622 | (37.7372512681409, -122.415555222622) | 2 | 7 | 7 | 28859 | 2 | |||
| 6488 | 239304 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 821 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009936.73456 | 2104250.32887 | 37.7584311369078 | -122.408665244799 | (37.7584311369078, -122.408665244799) | 2 | 4 | 7 | 28859 | 19 | |||
| 7088 | 70592 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004234.1327 | 2091472.60684 | 37.7230253908821 | -122.4274770979 | (37.7230253908821, -122.4274770979) | 9 | 7 | 6 | 28861 | 5 | |||
| 7527 | 136248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.8008927343603 | -122.414423864695 | (37.8008927343603, -122.414423864695) | 5 | 1 | 10 | 308 | 32 | |||
| 7723 | 69741 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010157.17597 | 2089735.57492 | 37.7185890892048 | -122.406879871126 | (37.7185890892048, -122.406879871126) | 10 | 7 | 8 | 309 | 39 | |||
| 7946 | 74150 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004499.396 | 2111088.6935 | 37.7769016055642 | -122.427957272174 | (37.7769016055642, -122.427957272174) | 7 | 9 | 11 | 28852 | 10 | |||
| 7988 | 24147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | 10 | 3 | 8 | 58 | 1 | |||
| 8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
| 8259 | 138334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1971 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002917.5822 | 2115096.7114 | 37.7878169981836 | -122.433715769701 | (37.7878169981836, -122.433715769701) | 13 | 9 | 11 | 29490 | 27 | |||
| 8277 | 75145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010592.19708 | 2106537.02068 | 37.7647465666182 | -122.406559489431 | (37.7647465666182, -122.406559489431) | 8 | 4 | 8 | 28853 | 19 | |||
| 8502 | 73401 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | 13 | 9 | 10 | 28858 | 32 | |||
| 8876 | 136239 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | 13 | 9 | 10 | 28858 | 32 | |||
| 9017 | 239285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2750 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009605.36999 | 2105497.87366 | 37.7618380476199 | -122.409899320599 | (37.7618380476199, -122.409899320599) | 8 | 4 | 8 | 28859 | 19 | |||
| 9038 | 239314 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2720 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010004.35252 | 2104577.87538 | 37.7593342927654 | -122.40845449498 | (37.7593342927654, -122.40845449498) | 2 | 4 | 8 | 28859 | 19 | |||
| 9515 | 239254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3715 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005705.30849 | 2100786.77225 | 37.748683110957 | -122.423053239242 | (37.748683110957, -122.423053239242) | 2 | 4 | 5 | 28859 | 19 | |||
| 9648 | 72127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012120.03521 | 2102839.43148 | 37.7546791626274 | -122.401015240957 | (37.7546791626274, -122.401015240957) | 10 | 3 | 8 | 28856 | 29 | |||
| 9955 | 71391 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015562.7322 | 2096452.7948 | 37.7373342278764 | -122.388663558077 | (37.7373342278764, -122.388663558077) | 10 | 3 | 8 | 58 | 1 | |||
| 9959 | 71411 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | 10 | 3 | 8 | 58 | 1 | |||
| 10453 | 75980 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.489828952967 | (37.7797135654944, -122.489828952967) | 11 | 6 | 2 | 55 | 26 | |||
| 10757 | 238849 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007801.00794 | 2096580.35759 | 37.737251268132 | -122.41550854151 | (37.737251268132, -122.41550854151) | 2 | 7 | 7 | 28859 | 2 | |||
| 10984 | 138446 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003295.7109 | 2114182.3135 | 37.7853277416205 | -122.432342183898 | (37.7853277416205, -122.432342183898) | 13 | 9 | 11 | 29490 | 13 | |||
| 11540 | 102493 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999461.6709 | 2111166.2585 | 37.7768282889466 | -122.445389813922 | (37.7768282889466, -122.445389813922) | 15 | 5 | 11 | 29492 | 16 | |||
| 11660 | 120676 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003502 | 2105614 | 37.7618129556584 | -122.431016735878 | (37.7618129556584, -122.431016735878) | 15 | 4 | 5 | 28862 | 3 | ||||
| 11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
| 11688 | 141943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004162.7275 | 2112162.4936 | 37.77983094307 | -122.429198496132 | (37.77983094307, -122.429198496132) | 7 | 9 | 11 | 29490 | 41 | |||
| 11751 | 142826 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | 13 | 9 | 10 | 28858 | 32 | |||
| 12053 | 72144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000049.527 | 2091859.62504 | 37.7238504846937 | -122.441970156497 | (37.7238504846937, -122.441970156497) | 9 | 7 | 6 | 28861 | 25 | |||
| 12061 | 239335 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3206 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008987.26449 | 2099969.0979 | 37.7466226130369 | -122.411646456035 | (37.7466226130369, -122.411646456035) | 2 | 7 | 7 | 28859 | 2 | |||
| 12162 | 239887 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007798.48319 | 2096533.32571 | 37.7371219869923 | -122.415513941937 | (37.7371219869923, -122.415513941937) | 2 | 7 | 7 | 28859 | 2 | |||
| 12316 | 124412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.7878533198568 | -122.45724420279 | (37.7878533198568, -122.45724420279) | 11 | 6 | 1 | 54 | 31 | |||
| 12876 | 138454 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002945.3416 | 2114886.8927 | 37.7872424644786 | -122.433604726492 | (37.7872424644786, -122.433604726492) | 13 | 9 | 11 | 29490 | 27 | |||
| 13308 | 74007 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012344.40813 | 2102849.33443 | 37.7547188676881 | -122.40023998939 | (37.7547188676881, -122.40023998939) | 10 | 3 | 8 | 28856 | 29 | ||
| 13336 | 136240 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006640.65595 | 2116994.76492 | 37.7932391350289 | -122.420969421921 | (37.7932391350289, -122.420969421921) | 13 | 9 | 10 | 28858 | 32 | |||
| 13381 | 238854 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007995.79542 | 2096561.34412 | 37.7372100081447 | -122.414833724393 | (37.7372100081447, -122.414833724393) | 2 | 7 | 7 | 28859 | 2 | |||
| 13606 | 264731 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014824 | 2093132 | 37.7281750296252 | -122.390985688648 | (37.7281750296252, -122.390985688648) | 10 | 3 | 8 | 58 | 1 | ||||
| 13618 | 143549 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002240.1517 | 2118427.2493 | 37.7969233328664 | -122.436297997013 | (37.7969233328664, -122.436297997013) | 13 | 9 | 1 | 57 | 17 | |||
| 14031 | 213996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.443135805584 | (37.7299571835696, -122.443135805584) | 9 | 7 | 4 | 63 | 40 | |||
| 14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
| 14166 | 197170 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1510X Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016200.17093 | 2097456.77974 | 37.740126273917 | -122.386529601766 | (37.740126273917, -122.386529601766) | 10 | 3 | 8 | 58 | 1 | |||
| 14662 | 248025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 439 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6010001 | 2098476 | 37.7425797058833 | -122.408035769643 | (37.7425797058833, -122.408035769643) | 10 | 7 | 7 | 28859 | 2 | |||
| 15005 | 261438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 384 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007303 | 2095696 | 37.7347950116026 | -122.417167741106 | (37.7347950116026, -122.417167741106) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
| 15461 | 197112 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012308.80023 | 2102801.31444 | 37.7545850296985 | -122.400359759302 | (37.7545850296985, -122.400359759302) | 10 | 3 | 8 | 28856 | 29 | |||
| 15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
| 15634 | 136235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008235.61174 | 2115647.76794 | 37.7896303876902 | -122.415355351862 | (37.7896303876902, -122.415355351862) | 5 | 1 | 10 | 28858 | 21 | |||
| 15852 | 239886 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007782.31959 | 2096534.49049 | 37.737124276671 | -122.415569909436 | (37.737124276671, -122.415569909436) | 2 | 7 | 7 | 28859 | 2 | |||
| 15862 | 99761 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485 | 2101232 | 37.7497233531083 | -122.434220849449 | (37.7497233531083, -122.434220849449) | 2 | 4 | 5 | 28862 | 22 | |||
| 15913 | 258136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | ||
| 15928 | 197140 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 53 Pomona St | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014151.58684 | 2094423.96338 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | 10 | 3 | 8 | 58 | 1 | |||
| 15988 | 136243 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978457 | (37.7932611216587, -122.42077978457) | 13 | 9 | 10 | 28858 | 32 | |||
| 16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16300 | 248300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.419362356984 | (37.74621325229, -122.419362356984) | 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) );