Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 360 | 360 | 6307 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | |||
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 700 | 700 | 6319 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001987.058999999 | 2112951.3489 | 37.781873535447396 | -122.436781566115 | (37.7818735354474, -122.436781566115) | |||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 877 | 877 | 6322 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902046998 | (37.7818440417219, -122.43704902047) | |||
| 880 | 880 | 246102 | DPW Maintained 3 | Tristania conferta :: 79 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.768333957535795 | -122.453033652641 | (37.7683339575358, -122.453033652641) | |||
| 978 | 978 | 200822 | DPW Maintained 3 | Tristania conferta :: 79 | 5266 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6014368.9731 | 2093728.9009999998 | 37.7297887395904 | -122.392600482998 | (37.7297887395904, -122.392600482998) | |||
| 1020 | 1020 | 10701 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.43758304169201 | (37.7750880443133, -122.437583041692) | |||
| 1195 | 1195 | 12282 | DPW Maintained 3 | Tristania conferta :: 79 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.42668800624901 | (37.7781341613075, -122.426688006249) | |||
| 1242 | 1242 | 138398 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.787641421844896 | -122.435543840756 | (37.7876414218449, -122.435543840756) | |||
| 1247 | 1247 | 13128 | DPW Maintained 3 | Tristania conferta :: 79 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.42985071173901 | (37.8007374433085, -122.429850711739) | |||
| 1263 | 1263 | 138399 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6002411.2137 | 2115044.4135 | 37.7876446559027 | -122.435463964972 | (37.7876446559027, -122.435463964972) | |||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1505 | 1505 | 8187 | DPW Maintained 3 | Tristania conferta :: 79 | 1255 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001743.6158 | 2111134.8252 | 37.7768719817661 | -122.43749364217301 | (37.7768719817661, -122.437493642173) | |||
| 1927 | 1927 | 10692 | DPW Maintained 3 | Tristania conferta :: 79 | 1249 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001880.3859 | 2110463.9678 | 37.7750377503654 | -122.43697247440201 | (37.7750377503654, -122.436972474402) | |||
| 1999 | 1999 | 141841 | DPW Maintained 3 | Tristania conferta :: 79 | 1297 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6004290.5512 | 2112882.1345 | 37.781814133771704 | -122.42880761506001 | (37.7818141337717, -122.42880761506) | |||
| 2329 | 2329 | 6184 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | |||
| 2578 | 2578 | 21604 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005122.6686 | 2114733.0427 | 37.7869433299583 | -122.426060678785 | (37.7869433299583, -122.426060678785) | |||
| 2795 | 2795 | 6186 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.42485024282301 | (37.783400948036, -122.424850242823) | |||
| 2965 | 2965 | 6183 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005506.7779 | 2113443.7591 | 37.78342497809621 | -122.424639997895 | (37.7834249780962, -122.424639997895) | |||
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 3350 | 3350 | 21605 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | |||
| 3372 | 3372 | 101650 | Undocumented 2 | Tristania conferta :: 79 | 3X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998828.7375 | 2112398.5369 | 37.780175655731796 | -122.447668041416 | (37.7801756557318, -122.447668041416) | |||
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 3926 | 3926 | 13242 | DPW Maintained 3 | Tristania conferta :: 79 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | |||
| 4172 | 4172 | 6318 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002006.0106 | 2112955.7484 | 37.7818866924078 | -122.436716317501 | (37.7818866924078, -122.436716317501) | |||
| 4181 | 4181 | 21599 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 6005255.9404 | 2114750.4037 | 37.7869985302762 | -122.425600824408 | (37.7869985302762, -122.425600824408) | |||
| 4438 | 4438 | 6185 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005465.536 | 2113438.1352 | 37.783407206982005 | -122.424782278636 | (37.783407206982, -122.424782278636) | |||
| 4663 | 4663 | 17684 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002398.395 | 2112227.2208 | 37.7799086308334 | -122.435306723377 | (37.7799086308334, -122.435306723377) | |||
| 5039 | 5039 | 13231 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866001 | (37.7992872786644, -122.43957165866) | |||
| 5298 | 5298 | 13176 | Permitted Site 1 | Tristania conferta :: 79 | 1964 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002959.4463 | 2119614.5629 | 37.800224230069205 | -122.43389397959601 | (37.8002242300692, -122.433893979596) | |||
| 5351 | 5351 | 13158 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | |||
| 5483 | 5483 | 17683 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002401.1721 | 2112213.0575 | 37.7798698996827 | -122.43529610278401 | (37.7798698996827, -122.435296102784) | |||
| 5517 | 5517 | 10700 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.775098494652795 | -122.437463562764 | (37.7750984946528, -122.437463562764) | |||
| 5607 | 5607 | 6200 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005257.1287 | 2113359.2082 | 37.783178719822295 | -122.42549766781099 | (37.7831787198223, -122.425497667811) | |||
| 5654 | 5654 | 6078 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001057.2451 | 2112477.7276 | 37.7805202046224 | -122.439964313123 | (37.7805202046224, -122.439964313123) | |||
| 5670 | 5670 | 10699 | DPW Maintained 3 | Tristania conferta :: 79 | 1275 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001777.3475 | 2110450.1636 | 37.774993990438205 | -122.43732791737 | (37.7749939904382, -122.43732791737) | |||
| 5716 | 5716 | 7070 | Permitted Site 1 | Tristania conferta :: 79 | 1634 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999592.5889 | 2109848.7666 | 37.7732182646887 | -122.4448422034 | (37.7732182646887, -122.4448422034) | |||
| 5898 | 5898 | 14455 | DPW Maintained 3 | Tristania conferta :: 79 | 125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998862.4105 | 2112574.347 | 37.780660309110296 | -122.447564210548 | (37.7806603091103, -122.447564210548) | |||
| 5939 | 5939 | 10696 | DPW Maintained 3 | Tristania conferta :: 79 | 1257 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001848.8335 | 2110459.5307 | 37.7750237737687 | -122.43708130308998 | (37.7750237737687, -122.43708130309) | |||
| 5943 | 5943 | 9604 | Permitted Site 1 | Tristania conferta :: 79 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | |||
| 5954 | 5954 | 13262 | Permitted Site 1 | Tristania conferta :: 79 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000711.0138 | 2119222.9095 | 37.799021004008104 | -122.44164629161301 | (37.7990210040081, -122.441646291613) | |||
| 6017 | 6017 | 29686 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.800409236193296 | -122.432581299288 | (37.8004092361933, -122.432581299288) | |||
| 6025 | 6025 | 9561 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003758.3426 | 2112108.0173 | 37.7796584641609 | -122.430593553118 | (37.7796584641609, -122.430593553118) | |||
| 6059 | 6059 | 10683 | Permitted Site 1 | Tristania conferta :: 79 | 1155 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002334.989 | 2110528.6392 | 37.775241150218 | -122.43540453260401 | (37.775241150218, -122.435404532604) | |||
| 6104 | 6104 | 18099 | DPW Maintained 3 | Tristania conferta :: 79 | 3019 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999451.351 | 2114633.9478 | 37.786349077981 | -122.445674946059 | (37.786349077981, -122.445674946059) | |||
| 6167 | 6167 | 10693 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221001 | (37.7751568758154, -122.43700960221) | |||
| 6179 | 6179 | 9633 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002619.654 | 2111947.8436 | 37.779154093768796 | -122.434521309627 | (37.7791540937688, -122.434521309627) | |||
| 6191 | 6191 | 13159 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.43234907433599 | (37.8004302230496, -122.432349074336) | |||
| 6333 | 6333 | 6317 | DPW Maintained 3 | Tristania conferta :: 79 | 1830 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002046.2828 | 2112962.5168 | 37.781907565329206 | -122.436577479183 | (37.7819075653292, -122.436577479183) | |||
| 6344 | 6344 | 13283 | Permitted Site 1 | Tristania conferta :: 79 | 2539 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000208.0345 | 2119155.4664 | 37.7988071530908 | -122.44338191608999 | (37.7988071530908, -122.44338191609) | |||
| 6411 | 6411 | 10687 | Permitted Site 1 | Tristania conferta :: 79 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.775183940568496 | -122.435850276383 | (37.7751839405685, -122.435850276383) | |||
| 6471 | 6471 | 14471 | DPW Maintained 3 | Tristania conferta :: 79 | 227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5998914.8659 | 2112201.4062 | 37.77963930788229 | -122.447355892513 | (37.7796393078823, -122.447355892513) | |||
| 6482 | 6482 | 6194 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005201.2129999995 | 2113404.3918 | 37.7832996233389 | -122.42569433072799 | (37.7832996233389, -122.425694330728) | |||
| 6548 | 6548 | 12281 | Permitted Site 1 | Tristania conferta :: 79 | 739 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004881.0373 | 2111477.1625 | 37.777989829673096 | -122.426664727755 | (37.7779898296731, -122.426664727755) | |||
| 6590 | 6590 | 21597 | DPW Maintained 3 | Tristania conferta :: 79 | 1515 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005206.9209 | 2114744.2763 | 37.7869789360246 | -122.42576998467301 | (37.7869789360246, -122.425769984673) | |||
| 6605 | 6605 | 9632 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002597.6566 | 2111945.8131 | 37.7791472697919 | -122.434597262323 | (37.7791472697919, -122.434597262323) | |||
| 6633 | 6633 | 17842 | DPW Maintained 3 | Tristania conferta :: 79 | 2031 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004091.8528 | 2115280.5278 | 37.7883882726819 | -122.42966612859699 | (37.7883882726819, -122.429666128597) | |||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 6702 | 6702 | 10686 | DPW Maintained 3 | Tristania conferta :: 79 | 1179 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002229.5074 | 2110511.8739 | 37.775189125797205 | -122.435768217131 | (37.7751891257972, -122.435768217131) | |||
| 6706 | 6706 | 21600 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005281.4713 | 2114753.9781 | 37.7870097872628 | -122.42551274764999 | (37.7870097872628, -122.42551274765) | |||
| 6826 | 6826 | 13243 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.799215511035705 | -122.440135189953 | (37.7992155110357, -122.440135189953) | |||
| 6841 | 6841 | 14479 | DPW Maintained 3 | Tristania conferta :: 79 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998992.7029 | 2112117.3083 | 37.7794128442998 | -122.44708056796001 | (37.7794128442998, -122.44708056796) | |||
| 6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
| 6863 | 6863 | 10685 | Permitted Site 1 | Tristania conferta :: 79 | 1167 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002283.296 | 2110520.9551 | 37.7752171157043 | -122.435582800345 | (37.7752171157043, -122.435582800345) | |||
| 6887 | 6887 | 13251 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000984.848999999 | 2119261.9127 | 37.7991436944439 | -122.44070153167699 | (37.7991436944439, -122.440701531677) | |||
| 6900 | 6900 | 13253 | Permitted Site 1 | Tristania conferta :: 79 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.44114410922899 | (37.7993111202698, -122.441144109229) | |||
| 6946 | 6946 | 18103 | DPW Maintained 3 | Tristania conferta :: 79 | 3042 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999290.1369 | 2114664.7113 | 37.7864243409392 | -122.446234917327 | (37.7864243409392, -122.446234917327) | |||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 6988 | 6988 | 7064 | Permitted Site 1 | Tristania conferta :: 79 | 1564 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999951.2096 | 2109897.9532 | 37.7733737782492 | -122.44360522471099 | (37.7733737782492, -122.443605224711) | |||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 7113 | 7113 | 29685 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.800412535842206 | -122.43251101256 | (37.8004125358422, -122.43251101256) | |||
| 7117 | 7117 | 7106 | DPW Maintained 3 | Tristania conferta :: 79 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | |||
| 7143 | 7143 | 13163 | DPW Maintained 3 | Tristania conferta :: 79 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | |||
| 7228 | 7228 | 13213 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001911.9905 | 2119390.9978 | 37.799550882806 | -122.437502561002 | (37.799550882806, -122.437502561002) | |||
| 7364 | 7364 | 6192 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005245.2668 | 2113409.0784 | 37.7833149808402 | -122.425542255616 | (37.7833149808402, -122.425542255616) | |||
| 7414 | 7414 | 14484 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998949.0465 | 2111993.9536 | 37.7790716497834 | -122.447222712917 | (37.7790716497834, -122.447222712917) | |||
| 7430 | 7430 | 6190 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | |||
| 7516 | 7516 | 6182 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005530.6795 | 2113448.9143 | 37.7834404828465 | -122.424557674459 | (37.7834404828465, -122.424557674459) | |||
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 7522 | 7522 | 13182 | DPW Maintained 3 | Tristania conferta :: 79 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | |||
| 7530 | 7530 | 6981 | DPW Maintained 3 | Tristania conferta :: 79 | 802 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003535.9112 | 2110394.3354 | 37.77494051486671 | -122.431240682973 | (37.7749405148667, -122.431240682973) | |||
| 7533 | 7533 | 23864 | DPW Maintained 3 | Tristania conferta :: 79 | 1440 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003698.6329 | 2113675.0331 | 37.7839577153907 | -122.43091198011601 | (37.7839577153907, -122.430911980116) | |||
| 7536 | 7536 | 6323 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001889.2551 | 2112939.5041 | 37.7818354537074 | -122.437119073338 | (37.7818354537074, -122.437119073338) | |||
| 7594 | 7594 | 21603 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005357.043 | 2114765.7223 | 37.7870463035591 | -122.42525212232901 | (37.7870463035591, -122.425252122329) | |||
| 7596 | 7596 | 21601 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005314.151000001 | 2114757.5524 | 37.7870214478079 | -122.42539993758999 | (37.7870214478079, -122.42539993759) | |||
| 7599 | 7599 | 6198 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005211.2623 | 2113352.5609 | 37.7831578763581 | -122.425655873927 | (37.7831578763581, -122.425655873927) | |||
| 7714 | 7714 | 14450 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.44733032611299 | (37.7806967093816, -122.447330326113) | |||
| 7726 | 7726 | 14482 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5998940.9244 | 2112049.1164 | 37.7792226484867 | -122.447254781672 | (37.7792226484867, -122.447254781672) | |||
| 7818 | 7818 | 6321 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001938.3263 | 2112944.9189 | 37.781853110577 | -122.43694969789301 | (37.781853110577, -122.436949697893) | |||
| 7874 | 7874 | 26540 | DPW Maintained 3 | Tristania conferta :: 79 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | |||
| 7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
| 7966 | 7966 | 100969 | Undocumented 2 | Tristania conferta :: 79 | 418 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007656.9693 | 2112859.914 | 37.7819430807706 | -122.417159773401 | (37.7819430807706, -122.417159773401) | |||
| 8060 | 8060 | 6320 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001964.3848 | 2112948.6415 | 37.78186481295621 | -122.436859814321 | (37.7818648129562, -122.436859814321) | |||
| 8171 | 8171 | 21598 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005231.4306 | 2114747.34 | 37.7869887331779 | -122.425685404725 | (37.7869887331779, -122.425685404725) | |||
| 8284 | 8284 | 7069 | DPW Maintained 3 | Tristania conferta :: 79 | 1620 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999644.1221 | 2109852.7822 | 37.7732322313227 | -122.44466423249399 | (37.7732322313227, -122.444664232494) | |||
| 8397 | 8397 | 13233 | DPW Maintained 3 | Tristania conferta :: 79 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | |||
| 8409 | 8409 | 14468 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998906.7438 | 2112277.8895 | 37.779848847108795 | -122.447389496791 | (37.7798488471088, -122.447389496791) | |||
| 8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) |
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");