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) | |||
| 87727 | 87727 | 65566 | Permitted Site 1 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | |||
| 143067 | 143067 | 65565 | Permitted Site 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | |||
| 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) | |||
| 2371 | 2371 | 253059 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2385 | 2385 | 253058 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2395 | 2395 | 253061 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2462 | 2462 | 253060 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 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) | |||
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2373 | 2373 | 253062 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2421 | 2421 | 253064 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2431 | 2431 | 253063 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 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) | |||
| 90246 | 90246 | 65563 | Permitted Site 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.36904110347099 | (37.8103107984086, -122.369041103471) | |||
| 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) | |||
| 2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
| 2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
| 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) | |||
| 2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
| 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) | ||
| 2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 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) | ||
| 2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 2460 | 2460 | 201825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.1924700001 | 37.7284547293849 | -122.36988121894899 | (37.7284547293849, -122.369881218949) | |
| 93209 | 93209 | 65564 | Permitted Site 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.36988228287599 | (37.8103949467147, -122.369882282876) | |||
| 2433 | 2433 | 201610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.9470099998 | 37.7286076240414 | -122.36989747059201 | (37.7286076240414, -122.369897470592) | |
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 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) | |||
| 2435 | 2435 | 201826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 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) | |||
| 2446 | 2446 | 201827 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 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) | |||
| 2444 | 2444 | 201828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.3694799999 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | |
| 2406 | 2406 | 201829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.7945400001 | 37.7281471046068 | -122.37015664263399 | (37.7281471046068, -122.370156642634) | |
| 2423 | 2423 | 201830 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
| 2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
| 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) | |||
| 2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
| 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) | |||
| 2411 | 2411 | 201831 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.8842900002 | 37.7278602487283 | -122.37041936696698 | (37.7278602487283, -122.370419366967) | |
| 2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
| 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) | |||
| 2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2390 | 2390 | 201832 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.727795861786205 | -122.370472171548 | (37.7277958617862, -122.370472171548) | |
| 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) | |||
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
| 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) | |||
| 2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) |
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");