Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1070 | 1070 | 19942 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 3884 | 3884 | 20320 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 6772 | 6772 | 20314 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 7805 | 7805 | 19939 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8002 | 8002 | 19938 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 12003 | 12003 | 20316 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 14348 | 14348 | 19941 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 14547 | 14547 | 19940 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 16276 | 16276 | 20315 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 17047 | 17047 | 20318 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 17109 | 17109 | 20319 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 12367 | 12367 | 24267 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.43787685174401 | (37.7094338594468, -122.437876851744) | |||
| 12342 | 12342 | 24268 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001111.916180001 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | |||
| 179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
| 183396 | 183396 | 176347 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6011214.18105 | 2087815.3375799998 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | ||||
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 158274 | 158274 | 176343 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | 6008484.74111 | 2088383.4213400001 | 37.714782633086294 | -122.412565284366 | (37.7147826330863, -122.412565284366) | ||||
| 71482 | 71482 | 176344 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008453.924319999 | 2088393.6006200002 | 37.714808853708604 | -122.41267251952299 | (37.7148088537086, -122.412672519523) | ||||
| 32543 | 32543 | 176345 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | ||||
| 3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
| 112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 138343 | 138343 | 105902 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 40 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 109893 | 109893 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
| 113956 | 113956 | 114069 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 5988091.0 | 2090188.0 | 37.7185719141165 | -122.483185851801 | (37.7185719141165, -122.483185851801) | ||||
| 90554 | 90554 | 114400 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 92772 | 92772 | 114075 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 108603 | 108603 | 114396 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||||
| 113582 | 113582 | 114403 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 122260 | 122260 | 66251 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | Permit Number 29352 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 138466 | 138466 | 114076 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 24 HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 54108 | 54108 | 176348 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.47798295295799 | (37.7196430676648, -122.477982952958) | ||||
| 44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
| 139032 | 139032 | 30154 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 410X Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) | |||
| 71413 | 71413 | 113506 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 39 | 3x3 | 6011135.08211 | 2090555.5358799999 | 37.7208952054249 | -122.40355728893199 | (37.7208952054249, -122.403557288932) | |||
| 171841 | 171841 | 176342 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.721003982019504 | -122.40245197087799 | (37.7210039820195, -122.402451970878) | |||
| 44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
| 28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
| 38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
| 47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
| 19139 | 19139 | 29600 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | ||
| 175511 | 175511 | 208978 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Junipero Serra Blvd | 109 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991241.872330001 | 2091923.37185 | 37.723519677182495 | -122.47242112456001 | (37.7235196771825, -122.47242112456) | |||
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 175100 | 175100 | 207765 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 356 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5992543.86147 | 2094436.1305 | 37.7304943639181 | -122.46810311696998 | (37.7304943639181, -122.46810311697) | |||
| 103018 | 103018 | 104402 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000011.7 | 2094912.1 | 37.7322297190532 | -122.44231994912901 | (37.7322297190532, -122.442319949129) | |||||
| 74562 | 74562 | 209046 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.732290932375605 | -122.442419949729 | (37.7322909323756, -122.442419949729) | |||
| 65353 | 65353 | 207764 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1520 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5993438.38203 | 2095281.4007599999 | 37.7328668869905 | -122.46507202306299 | (37.7328668869905, -122.465072023063) | |||
| 154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
| 161658 | 161658 | 209044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 5996811.85436 | 2095301.80777 | 37.7331168670328 | -122.453410604043 | (37.7331168670328, -122.453410604043) | |||
| 46778 | 46778 | 209043 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 10ft | 5996832.93686 | 2095303.5906200001 | 37.7331229707542 | -122.453337845278 | (37.7331229707542, -122.453337845278) | |||
| 172222 | 172222 | 201510 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6018594.17439 | 2094891.11142 | 37.73321369166371 | -122.378073969944 | (37.7332136916637, -122.378073969944) | ||||
| 175986 | 175986 | 207763 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5993266.97338 | 2095443.21542 | 37.7333013044925 | -122.46567637377599 | (37.7333013044925, -122.465676373776) | |||
| 170494 | 170494 | 209008 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 406 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6000788.7045 | 2095325.02184 | 37.7334077617457 | -122.439663267741 | (37.7334077617457, -122.439663267741) | ||||
| 36668 | 36668 | 209041 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000751.4342 | 2095340.2355900002 | 37.7334474137664 | -122.43979321169901 | (37.7334474137664, -122.439793211699) | ||||
| 45082 | 45082 | 209042 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | ||||
| 56581 | 56581 | 209009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000785.2821 | 2095342.6683900002 | 37.7334560202787 | -122.439676364582 | (37.7334560202787, -122.439676364582) | ||||
| 34595 | 34595 | 209040 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000753.71672 | 2095344.13435 | 37.7334582487793 | -122.43978559983 | (37.7334582487793, -122.43978559983) | ||||
| 157173 | 157173 | 209039 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000750.66308 | 2095345.5130200002 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | ||||
| 35228 | 35228 | 209038 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000746.779019999 | 2095349.3205099998 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) | ||||
| 176149 | 176149 | 209037 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000749.92806 | 2095352.54396 | 37.7334811239592 | -122.43979930099701 | (37.7334811239592, -122.439799300997) | ||||
| 134583 | 134583 | 209010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000785.06362 | 2095352.2063400003 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | ||||
| 182141 | 182141 | 209011 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6000782.1941599995 | 2095354.33843 | 37.7334878877384 | -122.439687876799 | (37.7334878877384, -122.439687876799) | ||||
| 25962 | 25962 | 209036 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | ||||
| 165522 | 165522 | 209035 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6000759.78323 | 2095371.55913 | 37.733533896164104 | -122.43976659178101 | (37.7335338961641, -122.439766591781) | ||||
| 159119 | 159119 | 209012 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 410 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6000789.00569 | 2095372.0781 | 37.7335369844496 | -122.439665598801 | (37.7335369844496, -122.439665598801) | ||||
| 48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
| 69214 | 69214 | 208986 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 372 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5993143.09775 | 2095558.09178 | 37.7336095804246 | -122.46611298742701 | (37.7336095804246, -122.466112987427) | |||
| 52384 | 52384 | 208985 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 372 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 59 | Width 3ft | 5993126.32529 | 2095592.5648700001 | 37.7337032672843 | -122.466173478533 | (37.7337032672843, -122.466173478533) | |||
| 45967 | 45967 | 209014 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.43967636459601 | (37.733789492485, -122.439676364596) | ||||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 189014 | 189014 | 209015 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6000779.78636 | 2095479.1538 | 37.73383046469421 | -122.439705146498 | (37.7338304646942, -122.439705146498) | ||||
| 114729 | 114729 | 96803 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300X Melrose Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 48 | 5998134.5 | 2095546.7 | 37.733865009274204 | -122.448855518806 | (37.7338650092742, -122.448855518806) | ||||
| 182600 | 182600 | 209016 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6000787.61929 | 2095495.57167 | 37.7338759901863 | -122.43967924239901 | (37.7338759901863, -122.439679242399) | ||||
| 36584 | 36584 | 208984 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 3ft | 5993109.71634 | 2095669.50335 | 37.7339135629453 | -122.466236489538 | (37.7339135629453, -122.466236489538) | |||
| 158456 | 158456 | 207762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993165.17049 | 2095669.26931 | 37.7339161197195 | -122.46604475226499 | (37.7339161197195, -122.466044752265) | |||
| 102874 | 102874 | 111513 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 16 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 111260 | 111260 | 111511 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 63043 | 63043 | 209019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000764.3171 | 2095528.5679900001 | 37.7339652640682 | -122.43976216978201 | (37.7339652640682, -122.439762169782) | ||||
| 185838 | 185838 | 209018 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | ||||
| 153234 | 153234 | 209020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | ||||
| 27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
| 30144 | 30144 | 209022 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6000785.93499 | 2095562.5681900003 | 37.7340598511869 | -122.43968986701401 | (37.7340598511869, -122.439689867014) | ||||
| 156854 | 156854 | 209023 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6000780.47253 | 2095565.1582 | 37.7340666518368 | -122.439708938014 | (37.7340666518368, -122.439708938014) | ||||
| 77296 | 77296 | 209024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6000772.29534 | 2095570.30388 | 37.7340803152378 | -122.43973757782601 | (37.7340803152378, -122.439737577826) | ||||
| 57024 | 57024 | 209025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6000769.58789 | 2095570.4874200001 | 37.7340806650885 | -122.43974695145599 | (37.7340806650885, -122.439746951456) | ||||
| 158564 | 158564 | 209026 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6000767.091 | 2095571.9190599998 | 37.7340844539158 | -122.439755686569 | (37.7340844539158, -122.439755686569) | ||||
| 160722 | 160722 | 209027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000763.850930001 | 2095573.2374 | 37.7340878893448 | -122.439766982962 | (37.7340878893448, -122.439766982962) | ||||
| 148610 | 148610 | 209028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6000760.3597 | 2095574.5612700002 | 37.7340913256606 | -122.439779148088 | (37.7340913256606, -122.439779148088) | ||||
| 72350 | 72350 | 209029 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6000758.12976 | 2095576.10922 | 37.7340954490409 | -122.43978696861299 | (37.7340954490409, -122.439786968613) | ||||
| 42046 | 42046 | 209030 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6000755.13076 | 2095576.9220900002 | 37.7340975102859 | -122.439797395328 | (37.7340975102859, -122.439797395328) |
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");