Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30646 | 30646 | 123738 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Cabrillo St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994608.02307 | 2110726.73042 | 37.775343195361295 | -122.46214803765801 | (37.7753431953613, -122.462148037658) | |||
30839 | 30839 | 115000 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009069.9005 | 2121160.0836 | 37.804812702509 | -122.412858672154 | (37.804812702509, -122.412858672154) | |||
30844 | 30844 | 248436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 755 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999049.7676 | 2107927.8319 | 37.7679128724009 | -122.446581655831 | (37.7679128724009, -122.446581655831) | |||
30904 | 30904 | 214185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992626.04523 | 2094642.7577 | 37.731066456833794 | -122.467834020931 | (37.7310664568338, -122.467834020931) | |||
30968 | 30968 | 138487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002041.5919 | 2114791.6986 | 37.786929766345 | -122.436724685254 | (37.786929766345, -122.436724685254) | |||
32107 | 32107 | 74167 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.44202094864599 | (37.7772526604879, -122.442020948646) | ||
32417 | 32417 | 105247 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1301X COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x 5 | 5998246.0 | 2105821.0 | 37.7620821004846 | -122.44920998148999 | (37.7620821004846, -122.44920998149) | ||||
32674 | 32674 | 123736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994542.01129 | 2110789.2592 | 37.775511081800396 | -122.462380922286 | (37.7755110818004, -122.462380922286) | |||
32934 | 32934 | 197552 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011729.09071 | 2107385.60351 | 37.7671401230397 | -122.40268692957399 | (37.7671401230397, -122.402686929574) | |||
33092 | 33092 | 142733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009242.9671 | 2121140.0929 | 37.8047675258137 | -122.412258341021 | (37.8047675258137, -122.412258341021) | |||
33129 | 33129 | 101872 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | |||
33262 | 33262 | 245058 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000819.4043 | 2109108.2246 | 37.771254859042294 | -122.440545371757 | (37.7712548590423, -122.440545371757) | |||
33442 | 33442 | 138390 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1955 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002448.3159 | 2114992.6104 | 37.787504524919896 | -122.435331891812 | (37.7875045249199, -122.435331891812) | |||
33555 | 33555 | 214199 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 159 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994376.25623 | 2095510.5029900002 | 37.7335499814343 | -122.46184618277 | (37.7335499814343, -122.46184618277) | |||
33568 | 33568 | 179425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006737.87137 | 2087492.2529799999 | 37.712237478839796 | -122.418540048182 | (37.7122374788398, -122.418540048182) | |||
33832 | 33832 | 240554 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3749 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003416.631030001 | 2102998.4591599996 | 37.754626466853 | -122.43112530030399 | (37.754626466853, -122.431125300304) | |||
34052 | 34052 | 136411 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 160 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013483.17698 | 2118325.06374 | 37.797275146684 | -122.397387020609 | (37.797275146684, -122.397387020609) | |||
34171 | 34171 | 239736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1449 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003316.36973 | 2099822.47009 | 37.745900265003705 | -122.431245341824 | (37.7459002650037, -122.431245341824) | |||
34284 | 34284 | 179448 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006504.268209999 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | |||
34304 | 34304 | 62258 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.729384933111604 | -122.437715130621 | (37.7293849331116, -122.437715130621) | ||
34575 | 34575 | 179465 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.719027441244705 | -122.43612910838101 | (37.7190274412447, -122.436129108381) | |||
34723 | 34723 | 75661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | ||
34731 | 34731 | 240532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009359.969409999 | 2102744.60217 | 37.7542644303799 | -122.410553636735 | (37.7542644303799, -122.410553636735) | |||
34902 | 34902 | 215020 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.732257843614704 | -122.44665550384701 | (37.7322578436147, -122.446655503847) | |||
35423 | 35423 | 138401 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002032.4913 | 2114859.6026 | 37.7871156961534 | -122.43676103385599 | (37.7871156961534, -122.436761033856) | |||
35537 | 35537 | 141930 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004152.017000001 | 2111873.3634 | 37.7790364568014 | -122.42921492627701 | (37.7790364568014, -122.429214926277) | |||
35663 | 35663 | 217714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.45476826329599 | (37.7234935241877, -122.454768263296) | |||
35849 | 35849 | 197509 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570732999 | (37.7726840927246, -122.40966570733) | ||||
36086 | 36086 | 118225 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984452.242269999 | 2111581.69085 | 37.7771006996432 | -122.49734183320601 | (37.7771006996432, -122.497341833206) | |||
36473 | 36473 | 123827 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1501 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993999.90025 | 2112075.9753799997 | 37.77901282804729 | -122.46434964043002 | (37.7790128280473, -122.46434964043) | |||
36655 | 36655 | 123174 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5992855.85161 | 2110444.11138 | 37.7744661593712 | -122.468188588983 | (37.7744661593712, -122.468188588983) | |||
37203 | 37203 | 179446 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006032.90525 | 2087456.2020599998 | 37.712098777304 | -122.42097406600901 | (37.712098777304, -122.420974066009) | |||
37342 | 37342 | 142551 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009269.3434 | 2121145.5233 | 37.80478391634529 | -122.41216744681101 | (37.8047839163453, -122.412167446811) | |||
37444 | 37444 | 136389 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998748.07929 | 2115242.8098299997 | 37.787980675804796 | -122.448151933487 | (37.7879806758048, -122.448151933487) | |||
37529 | 37529 | 114872 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.43311697309099 | (37.7167721250182, -122.433116973091) | ||||
37601 | 37601 | 43760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.783338239757704 | -122.47645167744601 | (37.7833382397577, -122.476451677446) | |
37740 | 37740 | 240550 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 437 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003457.73972 | 2103292.10883 | 37.755435088681104 | -122.43100409237101 | (37.7554350886811, -122.431004092371) | |||
37833 | 37833 | 71250 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.796591545013705 | -122.417569230932 | (37.7965915450137, -122.417569230932) | |
37944 | 37944 | 179455 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006947.074519999 | 2087492.6533099997 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | |||
38198 | 38198 | 43696 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | |
38252 | 38252 | 245993 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1419 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999291.5767 | 2108712.9163 | 37.7700823250716 | -122.44580173719801 | (37.7700823250716, -122.445801737198) | |||
38279 | 38279 | 200678 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.734208388060104 | -122.388207305661 | (37.7342083880601, -122.388207305661) | |||
38840 | 38840 | 215014 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 158 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994270.1897599995 | 2095584.01107 | 37.7337457098893 | -122.462218211614 | (37.7337457098893, -122.462218211614) | |||
38859 | 38859 | 239735 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003316.0935 | 2099809.08635 | 37.7458635007156 | -122.431245341826 | (37.7458635007156, -122.431245341826) | |||
39125 | 39125 | 197507 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009714.36956 | 2109423.2134700003 | 37.772622236462205 | -122.409799423029 | (37.7726222364622, -122.409799423029) | |||
39322 | 39322 | 217596 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1637 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5994881.6994 | 2092227.6519 | 37.7245651536401 | -122.459861012566 | (37.7245651536401, -122.459861012566) | |||
39333 | 39333 | 123466 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 672 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995362.13932 | 2110969.4797099996 | 37.7760531114849 | -122.459556977451 | (37.7760531114849, -122.459556977451) | |||
39386 | 39386 | 215002 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995954.159990001 | 2091115.9744900002 | 37.7215743707347 | -122.45607334462099 | (37.7215743707347, -122.456073344621) | |||
39538 | 39538 | 75600 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5984118.61972 | 2110981.94357 | 37.775434407710705 | -122.49845161010599 | (37.7754344077107, -122.498451610106) | ||
40326 | 40326 | 246423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 406 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6003794.9997 | 2099851.1264400003 | 37.746006061224605 | -122.429592349221 | (37.7460060612246, -122.429592349221) | |||
40375 | 40375 | 179440 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | |||
40850 | 40850 | 136407 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6009007.217180001 | 2119024.8122799997 | 37.798946260622294 | -122.412924532036 | (37.7989462606223, -122.412924532036) | |||
41351 | 41351 | 240569 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6000897.89001 | 2104935.4269999997 | 37.759801858378296 | -122.439974637337 | (37.7598018583783, -122.439974637337) | |||
41432 | 41432 | 245059 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.77115868561361 | -122.44052972578001 | (37.7711586856136, -122.44052972578) | |||
41498 | 41498 | 214201 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.733871759758394 | -122.462212852568 | (37.7338717597584, -122.462212852568) | |||
41692 | 41692 | 107848 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 407 09th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009766.34192 | 2109306.87193 | 37.7723057020722 | -122.40961143144101 | (37.7723057020722, -122.409611431441) | |||
42737 | 42737 | 239675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | |||
42807 | 42807 | 43677 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.776349084718596 | -122.45957524379101 | (37.7763490847186, -122.459575243791) | |
42864 | 42864 | 197567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.767449026680495 | -122.402508917767 | (37.7674490266805, -122.402508917767) | |||
42873 | 42873 | 46597 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.46773026674101 | (37.7852352793736, -122.467730266741) | |
42918 | 42918 | 138403 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002027.5911 | 2114900.905 | 37.7872288234819 | -122.436780945176 | (37.7872288234819, -122.436780945176) | |||
43291 | 43291 | 197532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013605.01625 | 2103874.9640900004 | 37.757605236406995 | -122.39595229975299 | (37.757605236407, -122.395952299753) | ||||
43292 | 43292 | 113589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6013618.317290001 | 2118086.59987 | 37.796627904610204 | -122.39690267003799 | (37.7966279046102, -122.396902670038) | |||
43437 | 43437 | 197539 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | |||
43559 | 43559 | 31153 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34856 | 5999668.77928 | 2093756.1386900002 | 37.729036168077705 | -122.443422496853 | (37.7290361680777, -122.443422496853) | |
44138 | 44138 | 239690 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003983.46456 | 2099388.15936 | 37.744745530090796 | -122.428907662057 | (37.7447455300908, -122.428907662057) | |||
44139 | 44139 | 200675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | |||
44389 | 44389 | 59288 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | ||
44413 | 44413 | 200830 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.766175269536205 | -122.402377754798 | (37.7661752695362, -122.402377754798) | |||
44607 | 44607 | 197563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563784996 | -122.40220204389799 | (37.767473563785, -122.402202043898) | |||
44660 | 44660 | 140664 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 536 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5996926.8557 | 2109499.2642 | 37.7721061302796 | -122.4540380318 | (37.7721061302796, -122.4540380318) | |||
44932 | 44932 | 179450 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006580.779159999 | 2087379.51909 | 37.7119190900695 | -122.41907501532499 | (37.7119190900695, -122.419075015325) | |||
45066 | 45066 | 70152 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 7 | 5993349.447480001 | 2113931.04039 | 37.78406881848979 | -122.46673468365299 | (37.7840688184898, -122.466734683653) | ||
45132 | 45132 | 179472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 416 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003621.62429 | 2091003.33187 | 37.7217022030671 | -122.42956096376999 | (37.7217022030671, -122.42956096377) | |||
45178 | 45178 | 239695 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004807.135419999 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | |||
45376 | 45376 | 32233 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.1022900003 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | |
45696 | 45696 | 40608 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2756 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 12 | Permit Number 41618 | 5996415.12538 | 2111289.35266 | 37.7769918898751 | -122.45593757087 | (37.7769918898751, -122.45593757087) | ||
45807 | 45807 | 240555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | |||
45870 | 45870 | 214171 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994229.270690001 | 2106420.5092700003 | 37.7634976322383 | -122.46314569683001 | (37.7634976322383, -122.46314569683) | |||
46150 | 46150 | 239714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | |||
46348 | 46348 | 197519 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1055 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007591.229180001 | 2109427.92338 | 37.772515957284206 | -122.417143942455 | (37.7725159572842, -122.417143942455) | |||
46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
46443 | 46443 | 200679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | |||
46462 | 46462 | 200672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.734392825730794 | -122.388474327143 | (37.7343928257308, -122.388474327143) | |||
46825 | 46825 | 179482 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988878.80429 | 2090370.98469 | 37.719120158641296 | -122.48047615337 | (37.7191201586413, -122.48047615337) | ||||
47230 | 47230 | 240537 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 21 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005750.77925 | 2099620.18871 | 37.7454825047108 | -122.422813105861 | (37.7454825047108, -122.422813105861) | |||
47246 | 47246 | 64355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.4722700003 | 37.782873389928795 | -122.40238669808399 | (37.7828733899288, -122.402386698084) | ||
47632 | 47632 | 62229 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.728835505929396 | -122.43714804475701 | (37.7288355059294, -122.437148044757) | |
48114 | 48114 | 240565 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | |||
48286 | 48286 | 215017 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.734323119609606 | -122.44426940102801 | (37.7343231196096, -122.444269401028) | |||
48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
48654 | 48654 | 124458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41 Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996118.46825 | 2111510.19918 | 37.7775812452699 | -122.45697977108601 | (37.7775812452699, -122.456979771086) | |||
48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
48810 | 48810 | 183900 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989432.8197 | 2100761.3499 | 37.7476816186189 | -122.479320872687 | (37.7476816186189, -122.479320872687) | |||
48874 | 48874 | 215006 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995155.473540001 | 2106606.4972900003 | 37.764061618685005 | -122.45995575296101 | (37.764061618685, -122.459955752961) | |||
48880 | 48880 | 197526 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010646.79925 | 2106595.9922 | 37.764911543656794 | -122.40637478936002 | (37.7649115436568, -122.40637478936) | |||
49033 | 49033 | 118221 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984455.23409 | 2111482.2118900004 | 37.776827734448105 | -122.49732413820101 | (37.7768277344481, -122.497324138201) | |||
49154 | 49154 | 118227 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5984452.03524 | 2111621.56677 | 37.77721017528479 | -122.497345493843 | (37.7772101752848, -122.497345493843) | |||
49441 | 49441 | 239733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2002 Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002632.00291 | 2099712.5863900003 | 37.745559743 | -122.433603933486 | (37.745559743, -122.433603933486) | |||
49719 | 49719 | 136405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) |
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");