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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 8246 | 8246 | 20349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 9565 | 9565 | 20409 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 9595 | 9595 | 35817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 9606 | 9606 | 20333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10242 | 10242 | 20328 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 11483 | 11483 | 20348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 12000 | 12000 | 20347 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 8 | ||||||||
| 12183 | 12183 | 20411 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 12674 | 12674 | 20327 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12686 | 12686 | 35818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 12828 | 12828 | 20459 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 495X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 13881 | 13881 | 35819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 14471 | 14471 | 20350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 14576 | 14576 | 20410 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15498 | 15498 | 35820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 18528 | 18528 | 120131 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 20185 | 20185 | 120130 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 45359 | 45359 | 68576 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 32 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32469 | 5981483.59375 | 2111332.3319599996 | 37.776241595894106 | -122.50759263196899 | (37.7762415958941, -122.507592631969) | |
| 39598 | 39598 | 118510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 8137 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 5981731.77881 | 2112327.0562 | 37.778987433126105 | -122.50680790507 | (37.7789874331261, -122.50680790507) | |||
| 25488 | 25488 | 39821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2101 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | 3 | Permit Number 41148 | 5981982.6078 | 2100745.8281 | 37.7472034694978 | -122.505081701882 | (37.7472034694978, -122.505081701882) | ||
| 187206 | 187206 | 47445 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 811 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45355 | 5982594.30489 | 2110210.15333 | 37.77322578967961 | -122.50366731846701 | (37.7732257896796, -122.503667318467) | |
| 166906 | 166906 | 183702 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1343 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5982736.6857 | 2105979.0791 | 37.7616168455095 | -122.502861540497 | (37.7616168455095, -122.502861540497) | |||
| 70334 | 70334 | 183703 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1343 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5982737.637 | 2105959.1018 | 37.76156204943371 | -122.502856771493 | (37.7615620494337, -122.502856771493) | |||
| 38284 | 38284 | 67224 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30683 | 5983507.38436 | 2109708.43135 | 37.771901847852895 | -122.500471801712 | (37.7719018478529, -122.500471801712) | |
| 184032 | 184032 | 57999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 871 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1977 12:00:00 AM | 19 | Permit Number 16964 | 5983538.74255 | 2109889.72287 | 37.772401462891004 | -122.50037673928499 | (37.772401462891, -122.500376739285) | ||
| 18484 | 18484 | 12450 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 84810 | 84810 | 12452 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 104060 | 104060 | 12451 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 122168 | 122168 | 12453 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127553 | 127553 | 12454 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127742 | 127742 | 12455 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 131275 | 131275 | 117894 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 559 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5984080.2137400005 | 2112029.0427099997 | 37.7783071869826 | -122.498661831158 | (37.7783071869826, -122.498661831158) | |||
| 136952 | 136952 | 183712 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3733 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984088.4104 | 2106972.4655 | 37.7644237543554 | -122.498259918056 | (37.7644237543554, -122.498259918056) | |||
| 163767 | 163767 | 183713 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3733 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5984106.6873 | 2106973.5567 | 37.7644278221565 | -122.49819678488501 | (37.7644278221565, -122.498196784885) | |||
| 123293 | 123293 | 102368 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | |||
| 31420 | 31420 | 102369 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.49827212221099 | (37.773005270668, -122.498272122211) | |||
| 166717 | 166717 | 102372 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984152.563490001 | 2110057.09296 | 37.7728970243511 | -122.49826587084299 | (37.7728970243511, -122.498265870843) | |||
| 182049 | 182049 | 102370 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.18727 | 2110032.649 | 37.7728299448261 | -122.49826190746201 | (37.7728299448261, -122.498261907462) | |||
| 156733 | 156733 | 102371 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.49826336723801 | (37.7729475975471, -122.498263367238) | |||
| 38057 | 38057 | 102379 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5984156.57881 | 2110013.67242 | 37.772778039448106 | -122.49824877411999 | (37.7727780394481, -122.49824877412) | ||||
| 150039 | 150039 | 102376 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 5984157.512069999 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | ||||
| 180908 | 180908 | 184819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984690.0704 | 2106941.5787 | 37.764374208700104 | -122.496176694676 | (37.7643742087001, -122.496176694676) | |||
| 67988 | 67988 | 184818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984694.627 | 2106957.5269 | 37.7644182648708 | -122.49616211163 | (37.7644182648708, -122.49616211163) | |||
| 150757 | 150757 | 184890 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984711.7144 | 2106963.4126 | 37.7644354262232 | -122.496103446187 | (37.7644354262232, -122.496103446187) | |||
| 63289 | 63289 | 118267 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5984728.94591 | 2111276.55423 | 37.776279095764 | -122.496362122462 | (37.776279095764, -122.496362122462) | |||
| 149564 | 149564 | 118268 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5984729.81712 | 2111254.48497 | 37.7762185509537 | -122.496357479966 | (37.7762185509537, -122.496357479966) | |||
| 107253 | 107253 | 20476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 115969 | 115969 | 20467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 146051 | 146051 | 20469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 80842 | 80842 | 20504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | ||
| 76533 | 76533 | 118256 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 747 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5985057.16315 | 2110772.73924 | 37.774914985746 | -122.49518958386001 | (37.774914985746, -122.49518958386) | |||
| 46368 | 46368 | 118255 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 747 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5985057.6853 | 2110754.64892 | 37.774865345470296 | -122.49518644334 | (37.7748653454703, -122.49518644334) | |||
| 103884 | 103884 | 21495 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2792X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 185221 | 185221 | 78048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 783 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985063.43296 | 2110545.25732 | 37.7742907524801 | -122.495151117096 | (37.7742907524801, -122.495151117096) | ||
| 104125 | 104125 | 78350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 764 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 5 | 5985108.450019999 | 2110660.3816400003 | 37.7746094864044 | -122.49500388771901 | (37.7746094864044, -122.495003887719) | ||
| 45084 | 45084 | 69872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 3x3 | 5985114.18885 | 2110476.07325 | 37.774103764151896 | -122.49497044343599 | (37.7741037641519, -122.494970443436) | |
| 29123 | 29123 | 186920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985200.7204 | 2096727.014 | 37.73635770677671 | -122.493657794712 | (37.7363577067767, -122.493657794712) | |||
| 186314 | 186314 | 118191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5985457.0333 | 2109984.4342900002 | 37.7727739274481 | -122.49374826573299 | (37.7727739274481, -122.493748265733) | |||
| 11168 | 11168 | 66002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1242 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1990 12:00:00 AM | 14 | 3x3 | Permit Number 29036 | 5985545.5711 | 2106756.716 | 37.7639167014529 | -122.493204178844 | (37.7639167014529, -122.493204178844) | |
| 112647 | 112647 | 69453 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 459 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 15 | 6x9 | Permit Number 33563 | 5985605.84685 | 2112812.05347 | 37.780546467003 | -122.49344188362801 | (37.780546467003, -122.493441883628) |
| 156291 | 156291 | 250976 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985685.129819999 | 2113916.728 | 37.783584222178995 | -122.49324901662399 | (37.783584222179, -122.493249016624) | |||
| 170541 | 170541 | 48891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985690.94714 | 2113237.00512 | 37.781718239515705 | -122.49317880031299 | (37.7817182395157, -122.493178800313) | ||
| 160175 | 160175 | 250975 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985704.58491 | 2113917.1556700002 | 37.7835865343301 | -122.49318174196699 | (37.7835865343301, -122.493181741967) | |||
| 70752 | 70752 | 250974 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985720.677490001 | 2113918.49675 | 37.78359115774511 | -122.493126167444 | (37.7835911577451, -122.493126167444) | |||
| 186039 | 186039 | 48890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985723.18076 | 2113238.27416 | 37.781723609133394 | -122.493067382279 | (37.7817236091334, -122.493067382279) | ||
| 33448 | 33448 | 250973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985735.07087 | 2113919.4528200002 | 37.7835946246316 | -122.493076443038 | (37.7835946246316, -122.493076443038) | |||
| 72307 | 72307 | 48889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985750.33557 | 2113240.82458 | 37.7817321999331 | -122.49297362868799 | (37.7817321999331, -122.492973628688) | ||
| 93722 | 93722 | 3433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) |
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");