trees
194,517 rows 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 27746 | 54159 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.83842 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | 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 | |||
| 131166 | 54149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | 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 | |||
| 86872 | 54138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.7949665825052 | -122.437710167809 | (37.7949665825052, -122.437710167809) | 13 | 9 | 1 | 57 | 27 | ||
| 131226 | 54136 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | 13 | 9 | 1 | 57 | 27 | ||
| 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 | |||||||||||||
| 187399 | 54132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 461 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 24 | Permit Number 9865 | 6012176.49549 | 2086499.28373 | 37.7098156657361 | -122.3996727573 | (37.7098156657361, -122.3996727573) | 10 | 3 | 8 | 309 | 1 | ||
| 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 | |||
| 67808 | 54126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.19326 | 37.7103848043898 | -122.399454574563 | (37.7103848043898, -122.399454574563) | 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 | |||
| 185367 | 54120 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 775 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/2000 12:00:00 AM | Permit Number 9853 | 5994299.65074367 | 2089905.11614326 | 37.7181545378086 | -122.461704745095 | (37.7181545378086, -122.461704745095) | 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 | |||
| 121496 | 53398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) | 5 | 1 | 10 | 28858 | 21 | ||
| 54460 | 54103 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.7925711821936 | -122.433204275613 | (37.7925711821936, -122.433204275613) | 13 | 9 | 1 | 29490 | 27 | ||
| 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 | |||
| 105415 | 54097 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.7595947080418 | -122.441471294748 | (37.7595947080418, -122.441471294748) | 2 | 4 | 5 | 28862 | 3 | ||
| 66828 | 54096 | Permitted Site 7 | Tree(s) :: 17 | 117 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9823 | 6000482.70518522 | 2104870.11449829 | 37.7595988825678 | -122.441405867103 | (37.7595988825678, -122.441405867103) | 2 | 4 | 5 | 28862 | 3 | |||
| 25467 | 54095 | Permitted Site 7 | Tree(s) :: 17 | 111 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9822 | 6000511.11725358 | 2104871.80553599 | 37.7596051442907 | -122.441307725593 | (37.7596051442907, -122.441307725593) | 2 | 4 | 5 | 28862 | 3 | |||
| 185945 | 54094 | Permitted Site 7 | Tree(s) :: 17 | 140 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9821 | 5991851.44721454 | 2095243.83587633 | 37.7326721081232 | -122.470555676048 | (37.7326721081232, -122.470555676048) | 9 | 8 | 4 | 59 | 40 | |||
| 131184 | 54091 | Permitted Site 7 | Tree(s) :: 17 | 120 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9818 | 5991857.39291324 | 2095334.42590853 | 37.7329211894262 | -122.470541716027 | (37.7329211894262, -122.470541716027) | 9 | 8 | 4 | 59 | 40 | |||
| 1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9817 | 5991911.06498332 | 2095358.19732765 | 37.7329895631391 | -122.47035789011 | (37.7329895631391, -122.47035789011) | 9 | 8 | 4 | 59 | 40 | |||
| 148563 | 54089 | Permitted Site 7 | Tree(s) :: 17 | 2045 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9815 | 5992026.97147266 | 2095387.75792656 | 37.733077429943 | -122.469959326356 | (37.733077429943, -122.469959326356) | 9 | 8 | 4 | 59 | 40 | |||
| 117042 | 54088 | Permitted Site 7 | Tree(s) :: 17 | 229 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9814 | 6003645.03280335 | 2101545.85493043 | 37.7506508977166 | -122.430231799677 | (37.7506508977166, -122.430231799677) | 2 | 4 | 5 | 28862 | 22 | |||
| 109753 | 54086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.7916772707399 | -122.433147915142 | (37.7916772707399, -122.433147915142) | 13 | 9 | 1 | 29490 | 27 | ||
| 84820 | 98591 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2375 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 9808 | 6002830 | 2116793 | 37.7924696026791 | -122.434140096981 | (37.7924696026791, -122.434140096981) | 13 | 9 | 1 | 29490 | 27 | |||
| 143320 | 54085 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2379 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 18 | 3x3 | Permit Number 9808 | 6002844.62631 | 2116794.52843 | 37.7924746294584 | -122.434089598877 | (37.7924746294584, -122.434089598877) | 13 | 9 | 1 | 29490 | 27 | |
| 189209 | 54083 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2357 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 16 | 3x3 | Permit Number 9806 | 6002926.33793 | 2116799.1944 | 37.7924920780853 | -122.433807208158 | (37.7924920780853, -122.433807208158) | 13 | 9 | 1 | 29490 | 27 | |
| 40410 | 54082 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2345 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 17 | 3x3 | Permit Number 9805 | 6002974.20381 | 2116807.56972 | 37.7925177906011 | -122.433642189743 | (37.7925177906011, -122.433642189743) | 13 | 9 | 1 | 29490 | 27 | |
| 140618 | 54081 | Permitted Site 7 | Tree(s) :: 17 | 230 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9804 | 6003629.85128226 | 2101597.09604643 | 37.7507907339032 | -122.430287953983 | (37.7507907339032, -122.430287953983) | 2 | 4 | 5 | 28862 | 22 | |||
| 144200 | 54079 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2200 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 23 | Permit Number 9802 | 6001303.48961 | 2119734.44129 | 37.8004592737376 | -122.439632823002 | (37.8004592737376, -122.439632823002) | 13 | 9 | 1 | 57 | 17 | ||
| 172012 | 54078 | Permitted Site 7 | Tree(s) :: 17 | 1549 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | Permit Number 9801 | 5998741.99793712 | 2089243.04009374 | 37.7165913487597 | -122.446301913894 | (37.7165913487597, -122.446301913894) | 9 | 7 | 6 | 28861 | 25 | |||
| 103074 | 54077 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1416 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1972 12:00:00 AM | 12 | Permit Number 9800 | 5982488.8605 | 2105444.4291 | 37.7601342805878 | -122.503679056793 | (37.7601342805878, -122.503679056793) | 1 | 8 | 3 | 56 | 35 | ||
| 33595 | 54076 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1684 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 12 | Permit Number 9799 | 5981309.7555 | 2103628.6509 | 37.7550792755366 | -122.507622210407 | (37.7550792755366, -122.507622210407) | 1 | 8 | 3 | 56 | 35 | ||
| 96763 | 54075 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1682 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 4 | Permit Number 9798 | 5981308.9916 | 2103651.7218 | 37.7551425766668 | -122.507626563979 | (37.7551425766668, -122.507626563979) | 1 | 8 | 3 | 56 | 35 | ||
| 93525 | 54074 | Permitted Site 7 | Tree(s) :: 17 | 1671 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9797 | 5981259.23298317 | 2103705.89858469 | 37.7552883992367 | -122.507802660949 | (37.7552883992367, -122.507802660949) | 1 | 8 | 3 | 56 | 35 | |||
| 59039 | 54073 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1668 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 11 | Permit Number 9796 | 5981306.2414 | 2103720.476 | 37.7553311941305 | -122.507641176321 | (37.7553311941305, -122.507641176321) | 1 | 8 | 3 | 56 | 35 | ||
| 173361 | 54071 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1650 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 17 | Permit Number 9794 | 5981301.6578 | 2103844.8448 | 37.7556724054432 | -122.50766625573 | (37.7556724054432, -122.50766625573) | 1 | 8 | 3 | 56 | 35 | ||
| 115776 | 54070 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.507808305508 | (37.7556473215408, -122.507808305508) | 1 | 8 | 3 | 56 | 35 | ||
| 191480 | 54069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1645 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 8 | Permit Number 9792 | 5981258.5718 | 2103857.679 | 37.7557051061066 | -122.507816210489 | (37.7557051061066, -122.507816210489) | 1 | 8 | 3 | 56 | 35 | ||
| 97119 | 54068 | Permitted Site 7 | Tree(s) :: 17 | 1643 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9791 | 5981252.96111373 | 2103888.20574043 | 37.7557885932785 | -122.507837878985 | (37.7557885932785, -122.507837878985) | 1 | 8 | 3 | 56 | 35 | |||
| 159291 | 54067 | Permitted Site 7 | Tree(s) :: 17 | 1637 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9790 | 5981251.61714201 | 2103927.27155082 | 37.7558957776852 | -122.507845425767 | (37.7558957776852, -122.507845425767) | 1 | 8 | 3 | 56 | 35 | |||
| 144266 | 54066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1636 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 10 | Permit Number 9789 | 5981299.5188 | 2103912.0712 | 37.7558568639886 | -122.507678641222 | (37.7558568639886, -122.507678641222) | 1 | 8 | 3 | 56 | 35 | ||
| 65348 | 54065 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1632 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9788 | 5981297.9909 | 2103950.8792 | 37.7559633296946 | -122.507686804724 | (37.7559633296946, -122.507686804724) | 1 | 8 | 3 | 56 | 35 | ||
| 23609 | 54064 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1619-1621 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9787 | 5981254.141 | 2104003.8963 | 37.7561063161195 | -122.50784238373 | (37.7561063161195, -122.50784238373) | 1 | 8 | 3 | 56 | 35 | ||
| 34483 | 54062 | Permitted Site 7 | Tree(s) :: 17 | 334 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9785 | 5988746.98730455 | 2113069.95091128 | 37.7814378207275 | -122.482594221964 | (37.7814378207275, -122.482594221964) | 11 | 6 | 2 | 55 | 26 | |||
| 152024 | 54057 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 874 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | 8 | Permit Number 9779 | 5985134.071 | 2109910.10647 | 37.7725509445557 | -122.494859930916 | (37.7725509445557, -122.494859930916) | 11 | 6 | 2 | 55 | 26 | ||
| 173776 | 54056 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 839 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | 12 | Permit Number 9778 | 5985079.18018 | 2110144.91058 | 37.7731924364746 | -122.495067118327 | (37.7731924364746, -122.495067118327) | 11 | 6 | 2 | 55 | 26 | ||
| 48580 | 54054 | Permitted Site 7 | Tree(s) :: 17 | 3920 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9776 | 6003673.71636522 | 2101895.43443972 | 37.7516123856509 | -122.4301575457 | (37.7516123856509, -122.4301575457) | 2 | 4 | 5 | 28862 | 22 | |||
| 90050 | 54053 | Permitted Site 7 | Tree(s) :: 17 | 866 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9775 | 6003077.10918179 | 2103173.87360147 | 37.7550888677615 | -122.432311984146 | (37.7550888677615, -122.432311984146) | 2 | 4 | 5 | 28862 | 22 | |||
| 81286 | 54052 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 284 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 9774 | 6009944.92418425 | 2114405.86793531 | 37.7863163497004 | -122.409353602077 | (37.7863163497004, -122.409353602077) | 5 | 10 | 10 | 28852 | 36 | |
| 79408 | 54051 | Permitted Site 7 | Tree(s) :: 17 | 439 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | Permit Number 9773 | 6010735.95376867 | 2120301.35601681 | 37.8025482234186 | -122.407032527097 | (37.8025482234186, -122.407032527097) | 3 | 1 | 10 | 308 | 23 | |||
| 115120 | 54050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 7 | Permit Number 9772 | 6000883.53161 | 2116117.87685 | 37.7905052265944 | -122.440826467079 | (37.7905052265944, -122.440826467079) | 13 | 6 | 1 | 29490 | 27 | ||
| 43536 | 54049 | Permitted Site 7 | Tree(s) :: 17 | 606 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9771 | 6001837.75949921 | 2102323.68819229 | 37.7526841114374 | -122.43653715738 | (37.7526841114374, -122.43653715738) | 2 | 4 | 5 | 28862 | 22 | |||
| 127532 | 54048 | Permitted Site 7 | Tree(s) :: 17 | 4186 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1972 12:00:00 AM | Permit Number 9770 | 6002689.85524021 | 2100375.46527315 | 37.7473831353694 | -122.433451251005 | (37.7473831353694, -122.433451251005) | 2 | 4 | 5 | 63 | 22 | |||
| 142308 | 54047 | Permitted Site 7 | Tree(s) :: 17 | 149 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | Permit Number 9769 | 6001443.27762787 | 2107418.20108086 | 37.7666499791028 | -122.438266279926 | (37.7666499791028, -122.438266279926) | 15 | 5 | 5 | 28862 | 3 | |||
| 39706 | 54045 | Permitted Site 7 | Tree(s) :: 17 | 249 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | Permit Number 9767 | 6003973.30133773 | 2097690.21555937 | 37.7400827913309 | -122.42882178061 | (37.7400827913309, -122.42882178061) | 2 | 7 | 5 | 63 | 7 | |||
| 66715 | 54044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1802 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 10 | Permit Number 9766 | 6004429.1474 | 2115067.6282 | 37.7878227969866 | -122.428483962143 | (37.7878227969866, -122.428483962143) | 13 | 9 | 11 | 28858 | 27 | ||
| 148232 | 54042 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2500 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 14 | Permit Number 9764 | 6001049.73361 | 2117960.3763 | 37.7955737130117 | -122.440383615719 | (37.7955737130117, -122.440383615719) | 13 | 9 | 1 | 57 | 17 | ||
| 172710 | 54041 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2855 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 14 | Permit Number 9763 | 6001036.63383 | 2118177.80488 | 37.7961699689158 | -122.440444544776 | (37.7961699689158, -122.440444544776) | 13 | 9 | 1 | 57 | 17 | ||
| 71333 | 54040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2815 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 13 | Permit Number 9762 | 6001043.48682 | 2118118.78953 | 37.7960083184722 | -122.440416597468 | (37.7960083184722, -122.440416597468) | 13 | 9 | 1 | 57 | 17 | ||
| 119562 | 54039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2813 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 11 | Permit Number 9761 | 6001046.84176 | 2118093.62628 | 37.7959394178222 | -122.440403183184 | (37.7959394178222, -122.440403183184) | 13 | 9 | 1 | 57 | 17 | ||
| 28818 | 54037 | Permitted Site 7 | Tree(s) :: 17 | 957 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | Permit Number 9759 | 6004410.3613312 | 2103324.76407224 | 37.755578684868 | -122.427711961591 | (37.755578684868, -122.427711961591) | 2 | 4 | 5 | 28862 | 22 | |||
| 37378 | 54036 | Permitted Site 7 | Tree(s) :: 17 | 951 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | Permit Number 9758 | 6004408.42863104 | 2103358.76023259 | 37.7556719210005 | -122.427721067579 | (37.7556719210005, -122.427721067579) | 2 | 4 | 5 | 28862 | 22 | |||
| 84746 | 54035 | Permitted Site 7 | Tree(s) :: 17 | 947 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | Permit Number 9757 | 6004406.78180474 | 2103387.71419535 | 37.7557513286139 | -122.427728825706 | (37.7557513286139, -122.427728825706) | 2 | 4 | 5 | 28862 | 22 | |||
| 85036 | 54034 | Permitted Site 7 | Tree(s) :: 17 | 943 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | Permit Number 9756 | 6004405.4756405 | 2103410.67410596 | 37.7558142972394 | -122.427734978669 | (37.7558142972394, -122.427734978669) | 2 | 4 | 5 | 28862 | 22 |
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) );