trees
39,840 rows where qLegalStatus_id = 7 sorted by Latitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57815 | 65566 | Permitted Site 7 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | 2 | 9 | 62 | 37 | ||||
98286 | 27706 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | 1 | 10 | 308 | 23 | |||||
125862 | 27707 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1801 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | 1 | 10 | 308 | 23 | |||||
1742 | 28048 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
9221 | 28049 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
52938 | 28045 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
63150 | 28050 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
69024 | 28053 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
69445 | 28047 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
79601 | 28046 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
135463 | 28055 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
152629 | 28052 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
172485 | 28054 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
183471 | 28051 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
169670 | 66415 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1991 12:00:00 AM | Permit Number 29546 | 6006760.29248409 | 2122608.12240598 | 37.808658736106 | -122.420954201226 | (37.808658736106, -122.420954201226) | 1 | 1 | 28858 | 32 | |||||
109666 | 85055 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 77X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2007 12:00:00 AM | Permit Number 49393 | 6008831 | 2122475 | 37.8084097192397 | -122.413778482528 | (37.8084097192397, -122.413778482528) | 3 | 1 | 10 | 308 | 23 | |||
53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
78816 | 84934 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||
99636 | 84933 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
102582 | 84932 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||||
165158 | 30568 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.414214912471 | (37.8082195561589, -122.414214912471) | 3 | 1 | 10 | 308 | 23 | ||||
52035 | 28280 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2799 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6008221.59529 | 2122402.06867 | 37.8081752269627 | -122.415882331929 | (37.8081752269627, -122.415882331929) | 3 | 1 | 10 | 308 | 23 | |||
41521 | 85053 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2007 12:00:00 AM | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.8080537753788 | -122.413250320783 | (37.8080537753788, -122.413250320783) | 3 | 1 | 10 | 308 | 23 | |||
117601 | 85054 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.8080537753788 | -122.413250320783 | (37.8080537753788, -122.413250320783) | 3 | 1 | 10 | 308 | 23 | ||||
33374 | 21825 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2742 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008296.21715 | 2122224.91462 | 37.8076930017751 | -122.415611531478 | (37.8076930017751, -122.415611531478) | 5 | 1 | 10 | 308 | 23 | |||
42282 | 21827 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
64479 | 21828 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
102016 | 21829 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
142587 | 21821 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2734 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
147020 | 21822 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2734 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
23589 | 100099 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
57950 | 100097 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
64071 | 100096 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
81454 | 100098 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
122906 | 100101 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
171998 | 100100 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
121257 | 86891 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
136340 | 86890 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
59702 | 53186 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495@ Beach Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2006 12:00:00 AM | Permit Number 49104 | 6006849.69447935 | 2122196.72065308 | 37.8075341715403 | -122.420615575857 | (37.8075341715403, -122.420615575857) | 5 | 1 | 1 | 28858 | 32 | |||
169999 | 53187 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2006 12:00:00 AM | Permit Number 49104 | 6006849.69447935 | 2122196.72065308 | 37.8075341715403 | -122.420615575857 | (37.8075341715403, -122.420615575857) | 5 | 1 | 1 | 28858 | 32 | |||
152048 | 92896 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 226 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | 6009506.8 | 2122067 | 37.8073273816355 | -122.411410840149 | (37.8073273816355, -122.411410840149) | 3 | 1 | 10 | 308 | 23 | |||
49192 | 27705 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
85583 | 27704 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
141144 | 65287 | Permitted Site 7 | Tree(s) :: 17 | 2701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | Permit Number 28099 | 6008264.52815506 | 2122079.849214 | 37.8072929076287 | -122.415710920925 | (37.8072929076287, -122.415710920925) | 5 | 1 | 10 | 308 | 23 | |||
70668 | 21818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2693 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008270.97753 | 2122039.96134 | 37.8071837481777 | -122.415685775277 | (37.8071837481777, -122.415685775277) | 5 | 1 | 10 | 308 | 23 | |||
155421 | 107689 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2801 JONES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774455 | 6007799 | 2122017.1 | 37.8070944340447 | -122.417317538331 | (37.8070944340447, -122.417317538331) | 5 | 1 | 10 | 308 | 23 | ||
16280 | 44358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
53013 | 44361 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
55191 | 44355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
98570 | 44359 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
116805 | 44356 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
151949 | 44360 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
143711 | 43944 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2801 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43532 | 6007788.11286909 | 2122015.59896639 | 37.8070897000597 | -122.417355109204 | (37.8070897000597, -122.417355109204) | 5 | 1 | 10 | 308 | 23 | ||||
61990 | 40622 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
123485 | 40625 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
138759 | 40621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
179646 | 40623 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
193960 | 40624 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 14 | 3x3 | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |
28833 | 21815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | 5 | 1 | 10 | 308 | 23 | |||
65967 | 21814 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2653 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | 5 | 1 | 10 | 308 | 23 | |||
26107 | 21817 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2683 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008202.62871 | 2121958.17011 | 37.8069553278433 | -122.4159165161 | (37.8069553278433, -122.4159165161) | 5 | 1 | 10 | 308 | 23 | |||
122892 | 21816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2669 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008202.59065 | 2121958.17011 | 37.8069553257036 | -122.415916647815 | (37.8069553257036, -122.415916647815) | 5 | 1 | 10 | 308 | 23 | |||
33942 | 21800 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
45806 | 21801 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 25 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
101924 | 21796 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
165088 | 21802 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
166510 | 21799 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 11 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
193305 | 21798 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
16938 | 128083 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009715.0017 | 2121896.66309 | 37.8068713545053 | -122.410678271985 | (37.8068713545053, -122.410678271985) | 3 | 1 | 10 | 308 | 23 | |||
8631 | 128082 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009683.35171 | 2121893.27188 | 37.8068602685411 | -122.41078756392 | (37.8068602685411, -122.41078756392) | 3 | 1 | 10 | 308 | 23 | |||
1402 | 128081 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009658.72737 | 2121889.09987 | 37.8068474325394 | -122.410872486877 | (37.8068474325394, -122.410872486877) | 3 | 1 | 10 | 308 | 23 | |||
14047 | 128080 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009637.33282 | 2121886.34956 | 37.8068386812172 | -122.410946332908 | (37.8068386812172, -122.410946332908) | 3 | 1 | 10 | 308 | 23 | |||
18678 | 128079 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 13 | Width 4ft | 6009619.79049 | 2121884.15798 | 37.8068316799992 | -122.411006886985 | (37.8068316799992, -122.411006886985) | 3 | 1 | 10 | 308 | 23 | ||
10331 | 128078 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 245 North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:25:00 PM | 3 | Width 4ft | 6009589.18536 | 2121879.68336 | 37.8068176775527 | -122.411112486276 | (37.8068176775527, -122.411112486276) | 3 | 1 | 10 | 308 | 23 | ||
913 | 128077 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009569.08364 | 2121877.54409 | 37.8068106763465 | -122.411181901328 | (37.8068106763465, -122.411181901328) | 3 | 1 | 10 | 308 | 23 | |||
11874 | 110985 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
18979 | 110983 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
35514 | 110994 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
44244 | 110995 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
53203 | 110987 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
67256 | 110998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
73243 | 110988 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
74708 | 52076 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
88657 | 110984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
120183 | 110989 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 245x North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776694 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | ||
126032 | 110991 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
136446 | 110992 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
138984 | 110996 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
171851 | 110997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
172294 | 110990 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
183563 | 110986 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
190730 | 110993 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
15447 | 128076 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 7 | Width 4ft | 6009546.7837 | 2121872.26218 | 37.8067949229139 | -122.411258701628 | (37.8067949229139, -122.411258701628) | 3 | 1 | 10 | 308 | 23 | ||
16148 | 255011 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6009525.60238 | 2121869.50761 | 37.806786171612 | -122.411331809333 | (37.806786171612, -122.411331809333) | 3 | 1 | 10 | 308 | 23 | ||||
3413 | 128074 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2019 12:00:00 AM | 3 | Width 4ft | 6009478.77374 | 2121864.7268 | 37.8067704181858 | -122.411493531709 | (37.8067704181858, -122.411493531709) | 3 | 1 | 10 | 308 | 23 | ||
17607 | 128073 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009455.6728 | 2121862.0115 | 37.8067616668876 | -122.411573285385 | (37.8067616668876, -122.411573285385) | 3 | 1 | 10 | 308 | 23 | |||
18083 | 128072 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009436.58528 | 2121857.30143 | 37.806747663529 | -122.411639008733 | (37.806747663529, -122.411639008733) | 3 | 1 | 10 | 308 | 23 | |||
12010 | 128071 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009416.46616 | 2121854.31268 | 37.8067383285777 | -122.411708423825 | (37.8067383285777, -122.411708423825) | 3 | 1 | 10 | 308 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );