Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 109964 | 109964 | 1773 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2000X Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 21650 | 21650 | 1996 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 175 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6007331.5108 | 2098053.7261799998 | 37.741270411207296 | -122.41723618861201 | (37.7412704112073, -122.417236188612) | |||
| 6636 | 6636 | 2588 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1710 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1999 12:00:00 AM | 18 | 3 | 6005206.687000001 | 2115142.0135 | 37.788071009916 | -122.42579911500499 | (37.788071009916, -122.425799115005) | ||
| 13576 | 13576 | 3696 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016376.57655 | 2099377.09307 | 37.7454088259626 | -122.386053488085 | (37.7454088259626, -122.386053488085) | |||
| 15190 | 15190 | 3701 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/2000 12:00:00 AM | 3 | 3X3 | 6016463.92851 | 2099311.9747200003 | 37.745234858406 | -122.385746898422 | (37.745234858406, -122.385746898422) | ||
| 16643 | 16643 | 3702 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1990 12:00:00 AM | 12 | 3X3 | 6016478.46508 | 2099300.03196 | 37.7452028704157 | -122.385695800734 | (37.7452028704157, -122.385695800734) | ||
| 13958 | 13958 | 3709 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016611.7626 | 2099202.9223 | 37.7449436021699 | -122.38522811100201 | (37.7449436021699, -122.385228111002) | |||
| 14867 | 14867 | 3710 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6016627.8913900005 | 2099188.4950200003 | 37.7449048800496 | -122.385171335 | (37.7449048800496, -122.385171335) | ||
| 15189 | 15189 | 3712 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016661.27341 | 2099164.52322 | 37.7448409049843 | -122.385054235166 | (37.7448409049843, -122.385054235166) | |||
| 14535 | 14535 | 3713 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016679.4743 | 2099151.07612 | 37.7448049887681 | -122.384990362612 | (37.7448049887681, -122.384990362612) | |||
| 13907 | 13907 | 3714 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016696.4691699995 | 2099138.87958 | 37.744772439592204 | -122.384930747455 | (37.7447724395922, -122.384930747455) | |||
| 15631 | 15631 | 3715 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016713.472019999 | 2099127.09165 | 37.744741012786896 | -122.38487113321699 | (37.7447410127869, -122.384871133217) | ||
| 16170 | 16170 | 3716 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016802.38016 | 2099057.65052 | 37.744555258722 | -122.38455886702299 | (37.744555258722, -122.384558867023) | |||
| 14692 | 14692 | 3717 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016818.97287 | 2099045.87092 | 37.7445238319196 | -122.384500671891 | (37.7445238319196, -122.384500671891) | |||
| 14593 | 14593 | 3718 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.584419999 | 2099032.41565 | 37.7444879156766 | -122.384435379316 | (37.7444879156766, -122.384435379316) | |||
| 16584 | 16584 | 3719 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016852.7534 | 2099021.2782 | 37.744458173299996 | -122.38438215201799 | (37.7444581733, -122.384382152018) | |||
| 14717 | 14717 | 3720 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016885.74999 | 2098998.54038 | 37.7443975643918 | -122.38426647223999 | (37.7443975643918, -122.38426647224) | |||
| 15648 | 15648 | 3722 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016920.12543 | 2098972.91356 | 37.7443290989992 | -122.384145823682 | (37.7443290989992, -122.384145823682) | |||
| 15997 | 15997 | 3723 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016936.70179 | 2098960.3168599997 | 37.744295427497704 | -122.384087628549 | (37.7442954274977, -122.384087628549) | |||
| 16435 | 16435 | 3724 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016958.14867 | 2098944.9648700003 | 37.7442544597685 | -122.38401240026501 | (37.7442544597685, -122.384012400265) | |||
| 15280 | 15280 | 3725 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016971.06909 | 2098934.28119 | 37.7442258388522 | -122.383966980005 | (37.7442258388522, -122.383966980005) | |||
| 14990 | 14990 | 3727 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017002.99503 | 2098909.3169299997 | 37.7441590569979 | -122.383854848043 | (37.7441590569979, -122.383854848043) | |||
| 15456 | 15456 | 3728 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017021.23739 | 2098897.913 | 37.744128752548704 | -122.383790975489 | (37.7441287525487, -122.383790975489) | |||
| 15457 | 15457 | 3729 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017037.38715 | 2098884.5074400003 | 37.744092836325 | -122.38373419946998 | (37.744092836325, -122.38373419947) | |||
| 16000 | 16000 | 3730 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017054.36564 | 2098871.4939599996 | 37.744058042453496 | -122.383674585207 | (37.7440580424535, -122.383674585207) | |||
| 16127 | 16127 | 3731 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017071.75465 | 2098858.47223 | 37.74402324858939 | -122.383613550927 | (37.7440232485894, -122.383613550927) | |||
| 16519 | 16519 | 3732 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017092.791180001 | 2098843.12861 | 37.7439822808577 | -122.383539742673 | (37.7439822808577, -122.383539742673) | |||
| 14596 | 14596 | 3733 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017103.99643 | 2098828.8007400003 | 37.743943558756705 | -122.38349999984501 | (37.7439435587567, -122.383499999845) | |||
| 84520 | 84520 | 3734 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 87655 | 87655 | 3736 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 143797 | 143797 | 3737 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 80852 | 80852 | 3738 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 81325 | 81325 | 3739 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 125442 | 125442 | 3740 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 143272 | 143272 | 3741 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
| 79043 | 79043 | 4201 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3902 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004475.85975 | 2100470.10248 | 37.7477441545905 | -122.427282109286 | (37.7477441545905, -122.427282109286) | |||
| 16934 | 16934 | 4202 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3902 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004480.6649 | 2100468.03712 | 37.7477387553393 | -122.427265346224 | (37.7477387553393, -122.427265346224) | |||
| 21443 | 21443 | 4396 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1005 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004431.4266800005 | 2103008.65854 | 37.754711924921295 | -122.427616590837 | (37.7547119249213, -122.427616590837) | |||
| 22196 | 22196 | 4409 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1097 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6004456.37766 | 2102543.07479 | 37.753434952361495 | -122.427497136583 | (37.7534349523615, -122.427497136583) | |||
| 17697 | 17697 | 4413 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1108 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6x9 | 6004403.04195 | 2102416.52833 | 37.753084468576205 | -122.427672567341 | (37.7530844685762, -122.427672567341) | |||
| 129383 | 129383 | 4430 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1195 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004484.1301445 | 2101944.4411304 | 37.751792813836104 | -122.427358521283 | (37.7517928138361, -122.427358521283) | |||
| 19096 | 19096 | 4431 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1195 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004486.69317 | 2101949.49973 | 37.7518068485257 | -122.427350018309 | (37.7518068485257, -122.427350018309) | |||
| 18215 | 18215 | 4462 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1454 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004517.68898 | 2100379.8296 | 37.7474986516535 | -122.42713103697099 | (37.7474986516535, -122.427131036971) | |||
| 18512 | 18512 | 4810 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 20 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005841.28363 | 2097904.31782 | 37.7407762175496 | -122.42237826114099 | (37.7407762175496, -122.422378261141) | |||
| 21191 | 21191 | 4812 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 28 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 46 | 3X3 | 6005885.45019 | 2097879.1399 | 37.7407095759957 | -122.422223761224 | (37.7407095759957, -122.422223761224) | |||
| 22222 | 22222 | 4815 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005920.0488599995 | 2097862.788 | 37.740666628859294 | -122.42210297059799 | (37.7406666288593, -122.422102970598) | |||
| 21637 | 21637 | 4817 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 51 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005995.99863 | 2097868.77885 | 37.7406873618291 | -122.42184079032499 | (37.7406873618291, -122.421840790325) | |||
| 20730 | 20730 | 4823 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 66 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006092.06915 | 2097770.47064 | 37.74042284693579 | -122.421501634396 | (37.7404228469358, -122.421501634396) | |||
| 20228 | 20228 | 4824 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 73 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006137.31563 | 2097787.40171 | 37.740471886955 | -122.42134639164301 | (37.740471886955, -122.421346391643) | |||
| 21184 | 21184 | 4827 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6006160.77573 | 2097729.74879 | 37.74031490761921 | -122.421261182679 | (37.7403149076192, -122.421261182679) | |||
| 18235 | 18235 | 4828 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 85 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006188.87424 | 2097766.1175 | 37.740416352027204 | -122.421166610858 | (37.7404163520272, -122.421166610858) | |||
| 17259 | 17259 | 4834 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 108 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6006318.50135 | 2097642.9115299997 | 37.7400853628581 | -122.420709666225 | (37.7400853628581, -122.420709666225) | |||
| 19540 | 19540 | 4835 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 115 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6006362.63783 | 2097667.32197 | 37.7401548759573 | -122.420558792379 | (37.7401548759573, -122.420558792379) | |||
| 20001 | 20001 | 4839 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 135 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006426.94909 | 2097635.5595299997 | 37.7400712875725 | -122.42033417588699 | (37.7400712875725, -122.420334175887) | |||
| 18582 | 18582 | 4840 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 138 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6006436.16175 | 2097581.71528 | 37.7399239624285 | -122.42029850157499 | (37.7399239624285, -122.420298501575) | |||
| 21920 | 21920 | 4841 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 142 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x9 | 6006480.033919999 | 2097559.50493 | 37.7398654498357 | -122.420145233727 | (37.7398654498357, -122.420145233727) | |||
| 18226 | 18226 | 4848 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 229 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 2x3 | 6006739.96805 | 2097466.29285 | 37.7396241527309 | -122.419239878116 | (37.7396241527309, -122.419239878116) | |||
| 20202 | 20202 | 5091 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2600 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002242.42307 | 2096653.9998400002 | 37.7371394644141 | -122.434732362321 | (37.7371394644141, -122.434732362321) | |||
| 7002 | 7002 | 5239 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1100 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001407.3425 | 2112393.2913 | 37.780308287354295 | -122.438747110907 | (37.7803082873543, -122.438747110907) | |||
| 100144 | 100144 | 5241 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 141336 | 141336 | 5243 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 143972 | 143972 | 5244 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 86602 | 86602 | 5245 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 19295 | 19295 | 5760 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 398 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6003950.51884 | 2108401.53413 | 37.7694922566853 | -122.42966430666999 | (37.7694922566853, -122.42966430667) | |||
| 109749 | 109749 | 5761 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 DUBOCE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003934.4 | 2108512.1 | 37.7697949309592 | -122.429727948184 | (37.7697949309592, -122.429727948184) | |||
| 93664 | 93664 | 6117 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 103050 | 103050 | 6118 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 81339 | 81339 | 6119 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 145856 | 145856 | 6120 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 84321 | 84321 | 6121 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 109965 | 109965 | 6122 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 81374 | 81374 | 6123 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 146271 | 146271 | 6125 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 99444 | 99444 | 6126 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000780.36286 | 2096039.2702900001 | 37.7353684469933 | -122.439743296782 | (37.7353684469933, -122.439743296782) | |||
| 138565 | 138565 | 6127 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000782.74757 | 2096053.9984099998 | 37.735409022713704 | -122.439736107551 | (37.7354090227137, -122.439736107551) | |||
| 82431 | 82431 | 6309 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1807 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002200.5977300005 | 2112898.1085099997 | 37.7817394844201 | -122.43603901136999 | (37.7817394844201, -122.43603901137) | |||
| 92387 | 92387 | 6315 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1829 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002129.29202 | 2112924.84308 | 37.781808839600394 | -122.43628760910102 | (37.7818088396004, -122.436287609101) | |||
| 96484 | 96484 | 6324 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 77690 | 77690 | 6329 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 79295 | 79295 | 6333 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 79767 | 79767 | 6335 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 7531 | 7531 | 8183 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001748.9425 | 2111188.325 | 37.777019181607706 | -122.437479047598 | (37.7770191816077, -122.437479047598) | |||
| 6238 | 6238 | 8189 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1279 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001660.1742 | 2111123.4233 | 37.7768359307235 | -122.437781474603 | (37.7768359307235, -122.437781474603) | |||
| 8329 | 8329 | 8190 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1280 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001658.902000001 | 2111173.1154 | 37.7769723003903 | -122.437789435412 | (37.7769723003903, -122.437789435412) | |||
| 1843 | 1843 | 9890 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005344.337040001 | 2115550.48459 | 37.7892003471598 | -122.42535194865299 | (37.7892003471598, -122.425351948653) | |||
| 22570 | 22570 | 9891 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005334.61917 | 2115551.7772 | 37.7892033473078 | -122.425385663344 | (37.7892033473078, -122.425385663344) | |||
| 22410 | 22410 | 9892 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005332.72699 | 2115570.2247599997 | 37.7892538927886 | -122.42539352339199 | (37.7892538927886, -122.425393523392) | |||
| 23295 | 23295 | 9894 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/1997 12:00:00 AM | 23 | 3X3 | 6005329.1496 | 2115601.42673 | 37.7893393634754 | -122.425408122112 | (37.7893393634754, -122.425408122112) | ||
| 8898 | 8898 | 10643 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003494.47 | 2110732.5385 | 37.77586678850471 | -122.431408185002 | (37.7758667885047, -122.431408185002) | |||
| 5984 | 5984 | 10644 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003470.6525 | 2110728.6613 | 37.775854792789296 | -122.431490298947 | (37.7758547927893, -122.431490298947) | |||
| 106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
| 6221 | 6221 | 10646 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003440.7423 | 2110725.3379 | 37.7758439722804 | -122.431593528606 | (37.7758439722804, -122.431593528606) | |||
| 8867 | 8867 | 10653 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 930 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003401.4158 | 2110719.799 | 37.775826534714106 | -122.43172917338 | (37.7758265347141, -122.43172917338) | |||
| 6681 | 6681 | 10654 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 930 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003365.9666 | 2110715.3678 | 37.7758123582585 | -122.431851484644 | (37.7758123582585, -122.431851484644) | |||
| 23051 | 23051 | 10656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 940 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6003283.9904 | 2110703.7361 | 37.7757757730917 | -122.432134230107 | (37.7757757730917, -122.432134230107) | |||
| 7223 | 7223 | 10658 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6003278.1745 | 2110658.3168 | 37.7756507331964 | -122.43215110447599 | (37.7756507331964, -122.432151104476) | ||
| 3849 | 3849 | 10659 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6003302.5458 | 2110662.7479 | 37.775664281642 | -122.43206711469601 | (37.775664281642, -122.432067114696) | |||
| 142506 | 142506 | 10660 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003300.92525 | 2110638.18324 | 37.7755967412885 | -122.432070966007 | (37.7755967412885, -122.432070966007) |
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");