Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51360 | 51360 | 110401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.779877404965504 | -122.4772748837 | (37.7798774049655, -122.4772748837) | ||
| 104962 | 104962 | 97215 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 20 | 4x12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||
| 118995 | 118995 | 97217 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 4 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 18 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
| 143072 | 143072 | 97216 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 3 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||||
| 13488 | 13488 | 3672 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 108 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017032.375109999 | 2098991.89434 | 37.7443874218329 | -122.383759005485 | (37.7443874218329, -122.383759005485) | |||
| 13776 | 13776 | 3680 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | |||
| 13880 | 13880 | 3671 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | |||
| 14381 | 14381 | 3679 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.744685084848896 | -122.384279393677 | (37.7446850848489, -122.384279393677) | |||
| 14752 | 14752 | 3664 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 100 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017168.62408 | 2098888.98032 | 37.744112371380204 | -122.383280718132 | (37.7441123713802, -122.383280718132) | ||
| 15305 | 15305 | 3683 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016838.589430001 | 2099135.269 | 37.7447703855426 | -122.384439066524 | (37.7447703855426, -122.384439066524) | |||
| 15310 | 15310 | 3668 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 104 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017100.61527 | 2098941.7519 | 37.7442535127858 | -122.38351955288 | (37.7442535127858, -122.38351955288) | |||
| 15340 | 15340 | 3684 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016817.82171 | 2099151.7639099997 | 37.744814528777795 | -122.384512026728 | (37.7448145287778, -122.384512026728) | |||
| 15381 | 15381 | 3665 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017153.34624 | 2098900.7145700003 | 37.74414374693129 | -122.383334362693 | (37.7441437469313, -122.383334362693) | |||
| 15426 | 15426 | 3670 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017067.53558 | 2098965.3092900002 | 37.744316368207706 | -122.383635576218 | (37.7443163682077, -122.383635576218) | |||
| 15773 | 15773 | 3675 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.1280400003 | 37.74448944274229 | -122.383946883753 | (37.7444894427423, -122.383946883753) | ||
| 16445 | 16445 | 3669 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 17 | 3X3 | 6017084.9315599995 | 2098953.56707 | 37.7442850879842 | -122.383574606702 | (37.7442850879842, -122.383574606702) | |||
| 16591 | 16591 | 3678 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 114 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016900.5532599995 | 2099090.71493 | 37.7446514753884 | -122.384221703094 | (37.7446514753884, -122.384221703094) | |||
| 16743 | 16743 | 3677 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 113 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3x3 | 6016945.8178 | 2099054.7063700003 | 37.7445551058345 | -122.38406267865801 | (37.7445551058345, -122.384062678658) | ||
| 84902 | 84902 | 3682 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 97915 | 97915 | 121201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 423 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990242.0 | 2112483.0 | 37.7799130778564 | -122.477379347216 | (37.7799130778564, -122.477379347216) | ||||
| 102914 | 102914 | 112377 | Property Tree 7 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 10282 | 10282 | 173941 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6004590.0 | 2105440.0 | 37.7613967828987 | -122.42724138037701 | (37.7613967828987, -122.427241380377) | ||||
| 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) | |||
| 792 | 792 | 199372 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 Newhall St | 2 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.37845506126499 | (37.7395514542225, -122.378455061265) | |
| 1068 | 1068 | 11520 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | ||
| 1153 | 1153 | 17806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.42686598915199 | (37.7887484569995, -122.426865989152) | |||
| 1520 | 1520 | 199389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 16 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6017439.78771 | 2096071.60272 | 37.7363914002406 | -122.38214713169901 | (37.7363914002406, -122.382147131699) | |||
| 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) | |||
| 2557 | 2557 | 139640 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 2560 | 2560 | 138642 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3059 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 0ft | 5999277.8969 | 2114611.151 | 37.7862765793233 | -122.446273410182 | (37.7862765793233, -122.446273410182) | |||
| 2566 | 2566 | 139641 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 2569 | 2569 | 139637 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6001520.6292 | 2112190.4921 | 37.7797578963919 | -122.438340667374 | (37.7797578963919, -122.438340667374) | |||
| 2574 | 2574 | 139639 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1997 12:00:00 AM | 22 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | ||
| 3087 | 3087 | 19650 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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) | |||
| 3956 | 3956 | 15038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6015648.0 | 2096190.0 | 37.7366173719863 | -122.388350408836 | (37.7366173719863, -122.388350408836) | |||
| 4862 | 4862 | 19656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 5348 | 5348 | 26872 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003227.2163 | 2110650.5623 | 37.7756265519671 | -122.432326827371 | (37.7756265519671, -122.432326827371) | |||
| 5896 | 5896 | 19680 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 5976 | 5976 | 19649 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 6914 | 6914 | 19672 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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) | |||
| 7023 | 7023 | 23544 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2800X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005656.2038 | 2120054.10262 | 37.80158375904121 | -122.424593418169 | (37.8015837590412, -122.424593418169) | |||
| 7103 | 7103 | 19675 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7153 | 7153 | 19677 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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) | ||
| 7446 | 7446 | 19683 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7523 | 7523 | 87408 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005843.02152 | 2118712.53051 | 37.7979106921903 | -122.42385149366501 | (37.7979106921903, -122.423851493665) | ||
| 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) | |||
| 7761 | 7761 | 23444 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 9 | 6005977.75981 | 2117720.35574 | 37.795194036322705 | -122.423314692816 | (37.7951940363227, -122.423314692816) | |||
| 7779 | 7779 | 10661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 958 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003257.9574 | 2110699.3049 | 37.7757621301077 | -122.432223968227 | (37.7757621301077, -122.432223968227) | |||
| 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) | |||
| 8547 | 8547 | 23445 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005972.56611 | 2117769.9625 | 37.7953299508697 | -122.423336192004 | (37.7953299508697, -122.423336192004) | |||
| 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) | |||
| 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) | |||
| 9546 | 9546 | 19678 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9875 | 9875 | 19651 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 10475 | 10475 | 19661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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) | |||
| 12748 | 12748 | 19671 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 13431 | 13431 | 11527 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018609.30332 | 2096848.22468 | 37.738588373848295 | -122.378157476493 | (37.7385883738483, -122.378157476493) | |||
| 13473 | 13473 | 11540 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | |||
| 13507 | 13507 | 11536 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018721.15121 | 2096997.58655 | 37.739004655647 | -122.377781119206 | (37.739004655647, -122.377781119206) | |||
| 13546 | 13546 | 11531 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018661.768080001 | 2096921.7146599998 | 37.7387930541475 | -122.37798117610501 | (37.7387930541475, -122.377981176105) | |||
| 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) | |||
| 13610 | 13610 | 11963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015687.60896 | 2096283.0567700001 | 37.736875081728705 | -122.38821995489599 | (37.7368750817287, -122.388219954896) | |||
| 13810 | 13810 | 11546 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018856.19666 | 2097185.73418 | 37.7395287121888 | -122.37732724037701 | (37.7395287121888, -122.377327240377) | |||
| 13853 | 13853 | 11518 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018467.96004 | 2096661.77747 | 37.7380686358665 | -122.37863323672899 | (37.7380686358665, -122.378633236729) | |||
| 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) | |||
| 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) | |||
| 13998 | 13998 | 11516 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018445.80461 | 2096632.24283 | 37.737986318204605 | -122.378707789643 | (37.7379863182046, -122.378707789643) | |||
| 14057 | 14057 | 19674 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14283 | 14283 | 11524 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) | |||
| 14511 | 14511 | 11548 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018882.85871 | 2097216.8887400003 | 37.7396157251883 | -122.377237214629 | (37.7396157251883, -122.377237214629) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 14617 | 14617 | 11525 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018584.76615 | 2096814.86638 | 37.7384954262103 | -122.37824000008499 | (37.7384954262103, -122.378240000085) | |||
| 14633 | 14633 | 11522 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018545.03968 | 2096763.4476400001 | 37.738352050906 | -122.37837378772801 | (37.738352050906, -122.378373787728) | |||
| 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) | |||
| 14711 | 14711 | 11538 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018744.95776 | 2097030.5986900001 | 37.7390966122121 | -122.377701096637 | (37.7390966122121, -122.377701096637) | |||
| 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) | |||
| 14729 | 14729 | 19657 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 14775 | 14775 | 11542 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018808.16459 | 2097116.8368799998 | 37.739336887696396 | -122.377488536484 | (37.7393368876964, -122.377488536484) | |||
| 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) | ||
| 14940 | 14940 | 26805 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1491 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015969.8239 | 2095448.3954 | 37.734598903014295 | -122.38718600253901 | (37.7345989030143, -122.387186002539) | |||
| 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) | |||
| 15014 | 15014 | 11529 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018637.527419999 | 2096885.1095 | 37.7386912077413 | -122.37806244962401 | (37.7386912077413, -122.378062449624) | |||
| 15019 | 15019 | 11534 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018698.318659999 | 2096968.53923 | 37.7389236393092 | -122.37785804901002 | (37.7389236393092, -122.37785804901) | |||
| 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) |
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");