Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99553 | 99553 | 93063 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 5 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 96625 | 96625 | 93062 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | ||
| 95827 | 95827 | 93061 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 3 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 83213 | 83213 | 93060 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 2 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 89654 | 89654 | 93059 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 1 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 90151 | 90151 | 94067 | Permitted Site 1 | Tree(s) :: 17 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2010 12:00:00 AM | 3x3 | Tree 1 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | ||
| 104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | |||||
| 94299 | 94299 | 84820 | Permitted Site 1 | Tree(s) :: 17 | 772 HARRISON St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49314 | 6012829.0 | 2112467.0 | 37.781153833736205 | -122.39923922217301 | (37.7811538337362, -122.399239222173) | ||||
| 113971 | 113971 | 84738 | Permitted Site 1 | Tree(s) :: 17 | 97 Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.41246638758899 | (37.7416302361339, -122.412466387589) | ||||
| 118924 | 118924 | 84818 | Permitted Site 1 | Tree(s) :: 17 | 760 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49223 | 6012704.0 | 2103964.0 | 37.757799540478395 | -122.399074649862 | (37.7577995404784, -122.399074649862) | ||||
| 45032 | 45032 | 54249 | Permitted Site 1 | Tree(s) :: 17 | 1274 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1972 12:00:00 AM | 20 | Permit Number 9991 | 5988659.40013717 | 2106655.34316867 | 37.763819989179204 | -122.482427078169 | (37.7638199891792, -122.482427078169) | ||
| 110213 | 110213 | 54248 | Permitted Site 1 | Tree(s) :: 17 | 1270 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1972 12:00:00 AM | Permit Number 9990 | 5988658.49378017 | 2106681.68861971 | 37.7638922738793 | -122.48243214344299 | (37.7638922738793, -122.482432143443) | |||
| 93532 | 93532 | 54242 | Permitted Site 1 | Tree(s) :: 17 | 1201 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1972 12:00:00 AM | Permit Number 9982 | 5998165.20998344 | 2106218.14593623 | 37.7631679419226 | -122.449518019404 | (37.7631679419226, -122.449518019404) | |||
| 97208 | 97208 | 54241 | Permitted Site 1 | Tree(s) :: 17 | 1289 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9981 | 5995148.59563824 | 2106773.34474969 | 37.764519343024794 | -122.459991629084 | (37.7645193430248, -122.459991629084) | |||
| 89804 | 89804 | 54239 | Permitted Site 1 | Tree(s) :: 17 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9979 | 5995147.26905248 | 2106811.90515359 | 37.764625143603794 | -122.459999010975 | (37.7646251436038, -122.459999010975) | |||
| 118456 | 118456 | 54236 | Permitted Site 1 | Tree(s) :: 17 | 1278 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9976 | 5995197.96939939 | 2106850.57690326 | 37.7647342420492 | -122.459826454653 | (37.7647342420492, -122.459826454653) | |||
| 80129 | 80129 | 54235 | Permitted Site 1 | Tree(s) :: 17 | 1275 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9975 | 5995145.50027148 | 2106863.31902546 | 37.764766211038705 | -122.46000885352899 | (37.7647662110387, -122.460008853529) | |||
| 139107 | 139107 | 54233 | Permitted Site 1 | Tree(s) :: 17 | 1269 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9973 | 5995144.17368572 | 2106901.87942936 | 37.7648720116121 | -122.460016235469 | (37.7648720116121, -122.460016235469) | |||
| 93090 | 93090 | 54230 | Permitted Site 1 | Tree(s) :: 17 | 1263 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9970 | 5995142.84709997 | 2106940.43983326 | 37.764977812183 | -122.46002361743 | (37.764977812183, -122.46002361743) | |||
| 112768 | 112768 | 54228 | Permitted Site 1 | Tree(s) :: 17 | 1236 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9967 | 5995188.02638703 | 2107139.59434987 | 37.7655272371859 | -122.45988178223 | (37.7655272371859, -122.45988178223) | |||
| 79508 | 79508 | 54227 | Permitted Site 1 | Tree(s) :: 17 | 1218 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9966 | 5995184.16942835 | 2107251.70599926 | 37.7658348448517 | -122.45990324446501 | (37.7658348448517, -122.459903244465) | |||
| 125691 | 125691 | 54226 | Permitted Site 1 | Tree(s) :: 17 | 1214 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9964 | 5995183.31232643 | 2107276.61969912 | 37.765903202108 | -122.45990801387501 | (37.765903202108, -122.459908013875) | |||
| 89791 | 89791 | 54225 | Permitted Site 1 | Tree(s) :: 17 | 1200 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9963 | 5995180.31246968 | 2107363.81764864 | 37.7661424524971 | -122.45992470687901 | (37.7661424524971, -122.459924706879) | |||
| 94496 | 94496 | 54224 | Permitted Site 1 | Tree(s) :: 17 | 1275 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9962 | 5995455.80388001 | 2106874.03814043 | 37.76481348491 | -122.45893637741399 | (37.76481348491, -122.458936377414) | |||
| 116173 | 116173 | 54223 | Permitted Site 1 | Tree(s) :: 17 | 1272 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9961 | 5995507.09104626 | 2106895.652617 | 37.76487578066371 | -122.458760554457 | (37.7648757806637, -122.458760554457) | |||
| 102929 | 102929 | 54222 | Permitted Site 1 | Tree(s) :: 17 | 1265 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9960 | 5995453.59170055 | 2106938.34058964 | 37.7649899156402 | -122.458948684825 | (37.7649899156402, -122.458948684825) | |||
| 129258 | 129258 | 54221 | Permitted Site 1 | Tree(s) :: 17 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9959 | 5995452.70682877 | 2106964.06156933 | 37.7650604879304 | -122.458953607806 | (37.7650604879304, -122.458953607806) | |||
| 103345 | 103345 | 54220 | Permitted Site 1 | Tree(s) :: 17 | 1257 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9958 | 5995451.82195698 | 2106989.78254901 | 37.765131060219495 | -122.458958530796 | (37.7651310602195, -122.458958530796) | |||
| 110170 | 110170 | 54218 | Permitted Site 1 | Tree(s) :: 17 | 1219 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9956 | 5995442.51666838 | 2107260.2641065 | 37.7658731976209 | -122.459010301428 | (37.7658731976209, -122.459010301428) | |||
| 124756 | 124756 | 54216 | Permitted Site 1 | Tree(s) :: 17 | 650 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1972 12:00:00 AM | Permit Number 9954 | 5995030.20332455 | 2106164.63187071 | 37.762841165213295 | -122.460357005 | (37.7628411652133, -122.460357005) | |||
| 122043 | 122043 | 54211 | Permitted Site 1 | Tree(s) :: 17 | 700 Lincoln St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9949 | 5993605.60395035 | 2107361.64964194 | 37.7660458098349 | -122.46537111308399 | (37.7660458098349, -122.465371113084) | |||
| 118983 | 118983 | 54206 | Permitted Site 1 | Tree(s) :: 17 | 526 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9944 | 5994147.95293559 | 2107032.11537111 | 37.7651722581206 | -122.46347133431499 | (37.7651722581206, -122.463471334315) | |||
| 112322 | 112322 | 54205 | Permitted Site 1 | Tree(s) :: 17 | 139 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9943 | 5995354.17926051 | 2107022.12845835 | 37.76521426040021 | -122.45929859343 | (37.7652142604002, -122.45929859343) | |||
| 82541 | 82541 | 54204 | Permitted Site 1 | Tree(s) :: 17 | 131 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | Permit Number 9942 | 5995377.99005235 | 2107022.95842059 | 37.7652179081932 | -122.459216298261 | (37.7652179081932, -122.459216298261) | |||
| 75747 | 75747 | 54203 | Permitted Site 1 | Tree(s) :: 17 | 129 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9941 | 5995383.94275448 | 2107023.1659113 | 37.76521882013321 | -122.459195724453 | (37.7652188201332, -122.459195724453) | |||
| 108112 | 108112 | 54200 | Permitted Site 1 | Tree(s) :: 17 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9938 | 5995654.85488521 | 2107032.60892369 | 37.7652603192898 | -122.458259393816 | (37.7652603192898, -122.458259393816) | |||
| 110908 | 110908 | 54198 | Permitted Site 1 | Tree(s) :: 17 | 30 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9936 | 5995701.15076447 | 2107086.25420453 | 37.7654102755527 | -122.45810315116199 | (37.7654102755527, -122.458103151162) | |||
| 111921 | 111921 | 54197 | Permitted Site 1 | Tree(s) :: 17 | 7 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9935 | 5995773.43287988 | 2107036.74210984 | 37.7652784810606 | -122.457849562414 | (37.7652784810606, -122.457849562414) | |||
| 108347 | 108347 | 54196 | Permitted Site 1 | Tree(s) :: 17 | 2400 Washington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1972 12:00:00 AM | Permit Number 9933 | 6003211.73035165 | 2116564.51715591 | 37.7918639049586 | -122.43280297004401 | (37.7918639049586, -122.432802970044) | |||
| 26651 | 26651 | 54195 | Permitted Site 1 | Tree(s) :: 17 | 863 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | Permit Number 9932 | 5983223.98924122 | 2109926.2761241 | 37.7724833470275 | -122.501468187751 | (37.7724833470275, -122.501468187751) | |||
| 79106 | 79106 | 54194 | Permitted Site 1 | Tree(s) :: 17 | 4507 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1972 12:00:00 AM | Permit Number 9931 | 6001090.41996526 | 2104621.18240143 | 37.7589499775483 | -122.43928624794701 | (37.7589499775483, -122.439286247947) | |||
| 82082 | 82082 | 54193 | Permitted Site 1 | Tree(s) :: 17 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1972 12:00:00 AM | Permit Number 9929 | 6004425.95705553 | 2099300.95070846 | 37.7445311111316 | -122.427371396194 | (37.7445311111316, -122.427371396194) | |||
| 88978 | 88978 | 54192 | Permitted Site 1 | Tree(s) :: 17 | 1800 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1972 12:00:00 AM | Permit Number 9928 | 6003970.071417401 | 2114620.22643789 | 37.7865683551319 | -122.430040351032 | (37.7865683551319, -122.430040351032) | |||
| 120726 | 120726 | 54191 | Permitted Site 1 | Tree(s) :: 17 | 177 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1972 12:00:00 AM | Permit Number 9927 | 6005446.49280939 | 2102690.15694653 | 37.753894757346394 | -122.42408356355699 | (37.7538947573464, -122.424083563557) | |||
| 108125 | 108125 | 54190 | Permitted Site 1 | Tree(s) :: 17 | 81 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9926 | 6005661.0124984 | 2108583.32813962 | 37.7700881256225 | -122.423760699167 | (37.7700881256225, -122.423760699167) | |||
| 127327 | 127327 | 54184 | Permitted Site 1 | Tree(s) :: 17 | 1523 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9919 | 6015575.83102515 | 2096446.47115556 | 37.7373175903777 | -122.38861782768299 | (37.7373175903777, -122.388617827683) | |||
| 125281 | 125281 | 54183 | Permitted Site 1 | Tree(s) :: 17 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9918 | 5992252.86810384 | 2102050.91586578 | 37.7513858215434 | -122.46966325582501 | (37.7513858215434, -122.469663255825) | |||
| 106884 | 106884 | 54182 | Permitted Site 1 | Tree(s) :: 17 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9917 | 5992242.56777336 | 2102077.94043422 | 37.75145942867229 | -122.469700842466 | (37.7514594286723, -122.469700842466) | |||
| 141919 | 141919 | 54181 | Permitted Site 1 | Tree(s) :: 17 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9916 | 5992280.85765043 | 2102123.48503857 | 37.7515866953923 | -122.469571747805 | (37.7515866953923, -122.469571747805) | |||
| 82606 | 82606 | 54180 | Permitted Site 1 | Tree(s) :: 17 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9915 | 5992281.85082546 | 2102137.9648812 | 37.7516265106914 | -122.469569367285 | (37.7516265106914, -122.469569367285) | |||
| 123195 | 123195 | 54179 | Permitted Site 1 | Tree(s) :: 17 | 1946 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9914 | 5992286.60814003 | 2102166.49194956 | 37.7517051135809 | -122.469554992473 | (37.7517051135809, -122.469554992473) | |||
| 111348 | 111348 | 54178 | Permitted Site 1 | Tree(s) :: 17 | 1940 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9913 | 5992293.74410745 | 2102209.28252543 | 37.7518230178364 | -122.46953343021099 | (37.7518230178364, -122.469533430211) | |||
| 83787 | 83787 | 54177 | Permitted Site 1 | Tree(s) :: 17 | 1926 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9912 | 5992278.63670938 | 2102318.40263055 | 37.7521217602474 | -122.469593616061 | (37.7521217602474, -122.469593616061) | |||
| 85061 | 85061 | 54175 | Permitted Site 1 | Tree(s) :: 17 | 1906 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9910 | 5992259.24604597 | 2102456.89958784 | 37.752500916266705 | -122.469670752945 | (37.7525009162667, -122.469670752945) | |||
| 144275 | 144275 | 54173 | Permitted Site 1 | Tree(s) :: 17 | 881 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9908 | 6009258.20888465 | 2090119.45963122 | 37.7195928134325 | -122.410014331585 | (37.7195928134325, -122.410014331585) | |||
| 94780 | 94780 | 54172 | Permitted Site 1 | Tree(s) :: 17 | 875 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9907 | 6009250.66071403 | 2090144.34753997 | 37.7196607273878 | -122.41004217905198 | (37.7196607273878, -122.410042179052) | |||
| 87611 | 87611 | 54171 | Permitted Site 1 | Tree(s) :: 17 | 863 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9906 | 6009235.5643822 | 2090194.12332646 | 37.7197965551917 | -122.41009787410401 | (37.7197965551917, -122.410097874104) | |||
| 143222 | 143222 | 54170 | Permitted Site 1 | Tree(s) :: 17 | 851 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9905 | 6009220.46805037 | 2090243.89911296 | 37.7199323829664 | -122.41015356936 | (37.7199323829664, -122.41015356936) | |||
| 80351 | 80351 | 54168 | Permitted Site 1 | Tree(s) :: 17 | 845 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9903 | 6009212.91988445 | 2090268.7870062 | 37.720000296842706 | -122.410181417064 | (37.7200002968427, -122.410181417064) | |||
| 83843 | 83843 | 54166 | Permitted Site 1 | Tree(s) :: 17 | 838 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9901 | 6009155.60998668 | 2090278.58284714 | 37.7200239816424 | -122.410380209835 | (37.7200239816424, -122.410380209835) | |||
| 95295 | 95295 | 54161 | Permitted Site 1 | Tree(s) :: 17 | 289 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9896 | 6012957.31958324 | 2095132.98285563 | 37.7335655593608 | -122.39757919869699 | (37.7335655593608, -122.397579198697) | |||
| 96956 | 96956 | 54160 | Permitted Site 1 | Tree(s) :: 17 | 285 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1972 12:00:00 AM | Permit Number 9895 | 6012961.37568572 | 2095152.55575624 | 37.733619528348704 | -122.39756654777 | (37.7336195283487, -122.39756654777) | |||
| 84550 | 84550 | 54158 | Permitted Site 1 | Tree(s) :: 17 | 239 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9893 | 6013008.02089396 | 2095377.6442566002 | 37.7342401719727 | -122.397421060698 | (37.7342401719727, -122.397421060698) | |||
| 107923 | 107923 | 54157 | Permitted Site 1 | Tree(s) :: 17 | 229 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9892 | 6013018.16115388 | 2095426.57652604 | 37.7343750944309 | -122.397389432761 | (37.7343750944309, -122.397389432761) | |||
| 92262 | 92262 | 54156 | Permitted Site 1 | Tree(s) :: 17 | 187 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9891 | 6013109.68058036 | 2095642.16455221 | 37.734972149602 | -122.397088129643 | (37.734972149602, -122.397088129643) | |||
| 78548 | 78548 | 54155 | Permitted Site 1 | Tree(s) :: 17 | 115 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9890 | 6013490.97783472 | 2095581.63192956 | 37.7348271583267 | -122.39576560071899 | (37.7348271583267, -122.395765600719) | |||
| 93447 | 93447 | 54154 | Permitted Site 1 | Tree(s) :: 17 | 114 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9889 | 6013459.63780597 | 2095630.80184111 | 37.7349604252662 | -122.3958773992 | (37.7349604252662, -122.3958773992) | |||
| 124431 | 124431 | 54153 | Permitted Site 1 | Tree(s) :: 17 | 70 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9888 | 6013800.24074059 | 2095580.63070839 | 37.7348416084767 | -122.394696293612 | (37.7348416084767, -122.394696293612) | |||
| 17912 | 17912 | 54152 | Permitted Site 1 | Tree(s) :: 17 | 62 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9887 | 6013860.72555877 | 2095569.21827622 | 37.7348136349442 | -122.394486376168 | (37.7348136349442, -122.394486376168) | |||
| 111269 | 111269 | 54151 | Permitted Site 1 | Tree(s) :: 17 | 59 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9886 | 6013874.75190505 | 2095512.30353023 | 37.734658138498204 | -122.39443389802099 | (37.7346581384982, -122.394433898021) | |||
| 125766 | 125766 | 54150 | Permitted Site 1 | Tree(s) :: 17 | 55 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9885 | 6013898.26264123 | 2095494.80066031 | 37.7346113861595 | -122.394351387742 | (37.7346113861595, -122.394351387742) | |||
| 126725 | 126725 | 54148 | Permitted Site 1 | Tree(s) :: 17 | 22 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9883 | 6014069.39743863 | 2095324.65039401 | 37.7341536999836 | -122.393747806992 | (37.7341536999836, -122.393747806992) | |||
| 109396 | 109396 | 54147 | Permitted Site 1 | Tree(s) :: 17 | 11 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 9882 | 6013981.98431201 | 2095285.15444132 | 37.7340403942352 | -122.394047260019 | (37.7340403942352, -122.394047260019) | |||
| 179209 | 179209 | 54146 | Permitted Site 1 | Tree(s) :: 17 | 1482 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 0 | Permit Number 9881 | 5984367.42341102 | 2105093.5901913997 | 37.75928124701571 | -122.49715620319401 | (37.7592812470157, -122.497156203194) | ||
| 119683 | 119683 | 54144 | Permitted Site 1 | Tree(s) :: 17 | 1453 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9879 | 5984308.71127591 | 2105287.8013383 | 37.759811055511705 | -122.497373592535 | (37.7598110555117, -122.497373592535) | |||
| 96710 | 96710 | 54143 | Permitted Site 1 | Tree(s) :: 17 | 1450 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9878 | 5984360.2310056 | 2105302.65582501 | 37.7598548612321 | -122.497196510338 | (37.7598548612321, -122.497196510338) | |||
| 115092 | 115092 | 54140 | Permitted Site 1 | Tree(s) :: 17 | 1418 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | Permit Number 9875 | 5984353.03860019 | 2105511.72145863 | 37.7604284753779 | -122.497236818104 | (37.7604284753779, -122.497236818104) | |||
| 8937 | 8937 | 54133 | Permitted Site 1 | Tree(s) :: 17 | 510 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9866 | ||||||||
| 81476 | 81476 | 54131 | Permitted Site 1 | Tree(s) :: 17 | 455 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9864 | 6012222.53268581 | 2086618.87780535 | 37.710146613631395 | -122.399522034148 | (37.7101466136314, -122.399522034148) | |||
| 89259 | 89259 | 54130 | Permitted Site 1 | Tree(s) :: 17 | 443 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9863 | 6012234.5851677 | 2086656.32804744 | 37.71025011638721 | -122.399483005618 | (37.7102501163872, -122.399483005618) | |||
| 90232 | 90232 | 54129 | Permitted Site 1 | Tree(s) :: 17 | 442 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9862 | 6012185.08542475 | 2086672.25837852 | 37.7102910987425 | -122.399655205679 | (37.7102910987425, -122.399655205679) | |||
| 78632 | 78632 | 54128 | Permitted Site 1 | Tree(s) :: 17 | 430 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9861 | 6012197.13790852 | 2086709.70862645 | 37.7103946015562 | -122.399616177252 | (37.7103946015562, -122.399616177252) | |||
| 91327 | 91327 | 54127 | Permitted Site 1 | Tree(s) :: 17 | 422 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9860 | 6012205.17289769 | 2086734.6754584 | 37.710463603423904 | -122.39959015824101 | (37.7104636034239, -122.399590158241) | |||
| 82814 | 82814 | 54125 | Permitted Site 1 | Tree(s) :: 17 | 401 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9858 | 6012276.76886181 | 2086787.40391812 | 37.710612375981896 | -122.399346404882 | (37.7106123759819, -122.399346404882) | |||
| 99895 | 99895 | 54124 | Permitted Site 1 | Tree(s) :: 17 | 400 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9857 | 6012227.26911887 | 2086803.33424919 | 37.7106533585345 | -122.399518605707 | (37.7106533585345, -122.399518605707) | |||
| 79046 | 79046 | 54123 | Permitted Site 1 | Tree(s) :: 17 | 782 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9856 | 5994226.42547983 | 2089957.55328167 | 37.718294302218496 | -122.461961651964 | (37.7182943022185, -122.461961651964) | |||
| 116834 | 116834 | 54122 | Permitted Site 1 | Tree(s) :: 17 | 779 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9855 | 5994262.8832332 | 2089905.33517377 | 37.7181530226485 | -122.461831849553 | (37.7181530226485, -122.461831849553) | |||
| 109438 | 109438 | 54121 | Permitted Site 1 | Tree(s) :: 17 | 778 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9854 | 5994263.19300082 | 2089957.33425111 | 37.718295817519 | -122.461834547231 | (37.718295817519, -122.461834547231) | |||
| 116315 | 116315 | 54119 | Permitted Site 1 | Tree(s) :: 17 | 774 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | Permit Number 9852 | 5994299.96051129 | 2089957.1152206 | 37.7182973326819 | -122.461707442528 | (37.7182973326819, -122.461707442528) | |||
| 85020 | 85020 | 54116 | Permitted Site 1 | Tree(s) :: 17 | 61 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9847 | 6007767.97908873 | 2088076.43250813 | 37.7138994532662 | -122.415021002579 | (37.7138994532662, -122.415021002579) | |||
| 88319 | 88319 | 54115 | Permitted Site 1 | Tree(s) :: 17 | 60 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9846 | 6007720.36530114 | 2088097.56556644 | 37.7139548044762 | -122.415187069127 | (37.7139548044762, -122.415187069127) | |||
| 99859 | 99859 | 54114 | Permitted Site 1 | Tree(s) :: 17 | 48 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9845 | 6007737.23208963 | 2088142.6541779998 | 37.714079556281 | -122.415131960632 | (37.714079556281, -122.415131960632) | |||
| 126557 | 126557 | 54112 | Permitted Site 1 | Tree(s) :: 17 | 42 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9843 | 6007745.66548388 | 2088165.19848378 | 37.7141419321728 | -122.415104406315 | (37.7141419321728, -122.415104406315) | |||
| 124654 | 124654 | 54111 | Permitted Site 1 | Tree(s) :: 17 | 30 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9842 | 6007762.53227495 | 2088210.28710223 | 37.7142666839542 | -122.41504929753401 | (37.7142666839542, -122.415049297534) | |||
| 77559 | 77559 | 54109 | Permitted Site 1 | Tree(s) :: 17 | 15 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9840 | 6007831.3156026 | 2088245.74485069 | 37.7143679086038 | -122.414814062701 | (37.7143679086038, -122.414814062701) | |||
| 92909 | 92909 | 54106 | Permitted Site 1 | Tree(s) :: 17 | 4462 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9836 | 5999574.81504574 | 2105761.15850969 | 37.761993705687296 | -122.444609836838 | (37.7619937056873, -122.444609836838) | |||
| 126304 | 126304 | 54104 | Permitted Site 1 | Tree(s) :: 17 | 1404 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 9834 | 6009358.56357861 | 2118075.54758209 | 37.7963595290197 | -122.411641645457 | (37.7963595290197, -122.411641645457) | |||
| 113898 | 113898 | 54102 | Permitted Site 1 | Tree(s) :: 17 | 525 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | Permit Number 9830 | 6001563.14471568 | 2102766.75797554 | 37.7538850657245 | -122.437518548541 | (37.7538850657245, -122.437518548541) | |||
| 81447 | 81447 | 54101 | Permitted Site 1 | Tree(s) :: 17 | 210 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1972 12:00:00 AM | Permit Number 9828 | 5999981.765399201 | 2104880.32983358 | 37.759598380906894 | -122.443139095175 | (37.7595983809069, -122.443139095175) | |||
| 139480 | 139480 | 54099 | Permitted Site 1 | Tree(s) :: 17 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1972 12:00:00 AM | Permit Number 9826 | 6000410.71538796 | 2104865.91876802 | 37.7595832607186 | -122.44165454195101 | (37.7595832607186, -122.441654541951) |
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");