Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162153 | 162153 | 201632 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6021871.21572 | 2093119.8757200001 | 37.728530265257504 | -122.366622037185 | (37.7285302652575, -122.366622037185) | |||
25954 | 25954 | 201635 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6021853.58241 | 2093133.73067 | 37.7285673424948 | -122.36668395282301 | (37.7285673424948, -122.366683952823) | |||
61764 | 61764 | 201633 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6021837.4277 | 2093144.7538400001 | 37.7285967251547 | -122.36674056154699 | (37.7285967251547, -122.366740561547) | |||
186137 | 186137 | 201634 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6021819.77945 | 2093157.84467 | 37.728631703379996 | -122.366802476247 | (37.72863170338, -122.366802476247) | |||
152013 | 152013 | 201631 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6021802.56362 | 2093169.8437599998 | 37.728663707547 | -122.366862820783 | (37.728663707547, -122.366862820783) | |||
147489 | 147489 | 201630 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 451 Galvez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6021771.18031 | 2093196.4626099998 | 37.72873507866179 | -122.36697315229799 | (37.7287350786618, -122.366973152298) | |||
50863 | 50863 | 201629 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 13 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6021522.6239599995 | 2093379.49172 | 37.7292240220626 | -122.36784506930599 | (37.7292240220626, -122.367845069306) | |||
33230 | 33230 | 201628 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 12 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6021496.8135400005 | 2093398.7623299998 | 37.729275520830996 | -122.36793562924 | (37.729275520831, -122.36793562924) | |||
60882 | 60882 | 201626 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6021390.17472 | 2093479.1465200002 | 37.729490394945294 | -122.36830984254298 | (37.7294903949453, -122.368309842543) | |||
61834 | 61834 | 201616 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Innes Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021349.55513 | 2092801.0747099998 | 37.7276263098888 | -122.36840346285801 | (37.7276263098888, -122.368403462858) | |||
147636 | 147636 | 201625 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6021338.5629 | 2093518.11855 | 37.729594575111 | -122.368490962388 | (37.729594575111, -122.368490962388) | |||
67615 | 67615 | 201618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6021223.045080001 | 2093587.4702 | 37.7297786672424 | -122.36889511322701 | (37.7297786672424, -122.368895113227) | |||
162543 | 162543 | 201617 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6021188.31873 | 2093585.6418599999 | 37.729771742469794 | -122.369015041404 | (37.7297717424698, -122.369015041404) | |||
31009 | 31009 | 201796 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021152.60745 | 2092710.04539 | 37.727365560462395 | -122.369078036218 | (37.7273655604624, -122.369078036218) | |||
164353 | 164353 | 201797 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021117.279709999 | 2092731.0926599998 | 37.7274214146518 | -122.369201619254 | (37.7274214146518, -122.369201619254) | |||
2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
70745 | 70745 | 201798 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021088.33309 | 2092752.01283 | 37.7274772697451 | -122.36930313385099 | (37.7274772697451, -122.369303133851) | |||
2381 | 2381 | 201818 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.4173400002 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | ||
2417 | 2417 | 201819 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.7706900002 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | ||
33142 | 33142 | 201605 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 570 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021066.69823 | 2093118.6837900002 | 37.7284828925695 | -122.369403250859 | (37.7284828925695, -122.369403250859) | |||
178920 | 178920 | 201812 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.728774126326705 | -122.369414113788 | (37.7287741263267, -122.369414113788) | |||
2408 | 2408 | 201820 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.728922786051506 | -122.369449472416 | (37.7289227860515, -122.369449472416) | ||
133056 | 133056 | 201799 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021051.90692 | 2092781.9816400001 | 37.727557560315795 | -122.36943113075 | (37.7275575603158, -122.36943113075) | |||
64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
2383 | 2383 | 201821 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021045.51426 | 2093266.4470799998 | 37.7288874606638 | -122.369486691782 | (37.7288874606638, -122.369486691782) | ||
71242 | 71242 | 201604 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | |||
59854 | 59854 | 201603 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 565 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6021043.02716 | 2093075.23068 | 37.7283622799705 | -122.369482082752 | (37.7283622799705, -122.369482082752) | |||
65062 | 65062 | 201810 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021035.70856 | 2093179.8039900002 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | |||
2387 | 2387 | 201822 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021035.49669 | 2093250.0299200001 | 37.72884183267921 | -122.36952018972299 | (37.7288418326792, -122.369520189723) | ||
2438 | 2438 | 201823 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 7 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.728794732485206 | -122.369559269737 | (37.7287947324852, -122.369559269737) | ||
182476 | 182476 | 201800 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021019.258830001 | 2092809.3324400003 | 37.7276308694498 | -122.36954588606001 | (37.7276308694498, -122.36954588606) | |||
2409 | 2409 | 201824 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 8 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.603680001 | 2093212.5880900002 | 37.728737329640495 | -122.369624404053 | (37.7287373296405, -122.369624404053) | ||
51493 | 51493 | 201801 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020978.953509999 | 2092836.83628 | 37.7277041785835 | -122.369687123669 | (37.7277041785835, -122.369687123669) | |||
2402 | 2402 | 201606 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.4635700001 | 37.7287012794353 | -122.36979738594101 | (37.7287012794353, -122.369797385941) | ||
163371 | 163371 | 201802 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020947.47999 | 2092859.07822 | 37.7277635239432 | -122.369797465976 | (37.7277635239432, -122.369797465976) | |||
157074 | 157074 | 201809 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 237 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020945.51773 | 2093059.3003900002 | 37.72831318869729 | -122.369818081152 | (37.7283131886973, -122.369818081152) | |||
2465 | 2465 | 201607 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020934.32673 | 2093214.8340900003 | 37.7287396409072 | -122.36986751418699 | (37.7287396409072, -122.369867514187) | ||
50519 | 50519 | 201808 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 247 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | |||
181683 | 181683 | 201803 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020924.86388 | 2092877.32885 | 37.7278123958223 | -122.36987691208401 | (37.7278123958223, -122.369876912084) | |||
176019 | 176019 | 201608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6020912.48689 | 2093230.64881 | 37.7287818667771 | -122.369944109446 | (37.7287818667771, -122.369944109446) | |||
52097 | 52097 | 201804 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020904.74927 | 2092892.98725 | 37.7278542871344 | -122.369947531359 | (37.7278542871344, -122.369947531359) | |||
179043 | 179043 | 201807 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 273 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6020893.117219999 | 2092989.08595 | 37.728117517799795 | -122.36999438334298 | (37.7281175177998, -122.369994383343) | |||
51993 | 51993 | 201805 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 10 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020879.60636 | 2092912.55986 | 37.727906650163 | -122.37003580431801 | (37.727906650163, -122.370035804318) | |||
55370 | 55370 | 201806 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020862.09511 | 2092930.7088400002 | 37.727955522906605 | -122.37009759584998 | (37.7279555229066, -122.37009759585) | |||
132813 | 132813 | 201611 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 9ft | 6020793.34161 | 2092957.5019 | 37.7280253184122 | -122.37033713297501 | (37.7280253184122, -122.370337132975) | |||
184420 | 184420 | 201549 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6020789.549380001 | 2093251.9329799998 | 37.728833562500206 | -122.370370588629 | (37.7288335625002, -122.370370588629) | |||
177224 | 177224 | 201612 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 3ft | 6020781.6072 | 2092974.15888 | 37.7280704113081 | -122.370378850726 | (37.7280704113081, -122.370378850726) | |||
184178 | 184178 | 201613 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6020763.58395 | 2092982.86481 | 37.728093326933205 | -122.370441760089 | (37.7280933269332, -122.370441760089) | |||
185405 | 185405 | 201614 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 4ft | 6020747.34365 | 2092993.8196 | 37.728122515333396 | -122.370498661104 | (37.7281225153334, -122.370498661104) | |||
69445 | 69445 | 201615 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6020732.10647 | 2093000.2197599998 | 37.728139252612 | -122.370551779534 | (37.728139252612, -122.370551779534) | |||
28938 | 28938 | 201582 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020666.22255 | 2092954.7050599998 | 37.7280106612574 | -122.370776399631 | (37.7280106612574, -122.370776399631) | |||
157712 | 157712 | 201581 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020642.22702 | 2092924.8193 | 37.7279272833017 | -122.370857288241 | (37.7279272833017, -122.370857288241) | |||
156960 | 156960 | 201545 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6020633.70615 | 2093371.77747 | 37.729154078192394 | -122.37091763995701 | (37.7291540781924, -122.370917639957) | ||||
179913 | 179913 | 201580 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020628.78345 | 2092907.8245700002 | 37.7278798809349 | -122.370902588897 | (37.7278798809349, -122.370902588897) | |||
65523 | 65523 | 201544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 601 Innes Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6020625.625519999 | 2093377.92947 | 37.7291705267859 | -122.370946000964 | (37.7291705267859, -122.370946000964) | ||||
188792 | 188792 | 201569 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 600 Donahue St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6020624.73776 | 2092976.30056 | 37.728067680971606 | -122.370921308297 | (37.7280676809716, -122.370921308297) | |||
76765 | 76765 | 201543 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6020620.74495 | 2093375.17595 | 37.72916269819 | -122.370962683378 | (37.72916269819, -122.370962683378) | ||||
69081 | 69081 | 201579 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020614.668740001 | 2092891.85925 | 37.7278352682694 | -122.370950280826 | (37.7278352682694, -122.370950280826) | |||
164394 | 164394 | 201578 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020600.888259999 | 2092872.2369900001 | 37.727780632667105 | -122.370996564459 | (37.7277806326671, -122.370996564459) | |||
188512 | 188512 | 201577 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020588.137 | 2092854.48102 | 37.727731178034894 | -122.37103941895799 | (37.7277311780349, -122.371039418958) | |||
61517 | 61517 | 201542 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6020585.50312 | 2093400.1960900002 | 37.7292294638519 | -122.37108624845699 | (37.7292294638519, -122.371086248457) | ||||
71593 | 71593 | 201576 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020573.723230001 | 2092835.80455 | 37.7276791045865 | -122.37108795716101 | (37.7276791045865, -122.371087957161) | |||
60468 | 60468 | 201541 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 601 Innes Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6020571.225269999 | 2093411.7582900003 | 37.7292604275206 | -122.371136408139 | (37.7292604275206, -122.371136408139) | ||||
40324 | 40324 | 201540 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6020451.57641 | 2093498.37325 | 37.729491685489 | -122.37155603899201 | (37.729491685489, -122.371556038992) | ||||
47028 | 47028 | 201539 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6020431.263809999 | 2093508.99897 | 37.7295197461253 | -122.37162699728201 | (37.7295197461253, -122.371626997282) | ||||
130534 | 130534 | 201524 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 740 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020392.93719 | 2093745.64338 | 37.730167421677606 | -122.371775862971 | (37.7301674216776, -122.371775862971) | ||||
24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
73961 | 73961 | 201525 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 740 Earl St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6020363.02265 | 2093708.60357 | 37.730064074283106 | -122.371876721056 | (37.7300640742831, -122.371876721056) | ||||
165139 | 165139 | 201526 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 740 Earl St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6020358.69967 | 2093703.87805 | 37.7300508614476 | -122.371891339508 | (37.7300508614476, -122.371891339508) | ||||
45365 | 45365 | 201527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 740 Earl St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.730052512603294 | -122.371951898056 | (37.7300525126033, -122.371951898056) | |||
156492 | 156492 | 201538 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6020320.60238 | 2093595.7564 | 37.7297518872405 | -122.37201557005899 | (37.7297518872405, -122.372015570059) | ||||
178375 | 178375 | 201528 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6020307.12095 | 2093692.07813 | 37.7300156278056 | -122.372068839601 | (37.7300156278056, -122.372068839601) | |||
47751 | 47751 | 201529 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020227.99181 | 2093752.40727 | 37.7301769329099 | -122.372346575457 | (37.7301769329099, -122.372346575457) | |||
47385 | 47385 | 201537 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020208.273080001 | 2093682.62725 | 37.729984246855295 | -122.372409919208 | (37.7299842468553, -122.372409919208) | ||||
76336 | 76336 | 201530 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 724 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6020205.16729 | 2093768.9038799999 | 37.7302209753954 | -122.37242662498899 | (37.7302209753954, -122.372426624989) | |||
65008 | 65008 | 201531 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 724 Innes Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020190.2852300005 | 2093779.8282400002 | 37.7302501539023 | -122.37247883063101 | (37.7302501539023, -122.372478830631) | |||
58893 | 58893 | 201536 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020184.941240001 | 2093703.94604 | 37.730041502210895 | -122.372492056066 | (37.7300415022109, -122.372492056066) | ||||
172235 | 172235 | 201654 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 744 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6020169.84192 | 2093795.1774099998 | 37.73029117649 | -122.372550568669 | (37.73029117649, -122.372550568669) | |||
163809 | 163809 | 201655 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 734 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6020157.476530001 | 2093804.76916 | 37.7303168341394 | -122.372593981633 | (37.7303168341394, -122.372593981633) | |||
184047 | 184047 | 201550 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020135.10106 | 2093474.49697 | 37.7294087400981 | -122.372648486831 | (37.7294087400981, -122.372648486831) | ||||
86028 | 86028 | 201535 | Undocumented 2 | Juglans californica :: Walnut: Black (s.calif) 407 | 601 Innes Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020117.52711 | 2093745.9964 | 37.730153260063794 | -122.372728027393 | (37.7301532600638, -122.372728027393) | ||||
57763 | 57763 | 201551 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020116.66531 | 2093486.6381700002 | 37.7294410644355 | -122.37271306177901 | (37.7294410644355, -122.372713061779) | ||||
66551 | 66551 | 201656 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020105.93205 | 2093842.3371599999 | 37.7304171562079 | -122.37277477954099 | (37.7304171562079, -122.372774779541) | |||
59918 | 59918 | 201657 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020084.79381 | 2093857.53228 | 37.7304577174311 | -122.372848909746 | (37.7304577174311, -122.372848909746) | |||
52457 | 52457 | 201534 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020030.3592 | 2093817.11357 | 37.7303437436519 | -122.373034303211 | (37.7303437436519, -122.373034303211) | ||||
177662 | 177662 | 201533 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6020026.382119999 | 2093819.59918 | 37.7303503500706 | -122.37304822470301 | (37.7303503500706, -122.373048224703) | ||||
150232 | 150232 | 201532 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6020021.83334 | 2093823.70013 | 37.7303613604801 | -122.373064234453 | (37.7303613604801, -122.373064234453) | ||||
55574 | 55574 | 194005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.728793337639296 | -122.373229233067 | (37.7287933376393, -122.373229233067) | |||
45320 | 45320 | 201553 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6019956.36355 | 2093604.98051 | 37.72975719952 | -122.373275437534 | (37.72975719952, -122.373275437534) | ||||
157235 | 157235 | 194006 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6019953.97455 | 2093259.9764900003 | 37.7288097529433 | -122.37325981899099 | (37.7288097529433, -122.373259818991) | |||
47244 | 47244 | 201554 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 6019933.4891099995 | 2093619.80077 | 37.729796635696296 | -122.373355543719 | (37.7297966356963, -122.373355543719) | ||||
72337 | 72337 | 201555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6019901.03231 | 2093652.00045 | 37.7298832655955 | -122.373469980666 | (37.7298832655955, -122.373469980666) | ||||
173224 | 173224 | 201556 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6019865.267469999 | 2093672.4938299998 | 37.729937570248 | -122.37359504397101 | (37.729937570248, -122.373595043971) | ||||
56492 | 56492 | 112098 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6019849.108630001 | 2093255.57368 | 37.7287918987073 | -122.373622047041 | (37.7287918987073, -122.373622047041) | |||
146878 | 146878 | 201557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 9ft | 6019843.77362 | 2093685.4029299999 | 37.7299718344327 | -122.373670245296 | (37.7299718344327, -122.373670245296) | |||
56527 | 56527 | 201482 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019833.06925 | 2094138.86397 | 37.731216363049704 | -122.373738644125 | (37.7312163630497, -122.373738644125) | |||
150959 | 150959 | 201558 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6019824.624340001 | 2093697.32313 | 37.7300035121512 | -122.37373727266899 | (37.7300035121512, -122.373737272669) | |||
160233 | 160233 | 201483 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6019824.354280001 | 2094127.5426599998 | 37.731184797722705 | -122.37376798991899 | (37.7311847977227, -122.373767989919) | |||
153943 | 153943 | 201484 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019815.12004 | 2094115.72508 | 37.731151841174004 | -122.37379909656 | (37.731151841174, -122.37379909656) | |||
149821 | 149821 | 201485 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019804.87091 | 2094104.0965 | 37.7311193477698 | -122.373833724951 | (37.7311193477698, -122.373833724951) |
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");