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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 185518 | 185518 | 135100 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010152.092130001 | 2122405.39789 | 37.8082927096059 | -122.409201548321 | (37.8082927096059, -122.409201548321) | |||
| 147530 | 147530 | 135099 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010189.07255 | 2122378.93733 | 37.8082221272074 | -122.40907169882401 | (37.8082221272074, -122.409071698824) | |||
| 149408 | 149408 | 135098 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010217.76574 | 2122446.50226 | 37.808409250946 | -122.408977168373 | (37.808409250946, -122.408977168373) | ||||
| 34032 | 34032 | 135097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010211.1601599995 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | ||||
| 33244 | 33244 | 135096 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010210.74566 | 2122411.37483 | 37.808312406561896 | -122.40899898321501 | (37.8083124065619, -122.408998983215) | ||||
| 26655 | 26655 | 135095 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010206.33452 | 2122371.7105799997 | 37.8082032513446 | -122.409011448713 | (37.8082032513446, -122.409011448713) | |||
| 168355 | 168355 | 135094 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010218.1810800005 | 2122393.28877 | 37.8082631632688 | -122.40897197389401 | (37.8082631632688, -122.408971973894) | ||||
| 45743 | 45743 | 135093 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010231.518209999 | 2122384.9462900003 | 37.8082410039906 | -122.408925228011 | (37.8082410039906, -122.408925228011) | ||||
| 68508 | 68508 | 135092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010225.12119 | 2122365.6479 | 37.808187657103204 | -122.408946004172 | (37.8081876571032, -122.408946004172) | |||
| 67107 | 67107 | 135091 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010242.35879 | 2122357.22585 | 37.80816549781579 | -122.40888575407101 | (37.8081654978158, -122.408885754071) | |||
| 130915 | 130915 | 135090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010270.120709999 | 2122364.4312 | 37.808186836917294 | -122.40879018494199 | (37.8081868369173, -122.408790184942) | ||||
| 139278 | 139278 | 25883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012823.46901 | 2119825.72901 | 37.8013588613344 | -122.39977521873001 | (37.8013588613344, -122.39977521873) | ||
| 168373 | 168373 | 135089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 47 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010261.39064 | 2122348.4681700002 | 37.8081425174406 | -122.40881927081499 | (37.8081425174406, -122.408819270815) | |||
| 31948 | 31948 | 135088 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010288.509880001 | 2122353.59437 | 37.8081581116658 | -122.40872577909201 | (37.8081581116658, -122.408725779092) | ||||
| 141928 | 141928 | 25882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012807.84401 | 2119847.86501 | 37.801418770405505 | -122.39983084376999 | (37.8014187704055, -122.39983084377) | ||
| 29517 | 29517 | 135087 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010278.59779 | 2122338.55223 | 37.8081162545339 | -122.408759020708 | (37.8081162545339, -122.408759020708) | |||
| 145792 | 145792 | 25880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012790.91701 | 2119868.69801 | 37.8014750291394 | -122.399890882882 | (37.8014750291394, -122.399890882882) | ||
| 168722 | 168722 | 135086 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010304.534990001 | 2122344.59902 | 37.808134310218705 | -122.40866968476601 | (37.8081343102187, -122.408669684766) | ||||
| 73121 | 73121 | 135085 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010323.2303 | 2122334.05501 | 37.8081064060573 | -122.408604240196 | (37.8081064060573, -122.408604240196) | ||||
| 128742 | 128742 | 25879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012777.89601 | 2119890.8330099997 | 37.8015350805856 | -122.399937496957 | (37.8015350805856, -122.399937496957) | ||
| 34960 | 34960 | 135084 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010314.2182599995 | 2122318.99449 | 37.8080645489009 | -122.40863436569201 | (37.8080645489009, -122.408634365692) | |||
| 119397 | 119397 | 25878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012763.5730099995 | 2119911.66701 | 37.8015914871903 | -122.399988525233 | (37.8015914871903, -122.399988525233) | ||
| 128103 | 128103 | 25877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012751.85401 | 2119935.10401 | 37.80165518616639 | -122.400030725403 | (37.8016551861664, -122.400030725403) | ||
| 151224 | 151224 | 135083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010341.3497 | 2122324.71825 | 37.8080817844136 | -122.40854087398701 | (37.8080817844136, -122.408540873987) | ||||
| 64424 | 64424 | 135082 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010330.81932 | 2122308.7922400003 | 37.8080374658197 | -122.408576193042 | (37.8080374658197, -122.408576193042) | |||
| 121781 | 121781 | 25876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012733.62501 | 2119959.8440099997 | 37.801722099881395 | -122.400095544948 | (37.8017220998814, -122.400095544948) | ||
| 139503 | 139503 | 25875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012723.209009999 | 2119979.37501 | 37.801775146535604 | -122.400132961793 | (37.8017751465356, -122.400132961793) | ||
| 186776 | 186776 | 135081 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010360.32068 | 2122312.9728200003 | 37.8080505968189 | -122.408474390679 | (37.8080505968189, -122.408474390679) | ||||
| 126272 | 126272 | 25874 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012710.18801 | 2119997.60401 | 37.8018244729495 | -122.40017930176799 | (37.8018244729495, -122.400179301768) | ||
| 133811 | 133811 | 135080 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010349.21464 | 2122298.25404 | 37.8080095607584 | -122.408511787199 | (37.8080095607584, -122.408511787199) | |||
| 97787 | 97787 | 25873 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012698.46901 | 2120014.53101 | 37.8018702969661 | -122.40022104474899 | (37.8018702969661, -122.400221044749) | ||
| 178398 | 178398 | 135079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010377.54006 | 2122303.65444 | 37.808025975171105 | -122.40841414062 | (37.8080259751711, -122.40841414062) | ||||
| 73434 | 73434 | 135078 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010369.3857 | 2122286.4841400003 | 37.80797837316371 | -122.408441149043 | (37.8079783731637, -122.408441149043) | |||
| 83768 | 83768 | 27906 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | |||
| 112756 | 112756 | 25872 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012680.24001 | 2120040.57301 | 37.8019407855515 | -122.40028595615401 | (37.8019407855515, -122.400285956154) | ||
| 75529 | 75529 | 135077 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010393.83504 | 2122293.15944 | 37.8079980710226 | -122.40835700668998 | (37.8079980710226, -122.40835700669) | ||||
| 96679 | 96679 | 25871 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012660.709009999 | 2120071.82301 | 37.8020255014061 | -122.40035573926201 | (37.8020255014061, -122.400355739262) | ||
| 139514 | 139514 | 27905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015930.902000001 | 2112710.767 | 37.7819955470034 | -122.388525109177 | (37.7819955470034, -122.388525109177) | |||
| 33678 | 33678 | 135076 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010384.52328 | 2122278.10501 | 37.807956213866 | -122.408388169972 | (37.807956213866, -122.408388169972) | |||
| 75152 | 75152 | 27904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015934.027000001 | 2112727.434 | 37.7820414840201 | -122.388515461744 | (37.7820414840201, -122.388515461744) | |||
| 76154 | 76154 | 195239 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017229.97011 | 2097361.8640799997 | 37.739922608954394 | -122.38296233565 | (37.7399226089544, -122.38296233565) | ||||
| 122404 | 122404 | 25870 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012643.78201 | 2120092.65601 | 37.8020817598664 | -122.400415779263 | (37.8020817598664, -122.400415779263) | ||
| 18001 | 18001 | 27903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015937.152000001 | 2112771.705 | 37.78216321542121 | -122.388507741674 | (37.7821632154212, -122.388507741674) | |||
| 125897 | 125897 | 25869 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012630.76101 | 2120113.49001 | 37.802138238866796 | -122.40046230270399 | (37.8021382388668, -122.400462302704) | ||
| 130521 | 130521 | 135075 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010411.666669999 | 2122284.4263400002 | 37.8079750906313 | -122.408294679165 | (37.8079750906313, -122.408294679165) | ||||
| 149614 | 149614 | 195238 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6017232.2408 | 2097349.7546 | 37.7398894842228 | -122.382953641924 | (37.7398894842228, -122.382953641924) | ||||
| 33991 | 33991 | 211989 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 751 Junipero Serra Blvd | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991413.9184 | 2093039.12628 | 37.7265932181855 | -122.47190767821002 | (37.7265932181855, -122.47190767821) | |||
| 53184 | 53184 | 27902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.38849525296699 | (37.782239240724, -122.388495252967) | |||
| 61053 | 61053 | 135074 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010403.22449 | 2122267.85965 | 37.807929129896294 | -122.408322726326 | (37.8079291298963, -122.408322726326) | |||
| 70908 | 70908 | 195237 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017245.0547 | 2097350.40694 | 37.7398919834226 | -122.38290938175699 | (37.7398919834226, -122.382909381757) | ||||
| 109280 | 109280 | 11700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 121671 | 121671 | 25868 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012612.53201 | 2120139.53101 | 37.8022087245701 | -122.40052721450199 | (37.8022087245701, -122.400527214502) | ||
| 132166 | 132166 | 195881 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014862.619080001 | 2088902.1636299998 | 37.716562878860294 | -122.390556737105 | (37.7165628788603, -122.390556737105) | |||
| 104427 | 104427 | 27901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015942.36 | 2112820.142 | 37.7822965011504 | -122.38849310613999 | (37.7822965011504, -122.38849310614) | |||
| 130910 | 130910 | 195880 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014854.38836 | 2088918.94793 | 37.716608508652705 | -122.39058635897699 | (37.7166085086527, -122.390586358977) | |||
| 138776 | 138776 | 25867 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012598.209009999 | 2120160.36501 | 37.8022651309127 | -122.400578243689 | (37.8022651309127, -122.400578243689) | ||
| 142960 | 142960 | 113569 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 162122 | 162122 | 195236 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017248.0064199995 | 2097338.05613 | 37.7398582336715 | -122.382898316528 | (37.7398582336715, -122.382898316528) | ||||
| 174780 | 174780 | 135073 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010429.76812 | 2122274.19323 | 37.807948006662 | -122.40823131203001 | (37.807948006662, -122.40823131203) | ||||
| 62281 | 62281 | 135072 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010421.04395 | 2122258.5290599996 | 37.8079045082466 | -122.408260398818 | (37.8079045082466, -122.408260398818) | |||
| 82862 | 82862 | 113568 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 87036 | 87036 | 27900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | |||
| 87440 | 87440 | 25866 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012586.49001 | 2120179.89601 | 37.8023181047385 | -122.400620170198 | (37.8023181047385, -122.400620170198) | ||
| 163339 | 163339 | 135128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 7ft | 6009778.15443 | 2122482.07693 | 37.808482294798104 | -122.410501083081 | (37.8084822947981, -122.410501083081) | |||
| 184470 | 184470 | 195879 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014843.010980001 | 2088936.2451799999 | 37.7166553723252 | -122.390626893234 | (37.7166553723252, -122.390626893234) | |||
| 189069 | 189069 | 195235 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017260.82922 | 2097339.16357 | 37.7398619829554 | -122.382854057268 | (37.7398619829554, -122.382854057268) | ||||
| 3453 | 3453 | 13461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6013807.91636 | 2116979.13322 | 37.793597613798205 | -122.39616895543199 | (37.7935976137982, -122.396168955432) | |||
| 14456 | 14456 | 6537 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017269.15486 | 2097321.24148 | 37.7398132324937 | -122.38282402351999 | (37.7398132324937, -122.38282402352) | |||
| 48073 | 48073 | 143402 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008574.2042 | 2111975.0324 | 37.779564965412895 | -122.413923936749 | (37.7795649654129, -122.413923936749) | |||
| 52775 | 52775 | 195878 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014756.78586 | 2089043.98437 | 37.716946419018 | -122.39093245857799 | (37.716946419018, -122.390932458578) | |||
| 78967 | 78967 | 25865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012565.65701 | 2120204.63501 | 37.8023848701418 | -122.400694001959 | (37.8023848701418, -122.400694001959) | ||
| 80237 | 80237 | 113567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 106855 | 106855 | 40577 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 116108 | 116108 | 27899 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015946.527000001 | 2112865.975 | 37.7824225791883 | -122.388481890173 | (37.7824225791883, -122.388481890173) | |||
| 135009 | 135009 | 135071 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010449.38794 | 2122264.82595 | 37.8079233850293 | -122.408162751324 | (37.8079233850293, -122.408162751324) | ||||
| 149057 | 149057 | 195566 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 120 Brannan St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015573.94786 | 2113364.80152 | 37.783771590531 | -122.389805715084 | (37.783771590531, -122.389805715084) | |||
| 158967 | 158967 | 195764 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013647.14727 | 2110149.40649 | 37.7748358106465 | -122.39624633850401 | (37.7748358106465, -122.396246338504) | |||
| 166646 | 166646 | 135127 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009796.651769999 | 2122491.2642 | 37.8085085577008 | -122.41043771682399 | (37.8085085577008, -122.410437716824) | |||
| 180827 | 180827 | 195716 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6014310.53841 | 2110782.68 | 37.776611528336794 | -122.39399585342899 | (37.7766115283368, -122.393995853429) | |||
| 8573 | 8573 | 13460 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6013821.04796 | 2116966.87557 | 37.793564687813 | -122.396122659246 | (37.793564687813, -122.396122659246) | |||
| 15501 | 15501 | 6536 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017286.0724599995 | 2097321.35634 | 37.739814482555204 | -122.382765536994 | (37.7398144825552, -122.382765536994) | |||
| 22902 | 22902 | 195565 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 120 Brannan St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015589.6474 | 2113378.76016 | 37.783810788393005 | -122.38975237539101 | (37.783810788393, -122.389752375391) | |||
| 28032 | 28032 | 195715 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014328.33682 | 2110800.56019 | 37.7766616124839 | -122.393935535005 | (37.7766616124839, -122.393935535005) | |||
| 31717 | 31717 | 135070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010442.39712 | 2122245.83866 | 37.8078708592274 | -122.4081856049 | (37.8078708592274, -122.4081856049) | |||
| 31864 | 31864 | 195877 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014742.2889 | 2089063.14086 | 37.7169982145749 | -122.390983906081 | (37.7169982145749, -122.390983906081) | |||
| 36273 | 36273 | 195763 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013664.42732 | 2110165.42428 | 37.774880753388 | -122.396187685616 | (37.774880753388, -122.396187685616) | |||
| 47889 | 47889 | 135126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6009794.33207 | 2122480.55113 | 37.808479012257706 | -122.410444987853 | (37.8084790122577, -122.410444987853) | |||
| 95284 | 95284 | 27898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015948.61 | 2112884.725 | 37.7824741779053 | -122.388475992994 | (37.7824741779053, -122.388475992994) | |||
| 123340 | 123340 | 113566 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 125811 | 125811 | 40580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 143314 | 143314 | 25864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012543.52101 | 2120234.5830099997 | 37.802465865475604 | -122.40077270907301 | (37.8024658654756, -122.400772709073) | ||
| 149379 | 149379 | 143401 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008587.0944 | 2111954.981 | 37.779510632978 | -122.41387792508002 | (37.779510632978, -122.41387792508) | |||
| 162027 | 162027 | 250287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008296.47872 | 2112132.36375 | 37.779981358185296 | -122.414895849576 | (37.7799813581853, -122.414895849576) | |||
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 2048 | 2048 | 143400 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | 6008592.8234 | 2111992.2193 | 37.779613202213994 | -122.41386074083401 | (37.779613202214, -122.413860740834) | |||
| 16465 | 16465 | 6535 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017290.8428 | 2097308.51335 | 37.739779481837296 | -122.382748149519 | (37.7397794818373, -122.382748149519) | |||
| 23354 | 23354 | 13459 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4X4 | 6013815.44637 | 2117053.59537 | 37.7938024883478 | -122.39614812174801 | (37.7938024883478, -122.396148121748) | |||
| 32725 | 32725 | 195762 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6013681.37567 | 2110182.13759 | 37.7749275873853 | -122.39613022884 | (37.7749275873853, -122.39613022884) | |||
| 34886 | 34886 | 135069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010465.71952 | 2122256.12348 | 37.8079004046485 | -122.408105617404 | (37.8079004046485, -122.408105617404) |
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");