Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100902 | 100902 | 27706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | ||||
| 107973 | 107973 | 27707 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | ||||
| 185575 | 185575 | 135176 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6009043.293819999 | 2122602.08116 | 37.8087705715725 | -122.41305277088999 | (37.8087705715725, -122.41305277089) | |||
| 62361 | 62361 | 135174 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6009066.35805 | 2122600.86777 | 37.808768534616604 | -122.412972864314 | (37.8087685346166, -122.412972864314) | |||
| 56560 | 56560 | 135172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6009083.4055699995 | 2122596.81093 | 37.808758352483295 | -122.412913579207 | (37.8087583524833, -122.412913579207) | |||
| 31802 | 31802 | 135170 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6009098.25007 | 2122594.28253 | 37.80875224337429 | -122.412862026464 | (37.8087522433743, -122.412862026464) | |||
| 171854 | 171854 | 135168 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6009115.60188 | 2122586.88161 | 37.8087328962651 | -122.41280145171999 | (37.8087328962651, -122.41280145172) | |||
| 158721 | 158721 | 135169 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009098.34948 | 2122580.92994 | 37.808715586113294 | -122.41286073775801 | (37.8087155861133, -122.412860737758) | |||
| 132860 | 132860 | 135175 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009042.10981 | 2122580.5962900002 | 37.808711513081 | -122.41305534834801 | (37.808711513081, -122.413055348348) | |||
| 164188 | 164188 | 135173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009065.91093 | 2122578.9974 | 37.8087084590055 | -122.412972864333 | (37.8087084590055, -122.412972864333) | |||
| 186981 | 186981 | 135171 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6009081.537769999 | 2122578.30683 | 37.808707440053894 | -122.412918734125 | (37.8087074400539, -122.412918734125) | |||
| 136976 | 136976 | 135167 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009297.39065 | 2122561.1634400003 | 37.8086724825285 | -122.41217049819201 | (37.8086724825285, -122.412170498192) | ||||
| 172987 | 172987 | 135165 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009319.750469999 | 2122555.32253 | 37.808657699448105 | -122.41209270231 | (37.8086576994481, -122.41209270231) | ||||
| 76952 | 76952 | 135177 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009002.92609 | 2122558.40528 | 37.8086483824759 | -122.41318938508199 | (37.8086483824759, -122.413189385082) | |||
| 46489 | 46489 | 135163 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | ||||
| 69245 | 69245 | 135161 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009360.267630001 | 2122546.84411 | 37.808636693089106 | -122.411951881091 | (37.8086366930891, -122.411951881091) | ||||
| 60061 | 60061 | 135166 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6009296.71843 | 2122542.1924 | 37.8086203551155 | -122.412171482933 | (37.8086203551155, -122.412171482933) | |||
| 166962 | 166962 | 135178 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008933.56816 | 2122548.59369 | 37.8086175483309 | -122.41342872435 | (37.8086175483309, -122.41342872435) | |||
| 64496 | 64496 | 135164 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6009318.816980001 | 2122537.49043 | 37.808608684618605 | -122.412094671852 | (37.8086086846186, -122.412094671852) | |||
| 52747 | 52747 | 135162 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6009337.24139 | 2122533.99681 | 37.8086001257557 | -122.41203066168998 | (37.8086001257557, -122.41203066169) | |||
| 132949 | 132949 | 135179 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008885.320280001 | 2122540.99865 | 37.808593985178206 | -122.41359516278999 | (37.8085939851782, -122.41359516279) | |||
| 61001 | 61001 | 135157 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009451.25096 | 2122529.40055 | 37.808593901544796 | -122.411635772999 | (37.8085939015448, -122.411635772999) | ||||
| 171105 | 171105 | 135160 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6009356.48989 | 2122529.06979 | 37.8085876773375 | -122.411963698174 | (37.8085876773375, -122.411963698174) | |||
| 52903 | 52903 | 135180 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008860.7937 | 2122537.90132 | 37.8085841034484 | -122.413679824982 | (37.8085841034484, -122.413679824982) | |||
| 59638 | 59638 | 135156 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009480.72759 | 2122523.69804 | 37.808579897317706 | -122.411533357278 | (37.8085798973177, -122.411533357278) | ||||
| 48102 | 48102 | 135159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6009379.72618 | 2122524.34495 | 37.8085760077391 | -122.41188294806001 | (37.8085760077391, -122.41188294806) | |||
| 167870 | 167870 | 135181 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008836.81707 | 2122534.51599 | 37.8085734617661 | -122.41376256350401 | (37.8085734617661, -122.413762563504) | |||
| 137623 | 137623 | 135158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6009395.60812 | 2122521.7536 | 37.808569783535106 | -122.41182780071199 | (37.8085697835351, -122.411827800712) | |||
| 67415 | 67415 | 135155 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009496.8532 | 2122519.11823 | 37.808568226806706 | -122.41147722608801 | (37.8085682268067, -122.411477226088) | ||||
| 184904 | 184904 | 135153 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009517.81435 | 2122514.4396599997 | 37.8085565563141 | -122.41140435313 | (37.8085565563141, -122.41140435313) | ||||
| 157993 | 157993 | 135137 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009675.17252 | 2122510.18452 | 37.8085536973592 | -122.41085946829901 | (37.8085536973592, -122.410859468299) | ||||
| 161852 | 161852 | 135151 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009534.78747 | 2122509.55925 | 37.8085441079032 | -122.411345267671 | (37.8085441079032, -122.411345267671) | ||||
| 152551 | 152551 | 135133 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009697.90214 | 2122506.13355 | 37.808543848874 | -122.410780519498 | (37.808543848874, -122.410780519498) | |||
| 174362 | 174362 | 135149 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009556.32302 | 2122505.1526099998 | 37.808533216194895 | -122.411270426102 | (37.8085332161949, -122.411270426102) | ||||
| 68718 | 68718 | 135129 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009719.11313 | 2122501.21683 | 37.8085315380587 | -122.4107067652 | (37.8085315380587, -122.4107067652) | |||
| 157851 | 157851 | 135147 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009572.95679 | 2122501.76157 | 37.8085248381209 | -122.411212620383 | (37.8085248381209, -122.411212620383) | ||||
| 173340 | 173340 | 135136 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009674.61624 | 2122497.64189 | 37.808519227256106 | -122.410860507034 | (37.8085192272561, -122.410860507034) | ||||
| 33779 | 33779 | 135154 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6009495.3394 | 2122500.7310200003 | 37.80851765524471 | -122.41148116512 | (37.8085176552447, -122.41148116512) | |||
| 34258 | 34258 | 135145 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | ||||
| 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) | |||
| 160660 | 160660 | 135152 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6009514.303780001 | 2122495.80991 | 37.808505206806004 | -122.411415185469 | (37.808505206806, -122.411415185469) | |||
| 173081 | 173081 | 135125 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009814.02361 | 2122489.41499 | 37.8085044540716 | -122.410377465851 | (37.8085044540716, -122.410377465851) | |||
| 68996 | 68996 | 135143 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009614.4871 | 2122492.8917400003 | 37.8085028128125 | -122.41106826569799 | (37.8085028128125, -122.411068265698) | ||||
| 177887 | 177887 | 135132 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009696.09091 | 2122490.92652 | 37.8085019926339 | -122.41078571309299 | (37.8085019926339, -122.410785713093) | |||
| 58970 | 58970 | 135150 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6009533.57548 | 2122492.01614 | 37.8084958709589 | -122.41134822196301 | (37.8084958709589, -122.411348221963) | |||
| 173108 | 173108 | 135141 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009636.62254 | 2122489.1519 | 37.808493785432795 | -122.410991395247 | (37.8084937854328, -122.410991395247) | ||||
| 68355 | 68355 | 135148 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6009553.896240001 | 2122488.10727 | 37.808486277873605 | -122.41127761976101 | (37.8084862778736, -122.411277619761) | |||
| 53095 | 53095 | 135139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009651.5635 | 2122485.8577099997 | 37.808485578225294 | -122.410939454894 | (37.8084855782253, -122.410939454894) | ||||
| 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) | |||
| 169413 | 169413 | 135146 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6009571.76938 | 2122485.2677 | 37.8084794835077 | -122.411215563861 | (37.8084794835077, -122.411215563861) | |||
| 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) | |||
| 86526 | 86526 | 107905 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2650 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008717.0 | 2122501.0 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | ||||
| 93860 | 93860 | 107908 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2650 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008717.0 | 2122501.0 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | |||||
| 113513 | 113513 | 107906 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2650 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008717.0 | 2122501.0 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | |||||
| 138855 | 138855 | 107907 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2650 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008717.0 | 2122501.0 | 37.8084747060674 | -122.414174852603 | (37.8084747060674, -122.414174852603) | |||||
| 150944 | 150944 | 135124 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009811.99757 | 2122478.3969 | 37.8084740875856 | -122.41038369905701 | (37.8084740875856, -122.410383699057) | |||
| 160771 | 160771 | 135135 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009673.362319999 | 2122480.3312 | 37.808471626139706 | -122.410863623176 | (37.8084716261397, -122.410863623176) | |||
| 132500 | 132500 | 135144 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6009592.59224 | 2122479.55439 | 37.808464963961896 | -122.411143096484 | (37.8084649639619, -122.411143096484) | |||
| 73408 | 73408 | 135131 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009694.30992 | 2122477.21308 | 37.8084642391119 | -122.410790907582 | (37.8084642391119, -122.410790907582) | |||
| 29183 | 29183 | 135142 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6009611.73281 | 2122475.6117 | 37.8084552117099 | -122.411076576336 | (37.8084552117099, -122.411076576336) | |||
| 37911 | 37911 | 135182 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008631.7515199995 | 2122495.19515 | 37.8084539787355 | -122.414469468391 | (37.8084539787355, -122.414469468391) | |||
| 64005 | 64005 | 135140 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6009635.03806 | 2122470.3531 | 37.8084420798001 | -122.410995550124 | (37.8084420798001, -122.410995550124) | |||
| 183446 | 183446 | 135183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008602.26751 | 2122490.0027099997 | 37.8084380652267 | -122.41457113855101 | (37.8084380652267, -122.414571138551) | |||
| 45068 | 45068 | 135138 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6009649.7092699995 | 2122468.55895 | 37.808437976201404 | -122.410944649373 | (37.8084379762014, -122.410944649373) | |||
| 30948 | 30948 | 135123 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009926.6128 | 2122461.4108700003 | 37.8084338726024 | -122.409985839882 | (37.8084338726024, -122.409985839882) | |||
| 45584 | 45584 | 135134 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009670.63247 | 2122464.2458099998 | 37.808427306630605 | -122.41087193379101 | (37.8084273066306, -122.410871933791) | |||
| 187268 | 187268 | 135184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008568.3734 | 2122486.00433 | 37.8084251824404 | -122.41468815562901 | (37.8084251824404, -122.414688155629) | |||
| 183203 | 183203 | 135121 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009946.94212 | 2122457.40911 | 37.808424024128605 | -122.40991520173 | (37.8084240241286, -122.40991520173) | |||
| 24870 | 24870 | 135130 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6009691.87426 | 2122460.8233 | 37.8084191003246 | -122.410798178599 | (37.8084191003246, -122.410798178599) | |||
| 153229 | 153229 | 135118 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009967.89586 | 2122454.5901099998 | 37.8084174581688 | -122.40984248615601 | (37.8084174581688, -122.409842486156) | |||
| 155199 | 155199 | 135115 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009986.16168 | 2122452.4240599996 | 37.8084125343708 | -122.409779119036 | (37.8084125343708, -122.409779119036) | |||
| 179835 | 179835 | 135185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008537.7982 | 2122481.6622900004 | 37.80841154241521 | -122.4147936623 | (37.8084115424152, -122.4147936623) | |||
| 100003 | 100003 | 85055 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 77X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2007 12:00:00 AM | Permit Number 49393 | 6008831.0 | 2122475.0 | 37.808409719239705 | -122.413778482528 | (37.8084097192397, -122.413778482528) | |||
| 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) | ||||
| 48824 | 48824 | 135113 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6010004.1150400005 | 2122449.66633 | 37.8084059684239 | -122.40971679148998 | (37.8084059684239, -122.40971679149) | |||
| 184685 | 184685 | 135122 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009935.99448 | 2122450.45895 | 37.8084043271757 | -122.40995259822901 | (37.8084043271757, -122.409952598229) | |||
| 162863 | 162863 | 135186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008499.160630001 | 2122476.10539 | 37.808394113568795 | -122.414926985002 | (37.8083941135688, -122.414926985002) | |||
| 173160 | 173160 | 135120 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009955.717680001 | 2122446.17053 | 37.8083936576166 | -122.409884037512 | (37.8083936576166, -122.409884037512) | |||
| 48735 | 48735 | 135110 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010045.12861 | 2122444.34572 | 37.808393657599 | -122.40957447647499 | (37.808393657599, -122.409574476475) | |||
| 63360 | 63360 | 135117 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009974.5771699995 | 2122443.69332 | 37.8083879127434 | -122.409818593865 | (37.8083879127434, -122.409818593865) | |||
| 36281 | 36281 | 135107 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010064.28228 | 2122441.56354 | 37.808387091666205 | -122.40950799321999 | (37.8083870916662, -122.40950799322) | |||
| 175738 | 175738 | 135187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008466.65712 | 2122472.35446 | 37.8083819880082 | -122.415039206912 | (37.8083819880082, -122.415039206912) | |||
| 47373 | 47373 | 135112 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6010033.25655 | 2122436.21857 | 37.8083706772342 | -122.409614989141 | (37.8083706772342, -122.409614989141) | |||
| 161169 | 161169 | 134958 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009185.01162 | 2122452.80097 | 37.8083686402722 | -122.412551754077 | (37.8083686402722, -122.412551754077) | |||
| 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) | ||||
| 169813 | 169813 | 135109 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010051.49773 | 2122432.85725 | 37.808362470021 | -122.40955162293301 | (37.808362470021, -122.409551622933) | |||
| 164791 | 164791 | 135188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008435.19986 | 2122465.54658 | 37.8083615275283 | -122.415147591413 | (37.8083615275283, -122.415147591413) | |||
| 173636 | 173636 | 135104 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010089.2658 | 2122430.29329 | 37.8083575462248 | -122.40942073468099 | (37.8083575462248, -122.409420734681) | |||
| 170740 | 170740 | 135189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102 Jefferson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008412.99212 | 2122463.79322 | 37.8083554652029 | -122.415224323337 | (37.8083554652029, -122.415224323337) | |||
| 153569 | 153569 | 135106 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6010072.1454 | 2122429.74587 | 37.8083550838852 | -122.409479946046 | (37.8083550838852, -122.409479946046) | |||
| 32282 | 32282 | 135102 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010114.95326 | 2122424.09004 | 37.8083419528727 | -122.409331397845 | (37.8083419528727, -122.409331397845) | |||
| 133330 | 133330 | 135101 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010136.77661 | 2122419.75891 | 37.8083312833417 | -122.40925556609301 | (37.8083312833417, -122.409255566093) | |||
| 56314 | 56314 | 135119 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6009951.286669999 | 2122420.2562 | 37.808322255030106 | -122.40989754175399 | (37.8083222550301, -122.409897541754) | |||
| 47291 | 47291 | 134953 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008630.92798 | 2122446.98018 | 37.8083215463747 | -122.41446890452299 | (37.8083215463747, -122.414468904523) | |||
| 139028 | 139028 | 135116 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6009971.32821 | 2122416.85808 | 37.8083140478199 | -122.409827942302 | (37.8083140478199, -122.409827942302) | |||
| 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) | ||||
| 133531 | 133531 | 134952 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008606.497930001 | 2122443.4372900003 | 37.8083104460454 | -122.414553200668 | (37.8083104460454, -122.414553200668) | |||
| 176363 | 176363 | 135114 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6009988.36934 | 2122413.52121 | 37.808305840604206 | -122.409768730958 | (37.8083058406042, -122.409768730958) | |||
| 66137 | 66137 | 134959 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009188.56229 | 2122429.4929 | 37.808304841455104 | -122.41253781726601 | (37.8083048414551, -122.412537817266) | |||
| 185306 | 185306 | 134951 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008585.64556 | 2122440.14481 | 37.8083002342206 | -122.41462513296301 | (37.8083002342206, -122.414625132963) |
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");