Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 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) | ||||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |
| 80184 | 80184 | 85053 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2007 12:00:00 AM | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.808053775378795 | -122.413250320783 | (37.8080537753788, -122.413250320783) | |||
| 107513 | 107513 | 85054 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.808053775378795 | -122.413250320783 | (37.8080537753788, -122.413250320783) | ||||
| 28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
| 126487 | 126487 | 21825 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2742 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008296.21715 | 2122224.91462 | 37.8076930017751 | -122.415611531478 | (37.8076930017751, -122.415611531478) | |||
| 137123 | 137123 | 43871 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 43487 | 6007273.68946 | 2122239.0795400003 | 37.8076743645534 | -122.41915124633101 | (37.8076743645534, -122.419151246331) | |||
| 81263 | 81263 | 21827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 88253 | 88253 | 21828 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 101004 | 101004 | 21829 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 111315 | 111315 | 21822 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2734 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 111367 | 111367 | 21821 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2734 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 87167 | 87167 | 100097 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 90647 | 90647 | 100096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 91649 | 91649 | 100098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 110150 | 110150 | 100101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 126698 | 126698 | 100099 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 140481 | 140481 | 100100 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 77803 | 77803 | 86893 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | ||
| 106093 | 106093 | 86891 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 110750 | 110750 | 86890 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 129146 | 129146 | 86892 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 85030 | 85030 | 53186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495@ Beach Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2006 12:00:00 AM | Permit Number 49104 | 6006849.69447935 | 2122196.72065308 | 37.8075341715403 | -122.42061557585698 | (37.8075341715403, -122.420615575857) | |||
| 116779 | 116779 | 53187 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2006 12:00:00 AM | Permit Number 49104 | 6006849.69447935 | 2122196.72065308 | 37.8075341715403 | -122.42061557585698 | (37.8075341715403, -122.420615575857) | |||
| 117498 | 117498 | 92896 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 226 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | 6009506.8 | 2122067.0 | 37.807327381635496 | -122.411410840149 | (37.8073273816355, -122.411410840149) | |||
| 83311 | 83311 | 27705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 94559 | 94559 | 27704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 113619 | 113619 | 65287 | Permitted Site 1 | Tree(s) :: 17 | 2701 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1989 12:00:00 AM | Permit Number 28099 | 6008264.52815506 | 2122079.849214 | 37.8072929076287 | -122.41571092092501 | (37.8072929076287, -122.415710920925) | |||
| 86274 | 86274 | 21818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2693 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008270.977530001 | 2122039.96134 | 37.80718374817771 | -122.415685775277 | (37.8071837481777, -122.415685775277) | |||
| 164736 | 164736 | 44354 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 4 | Permit Number 43731 | 6008055.5377 | 2122018.11955 | 37.8071116632331 | -122.41642980519899 | (37.8071116632331, -122.416429805199) | ||
| 48605 | 48605 | 44353 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | Permit Number 43731 | 6008040.41682 | 2122016.3517 | 37.8071059588299 | -122.416482009051 | (37.8071059588299, -122.416482009051) | ||
| 186009 | 186009 | 44352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 5 | Permit Number 43731 | 6008017.89414 | 2122013.61694 | 37.8070971832479 | -122.416559759923 | (37.8070971832479, -122.416559759923) | ||
| 119400 | 119400 | 107689 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2801 JONES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774455 | 6007799.0 | 2122017.1 | 37.80709443404471 | -122.41731753833099 | (37.8070944340447, -122.417317538331) | ||
| 72221 | 72221 | 44358 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 80513 | 80513 | 44361 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 84339 | 84339 | 44355 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 101218 | 101218 | 44359 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 108916 | 108916 | 44356 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 117341 | 117341 | 44360 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 25747 | 25747 | 44351 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | Permit Number 43731 | 6008003.5653099995 | 2122011.35371 | 37.8070901631447 | -122.41660918757601 | (37.8070901631447, -122.416609187576) | ||
| 112542 | 112542 | 43944 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2801 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43532 | 6007788.11286909 | 2122015.59896639 | 37.807089700059706 | -122.41735510920401 | (37.8070897000597, -122.417355109204) | ||||
| 37365 | 37365 | 44357 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 2 | Permit Number 43731 | 6007993.12258 | 2122010.7684299997 | 37.807087968806 | -122.416645285459 | (37.807087968806, -122.416645285459) | ||
| 86613 | 86613 | 40622 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2675 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.80702213595829 | -122.415657237402 | (37.8070221359583, -122.415657237402) | |||
| 106377 | 106377 | 40625 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2675 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.80702213595829 | -122.415657237402 | (37.8070221359583, -122.415657237402) | |||
| 115418 | 115418 | 40621 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2675 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.80702213595829 | -122.415657237402 | (37.8070221359583, -122.415657237402) | |||
| 140631 | 140631 | 40623 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2675 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.80702213595829 | -122.415657237402 | (37.8070221359583, -122.415657237402) | |||
| 145515 | 145515 | 40624 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2675 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 14 | 3x3 | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.80702213595829 | -122.415657237402 | (37.8070221359583, -122.415657237402) | |
| 77463 | 77463 | 21815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 85758 | 85758 | 21814 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 160299 | 160299 | 58305 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1990 12:00:00 AM | 12 | Permit Number 29301 | 6007350.5652 | 2121996.5002 | 37.807012632588204 | -122.418867983279 | (37.8070126325882, -122.418867983279) | ||
| 128123 | 128123 | 21817 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2683 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008202.62871 | 2121958.17011 | 37.8069553278433 | -122.41591651610001 | (37.8069553278433, -122.4159165161) | |||
| 104083 | 104083 | 21816 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2669 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008202.59065 | 2121958.17011 | 37.806955325703605 | -122.415916647815 | (37.8069553257036, -122.415916647815) | |||
| 80999 | 80999 | 21801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 25 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 100165 | 100165 | 21796 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 121127 | 121127 | 21802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 121333 | 121333 | 21799 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 11 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 126832 | 126832 | 21800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 145338 | 145338 | 21798 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 4592 | 4592 | 129653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009793.38554 | 2121873.20249 | 37.806811331947706 | -122.410405350227 | (37.8068113319477, -122.410405350227) | |||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 79385 | 79385 | 110987 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 81572 | 81572 | 110995 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 86422 | 86422 | 52076 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 86652 | 86652 | 110988 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 89318 | 89318 | 110998 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 94805 | 94805 | 110984 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 106836 | 106836 | 110991 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 108455 | 108455 | 110989 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245x North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776694 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | ||
| 114327 | 114327 | 110996 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 116009 | 116009 | 110992 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) |
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");