trees
3,965 rows where qSpecies_id = 70 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23390 | 22618 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
36156 | 22614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.7813650138202 | -122.424863625752 | (37.7813650138202, -122.424863625752) | 7 | 9 | 11 | 28852 | 41 | |||
65882 | 22610 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
69907 | 22615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
108199 | 22617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.7814583745998 | -122.424145957729 | (37.7814583745998, -122.424145957729) | 7 | 9 | 11 | 28852 | 41 | ||
130241 | 22612 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X5 | 6005303.8855 | 2112676.675 | 37.7813072936917 | -122.425287323246 | (37.7813072936917, -122.425287323246) | 7 | 9 | 11 | 28852 | 41 | |||
169179 | 22613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168 | (37.7813375942673, -122.42509837168) | 7 | 9 | 11 | 28852 | 41 | |||
133901 | 106598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001X SAN JOSE AVE | 11 | Median : Yard | Tree | DPW 1 | 21 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
106195 | 174983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1005 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001103.82585 | 2088413.52914 | 37.7144483038197 | -122.438078889846 | (37.7144483038197, -122.438078889846) | 9 | 7 | 6 | 28861 | 5 | |||
182792 | 174984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1005 Madrid St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 6001116.49451 | 2088434.79524 | 37.7145074162652 | -122.438036624391 | (37.7145074162652, -122.438036624391) | 9 | 7 | 6 | 28861 | 5 | |||
75242 | 125264 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1009 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008170.85008 | 2118913.6211 | 37.7985939745952 | -122.415810770352 | (37.7985939745952, -122.415810770352) | 5 | 1 | 10 | 28858 | 21 | |||
105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
24454 | 111167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003205.80331 | 2119813.99508 | 37.8007857959727 | -122.433055745441 | (37.8007857959727, -122.433055745441) | 13 | 9 | 1 | 57 | 17 | |||
27997 | 111166 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003221.39002 | 2119816.29205 | 37.8007929869658 | -122.433001973165 | (37.8007929869658, -122.433001973165) | 13 | 9 | 1 | 57 | 17 | |||
34132 | 111168 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003190.19669 | 2119810.74673 | 37.8007759915841 | -122.43310951859 | (37.8007759915841, -122.43310951859) | 13 | 9 | 1 | 57 | 17 | |||
148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
33296 | 24143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016705.20951 | 2095147.06572 | 37.7338122084672 | -122.38462252012 | (37.7338122084672, -122.38462252012) | 10 | 3 | 8 | 58 | 1 | |||
160018 | 24148 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | |||
162265 | 24144 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.384635938 | (37.7338509755474, -122.384635938) | 10 | 3 | 8 | 58 | 1 | |||
164474 | 24141 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.7337286308528 | -122.38459886076 | (37.7337286308528, -122.38459886076) | 10 | 3 | 8 | 58 | 1 | |||
166691 | 24142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | |||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
96918 | 120378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5987994.968 | 2115215.60018 | 37.7872853847458 | -122.485353306378 | (37.7872853847458, -122.485353306378) | 11 | 6 | 1 | 55 | 33 | |||
138086 | 120073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987689.48695 | 2115234.87158 | 37.787320497195 | -122.486411608023 | (37.787320497195, -122.486411608023) | 11 | 6 | 1 | 55 | 33 | |||
139431 | 120071 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987688.6545 | 2115263.01404 | 37.7873977198016 | -122.486416555063 | (37.7873977198016, -122.486416555063) | 11 | 6 | 1 | 55 | 33 | |||
146062 | 120072 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987688.32967 | 2115247.71242 | 37.7873556870051 | -122.486416555037 | (37.7873556870051, -122.486416555037) | 11 | 6 | 1 | 55 | 33 | |||
3224 | 188631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6010953.30174 | 2096155.78186 | 37.7362621559727 | -122.404579676927 | (37.7362621559727, -122.404579676927) | 10 | 3 | 8 | 58 | 1 | ||||
90387 | 188632 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Charter Oak Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010956.26861 | 2096182.79853 | 37.7363365038229 | -122.404571320413 | (37.7363365038229, -122.404571320413) | 10 | 3 | 8 | 58 | 1 | ||||
35458 | 115141 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
93001 | 115142 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
116719 | 115146 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
131287 | 115143 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
167987 | 115144 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
174412 | 115140 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
182929 | 115145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
164231 | 175017 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Nueva Ave | 7 | Front Yard : Yard | Tree | Private 2 | 1 | Width 4ft | 6013060.88681 | 2087564.62077 | 37.7127901320227 | -122.396690751081 | (37.7127901320227, -122.396690751081) | 10 | 3 | 8 | 58 | 1 | |||
25027 | 188574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 24 | Front Yard : Yard | Tree | Private 2 | 1 | 6014321.12378 | 2106534.34369 | 37.7649471289393 | -122.39366181916 | (37.7649471289393, -122.39366181916) | 14 | 3 | 8 | 310 | 29 | ||||
28632 | 188571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 19 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.12928 | 2106506.58009 | 37.764871007621 | -122.393652939236 | (37.764871007621, -122.393652939236) | 14 | 3 | 8 | 310 | 29 | ||||
37172 | 188573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 23 | Front Yard : Yard | Tree | Private 2 | 2 | 6014313.95748 | 2106525.31857 | 37.7649219497227 | -122.393685974041 | (37.7649219497227, -122.393685974041) | 14 | 3 | 8 | 310 | 29 | ||||
116008 | 188572 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 22 | Front Yard : Yard | Tree | Private 2 | 1 | 6014321.61552 | 2106524.04213 | 37.764918870439 | -122.393659397268 | (37.764918870439, -122.393659397268) | 14 | 3 | 8 | 310 | 29 | ||||
150425 | 89312 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
26769 | 175069 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Woolsey St | 6 | Side Yard : Yard | Tree | Private 2 | 20 | 6011573.1556 | 2092162.22602 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | 10 | 3 | 7 | 309 | 28 | ||||
161459 | 175068 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Woolsey St | 5 | Side Yard : Yard | Tree | Private 2 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | 10 | 3 | 7 | 309 | 28 | ||||
95249 | 140728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1010 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6002589.9611 | 2110263.1888 | 37.7745267665162 | -122.434503543236 | (37.7745267665162, -122.434503543236) | 15 | 5 | 11 | 29492 | 10 | |||
172060 | 7008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1010 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002586.66205 | 2110263.38045 | 37.774527105466 | -122.434514968983 | (37.774527105466, -122.434514968983) | 15 | 5 | 11 | 29492 | 10 | |||
182164 | 125285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1015 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.414251888207 | (37.7978424372369, -122.414251888207) | 5 | 1 | 10 | 308 | 21 | ||||
97390 | 11544 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | 10 | 3 | 8 | 58 | 1 | ||
171881 | 55211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.7812686237346 | -122.443721790146 | (37.7812686237346, -122.443721790146) | 15 | 5 | 1 | 29490 | 16 | |||
40170 | 24108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016610.88324 | 2095264.18914 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | 10 | 3 | 8 | 58 | 1 | |||
119805 | 24133 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | |||
122528 | 24131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | |||
136644 | 24132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | ||
97745 | 104425 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101x WHITNEY YOUNG CIR | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6016394 | 2096049 | 37.7362715234519 | -122.385761317359 | (37.7362715234519, -122.385761317359) | 10 | 3 | 8 | 58 | 1 | |||
154824 | 203232 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 102 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5994447.14483 | 2101331.42465 | 37.7495368607335 | -122.462023075825 | (37.7495368607335, -122.462023075825) | 1 | 8 | 4 | 29491 | 40 | |||
62455 | 187749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6018386.68976 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | 10 | 3 | 8 | 58 | 1 | ||||
10275 | 125283 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1022 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6008553.3357 | 2118652.52979 | 37.7978985774107 | -122.414468760628 | (37.7978985774107, -122.414468760628) | 5 | 1 | 10 | 308 | 21 | ||||
183295 | 125284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1022 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008534.98172 | 2118654.3458 | 37.7979025326232 | -122.414532399365 | (37.7979025326232, -122.414532399365) | 5 | 1 | 10 | 308 | 21 | ||||
13081 | 203859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991237.16543 | 2090216.16791 | 37.7188318441037 | -122.472313003552 | (37.7188318441037, -122.472313003552) | 9 | 8 | 6 | 64 | 24 | |||
42797 | 203857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991224.82027 | 2090017.23176 | 37.7182848998132 | -122.472341181102 | (37.7182848998132, -122.472341181102) | 9 | 8 | 6 | 64 | 24 | |||
57299 | 203860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | 9 | 8 | 6 | 64 | 24 | |||
111808 | 203861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991252.63127 | 2090414.41238 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | 9 | 8 | 6 | 64 | 24 | |||
164405 | 203858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991229.23047 | 2090077.70959 | 37.7184512123295 | -122.472330343369 | (37.7184512123295, -122.472330343369) | 9 | 8 | 6 | 64 | 24 | |||
180154 | 203856 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991221.72934 | 2089959.84815 | 37.7181271596151 | -122.472347684124 | (37.7181271596151, -122.472347684124) | 9 | 8 | 6 | 64 | 24 | |||
16375 | 122239 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 103 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5990148.76857 | 2114703.45142 | 37.7860044077166 | -122.477864239619 | (37.7860044077166, -122.477864239619) | 11 | 6 | 2 | 55 | 26 | |||
41717 | 203738 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1030 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992859.26291 | 2098454.84038 | 37.7415469455276 | -122.467304836462 | (37.7415469455276, -122.467304836462) | 1 | 8 | 4 | 59 | 40 | |||
131839 | 203737 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1030 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992875.80859 | 2098448.42334 | 37.7415302811001 | -122.467247161152 | (37.7415302811001, -122.467247161152) | 1 | 8 | 4 | 59 | 40 | |||
73923 | 249543 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1031 Franklin St | 4 | : | Tree | Private 2 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.422828983387 | (37.7840840006086, -122.422828983387) | 7 | 9 | 11 | 28858 | 41 | |||
137679 | 249542 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1031 Franklin St | 2 | : | Tree | Private 2 | 17 | Width 4ft | 6006025.64483 | 2113728.66347 | 37.7842365454133 | -122.422865173892 | (37.7842365454133, -122.422865173892) | 7 | 9 | 11 | 28858 | 41 | |||
51108 | 5225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.438532449677 | (37.779223304768, -122.438532449677) | 15 | 5 | 11 | 29490 | 41 | |||
44654 | 125275 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1036 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008484.89253 | 2118308.52925 | 37.7969501919583 | -122.414681237168 | (37.7969501919583, -122.414681237168) | 5 | 1 | 10 | 308 | 21 | |||
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
50841 | 103385 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999013 | 2116197 | 37.7906157715272 | -122.447304062173 | (37.7906157715272, -122.447304062173) | 13 | 6 | 1 | 29490 | 31 | ||||
91561 | 34180 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | 13 | 6 | 1 | 29490 | 31 | |||
104681 | 124844 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Retiro Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001807.9499 | 2121561.96756 | 37.8055058760609 | -122.438018170296 | (37.8055058760609, -122.438018170296) | 13 | 9 | 1 | 57 | 17 | |||
122918 | 124842 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001792.10412 | 2121538.65269 | 37.8054409584916 | -122.438071335542 | (37.8054409584916, -122.438071335542) | 13 | 9 | 1 | 57 | 17 | |||
168254 | 124843 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001801.68917 | 2121551.89814 | 37.8054778720718 | -122.438039114634 | (37.8054778720718, -122.438039114634) | 13 | 9 | 1 | 57 | 17 | |||
116782 | 175070 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Woolsey St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6011561.99348 | 2092186.33195 | 37.7253968743501 | -122.402196173126 | (37.7253968743501, -122.402196173126) | 10 | 3 | 7 | 309 | 28 | ||||
90405 | 5575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005061.37186 | 2102302.0381 | 37.752807321807 | -122.425387784834 | (37.752807321807, -122.425387784834) | 2 | 4 | 5 | 28862 | 22 | |||
51410 | 187757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6017577.45499 | 2093289.42876 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | 10 | 3 | 8 | 58 | 1 | ||||
54987 | 187761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6017511.07328 | 2093334.48306 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | 10 | 3 | 8 | 58 | 1 | ||||
103385 | 187760 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6017527.04391 | 2093321.80664 | 37.7288458211654 | -122.381654264546 | (37.7288458211654, -122.381654264546) | 10 | 3 | 8 | 58 | 1 | ||||
176169 | 187758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.381538779893 | (37.7287884075452, -122.381538779893) | 10 | 3 | 8 | 58 | 1 | ||||
180202 | 187759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6017547.84189 | 2093311.88395 | 37.7288197237472 | -122.381581673978 | (37.7288197237472, -122.381581673978) | 10 | 3 | 8 | 58 | 1 | ||||
119367 | 104714 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.422373535783 | (37.8034112154379, -122.422373535783) | 5 | 9 | 1 | 28858 | 32 | |||||
161844 | 104713 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.422373535783 | (37.8034112154379, -122.422373535783) | 5 | 9 | 1 | 28858 | 32 | |||||
142717 | 200159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857 | -122.393795976203 | (37.719486864857, -122.393795976203) | 10 | 3 | 8 | 58 | 1 | |||
135894 | 249446 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 6 | : | Tree | Private 2 | 21 | Width 5ft | 6005679.55916 | 2113469.5737 | 37.7835056151439 | -122.424044078095 | (37.7835056151439, -122.424044078095) | 7 | 9 | 11 | 28858 | 41 | |||
148046 | 249442 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6005782.21609 | 2113483.18621 | 37.7835487870901 | -122.423689892679 | (37.7835487870901, -122.423689892679) | 7 | 9 | 11 | 28858 | 41 | |||
162079 | 249441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 1 | : | Tree | Private 2 | 21 | Width 5ft | 6005807.98079 | 2113486.28035 | 37.7835587371777 | -122.423600976706 | (37.7835587371777, -122.423600976706) | 7 | 9 | 11 | 28858 | 41 | |||
42027 | 188598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 4 | : | Tree | Private 2 | 18 | Width 5ft | 6012781.12633 | 2102535.65122 | 37.7538819037331 | -122.398707676819 | (37.7538819037331, -122.398707676819) | 10 | 3 | 8 | 28856 | 29 | |||
122333 | 188597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 3 | : | Tree | Private 2 | 15 | Width 5ft | 6012781.38051 | 2102548.17796 | 37.7539163136043 | -122.398707676835 | (37.7539163136043, -122.398707676835) | 10 | 3 | 8 | 28856 | 29 | |||
44801 | 25393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | 9 | 7 | 6 | 28861 | 5 | |||
130230 | 175010 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Hester Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6012675.7431 | 2088120.44685 | 37.7142948767719 | -122.39806090961 | (37.7142948767719, -122.39806090961) | 10 | 3 | 8 | 309 | 1 | ||||
163522 | 175011 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Hester Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6012671.33567 | 2088131.05018 | 37.7143237459272 | -122.398076886938 | (37.7143237459272, -122.398076886938) | 10 | 3 | 8 | 309 | 1 | ||||
161329 | 3758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1056 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | 10 | 3 | 8 | 28856 | 29 | |||
33558 | 245204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1058 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6001022.4834 | 2109009.3407 | 37.7709949104145 | -122.43983582345 | (37.7709949104145, -122.43983582345) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );