Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 86341 | 86341 | 3693 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
| 104843 | 104843 | 3692 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
| 14047 | 14047 | 6510 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1200X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | |||
| 14296 | 14296 | 6512 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017582.68074 | 2097100.7392400003 | 37.7392250947568 | -122.381724640105 | (37.7392250947568, -122.381724640105) | |||
| 81080 | 81080 | 6509 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017579.3120099995 | 2097108.75601 | 37.739246921189 | -122.38173684520201 | (37.739246921189, -122.381736845202) | |||
| 16655 | 16655 | 6515 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15 | 6017527.69247 | 2097139.8588 | 37.7393294727638 | -122.38191748711999 | (37.7393294727638, -122.38191748712) | |||
| 15818 | 15818 | 6516 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017508.57687 | 2097144.1126599999 | 37.7393400973684 | -122.38198387686899 | (37.7393400973684, -122.381983876869) | |||
| 13896 | 13896 | 6519 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017483.589869999 | 2097174.66185 | 37.739422599379104 | -122.38207239623699 | (37.7394225993791, -122.382072396237) | |||
| 107848 | 107848 | 6514 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017471.58901 | 2097190.47601 | 37.7394653591044 | -122.38211499016899 | (37.7394653591044, -122.382114990169) | |||
| 13624 | 13624 | 6521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017462.61912 | 2097188.96881 | 37.739460725233606 | -122.38214589961599 | (37.7394607252336, -122.382145899616) | |||
| 15734 | 15734 | 6522 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017447.32839 | 2097190.1869 | 37.7394632253474 | -122.382198853519 | (37.7394632253474, -122.382198853519) | |||
| 14278 | 14278 | 6523 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017441.22819 | 2097205.1052900003 | 37.739503851329495 | -122.382220983128 | (37.7395038513295, -122.382220983128) | |||
| 14481 | 14481 | 6524 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6017425.7364 | 2097207.6932200002 | 37.7395101016101 | -122.382274727523 | (37.7395101016101, -122.382274727523) | |||
| 15309 | 15309 | 6525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017423.67126 | 2097218.66072 | 37.7395401020993 | -122.382282630765 | (37.7395401020993, -122.382282630765) | ||
| 98126 | 98126 | 6534 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017423.300009999 | 2097212.76401 | 37.7395238904111 | -122.38228350426901 | (37.7395238904111, -122.382283504269) | |||
| 15109 | 15109 | 6526 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017409.27613 | 2097218.95029 | 37.7395401020909 | -122.382332423519 | (37.7395401020909, -122.382332423519) | ||
| 109774 | 109774 | 6517 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017408.44101 | 2097236.90801 | 37.7395893642582 | -122.382336560068 | (37.7395893642582, -122.382336560068) | |||
| 15982 | 15982 | 6527 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 15 | 6017405.21421 | 2097232.9171599997 | 37.7395782279507 | -122.382347439479 | (37.7395782279507, -122.382347439479) | |||
| 81615 | 81615 | 6533 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017399.15501 | 2097229.47901 | 37.7395684527942 | -122.382368150642 | (37.7395684527942, -122.382368150642) | |||
| 84807 | 84807 | 6518 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017386.15401 | 2097259.19601 | 37.739649331573794 | -122.38241516995899 | (37.7396493315738, -122.382415169959) | |||
| 14619 | 14619 | 6528 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017381.090340001 | 2097249.5639299997 | 37.739622604108796 | -122.382432008146 | (37.7396226041088, -122.382432008146) | |||
| 114644 | 114644 | 6532 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017378.72501 | 2097246.19501 | 37.739613223073796 | -122.38243995218599 | (37.7396132230738, -122.382439952186) | |||
| 13615 | 13615 | 6529 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017368.28124 | 2097249.13872 | 37.7396207290066 | -122.382476267371 | (37.7396207290066, -122.382476267371) | |||
| 14858 | 14858 | 6530 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017366.22044 | 2097260.33377 | 37.7396513545281 | -122.38248417152799 | (37.7396513545281, -122.382484171528) | |||
| 175278 | 175278 | 199890 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1200x Quesada Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6017354.2822 | 2093058.6837 | 37.7281137963921 | -122.382233221943 | (37.7281137963921, -122.382233221943) | |||
| 15027 | 15027 | 6531 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017348.91467 | 2097263.64113 | 37.7396594798919 | -122.38254423812599 | (37.7396594798919, -122.382544238126) | |||
| 88290 | 88290 | 6520 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017343.43601 | 2097287.05501 | 37.739723467052 | -122.382564809911 | (37.739723467052, -122.382564809911) | |||
| 16465 | 16465 | 6535 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017290.8428 | 2097308.51335 | 37.739779481837296 | -122.382748149519 | (37.7397794818373, -122.382748149519) | |||
| 15501 | 15501 | 6536 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017286.0724599995 | 2097321.35634 | 37.739814482555204 | -122.382765536994 | (37.7398144825552, -122.382765536994) | |||
| 14456 | 14456 | 6537 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017269.15486 | 2097321.24148 | 37.7398132324937 | -122.38282402351999 | (37.7398132324937, -122.38282402352) | |||
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 82822 | 82822 | 3694 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017199.673908999 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | |||
| 13612 | 13612 | 3695 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | |||
| 86558 | 86558 | 6582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 103806 | 103806 | 6583 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 106689 | 106689 | 6584 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 118582 | 118582 | 6581 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017038.350166599 | 2097565.1506974 | 37.740470203399504 | -122.383639033462 | (37.7404702033995, -122.383639033462) | |||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 16031 | 16031 | 6586 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X Evans Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 15 | 6017026.1395 | 2097501.4027299997 | 37.740294489412 | -122.38367681643 | (37.740294489412, -122.38367681643) | |||
| 77349 | 77349 | 3742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 450X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.74447108289971 | -122.38401932754 | (37.7444710828997, -122.38401932754) | |||
| 13421 | 13421 | 6561 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6016932.91962 | 2097582.94738 | 37.740513241395604 | -122.384004813584 | (37.7405132413956, -122.384004813584) | |||
| 14815 | 14815 | 29657 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 299X Cashmere St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6016930.3488300005 | 2095863.99444 | 37.735793199983796 | -122.38389404137699 | (37.7357931999838, -122.383894041377) | ||
| 16058 | 16058 | 6562 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6016920.77309 | 2097581.3708900004 | 37.7405082411515 | -122.384046702218 | (37.7405082411515, -122.384046702218) | |||
| 16850 | 16850 | 6563 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 4 | 6016917.30927 | 2097594.07629 | 37.7405429361116 | -122.384059563412 | (37.7405429361116, -122.384059563412) | |||
| 16774 | 16774 | 6564 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016897.83831 | 2097600.27015 | 37.740558866707794 | -122.384127318327 | (37.7405588667078, -122.384127318327) | |||
| 152863 | 152863 | 192632 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 6016758.25797 | 2094440.43595 | 37.73187487720529 | -122.384389914969 | (37.7318748772053, -122.384389914969) | |||
| 87354 | 87354 | 6619 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 96408 | 96408 | 6618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 116609 | 116609 | 6609 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | ||
| 116954 | 116954 | 6614 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 118625 | 118625 | 6606 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
| 145281 | 145281 | 6608 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | ||
| 136337 | 136337 | 192633 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 6ft | 6016736.26235 | 2094477.0250400002 | 37.7319741272952 | -122.384468506713 | (37.7319741272952, -122.384468506713) | |||
| 66499 | 66499 | 192634 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6016723.45145 | 2094514.5247400003 | 37.732076385599704 | -122.38451540818001 | (37.7320763855997, -122.38451540818) | |||
| 161466 | 161466 | 193529 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2x Garlington Ct | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6016723.20154 | 2094502.11588 | 37.732042299514106 | -122.38451540818001 | (37.7320422995141, -122.38451540818) | |||
| 15023 | 15023 | 97221 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 15x200 | 6016689.53805 | 2094986.8063299998 | 37.733371301443 | -122.38466554190701 | (37.733371301443, -122.384665541907) | |||
| 16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 16597 | 16597 | 97225 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.9135099999 | 37.7332595687675 | -122.38479997523599 | (37.7332595687675, -122.384799975236) | ||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
| 15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
| 13974 | 13974 | 97229 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 15x200 | 6016636.9425099995 | 2094930.8404400002 | 37.7332147213866 | -122.38484348356701 | (37.7332147213866, -122.384843483567) | |||
| 15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
| 13446 | 13446 | 6607 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6016551.319490001 | 2097860.71449 | 37.741254829556105 | -122.38534360193898 | (37.7412548295561, -122.385343601939) | ||
| 69629 | 69629 | 200633 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6016537.4545 | 2094850.7585 | 37.732989329256505 | -122.38518186591601 | (37.7329893292565, -122.385181865916) | |||
| 173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
| 46120 | 46120 | 200598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.732956277793896 | -122.385302911931 | (37.7329562777939, -122.385302911931) | |||
| 14093 | 14093 | 97435 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.732951043415206 | -122.385341956131 | (37.7329510434152, -122.385341956131) | |||
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 15150 | 15150 | 6612 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6016472.61883 | 2097917.5413 | 37.7414065100921 | -122.385619683024 | (37.7414065100921, -122.385619683024) | |||
| 43571 | 43571 | 200600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | |||
| 58587 | 58587 | 200519 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.38543201583401 | (37.7335445478075, -122.385432015834) | |||
| 38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
| 137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
| 16076 | 16076 | 6613 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016450.58483 | 2097934.2856900003 | 37.741451267574206 | -122.385697036412 | (37.7414512675742, -122.385697036412) | |||
| 30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
| 58287 | 58287 | 200617 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 58 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | |||
| 188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
| 164960 | 164960 | 200615 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.38554059619301 | (37.7336853915549, -122.385540596193) | |||
| 76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
| 72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
| 136924 | 136924 | 200613 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.733722632810604 | -122.38556694616501 | (37.7337226328106, -122.385566946165) | |||
| 14571 | 14571 | 6615 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016429.61259 | 2097949.5600400004 | 37.7414920473285 | -122.385770616219 | (37.7414920473285, -122.385770616219) | |||
| 76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
| 14699 | 14699 | 6616 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016425.355719999 | 2097963.9541599997 | 37.741531335091295 | -122.385786338186 | (37.7415313350913, -122.385786338186) | |||
| 137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
| 23851 | 23851 | 200603 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.38560931762301 | (37.733790555057, -122.385609317623) | |||
| 59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
| 147918 | 147918 | 200634 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6016413.6949 | 2094834.3971 | 37.7329375570822 | -122.38560859930901 | (37.7329375570822, -122.385608599309) | |||
| 13967 | 13967 | 6617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016412.3999 | 2097961.86068 | 37.741524869881104 | -122.38583098952101 | (37.7415248698811, -122.385830989521) | |||
| 55316 | 55316 | 200609 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | |||
| 131211 | 131211 | 200607 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.73389469904829 | -122.385657689133 | (37.7338946990483, -122.385657689133) | |||
| 59826 | 59826 | 200635 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016404.4653 | 2094836.0752 | 37.7329416541175 | -122.385640625637 | (37.7329416541175, -122.385640625637) |
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");