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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93209 | 93209 | 65564 | Permitted Site 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.36988228287599 | (37.8103949467147, -122.369882282876) | |||
| 90246 | 90246 | 65563 | Permitted Site 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.36904110347099 | (37.8103107984086, -122.369041103471) | |||
| 143067 | 143067 | 65565 | Permitted Site 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | |||
| 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) | ||||
| 50106 | 50106 | 28049 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 80340 | 80340 | 28045 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 87468 | 87468 | 28050 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 88591 | 88591 | 28047 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 89860 | 89860 | 28053 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 95965 | 95965 | 28046 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 112403 | 112403 | 28055 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 121432 | 121432 | 28052 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 124163 | 124163 | 28048 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 143432 | 143432 | 28051 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 144070 | 144070 | 28054 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 87727 | 87727 | 65566 | Permitted Site 1 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | |||
| 121276 | 121276 | 66415 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1991 12:00:00 AM | Permit Number 29546 | 6006760.29248409 | 2122608.12240598 | 37.808658736106 | -122.42095420122601 | (37.808658736106, -122.420954201226) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 80909 | 80909 | 84931 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49345 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | ||||
| 92486 | 92486 | 84934 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49345 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | |||
| 98539 | 98539 | 84933 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49345 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | ||||
| 98748 | 98748 | 84932 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 80433 | 80433 | 104262 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 87816 | 87816 | 104263 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 97396 | 97396 | 104266 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 99537 | 99537 | 104265 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 142864 | 142864 | 104264 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 132292 | 132292 | 134950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008530.77029 | 2122432.69748 | 37.808276702577 | -122.414814516693 | (37.808276702577, -122.414814516693) | |||
| 63105 | 63105 | 134949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008502.47143 | 2122430.5276099998 | 37.8082691545757 | -122.414912299066 | (37.8082691545757, -122.414912299066) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 182204 | 182204 | 134948 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008484.71937 | 2122427.98044 | 37.80826116317839 | -122.41497355457899 | (37.8082611631784, -122.414973554579) | |||
| 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) | |||
| 149769 | 149769 | 41638 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008374.705019999 | 2122409.49865 | 37.808204234292 | -122.415352980375 | (37.808204234292, -122.415352980375) | |
| 49889 | 49889 | 41643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008364.2633 | 2122408.61155 | 37.8082012116738 | -122.41538905396001 | (37.8082012116738, -122.41538905396) | |
| 122115 | 122115 | 30568 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.41421491247101 | (37.8082195561589, -122.414214912471) | ||||
| 73984 | 73984 | 41642 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008347.815880001 | 2122407.53263 | 37.80819732479971 | -122.415445898318 | (37.8081973247997, -122.415445898318) | |
| 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) | |||
| 49085 | 49085 | 134960 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009191.48002 | 2122404.19262 | 37.8082355370081 | -122.41252593002399 | (37.8082355370081, -122.412525930024) | |||
| 81393 | 81393 | 28280 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2799 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008221.595290001 | 2122402.06867 | 37.8081752269627 | -122.415882331929 | (37.8081752269627, -122.415882331929) | |||
| 53999 | 53999 | 41641 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008318.31427 | 2122401.37399 | 37.8081787565193 | -122.415547560374 | (37.8081787565193, -122.415547560374) | |
| 52303 | 52303 | 41640 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008303.89341 | 2122398.99555 | 37.808171415331294 | -122.415597299176 | (37.8081714153313, -122.415597299176) | |
| 43638 | 43638 | 41639 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008290.6132 | 2122398.32381 | 37.8081688244054 | -122.41564321135799 | (37.8081688244054, -122.415643211358) | |
| 148039 | 148039 | 134947 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008187.16664 | 2122385.16272 | 37.808126871914 | -122.41600028361 | (37.808126871914, -122.41600028361) | |||
| 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) | |||
| 22914 | 22914 | 134946 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008140.23343 | 2122378.4713 | 37.808105860161795 | -122.41616223440501 | (37.8081058601618, -122.416162234405) |
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");