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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142782 | 142782 | 72861 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1999 12:00:00 AM | 14 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||
118339 | 118339 | 74274 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1999 12:00:00 AM | 15 | 3x3 | 6009331.26403705 | 2104492.17139473 | 37.759061252045 | -122.410776319185 | (37.759061252045, -122.410776319185) | ||
82229 | 82229 | 75088 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936.0 | 2108949.0 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | ||
75077 | 75077 | 78716 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 412 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | 6008662.0794 | 2088043.1280200002 | 37.7138582091656 | -122.41192829456699 | (37.7138582091656, -122.411928294567) | ||
103216 | 103216 | 83711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | ||
106430 | 106430 | 98025 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1633 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988173.0 | 2098960.0 | 37.742662336498604 | -122.48354516443199 | (37.7426623364986, -122.483545164432) | ||||
85375 | 85375 | 98530 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
95737 | 95737 | 98531 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
126605 | 126605 | 98985 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
105170 | 105170 | 98986 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
140187 | 140187 | 98987 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
114426 | 114426 | 98988 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
144222 | 144222 | 99114 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
88976 | 88976 | 99115 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
80439 | 80439 | 99116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
87279 | 87279 | 99175 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
105221 | 105221 | 99176 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
126915 | 126915 | 99178 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008617.0 | 2122137.0 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | ||||
124761 | 124761 | 99286 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
51250 | 51250 | 99287 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
99249 | 99249 | 101053 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 746 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008144.0 | 2114503.0 | 37.786481984518396 | -122.415591235338 | (37.7864819845184, -122.415591235338) | |||
77470 | 77470 | 101054 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) | |||
142421 | 142421 | 101055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) | |||
66195 | 66195 | 101056 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008144.0 | 2114503.0 | 37.786481984518396 | -122.415591235338 | (37.7864819845184, -122.415591235338) | |||
124911 | 124911 | 101249 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993518.0 | 2106670.0 | 37.764141669108 | -122.46562386166799 | (37.764141669108, -122.465623861668) | ||||
129241 | 129241 | 101288 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | ||||
95128 | 95128 | 101426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
127861 | 127861 | 101427 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
104415 | 104415 | 101428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
139219 | 139219 | 101429 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
126711 | 126711 | 101430 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
87598 | 87598 | 101431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
144556 | 144556 | 101432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
30530 | 30530 | 101433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
108609 | 108609 | 101519 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15X Bellair Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | |||
118270 | 118270 | 101520 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15X Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | |||
125474 | 125474 | 101895 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011780.0 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | ||||
82620 | 82620 | 102901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 BATTERY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012523.0 | 2118543.0 | 37.797820041376205 | -122.400724815577 | (37.7978200413762, -122.400724815577) | ||||
126776 | 126776 | 102902 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012556.0 | 2118523.0 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | ||||
143912 | 143912 | 103151 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
92014 | 92014 | 103152 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
100915 | 100915 | 103153 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
78100 | 78100 | 104437 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005464.0 | 2111103.0 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | |||||
95412 | 95412 | 105718 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | |||
78272 | 78272 | 106690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4x4 | 6004701.0 | 2103385.0 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | |||
122522 | 122522 | 107383 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6005896.4 | 2103362.0 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | ||||
119749 | 119749 | 107384 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x6 | 6005896.4 | 2103362.0 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | ||||
87713 | 87713 | 107997 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | ||||
83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
110078 | 110078 | 108964 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
129373 | 129373 | 109918 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6010269.5 | 2121152.3 | 37.80485859155171 | -122.408706764133 | (37.8048585915517, -122.408706764133) | ||||
121075 | 121075 | 110116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
79146 | 79146 | 110117 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
184359 | 184359 | 111317 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011270.9057 | 2089563.6222599999 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | |||
83747 | 83747 | 111387 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014036.0 | 2112699.0 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | ||||
73707 | 73707 | 111609 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.71831496682871 | -122.403375421742 | (37.7183149668287, -122.403375421742) | |||
187298 | 187298 | 111610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.71833459814221 | -122.403290521257 | (37.7183345981422, -122.403290521257) | |||
154035 | 154035 | 111611 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 9x3 | 6011211.1462900005 | 2089627.82993 | 37.718352162787795 | -122.40322913082599 | (37.7183521627878, -122.403229130826) | |||
12464 | 12464 | 111889 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011076.19973 | 2092521.5640200002 | 37.72629022399121 | -122.40389910598302 | (37.7262902239912, -122.403899105983) | |||
121528 | 121528 | 113877 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
141964 | 141964 | 114015 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
86230 | 86230 | 114016 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
91851 | 91851 | 114017 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
92579 | 92579 | 114018 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
79998 | 79998 | 115675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | |||||
180059 | 180059 | 116038 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008011.067530001 | 2116537.17208 | 37.792059850433795 | -122.416195270994 | (37.7920598504338, -122.416195270994) | |||
151509 | 151509 | 116039 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6008038.315669999 | 2116541.7615900002 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | |||
106386 | 106386 | 116389 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
105684 | 105684 | 116390 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
104912 | 104912 | 116391 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
90375 | 90375 | 116392 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
89159 | 89159 | 116393 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
122320 | 122320 | 121141 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
103877 | 103877 | 121142 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
178436 | 178436 | 126616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.797125207219295 | -122.443251440404 | (37.7971252072193, -122.443251440404) | |||
39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
135535 | 135535 | 126618 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3301 Van Ness Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6005157.457169999 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | |||
154959 | 154959 | 126619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996924.84901 | 2116015.0059599997 | 37.789996524161 | -122.45451575299299 | (37.789996524161, -122.454515752993) | |||
138144 | 138144 | 126620 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.41656913265801 | (37.7920924400618, -122.416569132658) | |||
175781 | 175781 | 126621 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | |||
75837 | 75837 | 126622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998235.513119999 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | |||
59614 | 59614 | 126623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3200 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998899.76803 | 2116292.09263 | 37.7908703998933 | -122.44770268523399 | (37.7908703998933, -122.447702685234) | |||
158006 | 158006 | 126625 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.40330078161101 | (37.8033465696629, -122.403300781611) | |||
62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
9698 | 9698 | 173643 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
9737 | 9737 | 173681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010317.0 | 2099454.0 | 37.7452827689443 | -122.40701204748301 | (37.7452827689443, -122.407012047483) | ||||
9802 | 9802 | 173694 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011772.0 | 2114653.0 | 37.7870971135768 | -122.40304974212799 | (37.7870971135768, -122.403049742128) | ||||
9891 | 9891 | 173730 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999535.0 | 2094919.0 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | ||||
157131 | 157131 | 176402 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998803.89987 | 2087884.3075400002 | 37.7128641138726 | -122.44599027982201 | (37.7128641138726, -122.445990279822) | |||
40036 | 40036 | 176403 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998770.03746 | 2087851.6869599998 | 37.7127726114513 | -122.44610497396201 | (37.7127726114513, -122.446104973962) | |||
170317 | 170317 | 176404 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.44616620971901 | (37.712723399629, -122.446166209719) | |||
137325 | 137325 | 176405 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5998552.29871 | 2087983.35456 | 37.7131217039812 | -122.446867014517 | (37.7131217039812, -122.446867014517) | |||
25064 | 25064 | 176406 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.71305480791771 | -122.446884509935 | (37.7130548079177, -122.446884509935) | |||
54887 | 54887 | 176407 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | |||
39277 | 39277 | 176408 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 55 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998608.92575 | 2087907.1259400002 | 37.7129156324143 | -122.44666581189101 | (37.7129156324143, -122.446665811891) |
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");