trees
11,761 rows where qSpecies_id = 17 sorted by PermitNotes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108599 | 93063 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | Tree 5 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
| 83912 | 93062 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | ||
| 87252 | 93061 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | Tree 3 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
| 46890 | 93060 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x5 | Tree 2 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
| 72816 | 93059 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x5 | Tree 1 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
| 73965 | 94067 | Permitted Site 7 | Tree(s) :: 17 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2010 12:00:00 AM | 3x3 | Tree 1 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | ||
| 123690 | 98250 | DPW Maintained 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | |||||
| 89921 | 84820 | Permitted Site 7 | Tree(s) :: 17 | 772 HARRISON St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Removed on Permit No. 49314 | 6012829 | 2112467 | 37.7811538337362 | -122.399239222173 | (37.7811538337362, -122.399239222173) | 6 | 2 | 9 | 28856 | 34 | ||||
| 139114 | 84738 | Permitted Site 7 | Tree(s) :: 17 | 97 Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Removed on Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.412466387589 | (37.7416302361339, -122.412466387589) | 10 | 7 | 7 | 28859 | 2 | ||||
| 166560 | 84818 | Permitted Site 7 | Tree(s) :: 17 | 760 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Removed on Permit No. 49223 | 6012704 | 2103964 | 37.7577995404784 | -122.399074649862 | (37.7577995404784, -122.399074649862) | 10 | 3 | 8 | 28856 | 29 | ||||
| 145534 | 54248 | Permitted Site 7 | Tree(s) :: 17 | 1270 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | Permit Number 9990 | 5988658.49378017 | 2106681.68861971 | 37.7638922738793 | -122.482432143443 | (37.7638922738793, -122.482432143443) | 1 | 8 | 3 | 56 | 35 | |||
| 80051 | 54242 | Permitted Site 7 | Tree(s) :: 17 | 1201 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9982 | 5998165.20998344 | 2106218.14593623 | 37.7631679419226 | -122.449518019404 | (37.7631679419226, -122.449518019404) | 15 | 5 | 11 | 29492 | 9 | |||
| 76590 | 54241 | Permitted Site 7 | Tree(s) :: 17 | 1289 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9981 | 5995148.59563824 | 2106773.34474969 | 37.7645193430248 | -122.459991629084 | (37.7645193430248, -122.459991629084) | 15 | 5 | 11 | 56 | 12 | |||
| 69136 | 54239 | Permitted Site 7 | Tree(s) :: 17 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9979 | 5995147.26905248 | 2106811.90515359 | 37.7646251436038 | -122.459999010975 | (37.7646251436038, -122.459999010975) | 15 | 5 | 11 | 56 | 12 | |||
| 158320 | 54236 | Permitted Site 7 | Tree(s) :: 17 | 1278 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9976 | 5995197.96939939 | 2106850.57690326 | 37.7647342420492 | -122.459826454653 | (37.7647342420492, -122.459826454653) | 15 | 5 | 11 | 56 | 12 | |||
| 41941 | 54235 | Permitted Site 7 | Tree(s) :: 17 | 1275 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9975 | 5995145.50027148 | 2106863.31902546 | 37.7647662110387 | -122.460008853529 | (37.7647662110387, -122.460008853529) | 15 | 5 | 11 | 56 | 12 | |||
| 186189 | 54233 | Permitted Site 7 | Tree(s) :: 17 | 1269 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9973 | 5995144.17368572 | 2106901.87942936 | 37.7648720116121 | -122.460016235469 | (37.7648720116121, -122.460016235469) | 15 | 5 | 11 | 56 | 12 | |||
| 89573 | 54230 | Permitted Site 7 | Tree(s) :: 17 | 1263 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9970 | 5995142.84709997 | 2106940.43983326 | 37.764977812183 | -122.46002361743 | (37.764977812183, -122.46002361743) | 15 | 5 | 11 | 56 | 12 | |||
| 139392 | 54228 | Permitted Site 7 | Tree(s) :: 17 | 1236 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9967 | 5995188.02638703 | 2107139.59434987 | 37.7655272371859 | -122.45988178223 | (37.7655272371859, -122.45988178223) | 15 | 5 | 11 | 56 | 12 | |||
| 53753 | 54227 | Permitted Site 7 | Tree(s) :: 17 | 1218 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9966 | 5995184.16942835 | 2107251.70599926 | 37.7658348448517 | -122.459903244465 | (37.7658348448517, -122.459903244465) | 15 | 5 | 11 | 56 | 12 | |||
| 27611 | 54226 | Permitted Site 7 | Tree(s) :: 17 | 1214 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9964 | 5995183.31232643 | 2107276.61969912 | 37.765903202108 | -122.459908013875 | (37.765903202108, -122.459908013875) | 15 | 5 | 11 | 56 | 12 | |||
| 63278 | 54225 | Permitted Site 7 | Tree(s) :: 17 | 1200 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9963 | 5995180.31246968 | 2107363.81764864 | 37.7661424524971 | -122.459924706879 | (37.7661424524971, -122.459924706879) | 15 | 5 | 11 | 29492 | 12 | |||
| 90778 | 54224 | Permitted Site 7 | Tree(s) :: 17 | 1275 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9962 | 5995455.80388001 | 2106874.03814043 | 37.76481348491 | -122.458936377414 | (37.76481348491, -122.458936377414) | 15 | 5 | 11 | 56 | 12 | |||
| 146108 | 54223 | Permitted Site 7 | Tree(s) :: 17 | 1272 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9961 | 5995507.09104626 | 2106895.652617 | 37.7648757806637 | -122.458760554457 | (37.7648757806637, -122.458760554457) | 15 | 5 | 11 | 56 | 12 | |||
| 103828 | 54222 | Permitted Site 7 | Tree(s) :: 17 | 1265 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9960 | 5995453.59170055 | 2106938.34058964 | 37.7649899156402 | -122.458948684825 | (37.7649899156402, -122.458948684825) | 15 | 5 | 11 | 56 | 12 | |||
| 33977 | 54221 | Permitted Site 7 | Tree(s) :: 17 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9959 | 5995452.70682877 | 2106964.06156933 | 37.7650604879304 | -122.458953607806 | (37.7650604879304, -122.458953607806) | 15 | 5 | 11 | 56 | 12 | |||
| 111187 | 54220 | Permitted Site 7 | Tree(s) :: 17 | 1257 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1972 12:00:00 AM | Permit Number 9958 | 5995451.82195698 | 2106989.78254901 | 37.7651310602195 | -122.458958530796 | (37.7651310602195, -122.458958530796) | 15 | 5 | 11 | 56 | 12 | |||
| 123425 | 54218 | Permitted Site 7 | Tree(s) :: 17 | 1219 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9956 | 5995442.51666838 | 2107260.2641065 | 37.7658731976209 | -122.459010301428 | (37.7658731976209, -122.459010301428) | 15 | 5 | 11 | 56 | 12 | |||
| 29763 | 54216 | Permitted Site 7 | Tree(s) :: 17 | 650 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/1972 12:00:00 AM | Permit Number 9954 | 5995030.20332455 | 2106164.63187071 | 37.7628411652133 | -122.460357005 | (37.7628411652133, -122.460357005) | 15 | 5 | 11 | 56 | 12 | |||
| 155295 | 54211 | Permitted Site 7 | Tree(s) :: 17 | 700 Lincoln St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9949 | 5993605.60395035 | 2107361.64964194 | 37.7660458098349 | -122.465371113084 | (37.7660458098349, -122.465371113084) | 11 | 8 | 11 | 29492 | 8 | |||
| 164223 | 54206 | Permitted Site 7 | Tree(s) :: 17 | 526 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9944 | 5994147.95293559 | 2107032.11537111 | 37.7651722581206 | -122.463471334315 | (37.7651722581206, -122.463471334315) | 11 | 5 | 11 | 56 | 12 | |||
| 133105 | 54205 | Permitted Site 7 | Tree(s) :: 17 | 139 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9943 | 5995354.17926051 | 2107022.12845835 | 37.7652142604002 | -122.45929859343 | (37.7652142604002, -122.45929859343) | 15 | 5 | 11 | 56 | 12 | |||
| 50457 | 54204 | Permitted Site 7 | Tree(s) :: 17 | 131 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | Permit Number 9942 | 5995377.99005235 | 2107022.95842059 | 37.7652179081932 | -122.459216298261 | (37.7652179081932, -122.459216298261) | 15 | 5 | 11 | 56 | 12 | |||
| 30071 | 54203 | Permitted Site 7 | Tree(s) :: 17 | 129 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9941 | 5995383.94275448 | 2107023.1659113 | 37.7652188201332 | -122.459195724453 | (37.7652188201332, -122.459195724453) | 15 | 5 | 11 | 56 | 12 | |||
| 126916 | 54200 | Permitted Site 7 | Tree(s) :: 17 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9938 | 5995654.85488521 | 2107032.60892369 | 37.7652603192898 | -122.458259393816 | (37.7652603192898, -122.458259393816) | 15 | 5 | 11 | 56 | 12 | |||
| 149250 | 54198 | Permitted Site 7 | Tree(s) :: 17 | 30 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9936 | 5995701.15076447 | 2107086.25420453 | 37.7654102755527 | -122.458103151162 | (37.7654102755527, -122.458103151162) | 15 | 5 | 11 | 56 | 12 | |||
| 144722 | 54197 | Permitted Site 7 | Tree(s) :: 17 | 7 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | Permit Number 9935 | 5995773.43287988 | 2107036.74210984 | 37.7652784810606 | -122.457849562414 | (37.7652784810606, -122.457849562414) | 15 | 5 | 11 | 56 | 12 | |||
| 118856 | 54196 | Permitted Site 7 | Tree(s) :: 17 | 2400 Washington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9933 | 6003211.73035165 | 2116564.51715591 | 37.7918639049586 | -122.432802970044 | (37.7918639049586, -122.432802970044) | 13 | 9 | 1 | 29490 | 27 | |||
| 19193 | 54195 | Permitted Site 7 | Tree(s) :: 17 | 863 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | Permit Number 9932 | 5983223.98924122 | 2109926.2761241 | 37.7724833470275 | -122.501468187751 | (37.7724833470275, -122.501468187751) | 11 | 6 | 2 | 55 | 26 | |||
| 56272 | 54194 | Permitted Site 7 | Tree(s) :: 17 | 4507 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9931 | 6001090.41996526 | 2104621.18240143 | 37.7589499775483 | -122.439286247947 | (37.7589499775483, -122.439286247947) | 2 | 4 | 5 | 28862 | 38 | |||
| 54223 | 54193 | Permitted Site 7 | Tree(s) :: 17 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1972 12:00:00 AM | Permit Number 9929 | 6004425.95705553 | 2099300.95070846 | 37.7445311111316 | -122.427371396194 | (37.7445311111316, -122.427371396194) | 2 | 7 | 5 | 63 | 22 | |||
| 60718 | 54192 | Permitted Site 7 | Tree(s) :: 17 | 1800 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9928 | 6003970.0714174 | 2114620.22643789 | 37.7865683551319 | -122.430040351032 | (37.7865683551319, -122.430040351032) | 13 | 9 | 11 | 29490 | 27 | |||
| 151934 | 54191 | Permitted Site 7 | Tree(s) :: 17 | 177 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 9927 | 6005446.49280939 | 2102690.15694653 | 37.7538947573464 | -122.424083563557 | (37.7538947573464, -122.424083563557) | 2 | 4 | 5 | 28859 | 19 | |||
| 129517 | 54190 | Permitted Site 7 | Tree(s) :: 17 | 81 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9926 | 6005661.0124984 | 2108583.32813962 | 37.7700881256225 | -122.423760699167 | (37.7700881256225, -122.423760699167) | 8 | 2 | 5 | 28853 | 19 | |||
| 30586 | 54184 | Permitted Site 7 | Tree(s) :: 17 | 1523 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | Permit Number 9919 | 6015575.83102515 | 2096446.47115556 | 37.7373175903777 | -122.388617827683 | (37.7373175903777, -122.388617827683) | 10 | 3 | 8 | 58 | 1 | |||
| 23464 | 54183 | Permitted Site 7 | Tree(s) :: 17 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9918 | 5992252.86810384 | 2102050.91586578 | 37.7513858215434 | -122.469663255825 | (37.7513858215434, -122.469663255825) | 1 | 8 | 4 | 29491 | 12 | |||
| 122576 | 54182 | Permitted Site 7 | Tree(s) :: 17 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9917 | 5992242.56777336 | 2102077.94043422 | 37.7514594286723 | -122.469700842466 | (37.7514594286723, -122.469700842466) | 1 | 8 | 4 | 29491 | 12 | |||
| 173980 | 54181 | Permitted Site 7 | Tree(s) :: 17 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9916 | 5992280.85765043 | 2102123.48503857 | 37.7515866953923 | -122.469571747805 | (37.7515866953923, -122.469571747805) | 1 | 8 | 4 | 29491 | 12 | |||
| 45025 | 54180 | Permitted Site 7 | Tree(s) :: 17 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9915 | 5992281.85082546 | 2102137.9648812 | 37.7516265106914 | -122.469569367285 | (37.7516265106914, -122.469569367285) | 1 | 8 | 4 | 29491 | 12 | |||
| 162281 | 54179 | Permitted Site 7 | Tree(s) :: 17 | 1946 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9914 | 5992286.60814003 | 2102166.49194956 | 37.7517051135809 | -122.469554992473 | (37.7517051135809, -122.469554992473) | 1 | 8 | 4 | 29491 | 12 | |||
| 148993 | 54178 | Permitted Site 7 | Tree(s) :: 17 | 1940 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9913 | 5992293.74410745 | 2102209.28252543 | 37.7518230178364 | -122.469533430211 | (37.7518230178364, -122.469533430211) | 1 | 8 | 4 | 29491 | 12 | |||
| 45978 | 54177 | Permitted Site 7 | Tree(s) :: 17 | 1926 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9912 | 5992278.63670938 | 2102318.40263055 | 37.7521217602474 | -122.469593616061 | (37.7521217602474, -122.469593616061) | 1 | 8 | 4 | 29491 | 12 | |||
| 64226 | 54175 | Permitted Site 7 | Tree(s) :: 17 | 1906 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9910 | 5992259.24604597 | 2102456.89958784 | 37.7525009162667 | -122.469670752945 | (37.7525009162667, -122.469670752945) | 1 | 8 | 4 | 29491 | 12 | |||
| 178257 | 54173 | Permitted Site 7 | Tree(s) :: 17 | 881 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9908 | 6009258.20888465 | 2090119.45963122 | 37.7195928134325 | -122.410014331585 | (37.7195928134325, -122.410014331585) | 9 | 3 | 7 | 309 | 28 | |||
| 80809 | 54172 | Permitted Site 7 | Tree(s) :: 17 | 875 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9907 | 6009250.66071403 | 2090144.34753997 | 37.7196607273878 | -122.410042179052 | (37.7196607273878, -122.410042179052) | 9 | 3 | 7 | 309 | 28 | |||
| 58130 | 54171 | Permitted Site 7 | Tree(s) :: 17 | 863 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9906 | 6009235.5643822 | 2090194.12332646 | 37.7197965551917 | -122.410097874104 | (37.7197965551917, -122.410097874104) | 9 | 3 | 7 | 309 | 28 | |||
| 172839 | 54170 | Permitted Site 7 | Tree(s) :: 17 | 851 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9905 | 6009220.46805037 | 2090243.89911296 | 37.7199323829664 | -122.41015356936 | (37.7199323829664, -122.41015356936) | 9 | 3 | 7 | 309 | 28 | |||
| 56363 | 54168 | Permitted Site 7 | Tree(s) :: 17 | 845 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9903 | 6009212.91988445 | 2090268.7870062 | 37.7200002968427 | -122.410181417064 | (37.7200002968427, -122.410181417064) | 9 | 3 | 7 | 309 | 28 | |||
| 52906 | 54166 | Permitted Site 7 | Tree(s) :: 17 | 838 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9901 | 6009155.60998668 | 2090278.58284714 | 37.7200239816424 | -122.410380209835 | (37.7200239816424, -122.410380209835) | 9 | 3 | 7 | 309 | 28 | |||
| 84372 | 54161 | Permitted Site 7 | Tree(s) :: 17 | 289 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9896 | 6012957.31958324 | 2095132.98285563 | 37.7335655593608 | -122.397579198697 | (37.7335655593608, -122.397579198697) | 10 | 3 | 8 | 58 | 1 | |||
| 85231 | 54160 | Permitted Site 7 | Tree(s) :: 17 | 285 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1972 12:00:00 AM | Permit Number 9895 | 6012961.37568572 | 2095152.55575624 | 37.7336195283487 | -122.39756654777 | (37.7336195283487, -122.39756654777) | 10 | 3 | 8 | 58 | 1 | |||
| 54492 | 54158 | Permitted Site 7 | Tree(s) :: 17 | 239 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9893 | 6013008.02089396 | 2095377.6442566 | 37.7342401719727 | -122.397421060698 | (37.7342401719727, -122.397421060698) | 10 | 3 | 8 | 58 | 1 | |||
| 125179 | 54157 | Permitted Site 7 | Tree(s) :: 17 | 229 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9892 | 6013018.16115388 | 2095426.57652604 | 37.7343750944309 | -122.397389432761 | (37.7343750944309, -122.397389432761) | 10 | 3 | 8 | 58 | 1 | |||
| 86796 | 54156 | Permitted Site 7 | Tree(s) :: 17 | 187 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9891 | 6013109.68058036 | 2095642.16455221 | 37.734972149602 | -122.397088129643 | (37.734972149602, -122.397088129643) | 10 | 3 | 8 | 58 | 1 | |||
| 40437 | 54155 | Permitted Site 7 | Tree(s) :: 17 | 115 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9890 | 6013490.97783472 | 2095581.63192956 | 37.7348271583267 | -122.395765600719 | (37.7348271583267, -122.395765600719) | 10 | 3 | 8 | 58 | 1 | |||
| 87090 | 54154 | Permitted Site 7 | Tree(s) :: 17 | 114 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9889 | 6013459.63780597 | 2095630.80184111 | 37.7349604252662 | -122.3958773992 | (37.7349604252662, -122.3958773992) | 10 | 3 | 8 | 58 | 1 | |||
| 25514 | 54153 | Permitted Site 7 | Tree(s) :: 17 | 70 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9888 | 6013800.24074059 | 2095580.63070839 | 37.7348416084767 | -122.394696293612 | (37.7348416084767, -122.394696293612) | 10 | 3 | 8 | 58 | 1 | |||
| 9890 | 54152 | Permitted Site 7 | Tree(s) :: 17 | 62 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9887 | 6013860.72555877 | 2095569.21827622 | 37.7348136349442 | -122.394486376168 | (37.7348136349442, -122.394486376168) | 10 | 3 | 8 | 58 | 1 | |||
| 148767 | 54151 | Permitted Site 7 | Tree(s) :: 17 | 59 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9886 | 6013874.75190505 | 2095512.30353023 | 37.7346581384982 | -122.394433898021 | (37.7346581384982, -122.394433898021) | 10 | 3 | 8 | 58 | 1 | |||
| 25011 | 54150 | Permitted Site 7 | Tree(s) :: 17 | 55 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9885 | 6013898.26264123 | 2095494.80066031 | 37.7346113861595 | -122.394351387742 | (37.7346113861595, -122.394351387742) | 10 | 3 | 8 | 58 | 1 | |||
| 29331 | 54148 | Permitted Site 7 | Tree(s) :: 17 | 22 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9883 | 6014069.39743863 | 2095324.65039401 | 37.7341536999836 | -122.393747806992 | (37.7341536999836, -122.393747806992) | 10 | 3 | 8 | 58 | 1 | |||
| 120068 | 54147 | Permitted Site 7 | Tree(s) :: 17 | 11 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 9882 | 6013981.98431201 | 2095285.15444132 | 37.7340403942352 | -122.394047260019 | (37.7340403942352, -122.394047260019) | 10 | 3 | 8 | 58 | 1 | |||
| 56643 | 54146 | DPW Maintained 1 | Tree(s) :: 17 | 1482 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 0 | Permit Number 9881 | 5984367.42341102 | 2105093.5901914 | 37.7592812470157 | -122.497156203194 | (37.7592812470157, -122.497156203194) | 1 | 8 | 3 | 56 | 35 | ||
| 151922 | 54144 | Permitted Site 7 | Tree(s) :: 17 | 1453 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9879 | 5984308.71127591 | 2105287.8013383 | 37.7598110555117 | -122.497373592535 | (37.7598110555117, -122.497373592535) | 1 | 8 | 3 | 56 | 35 | |||
| 87047 | 54143 | Permitted Site 7 | Tree(s) :: 17 | 1450 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9878 | 5984360.2310056 | 2105302.65582501 | 37.7598548612321 | -122.497196510338 | (37.7598548612321, -122.497196510338) | 1 | 8 | 3 | 56 | 35 | |||
| 151555 | 54140 | Permitted Site 7 | Tree(s) :: 17 | 1418 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | Permit Number 9875 | 5984353.03860019 | 2105511.72145863 | 37.7604284753779 | -122.497236818104 | (37.7604284753779, -122.497236818104) | 1 | 8 | 3 | 56 | 35 | |||
| 6738 | 54133 | Permitted Site 7 | Tree(s) :: 17 | 510 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9866 | |||||||||||||
| 47758 | 54131 | Permitted Site 7 | Tree(s) :: 17 | 455 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9864 | 6012222.53268581 | 2086618.87780535 | 37.7101466136314 | -122.399522034148 | (37.7101466136314, -122.399522034148) | 10 | 3 | 8 | 309 | 1 | |||
| 63100 | 54130 | Permitted Site 7 | Tree(s) :: 17 | 443 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9863 | 6012234.5851677 | 2086656.32804744 | 37.7102501163872 | -122.399483005618 | (37.7102501163872, -122.399483005618) | 10 | 3 | 8 | 309 | 1 | |||
| 59323 | 54129 | Permitted Site 7 | Tree(s) :: 17 | 442 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9862 | 6012185.08542475 | 2086672.25837852 | 37.7102910987425 | -122.399655205679 | (37.7102910987425, -122.399655205679) | 10 | 3 | 8 | 309 | 1 | |||
| 38934 | 54128 | Permitted Site 7 | Tree(s) :: 17 | 430 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9861 | 6012197.13790852 | 2086709.70862645 | 37.7103946015562 | -122.399616177252 | (37.7103946015562, -122.399616177252) | 10 | 3 | 8 | 309 | 1 | |||
| 80076 | 54127 | Permitted Site 7 | Tree(s) :: 17 | 422 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9860 | 6012205.17289769 | 2086734.6754584 | 37.7104636034239 | -122.399590158241 | (37.7104636034239, -122.399590158241) | 10 | 3 | 8 | 309 | 1 | |||
| 47598 | 54125 | Permitted Site 7 | Tree(s) :: 17 | 401 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9858 | 6012276.76886181 | 2086787.40391812 | 37.7106123759819 | -122.399346404882 | (37.7106123759819, -122.399346404882) | 10 | 3 | 8 | 309 | 1 | |||
| 109987 | 54124 | Permitted Site 7 | Tree(s) :: 17 | 400 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9857 | 6012227.26911887 | 2086803.33424919 | 37.7106533585345 | -122.399518605707 | (37.7106533585345, -122.399518605707) | 10 | 3 | 8 | 309 | 1 | |||
| 46470 | 54123 | Permitted Site 7 | Tree(s) :: 17 | 782 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9856 | 5994226.42547983 | 2089957.55328167 | 37.7182943022185 | -122.461961651964 | (37.7182943022185, -122.461961651964) | 9 | 8 | 6 | 28861 | 24 | |||
| 166735 | 54122 | Permitted Site 7 | Tree(s) :: 17 | 779 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9855 | 5994262.8832332 | 2089905.33517377 | 37.7181530226485 | -122.461831849553 | (37.7181530226485, -122.461831849553) | 9 | 8 | 6 | 28861 | 24 | |||
| 115225 | 54121 | Permitted Site 7 | Tree(s) :: 17 | 778 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9854 | 5994263.19300082 | 2089957.33425111 | 37.718295817519 | -122.461834547231 | (37.718295817519, -122.461834547231) | 9 | 8 | 6 | 28861 | 24 | |||
| 135700 | 54119 | Permitted Site 7 | Tree(s) :: 17 | 774 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | Permit Number 9852 | 5994299.96051129 | 2089957.1152206 | 37.7182973326819 | -122.461707442528 | (37.7182973326819, -122.461707442528) | 9 | 8 | 6 | 28861 | 24 | |||
| 61925 | 54116 | Permitted Site 7 | Tree(s) :: 17 | 61 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9847 | 6007767.97908873 | 2088076.43250813 | 37.7138994532662 | -122.415021002579 | (37.7138994532662, -122.415021002579) | 9 | 7 | 8 | 309 | 39 | |||
| 72711 | 54115 | Permitted Site 7 | Tree(s) :: 17 | 60 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9846 | 6007720.36530114 | 2088097.56556644 | 37.7139548044762 | -122.415187069127 | (37.7139548044762, -122.415187069127) | 9 | 7 | 8 | 309 | 39 | |||
| 102560 | 54114 | Permitted Site 7 | Tree(s) :: 17 | 48 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9845 | 6007737.23208963 | 2088142.654178 | 37.714079556281 | -122.415131960632 | (37.714079556281, -122.415131960632) | 9 | 7 | 8 | 309 | 39 | |||
| 25831 | 54112 | Permitted Site 7 | Tree(s) :: 17 | 42 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9843 | 6007745.66548388 | 2088165.19848378 | 37.7141419321728 | -122.415104406315 | (37.7141419321728, -122.415104406315) | 9 | 7 | 8 | 309 | 39 | |||
| 38440 | 54111 | Permitted Site 7 | Tree(s) :: 17 | 30 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9842 | 6007762.53227495 | 2088210.28710223 | 37.7142666839542 | -122.415049297534 | (37.7142666839542, -122.415049297534) | 9 | 7 | 8 | 309 | 39 | |||
| 27455 | 54109 | Permitted Site 7 | Tree(s) :: 17 | 15 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9840 | 6007831.3156026 | 2088245.74485069 | 37.7143679086038 | -122.414814062701 | (37.7143679086038, -122.414814062701) | 9 | 7 | 8 | 309 | 39 | |||
| 76689 | 54106 | Permitted Site 7 | Tree(s) :: 17 | 4462 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9836 | 5999574.81504574 | 2105761.15850969 | 37.7619937056873 | -122.444609836838 | (37.7619937056873, -122.444609836838) | 15 | 5 | 5 | 28862 | 3 | |||
| 25735 | 54104 | Permitted Site 7 | Tree(s) :: 17 | 1404 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 9834 | 6009358.56357861 | 2118075.54758209 | 37.7963595290197 | -122.411641645457 | (37.7963595290197, -122.411641645457) | 3 | 1 | 10 | 308 | 4 | |||
| 134362 | 54102 | Permitted Site 7 | Tree(s) :: 17 | 525 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | Permit Number 9830 | 6001563.14471568 | 2102766.75797554 | 37.7538850657245 | -122.437518548541 | (37.7538850657245, -122.437518548541) | 2 | 4 | 5 | 28862 | 22 | |||
| 47099 | 54101 | Permitted Site 7 | Tree(s) :: 17 | 210 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9828 | 5999981.7653992 | 2104880.32983358 | 37.7595983809069 | -122.443139095175 | (37.7595983809069, -122.443139095175) | 2 | 4 | 5 | 28862 | 3 | |||
| 182064 | 54099 | Permitted Site 7 | Tree(s) :: 17 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9826 | 6000410.71538796 | 2104865.91876802 | 37.7595832607186 | -122.441654541951 | (37.7595832607186, -122.441654541951) | 2 | 4 | 5 | 28862 | 3 | |||
| 161001 | 54098 | Permitted Site 7 | Tree(s) :: 17 | 127 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9825 | 6000431.85993184 | 2104867.13916804 | 37.7595878163392 | -122.441581501362 | (37.7595878163392, -122.441581501362) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );