Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
30852 | 30852 | 240192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.42777298295401 | (37.7415368893219, -122.427772982954) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
30857 | 30857 | 239336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008986.81884 | 2099989.0905299997 | 37.74667748337421 | -122.41164940941201 | (37.7466774833742, -122.411649409412) | |||
30859 | 30859 | 136223 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000162.373980001 | 2120896.2706299997 | 37.8035843324119 | -122.44366504043501 | (37.8035843324119, -122.443665040435) | |||
30941 | 30941 | 88552 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 649 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.5415199995 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | ||
31141 | 31141 | 123173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.890869999 | 2110769.52892 | 37.7753589775368 | -122.468253641396 | (37.7753589775368, -122.468253641396) | |||
31164 | 31164 | 240161 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 504 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998591.56873 | 2106281.83073 | 37.7633671855679 | -122.448047979048 | (37.7633671855679, -122.448047979048) | |||
31313 | 31313 | 56220 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 483 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 10 | Permit Number 12342 | 5990901.62894 | 2112114.24855 | 37.7789388399986 | -122.475070494342 | (37.7789388399986, -122.475070494342) | ||
31491 | 31491 | 239296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1114 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009989.84018 | 2102603.83852 | 37.753913217229 | -122.408365447707 | (37.753913217229, -122.408365447707) | |||
31500 | 31500 | 69354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | |
31714 | 31714 | 46872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | |
32007 | 32007 | 83299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52357 | 6014332.78372 | 2094054.3132099998 | 37.7306802456855 | -122.39274835074801 | (37.7306802456855, -122.392748350748) | |
32020 | 32020 | 197170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1440 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016200.17093 | 2097456.77974 | 37.740126273917 | -122.386529601766 | (37.740126273917, -122.386529601766) | |||
32309 | 32309 | 137616 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2260 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999176.7198 | 2111892.1732 | 37.77880519340229 | -122.446427777449 | (37.7788051934023, -122.446427777449) | |||
32581 | 32581 | 197122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.747376054258105 | -122.394415755007 | (37.7473760542581, -122.394415755007) | |||
32762 | 32762 | 96718 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008240.6871 | 2116926.6734700003 | 37.79314223396489 | -122.415428369639 | (37.7931422339649, -122.415428369639) | ||
32797 | 32797 | 139276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004285.6861 | 2111490.9383 | 37.777993978047704 | -122.428725241569 | (37.7779939780477, -122.428725241569) | |||
32871 | 32871 | 74007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012344.40813 | 2102849.33443 | 37.754718867688105 | -122.40023998938999 | (37.7547188676881, -122.40023998939) | ||
33109 | 33109 | 197147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.38288162868099 | (37.7332841805136, -122.382881628681) | |||
33299 | 33299 | 239254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 26th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005705.30849 | 2100786.77225 | 37.748683110956996 | -122.423053239242 | (37.748683110957, -122.423053239242) | |||
33428 | 33428 | 197157 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016598.7871900005 | 2095669.6865 | 37.7352413346217 | -122.385026857123 | (37.7352413346217, -122.385026857123) | |||
33654 | 33654 | 141285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 303 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998264.5884 | 2112604.2973 | 37.780708361851396 | -122.449634513412 | (37.7807083618514, -122.449634513412) | |||
33655 | 33655 | 239250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3743 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005344.37171 | 2100764.27917 | 37.7486009758548 | -122.42429975714701 | (37.7486009758548, -122.424299757147) | |||
33676 | 33676 | 136238 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1378 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007522.032000001 | 2117818.3708599997 | 37.7955501948379 | -122.41797820753901 | (37.7955501948379, -122.417978207539) | |||
33788 | 33788 | 213974 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | |||
34091 | 34091 | 197124 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013733.0286 | 2100130.5529400003 | 37.747331007214896 | -122.395247287949 | (37.7473310072149, -122.395247287949) | |||
34193 | 34193 | 122096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990911.764769999 | 2111862.01127 | 37.778246853274105 | -122.475017013162 | (37.7782468532741, -122.475017013162) | |||
34519 | 34519 | 136225 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000164.78748 | 2120871.42318 | 37.803516245636004 | -122.44365490235201 | (37.803516245636, -122.443654902352) | |||
34527 | 34527 | 123209 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993132.47666 | 2112678.91247 | 37.7806182922184 | -122.46739423754299 | (37.7806182922184, -122.467394237543) | |||
34565 | 34565 | 58091 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1750 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 2 | Permit Number 53771 | 6006613.15875288 | 2116850.06123449 | 37.7928402647887 | -122.42105428501101 | (37.7928402647887, -122.421054285011) | ||
34718 | 34718 | 139271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004149.5758 | 2111471.3855 | 37.7779325866279 | -122.42919470092698 | (37.7779325866279, -122.429194700927) | |||
34771 | 34771 | 200748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014912.0282 | 2094835.2906 | 37.73285680655879 | -122.39080035501699 | (37.7328568065588, -122.390800355017) | |||
35019 | 35019 | 239374 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004914.04474 | 2103668.95392 | 37.7565522283139 | -122.425994566404 | (37.7565522283139, -122.425994566404) | |||
35422 | 35422 | 239293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 936 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6009925.69316 | 2103743.6378599997 | 37.757039258881 | -122.40866768648199 | (37.757039258881, -122.408667686482) | |||
35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
35505 | 35505 | 240160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | |||
35711 | 35711 | 137620 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2280 Turk Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999093.1296 | 2111881.6822 | 37.7787716131699 | -122.446716192654 | (37.7787716131699, -122.446716192654) | |||
35715 | 35715 | 139272 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | |||
35804 | 35804 | 239300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 927 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299531996 | -122.408536698407 | (37.757160299532, -122.408536698407) | |||
35976 | 35976 | 181801 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986905.9682 | 2099586.0566 | 37.744307492185 | -122.487972126615 | (37.744307492185, -122.487972126615) | |||
36006 | 36006 | 246059 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 602 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997560.3028 | 2108454.9059 | 37.76927489165771 | -122.451771545977 | (37.7692748916577, -122.451771545977) | |||
36045 | 36045 | 213990 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Kingston St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994010.049330001 | 2099244.86467 | 37.743782519860794 | -122.46338315652099 | (37.7437825198608, -122.463383156521) | |||
36074 | 36074 | 240200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.43395336236401 | (37.736769456354, -122.433953362364) | |||
36094 | 36094 | 136210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3501 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997980.46007 | 2115787.2108299998 | 37.7894315448801 | -122.450847014574 | (37.7894315448801, -122.450847014574) | |||
36178 | 36178 | 197095 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.39280290452601 | (37.7527194688438, -122.392802904526) | |||
36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
36622 | 36622 | 102487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | |||
36783 | 36783 | 136264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011327.59811 | 2121029.0502400002 | 37.804579383680895 | -122.40503639942601 | (37.8045793836809, -122.405036399426) | |||
36878 | 36878 | 81916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.1897900002 | 37.731380822071706 | -122.396990173153 | (37.7313808220717, -122.396990173153) | |
36909 | 36909 | 141968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004837.9618 | 2111622.5068 | 37.778386474037205 | -122.426824094864 | (37.7783864740372, -122.426824094864) | |||
37187 | 37187 | 179321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009462.15792 | 2094931.0044 | 37.732815729946 | -122.409648778469 | (37.732815729946, -122.409648778469) | |||
37326 | 37326 | 138443 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003387.7672 | 2114195.0447 | 37.785367917648 | -122.432024606628 | (37.785367917648, -122.432024606628) | |||
37414 | 37414 | 239253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005658.48797 | 2100784.3269 | 37.7486737543928 | -122.42321497059099 | (37.7486737543928, -122.423214970591) | |||
37471 | 37471 | 137830 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002959.8323 | 2115200.8411 | 37.7881053091283 | -122.433577037034 | (37.7881053091283, -122.433577037034) | |||
37577 | 37577 | 213945 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2612 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991136.47615 | 2097605.20115 | 37.739114449377496 | -122.473199637055 | (37.7391144493775, -122.473199637055) | |||
37696 | 37696 | 32199 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35524 | 6009302.4465 | 2100450.1305 | 37.7479610974423 | -122.410590548539 | (37.7479610974423, -122.410590548539) | ||
38003 | 38003 | 136244 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1747 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006363.52762 | 2116626.5882200003 | 37.7922125885856 | -122.42190214028099 | (37.7922125885856, -122.421902140281) | |||
38038 | 38038 | 136216 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3330 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998869.71206 | 2115631.48922 | 37.7890548395604 | -122.447759099698 | (37.7890548395604, -122.447759099698) | |||
38106 | 38106 | 142044 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005880.5674 | 2111021.3015 | 37.7767946045442 | -122.423174581774 | (37.7767946045442, -122.423174581774) | |||
38315 | 38315 | 179295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004297.98606 | 2093012.3139099998 | 37.727256697520204 | -122.42736600014 | (37.7272566975202, -122.42736600014) | |||
38406 | 38406 | 46422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 708 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 1 | Permit Number 44644 | 5992896.66955 | 2110586.4046099996 | 37.7748592156207 | -122.468057745767 | (37.7748592156207, -122.468057745767) | ||
38430 | 38430 | 197164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017108.5730800005 | 2096118.78323 | 37.7365026499645 | -122.383295574057 | (37.7365026499645, -122.383295574057) | |||
38486 | 38486 | 239256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3425 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006919.52972 | 2100855.25708 | 37.748939598501394 | -122.418859320098 | (37.7489395985014, -122.418859320098) | |||
38610 | 38610 | 213996 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.44313580558399 | (37.7299571835696, -122.443135805584) | |||
38745 | 38745 | 121984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991256.96696 | 2112622.26651 | 37.780354305120504 | -122.47387832307501 | (37.7803543051205, -122.473878323075) | |||
38945 | 38945 | 239368 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 7 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004707.84944 | 2103578.58278 | 37.7562924348615 | -122.426701228489 | (37.7562924348615, -122.426701228489) | |||
39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
39213 | 39213 | 239316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | |||
39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | ||
39329 | 39329 | 213917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992756.585530001 | 2104219.0263799997 | 37.7573679916487 | -122.46807905201 | (37.7573679916487, -122.46807905201) | |||
39419 | 39419 | 197144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.717368885441395 | -122.397447893917 | (37.7173688854414, -122.397447893917) | |||
39442 | 39442 | 140393 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002743.2077 | 2113356.8165 | 37.7830297920416 | -122.43419464062299 | (37.7830297920416, -122.434194640623) | |||
39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
39644 | 39644 | 121918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | |||
39723 | 39723 | 73566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51073 | 6015551.1974 | 2096459.91912 | 37.737353150531504 | -122.388703936761 | (37.7373531505315, -122.388703936761) | |
39948 | 39948 | 239313 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005503.510559999 | 2100853.22302 | 37.7488541799866 | -122.423755779701 | (37.7488541799866, -122.423755779701) | |||
40517 | 40517 | 31313 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.776615227251604 | -122.428078115713 | (37.7766152272516, -122.428078115713) | |
40711 | 40711 | 179300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.42977895945499 | (37.7264539365874, -122.429778959455) | |||
40729 | 40729 | 136253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.805771731842704 | -122.420620147698 | (37.8057717318427, -122.420620147698) | |||
40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
40842 | 40842 | 197113 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.40040724889299 | (37.7547087979762, -122.400407248893) | |||
40908 | 40908 | 197109 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | ||||
41009 | 41009 | 239260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005530.51021 | 2101066.0904 | 37.7494401890135 | -122.42367754770001 | (37.7494401890135, -122.4236775477) | |||
41034 | 41034 | 239281 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 356 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006523.17494 | 2104019.48467 | 37.7576055152006 | -122.420454489001 | (37.7576055152006, -122.420454489001) | |||
41173 | 41173 | 49397 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451@ PACIFIC Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 4 | Permit Number 46412 | 6008850.17473 | 2117891.03277 | 37.7958243657476 | -122.413387728783 | (37.7958243657476, -122.413387728783) | ||
41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
41586 | 41586 | 197159 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016446.71962 | 2095806.9526900002 | 37.7356098273254 | -122.385562178561 | (37.7356098273254, -122.385562178561) | |||
41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
41805 | 41805 | 81939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
42163 | 42163 | 239262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1515 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007244.80682 | 2107321.6134599997 | 37.766713033200105 | -122.41819289551 | (37.7667130332001, -122.41819289551) | |||
42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
42229 | 42229 | 240207 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | |||
42316 | 42316 | 213920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 38 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996379.163369999 | 2106706.8374799998 | 37.764407428690795 | -122.455730647179 | (37.7644074286908, -122.455730647179) | |||
42701 | 42701 | 136231 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009179.0642099995 | 2115849.5687700002 | 37.790237464224894 | -122.412105358482 | (37.7902374642249, -122.412105358482) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");