Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189109 | 189109 | 222339 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | |||
| 189097 | 189097 | 205746 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 33 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993900.499 | 2101145.1165299998 | 37.748993818619795 | -122.46389985751999 | (37.7489938186198, -122.46389985752) | |||
| 188830 | 188830 | 118808 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 894 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5981738.117319999 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | |||
| 188818 | 188818 | 205732 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 326 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992852.621590001 | 2094635.50509 | 37.731059623795 | -122.46705018713399 | (37.731059623795, -122.467050187134) | |||
| 188814 | 188814 | 220817 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Linda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6005845.69678 | 2105382.02503 | 37.76130853038671 | -122.422894322721 | (37.7613085303867, -122.422894322721) | |||
| 188661 | 188661 | 188933 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2445 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6010250.20839 | 2105948.37762 | 37.763111147673996 | -122.40770083612401 | (37.763111147674, -122.407700836124) | |||
| 188631 | 188631 | 204531 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 3ft | 5999192.435380001 | 2097025.16393 | 37.7379849647319 | -122.44530419514999 | (37.7379849647319, -122.44530419515) | |||
| 188587 | 188587 | 182822 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2309 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986791.0294 | 2102976.7255 | 37.753610649826996 | -122.48861872093201 | (37.753610649827, -122.488618720932) | |||
| 188582 | 188582 | 204474 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 175 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994235.52744 | 2093484.54035 | 37.7279790815655 | -122.46218583961 | (37.7279790815655, -122.46218583961) | |||
| 188533 | 188533 | 45059 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 0 | Permit Number 43944 | 5988289.16857731 | 2099339.5667467 | 37.743711287686295 | -122.483171307647 | (37.7437112876863, -122.483171307647) | |
| 188520 | 188520 | 120860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 563 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989994.30954 | 2111525.98053 | 37.77727099265471 | -122.478166218158 | (37.7772709926547, -122.478166218158) | |||
| 188516 | 188516 | 188959 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1712 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6014904.41664 | 2096665.80836 | 37.737882612900705 | -122.390954562096 | (37.7378826129007, -122.390954562096) | |||
| 188495 | 188495 | 222374 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004025.35278 | 2105686.39209 | 37.7620413681468 | -122.429211828984 | (37.7620413681468, -122.429211828984) | |||
| 188431 | 188431 | 205674 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5990467.03481 | 2102486.1364 | 37.7524774441906 | -122.475870592067 | (37.7524774441906, -122.475870592067) | |||
| 188427 | 188427 | 58957 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 573 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1993 12:00:00 AM | 7 | Permit Number 32270 | 5994672.72826 | 2111619.94034 | 37.777799437364294 | -122.461988995399 | (37.7777994373643, -122.461988995399) | ||
| 188339 | 188339 | 222273 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 219 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007271.83337 | 2098797.5804 | 37.743309511526796 | -122.41749523831999 | (37.7433095115268, -122.41749523832) | |||
| 188286 | 188286 | 204393 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 535 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994053.9946 | 2106982.90993 | 37.7650317389351 | -122.463792739238 | (37.7650317389351, -122.463792739238) | |||
| 188266 | 188266 | 204576 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 589 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000101.14547 | 2095674.8200599998 | 37.734329067735 | -122.442065445065 | (37.734329067735, -122.442065445065) | |||
| 188162 | 188162 | 188987 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6012918.6311099995 | 2094968.5987900002 | 37.73311204037989 | -122.397701430785 | (37.7331120403799, -122.397701430785) | |||
| 188109 | 188109 | 54813 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 330 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 10 | Permit Number 10667 | 5997647.89997 | 2115270.3728099996 | 37.7879934021327 | -122.451960326717 | (37.7879934021327, -122.451960326717) | ||
| 188049 | 188049 | 222426 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004459.77799 | 2107349.87563 | 37.766633479179504 | -122.42782785418801 | (37.7666334791795, -122.427827854188) | |||
| 188043 | 188043 | 204591 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 298 Monterey Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000137.52565 | 2094717.93006 | 37.7317037443113 | -122.441871011631 | (37.7317037443113, -122.441871011631) | |||
| 188030 | 188030 | 222450 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 205 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999646.16459 | 2106427.4253599998 | 37.763827179798 | -122.444410951602 | (37.763827179798, -122.444410951602) | |||
| 187953 | 187953 | 55331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.3008700002 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | ||
| 187939 | 187939 | 222297 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 228 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007925.054930001 | 2100253.6658400004 | 37.7473443306744 | -122.415339618244 | (37.7473443306744, -122.415339618244) | |||
| 187936 | 187936 | 38624 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.728345567294795 | -122.386147618696 | (37.7283455672948, -122.386147618696) | |
| 187921 | 187921 | 205817 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Marston Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998664.62429 | 2093222.76421 | 37.7275143308076 | -122.446855559853 | (37.7275143308076, -122.446855559853) | ||||
| 187862 | 187862 | 220853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 406 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003857.3187 | 2098975.44107 | 37.743605160060206 | -122.42931442544399 | (37.7436051600602, -122.429314425444) | |||
| 187850 | 187850 | 204458 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 390 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993883.60942 | 2099617.77465 | 37.7447991512623 | -122.463847414442 | (37.7447991512623, -122.463847414442) | |||
| 187799 | 187799 | 220875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 760 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997994.43805 | 2107794.59906 | 37.767486711866 | -122.45022229873301 | (37.767486711866, -122.450222298733) | |||
| 187773 | 187773 | 205777 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998268.540569999 | 2094371.3450099998 | 37.7306454275246 | -122.44830749279 | (37.7306454275246, -122.44830749279) | |||
| 187670 | 187670 | 42671 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.9274699995 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | |
| 187637 | 187637 | 125806 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2791 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001438.2815 | 2115941.57277 | 37.7900527191983 | -122.43889443105199 | (37.7900527191983, -122.438894431052) | |||
| 187561 | 187561 | 205827 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994470.95616 | 2090706.48365 | 37.720364761009705 | -122.46117067590201 | (37.7203647610097, -122.461170675902) | |||
| 187530 | 187530 | 199919 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1208 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6017156.1904 | 2092897.3103 | 37.727659753516896 | -122.38290681304599 | (37.7276597535169, -122.382906813046) | |||
| 187432 | 187432 | 205671 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1484 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993692.069 | 2105423.43995 | 37.7607289793843 | -122.46493127466499 | (37.7607289793843, -122.464931274665) | |||
| 187397 | 187397 | 202109 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1833 Egbert Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6011952.26669 | 2092845.65038 | 37.7272290038035 | -122.400893327982 | (37.7272290038035, -122.400893327982) | |||
| 187378 | 187378 | 220943 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009173.019619999 | 2103460.05786 | 37.7562184278541 | -122.41125069586201 | (37.7562184278541, -122.411250695862) | |||
| 187347 | 187347 | 220903 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 308 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007508.86847 | 2097127.61862 | 37.7387375012193 | -122.41655735965901 | (37.7387375012193, -122.416557359659) | |||
| 187304 | 187304 | 222154 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4660 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000400.22903 | 2101121.9669999997 | 37.7493026817707 | -122.441422155504 | (37.7493026817707, -122.441422155504) | |||
| 187224 | 187224 | 125772 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3590 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997605.73985 | 2115780.38148 | 37.789391335294496 | -122.452143005101 | (37.7893913352945, -122.452143005101) | |||
| 187188 | 187188 | 188879 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 800 Vermont St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011290.47515 | 2104318.93293 | 37.758695235422294 | -122.40398820989799 | (37.7586952354223, -122.403988209898) | ||||
| 187151 | 187151 | 125789 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2812 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 5999154.23094 | 2118479.17049 | 37.79689007496071 | -122.44697971126699 | (37.7968900749607, -122.446979711267) | |||
| 187130 | 187130 | 50945 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1356 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | 11 | Permit Number 47441 | 6016050.0855 | 2093024.8319 | 37.7279487256885 | -122.386739556348 | (37.7279487256885, -122.386739556348) | ||
| 187119 | 187119 | 102739 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | |||
| 187073 | 187073 | 220786 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 27th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6005806.54234 | 2100249.31165 | 37.747213079126 | -122.42266498479601 | (37.747213079126, -122.422664984796) | |||
| 187037 | 187037 | 222230 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8 Aquavista Way | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998088.24008 | 2101938.03895 | 37.751411431901104 | -122.44947581647499 | (37.7514114319011, -122.449475816475) | |||
| 186979 | 186979 | 56490 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 574 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5988163.01569 | 2112081.67357 | 37.7786902989224 | -122.484541944424 | (37.7786902989224, -122.484541944424) | ||||
| 186974 | 186974 | 222419 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6003348.1743 | 2107394.4575099996 | 37.7666929441597 | -122.43167587965 | (37.7666929441597, -122.43167587965) | |||
| 186842 | 186842 | 121832 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5989977.86475 | 2113260.75723 | 37.7820332530406 | -122.478349984728 | (37.7820332530406, -122.478349984728) | |||
| 186827 | 186827 | 204478 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 478 Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994446.2741 | 2104501.5765 | 37.758241237872504 | -122.46225597595101 | (37.7582412378725, -122.462255975951) | |||
| 186824 | 186824 | 220784 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 157 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005923.459009999 | 2106310.00236 | 37.763860925057294 | -122.422691323266 | (37.7638609250573, -122.422691323266) | |||
| 186795 | 186795 | 204500 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Rosewood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994814.30919 | 2095289.8817599998 | 37.73296941779 | -122.460315739002 | (37.73296941779, -122.460315739002) | |||
| 186760 | 186760 | 222369 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003260.7575 | 2105331.22301 | 37.761022845438596 | -122.43183090569799 | (37.7610228454386, -122.431830905698) | |||
| 186736 | 186736 | 220924 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 121 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6009569.56061 | 2097892.28263 | 37.740952779637205 | -122.40948637980499 | (37.7409527796372, -122.409486379805) | |||
| 186708 | 186708 | 204387 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991259.598999999 | 2094303.40475 | 37.7300556800255 | -122.472533282603 | (37.7300556800255, -122.472533282603) | |||
| 186697 | 186697 | 188928 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2001 25th St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158001 | (37.7519707940373, -122.39914787158) | |||
| 186689 | 186689 | 204602 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200 Judson Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5998668.22296 | 2093529.8736400001 | 37.7283577869805 | -122.446865208659 | (37.7283577869805, -122.446865208659) | |||
| 186661 | 186661 | 200144 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1351 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6013679.8971 | 2090868.8737 | 37.7218973889739 | -122.39478249765301 | (37.7218973889739, -122.394782497653) | |||
| 186623 | 186623 | 175620 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009477.4678 | 2090042.2500200002 | 37.719393098398704 | -122.40925098404499 | (37.7193930983987, -122.409250984045) | |||
| 186574 | 186574 | 59349 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/1980 12:00:00 AM | 10 | Permit Number 18697 | 6002772.3177 | 2086703.6942599998 | 37.7098482184782 | -122.43218988627399 | (37.7098482184782, -122.432189886274) | ||
| 186508 | 186508 | 205797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998120.49312 | 2094141.78617 | 37.730006648067295 | -122.44880278452601 | (37.7300066480673, -122.448802784526) | |||
| 186417 | 186417 | 124411 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3906 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5996074.1747 | 2115241.80305 | 37.7878246921221 | -122.45740303299499 | (37.7878246921221, -122.457403032995) | |||
| 186359 | 186359 | 62064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.763263666636206 | -122.50082775809099 | (37.7632636666362, -122.500827758091) | ||
| 186336 | 186336 | 56724 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1582 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6015504.0444 | 2095869.4942 | 37.7357293502019 | -122.38882576103902 | (37.7357293502019, -122.388825761039) | ||||
| 186322 | 186322 | 188993 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Topeka Ave | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012747.96084 | 2095104.27422 | 37.7334750715082 | -122.398301003391 | (37.7334750715082, -122.398301003391) | |||
| 186302 | 186302 | 175614 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011421.832780001 | 2090628.0448200002 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | |||
| 186290 | 186290 | 222401 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4131 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002187.30073 | 2104685.61491 | 37.759189251909 | -122.435497334645 | (37.759189251909, -122.435497334645) | |||
| 186246 | 186246 | 199872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1452 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015728.3896 | 2093608.7319 | 37.7295341830028 | -122.387892403836 | (37.7295341830028, -122.387892403836) | |||
| 186185 | 186185 | 118197 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 854 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985129.46511 | 2110039.1376900002 | 37.7729049579345 | -122.49488537836599 | (37.7729049579345, -122.494885378366) | |||
| 186171 | 186171 | 222262 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 186 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009510.270269999 | 2097576.28192 | 37.7400817880389 | -122.40966908607099 | (37.7400817880389, -122.409669086071) | |||
| 186136 | 186136 | 175714 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Somerset St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6010274.74142 | 2091727.59324 | 37.7240653372183 | -122.40661379409201 | (37.7240653372183, -122.406613794092) | |||
| 186128 | 186128 | 204546 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 69 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999726.305480001 | 2097318.0909700003 | 37.738819733438504 | -122.443479384359 | (37.7388197334385, -122.443479384359) | |||
| 186083 | 186083 | 222457 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 136 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003829.662330001 | 2108917.04575 | 37.7709008819077 | -122.43011912532101 | (37.7709008819077, -122.430119125321) | |||
| 186061 | 186061 | 205780 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Hearst Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998340.4238 | 2094370.66525 | 37.73064767044821 | -122.448058933666 | (37.7306476704482, -122.448058933666) | |||
| 186026 | 186026 | 204380 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992207.49196 | 2088316.25633 | 37.713671258107 | -122.46882082092199 | (37.713671258107, -122.468820820922) | |||
| 186015 | 186015 | 188266 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 9 Navy Rd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6018074.33224 | 2093577.4379099999 | 37.7295779385535 | -122.379779984755 | (37.7295779385535, -122.379779984755) | |||
| 185997 | 185997 | 204390 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991146.571880001 | 2090545.43725 | 37.719730693094796 | -122.47265014049499 | (37.7197306930948, -122.472650140495) | |||
| 185977 | 185977 | 68539 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 155 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 7 | 3x7 | Permit Number 32421 | 5991148.39741 | 2114378.82995 | 37.7851710530124 | -122.47438213241301 | (37.7851710530124, -122.474382132413) |
| 185973 | 185973 | 244125 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 514 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998476.0616 | 2108868.3149 | 37.7704624126065 | -122.448633775108 | (37.7704624126065, -122.448633775108) | |||
| 185793 | 185793 | 125760 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 253 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002145.57423 | 2118944.4046400003 | 37.7983379321998 | -122.436662293934 | (37.7983379321998, -122.436662293934) | |||
| 185771 | 185771 | 222359 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 496 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003219.504269999 | 2102739.56773 | 37.7539044398485 | -122.431788533216 | (37.7539044398485, -122.431788533216) | |||
| 185753 | 185753 | 175651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008001 | (37.7189698369625, -122.47492674008) | |||
| 185747 | 185747 | 199837 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1610 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014558.1807 | 2092735.0741 | 37.7270703971337 | -122.39187689967699 | (37.7270703971337, -122.391876899677) | |||
| 185702 | 185702 | 125792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3801 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000092.0831699995 | 2121324.76719 | 37.804756859503605 | -122.443939089914 | (37.8047568595036, -122.443939089914) | |||
| 185701 | 185701 | 246440 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 485 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) | ||||
| 185570 | 185570 | 142557 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2500 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007977.1166 | 2121032.7906 | 37.8044017891252 | -122.41663135293899 | (37.8044017891252, -122.416631352939) | |||
| 185560 | 185560 | 188263 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Hudson Ave | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017270.30063 | 2095300.86237 | 37.7342657383686 | -122.382679509676 | (37.7342657383686, -122.382679509676) | |||
| 185540 | 185540 | 125811 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2210 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000356.4532699995 | 2116306.0770099997 | 37.7909919432784 | -122.442663639026 | (37.7909919432784, -122.442663639026) | |||
| 185465 | 185465 | 188950 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1739 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014798.53304 | 2096673.37347 | 37.7378975092664 | -122.39132118512899 | (37.7378975092664, -122.391321185129) | |||
| 185449 | 185449 | 123930 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 211 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993036.60641 | 2114007.84585 | 37.7842616458582 | -122.46782257941099 | (37.7842616458582, -122.467822579411) | |||
| 185422 | 185422 | 175731 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 582 Sweeny St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6007923.44818 | 2094303.9803400002 | 37.7310077131179 | -122.414924140441 | (37.7310077131179, -122.414924140441) | ||||
| 185379 | 185379 | 113500 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | |||
| 185375 | 185375 | 185604 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2616 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5985326.7624 | 2100947.2721 | 37.74795277169 | -122.493532882791 | (37.74795277169, -122.493532882791) | |||
| 185261 | 185261 | 142284 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1626 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000014.7322 | 2110599.453 | 37.7753035413789 | -122.443435890645 | (37.7753035413789, -122.443435890645) | |||
| 185240 | 185240 | 188937 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Hampshire St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010109.829059999 | 2105835.89058 | 37.762794424436706 | -122.40817842921001 | (37.7627944244367, -122.40817842921) | |||
| 185124 | 185124 | 217665 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5992999.2698 | 2097917.3829 | 37.740079304226 | -122.46678168408701 | (37.740079304226, -122.466781684087) | |||
| 185120 | 185120 | 222383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 534 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002966.0239 | 2105080.34846 | 37.7603172922179 | -122.432832337652 | (37.7603172922179, -122.432832337652) | |||
| 185057 | 185057 | 220805 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | |||
| 185024 | 185024 | 199834 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1622 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6014497.2734 | 2092780.1455 | 37.7271907726593 | -122.39209060766001 | (37.7271907726593, -122.39209060766) |
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");