trees
194,517 rows sorted by XCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57815 | 65566 | Permitted Site 7 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | 2 | 9 | 62 | 37 | ||||
| 33524 | 65565 | DPW Maintained 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | 2 | 9 | 62 | 37 | ||||
| 76265 | 201632 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6021871.21572 | 2093119.87572 | 37.7285302652575 | -122.366622037185 | (37.7285302652575, -122.366622037185) | 10 | 3 | 8 | 58 | 1 | |||
| 134311 | 201635 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6021853.58241 | 2093133.73067 | 37.7285673424948 | -122.366683952823 | (37.7285673424948, -122.366683952823) | 10 | 3 | 8 | 58 | 1 | |||
| 35317 | 201633 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6021837.4277 | 2093144.75384 | 37.7285967251547 | -122.366740561547 | (37.7285967251547, -122.366740561547) | 10 | 3 | 8 | 58 | 1 | |||
| 44597 | 201634 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6021819.77945 | 2093157.84467 | 37.72863170338 | -122.366802476247 | (37.72863170338, -122.366802476247) | 10 | 3 | 8 | 58 | 1 | |||
| 120824 | 201631 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6021802.56362 | 2093169.84376 | 37.728663707547 | -122.366862820783 | (37.728663707547, -122.366862820783) | 10 | 3 | 8 | 58 | 1 | |||
| 133969 | 201630 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451 Galvez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6021771.18031 | 2093196.46261 | 37.7287350786618 | -122.366973152298 | (37.7287350786618, -122.366973152298) | 10 | 3 | 8 | 58 | 1 | |||
| 174692 | 65563 | DPW Maintained 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.369041103471 | (37.8103107984086, -122.369041103471) | 2 | 9 | 62 | 37 | ||||
| 72238 | 65564 | DPW Maintained 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.369882282876 | (37.8103949467147, -122.369882282876) | 2 | 9 | 62 | 37 | ||||
| 182438 | 201629 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 13 | : | Tree | Private 2 | 6 | Width 3ft | 6021522.62396 | 2093379.49172 | 37.7292240220626 | -122.367845069306 | (37.7292240220626, -122.367845069306) | 10 | 3 | 8 | 58 | 1 | |||
| 94375 | 201628 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 12 | : | Tree | Private 2 | 13 | Width 3ft | 6021496.81354 | 2093398.76233 | 37.729275520831 | -122.36793562924 | (37.729275520831, -122.36793562924) | 10 | 3 | 8 | 58 | 1 | |||
| 10099 | 201626 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6021390.17472 | 2093479.14652 | 37.7294903949453 | -122.368309842543 | (37.7294903949453, -122.368309842543) | 10 | 3 | 8 | 58 | 1 | |||
| 157135 | 201616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 0 Innes Ct | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021349.55513 | 2092801.07471 | 37.7276263098888 | -122.368403462858 | (37.7276263098888, -122.368403462858) | 10 | 3 | 8 | 58 | 1 | |||
| 22681 | 253059 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 58908 | 253061 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 77011 | 253060 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 147667 | 253058 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.808 | 37.7284959916793 | -122.368425863032 | (37.7284959916793, -122.368425863032) | 10 | 3 | 8 | 58 | 1 | ||
| 16684 | 201625 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 7 | : | Tree | Private 2 | 11 | Width 3ft | 6021338.5629 | 2093518.11855 | 37.729594575111 | -122.368490962388 | (37.729594575111, -122.368490962388) | 10 | 3 | 8 | 58 | 1 | |||
| 13578 | 253069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 39885 | 253067 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 54074 | 253066 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 98056 | 253068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 90094 | 201618 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6021223.04508 | 2093587.4702 | 37.7297786672424 | -122.368895113227 | (37.7297786672424, -122.368895113227) | 10 | 3 | 8 | 58 | 1 | |||
| 120149 | 253062 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 150993 | 253063 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 173485 | 253064 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947 | 2093217.369 | 37.7287620496982 | -122.36889409743 | (37.7287620496982, -122.36889409743) | 10 | 3 | 8 | 58 | 1 | ||
| 102123 | 201617 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6021188.31873 | 2093585.64186 | 37.7297717424698 | -122.369015041404 | (37.7297717424698, -122.369015041404) | 10 | 3 | 8 | 58 | 1 | |||
| 129483 | 201796 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 1 | : | Tree | Private 2 | 2 | Width 5ft | 6021152.60745 | 2092710.04539 | 37.7273655604624 | -122.369078036218 | (37.7273655604624, -122.369078036218) | 10 | 3 | 8 | 58 | 1 | |||
| 21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
| 80797 | 201815 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | 10 | 3 | 8 | 58 | 1 | ||
| 32615 | 201797 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 2 | : | Tree | Private 2 | 2 | Width 5ft | 6021117.27971 | 2092731.09266 | 37.7274214146518 | -122.369201619254 | (37.7274214146518, -122.369201619254) | 10 | 3 | 8 | 58 | 1 | |||
| 156146 | 201814 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.369257791817 | (37.728943392223, -122.369257791817) | 10 | 3 | 8 | 58 | 1 | ||
| 72608 | 201817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 1 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.369296441991 | (37.7290887577236, -122.369296441991) | 10 | 3 | 8 | 58 | 1 | ||
| 25463 | 201798 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 3 | : | Tree | Private 2 | 2 | Width 5ft | 6021088.33309 | 2092752.01283 | 37.7274772697451 | -122.369303133851 | (37.7274772697451, -122.369303133851) | 10 | 3 | 8 | 58 | 1 | |||
| 76682 | 201818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 2 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.41734 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | 10 | 3 | 8 | 58 | 1 | ||
| 63555 | 201813 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.7288565518864 | -122.369345258092 | (37.7288565518864, -122.369345258092) | 10 | 3 | 8 | 58 | 1 | ||
| 147718 | 201819 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.77069 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | 10 | 3 | 8 | 58 | 1 | ||
| 130896 | 201605 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021066.69823 | 2093118.68379 | 37.7284828925695 | -122.369403250859 | (37.7284828925695, -122.369403250859) | 10 | 3 | 8 | 58 | 1 | |||
| 54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 1 | |||
| 149415 | 201820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.7289227860515 | -122.369449472416 | (37.7289227860515, -122.369449472416) | 10 | 3 | 8 | 58 | 1 | ||
| 74007 | 253057 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.7294758223376 | -122.369467779931 | (37.7294758223376, -122.369467779931) | 10 | 3 | 8 | 58 | 1 | |
| 156942 | 201590 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.7294758223376 | -122.369467779931 | (37.7294758223376, -122.369467779931) | 10 | 3 | 8 | 58 | 1 | |
| 89306 | 201799 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 4 | : | Tree | Private 2 | 2 | Width 5ft | 6021051.90692 | 2092781.98164 | 37.7275575603158 | -122.36943113075 | (37.7275575603158, -122.36943113075) | 10 | 3 | 8 | 58 | 1 | |||
| 125237 | 201811 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | 10 | 3 | 8 | 58 | 1 | |||
| 159328 | 201821 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021045.51426 | 2093266.44708 | 37.7288874606638 | -122.369486691782 | (37.7288874606638, -122.369486691782) | 10 | 3 | 8 | 58 | 1 | ||
| 17303 | 201604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | 10 | 3 | 8 | 58 | 1 | |||
| 170848 | 201603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 565 Innes Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6021043.02716 | 2093075.23068 | 37.7283622799705 | -122.369482082752 | (37.7283622799705, -122.369482082752) | 10 | 3 | 8 | 58 | 1 | |||
| 106307 | 201589 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.7294184626869 | -122.369519490027 | (37.7294184626869, -122.369519490027) | 10 | 3 | 8 | 58 | 1 | |
| 46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
| 184554 | 201822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021035.49669 | 2093250.02992 | 37.7288418326792 | -122.369520189723 | (37.7288418326792, -122.369520189723) | 10 | 3 | 8 | 58 | 1 | ||
| 80711 | 201588 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | 10 | 3 | 8 | 58 | 1 | |
| 168920 | 201823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 7 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.7287947324852 | -122.369559269737 | (37.7287947324852, -122.369559269737) | 10 | 3 | 8 | 58 | 1 | ||
| 131826 | 201800 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 5 | : | Tree | Private 2 | 2 | Width 5ft | 6021019.25883 | 2092809.33244 | 37.7276308694498 | -122.36954588606 | (37.7276308694498, -122.36954588606) | 10 | 3 | 8 | 58 | 1 | |||
| 169961 | 201587 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.17316 | 37.7293048117461 | -122.369623649518 | (37.7293048117461, -122.369623649518) | 10 | 3 | 8 | 58 | 1 | |
| 82173 | 201824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 8 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.60368 | 2093212.58809 | 37.7287373296405 | -122.369624404053 | (37.7287373296405, -122.369624404053) | 10 | 3 | 8 | 58 | 1 | ||
| 190826 | 201586 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.7292623727458 | -122.369660233928 | (37.7292623727458, -122.369660233928) | 10 | 3 | 8 | 58 | 1 | |
| 37953 | 201801 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 6 | : | Tree | Private 2 | 2 | Width 5ft | 6020978.95351 | 2092836.83628 | 37.7277041785835 | -122.369687123669 | (37.7277041785835, -122.369687123669) | 10 | 3 | 8 | 58 | 1 | |||
| 182462 | 201606 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.46357 | 37.7287012794353 | -122.369797385941 | (37.7287012794353, -122.369797385941) | 10 | 3 | 8 | 58 | 1 | ||
| 99082 | 201802 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 7 | : | Tree | Private 2 | 2 | Width 5ft | 6020947.47999 | 2092859.07822 | 37.7277635239432 | -122.369797465976 | (37.7277635239432, -122.369797465976) | 10 | 3 | 8 | 58 | 1 | |||
| 193987 | 201809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 237 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020945.51773 | 2093059.30039 | 37.7283131886973 | -122.369818081152 | (37.7283131886973, -122.369818081152) | 10 | 3 | 8 | 58 | 1 | |||
| 137638 | 201607 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020934.32673 | 2093214.83409 | 37.7287396409072 | -122.369867514187 | (37.7287396409072, -122.369867514187) | 10 | 3 | 8 | 58 | 1 | ||
| 57077 | 201825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.19247 | 37.7284547293849 | -122.369881218949 | (37.7284547293849, -122.369881218949) | 10 | 3 | 8 | 58 | 1 | |
| 135455 | 201808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 247 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | 10 | 3 | 8 | 58 | 1 | |||
| 146248 | 201803 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 8 | : | Tree | Private 2 | 2 | Width 5ft | 6020924.86388 | 2092877.32885 | 37.7278123958223 | -122.369876912084 | (37.7278123958223, -122.369876912084) | 10 | 3 | 8 | 58 | 1 | |||
| 38308 | 201610 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.94701 | 37.7286076240414 | -122.369897470592 | (37.7286076240414, -122.369897470592) | 10 | 3 | 8 | 58 | 1 | |
| 159634 | 201585 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.56387 | 37.728949436562 | -122.369928880323 | (37.728949436562, -122.369928880323) | 10 | 3 | 8 | 58 | 1 | |
| 117504 | 201608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6020912.48689 | 2093230.64881 | 37.7287818667771 | -122.369944109446 | (37.7287818667771, -122.369944109446) | 10 | 3 | 8 | 58 | 1 | |||
| 55719 | 201804 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 9 | : | Tree | Private 2 | 2 | Width 5ft | 6020904.74927 | 2092892.98725 | 37.7278542871344 | -122.369947531359 | (37.7278542871344, -122.369947531359) | 10 | 3 | 8 | 58 | 1 | |||
| 169734 | 201826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | 10 | 3 | 8 | 58 | 1 | |
| 175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
| 53926 | 201827 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | 10 | 3 | 8 | 58 | 1 | |
| 56589 | 201805 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 10 | : | Tree | Private 2 | 2 | Width 5ft | 6020879.60636 | 2092912.55986 | 37.727906650163 | -122.370035804318 | (37.727906650163, -122.370035804318) | 10 | 3 | 8 | 58 | 1 | |||
| 28299 | 253048 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 59401 | 253050 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 73673 | 253052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 79026 | 253049 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 100775 | 253051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 171535 | 253053 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.38844 | 37.7287677737371 | -122.3700946933 | (37.7287677737371, -122.3700946933) | 10 | 3 | 8 | 58 | 1 | ||
| 156156 | 201828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.36948 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | 10 | 3 | 8 | 58 | 1 | |
| 156656 | 201806 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 50 Jerrold Ave | 11 | : | Tree | Private 2 | 2 | Width 5ft | 6020862.09511 | 2092930.70884 | 37.7279555229066 | -122.37009759585 | (37.7279555229066, -122.37009759585) | 10 | 3 | 8 | 58 | 1 | |||
| 121234 | 201829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.79454 | 37.7281471046068 | -122.370156642634 | (37.7281471046068, -122.370156642634) | 10 | 3 | 8 | 58 | 1 | |
| 18536 | 201597 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.42964 | 37.728647714022 | -122.370224202392 | (37.728647714022, -122.370224202392) | 10 | 3 | 8 | 58 | 1 | |
| 169785 | 201830 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | 10 | 3 | 8 | 58 | 1 | |
| 139289 | 201596 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | 10 | 3 | 8 | 58 | 1 | |
| 126531 | 201595 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.70117 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | 10 | 3 | 8 | 58 | 1 | |
| 124916 | 201611 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 1 | Side Yard : Yard | Tree | Private 2 | 2 | Width 9ft | 6020793.34161 | 2092957.5019 | 37.7280253184122 | -122.370337132975 | (37.7280253184122, -122.370337132975) | 10 | 3 | 8 | 58 | 1 | |||
| 104092 | 201549 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Innes Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6020789.54938 | 2093251.93298 | 37.7288335625002 | -122.370370588629 | (37.7288335625002, -122.370370588629) | 10 | 3 | 8 | 58 | 1 | |||
| 193396 | 201594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.85351 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | 10 | 3 | 8 | 58 | 1 | |
| 111690 | 201612 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 2 | Side Yard : Yard | Tree | Private 2 | 2 | Width 3ft | 6020781.6072 | 2092974.15888 | 37.7280704113081 | -122.370378850726 | (37.7280704113081, -122.370378850726) | 10 | 3 | 8 | 58 | 1 | |||
| 76988 | 201593 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.7284230345862 | -122.370423544329 | (37.7284230345862, -122.370423544329) | 10 | 3 | 8 | 58 | 1 | |
| 59846 | 201831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.88429 | 37.7278602487283 | -122.370419366967 | (37.7278602487283, -122.370419366967) | 10 | 3 | 8 | 58 | 1 | |
| 2504 | 201613 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 3 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6020763.58395 | 2092982.86481 | 37.7280933269332 | -122.370441760089 | (37.7280933269332, -122.370441760089) | 10 | 3 | 8 | 58 | 1 | |||
| 53786 | 201592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | 10 | 3 | 8 | 58 | 1 | |
| 102075 | 201832 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.7277958617862 | -122.370472171548 | (37.7277958617862, -122.370472171548) | 10 | 3 | 8 | 58 | 1 | |
| 79437 | 201614 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 4 | Side Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6020747.34365 | 2092993.8196 | 37.7281225153334 | -122.370498661104 | (37.7281225153334, -122.370498661104) | 10 | 3 | 8 | 58 | 1 | |||
| 2855 | 201591 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.17806 | 37.7283237638216 | -122.37051506831 | (37.7283237638216, -122.37051506831) | 10 | 3 | 8 | 58 | 1 | |
| 31518 | 201833 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.87799 | 37.7277210345753 | -122.370535976659 | (37.7277210345753, -122.370535976659) | 10 | 3 | 8 | 58 | 1 | |
| 141744 | 201584 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | 10 | 3 | 8 | 58 | 1 | |
| 71510 | 201615 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 5 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6020732.10647 | 2093000.21976 | 37.728139252612 | -122.370551779534 | (37.728139252612, -122.370551779534) | 10 | 3 | 8 | 58 | 1 |
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) );