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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
120636 | 120636 | 22615 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
126289 | 126289 | 22618 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
39003 | 39003 | 174984 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1005 Madrid St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6001116.49451 | 2088434.7952400001 | 37.7145074162652 | -122.438036624391 | (37.7145074162652, -122.438036624391) | |||
167983 | 167983 | 174983 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1005 Madrid St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6001103.82585 | 2088413.5291400002 | 37.7144483038197 | -122.438078889846 | (37.7144483038197, -122.438078889846) | |||
57310 | 57310 | 125264 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1009 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008170.85008 | 2118913.6211 | 37.79859397459521 | -122.415810770352 | (37.7985939745952, -122.415810770352) | |||
13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
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) | |||
38066 | 38066 | 111168 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6003190.196690001 | 2119810.74673 | 37.8007759915841 | -122.43310951858999 | (37.8007759915841, -122.43310951859) | |||
71650 | 71650 | 111167 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003205.803309999 | 2119813.99508 | 37.80078579597271 | -122.433055745441 | (37.8007857959727, -122.433055745441) | |||
156773 | 156773 | 111166 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6003221.39002 | 2119816.29205 | 37.800792986965796 | -122.43300197316499 | (37.8007929869658, -122.433001973165) | |||
116268 | 116268 | 42069 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
9391 | 9391 | 24148 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | |||
13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
13870 | 13870 | 24143 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016705.2095099995 | 2095147.06572 | 37.7338122084672 | -122.38462252011999 | (37.7338122084672, -122.38462252012) | |||
14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
120584 | 120584 | 24142 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | |||
79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
164024 | 164024 | 120378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5987994.967999999 | 2115215.60018 | 37.7872853847458 | -122.485353306378 | (37.7872853847458, -122.485353306378) | |||
57184 | 57184 | 120073 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987689.48695 | 2115234.87158 | 37.787320497195 | -122.48641160802299 | (37.787320497195, -122.486411608023) | |||
154594 | 154594 | 120071 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987688.6545 | 2115263.0140400003 | 37.787397719801604 | -122.486416555063 | (37.7873977198016, -122.486416555063) | |||
186296 | 186296 | 120072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987688.32967 | 2115247.71242 | 37.7873556870051 | -122.486416555037 | (37.7873556870051, -122.486416555037) | |||
42043 | 42043 | 188631 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6010953.30174 | 2096155.7818599998 | 37.7362621559727 | -122.404579676927 | (37.7362621559727, -122.404579676927) | ||||
75315 | 75315 | 188632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Charter Oak Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010956.26861 | 2096182.79853 | 37.7363365038229 | -122.404571320413 | (37.7363365038229, -122.404571320413) | ||||
90217 | 90217 | 115147 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
96999 | 96999 | 115142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
104010 | 104010 | 115146 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
108315 | 108315 | 115143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
118266 | 118266 | 115144 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
128837 | 128837 | 115141 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
138505 | 138505 | 115140 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
139204 | 139204 | 115145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
169297 | 169297 | 175017 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Nueva Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | Width 4ft | 6013060.88681 | 2087564.6207700002 | 37.712790132022704 | -122.39669075108101 | (37.7127901320227, -122.396690751081) | |||
58205 | 58205 | 188572 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.6155199995 | 2106524.04213 | 37.764918870439 | -122.39365939726801 | (37.764918870439, -122.393659397268) | ||||
157254 | 157254 | 188571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014323.12928 | 2106506.5800900003 | 37.764871007621004 | -122.39365293923599 | (37.764871007621, -122.393652939236) | ||||
174896 | 174896 | 188573 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014313.95748 | 2106525.31857 | 37.764921949722705 | -122.393685974041 | (37.7649219497227, -122.393685974041) | ||||
175480 | 175480 | 188574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.12378 | 2106534.34369 | 37.7649471289393 | -122.39366181916 | (37.7649471289393, -122.39366181916) | ||||
116158 | 116158 | 89312 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
148953 | 148953 | 140728 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1010 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002589.9611 | 2110263.1888 | 37.7745267665162 | -122.434503543236 | (37.7745267665162, -122.434503543236) | |||
141304 | 141304 | 7008 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1010 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002586.66205 | 2110263.38045 | 37.774527105466 | -122.434514968983 | (37.774527105466, -122.434514968983) | |||
60424 | 60424 | 125285 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1015 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.41425188820699 | (37.7978424372369, -122.414251888207) | ||||
15245 | 15245 | 11544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | ||
138494 | 138494 | 55211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.781268623734604 | -122.44372179014601 | (37.7812686237346, -122.443721790146) | |||
14116 | 14116 | 24108 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016610.88324 | 2095264.1891400001 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | |||
104790 | 104790 | 24131 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016408.932866001 | 2096090.6845669998 | 37.7363868071997 | -122.38571259219101 | (37.7363868071997, -122.385712592191) | |||
106080 | 106080 | 24133 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016408.932866001 | 2096090.6845669998 | 37.7363868071997 | -122.38571259219101 | (37.7363868071997, -122.385712592191) | |||
111899 | 111899 | 24132 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016408.932866001 | 2096090.6845669998 | 37.7363868071997 | -122.38571259219101 | (37.7363868071997, -122.385712592191) | ||
99582 | 99582 | 104425 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101x WHITNEY YOUNG CIR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6016394.0 | 2096049.0 | 37.7362715234519 | -122.38576131735901 | (37.7362715234519, -122.385761317359) | |||
76699 | 76699 | 203232 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 102 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994447.144830001 | 2101331.42465 | 37.7495368607335 | -122.462023075825 | (37.7495368607335, -122.462023075825) | |||
63519 | 63519 | 187749 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6018386.6897599995 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | ||||
36572 | 36572 | 125283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1022 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6008553.3357 | 2118652.52979 | 37.797898577410706 | -122.414468760628 | (37.7978985774107, -122.414468760628) | ||||
165268 | 165268 | 125284 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1022 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008534.98172 | 2118654.3458 | 37.797902532623205 | -122.414532399365 | (37.7979025326232, -122.414532399365) | ||||
41859 | 41859 | 203857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991224.82027 | 2090017.2317599999 | 37.718284899813206 | -122.47234118110201 | (37.7182848998132, -122.472341181102) | |||
76095 | 76095 | 203859 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5991237.16543 | 2090216.1679099998 | 37.718831844103704 | -122.472313003552 | (37.7188318441037, -122.472313003552) | |||
153003 | 153003 | 203858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5991229.23047 | 2090077.70959 | 37.718451212329505 | -122.47233034336901 | (37.7184512123295, -122.472330343369) | |||
154993 | 154993 | 203861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991252.63127 | 2090414.4123799999 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | |||
168689 | 168689 | 203856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5991221.72934 | 2089959.84815 | 37.7181271596151 | -122.47234768412399 | (37.7181271596151, -122.472347684124) | |||
184381 | 184381 | 203860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | |||
47658 | 47658 | 122239 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 103 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5990148.768569999 | 2114703.4514200003 | 37.786004407716604 | -122.47786423961901 | (37.7860044077166, -122.477864239619) | |||
129517 | 129517 | 203738 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1030 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992859.26291 | 2098454.84038 | 37.7415469455276 | -122.467304836462 | (37.7415469455276, -122.467304836462) | |||
173417 | 173417 | 203737 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1030 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992875.8085900005 | 2098448.42334 | 37.741530281100104 | -122.467247161152 | (37.7415302811001, -122.467247161152) | |||
164663 | 164663 | 249542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1031 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6006025.644830001 | 2113728.66347 | 37.7842365454133 | -122.422865173892 | (37.7842365454133, -122.422865173892) | |||
187271 | 187271 | 249543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1031 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.42282898338699 | (37.7840840006086, -122.422828983387) | |||
4407 | 4407 | 5225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.43853244967698 | (37.779223304768, -122.438532449677) | |||
158909 | 158909 | 125275 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1036 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008484.892530001 | 2118308.52925 | 37.796950191958295 | -122.41468123716801 | (37.7969501919583, -122.414681237168) | |||
93980 | 93980 | 110202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1039 PAGE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.43795762529301 | (37.771984919077, -122.437957625293) | |||||
79636 | 79636 | 103385 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999013.0 | 2116197.0 | 37.79061577152721 | -122.447304062173 | (37.7906157715272, -122.447304062173) | ||||
92936 | 92936 | 34180 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | |||
47506 | 47506 | 124842 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001792.104119999 | 2121538.6526900004 | 37.8054409584916 | -122.43807133554199 | (37.8054409584916, -122.438071335542) | |||
170752 | 170752 | 124843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001801.68917 | 2121551.89814 | 37.8054778720718 | -122.438039114634 | (37.8054778720718, -122.438039114634) | |||
174897 | 174897 | 124844 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001807.9499 | 2121561.96756 | 37.8055058760609 | -122.438018170296 | (37.8055058760609, -122.438018170296) | |||
181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) | ||||
19012 | 19012 | 5575 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005061.37186 | 2102302.0381 | 37.752807321807 | -122.425387784834 | (37.752807321807, -122.425387784834) | |||
66689 | 66689 | 187761 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6017511.07328 | 2093334.4830599998 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | ||||
133165 | 133165 | 187758 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.38153877989299 | (37.7287884075452, -122.381538779893) | ||||
149025 | 149025 | 187760 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6017527.04391 | 2093321.80664 | 37.7288458211654 | -122.381654264546 | (37.7288458211654, -122.381654264546) | ||||
156153 | 156153 | 187757 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6017577.45499 | 2093289.4287599998 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | ||||
165389 | 165389 | 187759 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6017547.84189 | 2093311.88395 | 37.7288197237472 | -122.381581673978 | (37.7288197237472, -122.381581673978) | ||||
107424 | 107424 | 104714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.42237353578301 | (37.8034112154379, -122.422373535783) | |||||
122781 | 122781 | 104713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.42237353578301 | (37.8034112154379, -122.422373535783) | |||||
130262 | 130262 | 200159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857004 | -122.39379597620301 | (37.719486864857, -122.393795976203) | |||
31138 | 31138 | 249446 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 6 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6005679.55916 | 2113469.5737 | 37.7835056151439 | -122.424044078095 | (37.7835056151439, -122.424044078095) | |||
67123 | 67123 | 249442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6005782.21609 | 2113483.18621 | 37.783548787090105 | -122.42368989267901 | (37.7835487870901, -122.423689892679) | |||
70092 | 70092 | 249441 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6005807.98079 | 2113486.28035 | 37.7835587371777 | -122.42360097670601 | (37.7835587371777, -122.423600976706) | |||
29477 | 29477 | 188598 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6012781.12633 | 2102535.65122 | 37.7538819037331 | -122.398707676819 | (37.7538819037331, -122.398707676819) | |||
60307 | 60307 | 188597 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6012781.38051 | 2102548.17796 | 37.7539163136043 | -122.398707676835 | (37.7539163136043, -122.398707676835) | |||
10841 | 10841 | 25393 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | |||
153621 | 153621 | 175010 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012675.7431 | 2088120.44685 | 37.714294876771895 | -122.39806090961001 | (37.7142948767719, -122.39806090961) | ||||
175404 | 175404 | 175011 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Hester Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012671.33567 | 2088131.05018 | 37.7143237459272 | -122.398076886938 | (37.7143237459272, -122.398076886938) | ||||
9903 | 9903 | 3758 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1056 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
148612 | 148612 | 245204 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1058 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6001022.4834 | 2109009.3407 | 37.7709949104145 | -122.43983582345 | (37.7709949104145, -122.43983582345) | |||
107419 | 107419 | 10359 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1060 HAIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X4 | 6001056.0 | 2109004.0 | 37.770982153968 | -122.439719505856 | (37.770982153968, -122.439719505856) | |||
72260 | 72260 | 188721 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1062 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 41 | Width 5ft | 6013117.817000001 | 2089964.07481 | 37.7193817246629 | -122.396662082497 | (37.7193817246629, -122.396662082497) | |||
157071 | 157071 | 125252 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1067 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008499.87029 | 2118254.27562 | 37.7968020664151 | -122.41462556911699 | (37.7968020664151, -122.414625569117) | |||
102363 | 102363 | 112832 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1068x BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6008436.0 | 2118271.0 | 37.796844398836896 | -122.41484776006399 | (37.7968443988369, -122.414847760064) | |||
179282 | 179282 | 125250 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1073 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008472.63138 | 2118248.82998 | 37.796785583654 | -122.414719436774 | (37.796785583654, -122.414719436774) | |||
186711 | 186711 | 125251 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1073 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008484.56321 | 2118250.48158 | 37.7967907889218 | -122.414678266696 | (37.7967907889218, -122.414678266696) |
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");