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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147023 | 147023 | 109910 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | Private 3 | 9 | 3x3 | 6011008.58026 | 2110233.67588 | 37.774920023185295 | -122.40537967513 | (37.7749200231853, -122.40537967513) | ||
87779 | 87779 | 27372 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
117559 | 117559 | 27373 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
123968 | 123968 | 27369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
126356 | 126356 | 27368 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
128516 | 128516 | 27367 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
142719 | 142719 | 27371 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 18 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
142971 | 142971 | 27370 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
5731 | 5731 | 12910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 60 | 3X3 | 6007779.43261 | 2112129.0051 | 37.779943069560105 | -122.416684310636 | (37.7799430695601, -122.416684310636) | |||
7907 | 7907 | 12911 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 60 | 3X3 | 6007775.55734 | 2112148.5476900004 | 37.779996510859 | -122.416699101796 | (37.779996510859, -122.416699101796) | |||
8088 | 8088 | 12909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007780.304959999 | 2112111.9572400004 | 37.779896309296 | -122.41668008474 | (37.779896309296, -122.41668008474) | |||
8315 | 8315 | 12912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007764.05578 | 2112272.8599900003 | 37.7803371956541 | -122.41674770026 | (37.7803371956541, -122.41674770026) | |||
25916 | 25916 | 115393 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009906.5006099995 | 2087474.9292900001 | 37.712367789705 | -122.407587055718 | (37.712367789705, -122.407587055718) | ||
39914 | 39914 | 115395 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009893.891419999 | 2087442.30364 | 37.7122775004839 | -122.40762833818998 | (37.7122775004839, -122.40762833819) | ||
53226 | 53226 | 115394 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009899.82351 | 2087457.5745 | 37.7123197632209 | -122.407608911042 | (37.7123197632209, -122.407608911042) | ||
154144 | 154144 | 115392 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 6 | 3x3 | 6009912.446690001 | 2087490.89947 | 37.7124119734081 | -122.407567629444 | (37.7124119734081, -122.407567629444) | ||
157653 | 157653 | 115396 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 5 | 3x3 | 6009890.08055 | 2087427.6888 | 37.7122371577831 | -122.407640479942 | (37.7122371577831, -122.407640479942) | ||
2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
5751 | 5751 | 1741 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010277.5688 | 2121623.6186 | 37.8061531673047 | -122.408712111835 | (37.8061531673047, -122.408712111835) | |||
6111 | 6111 | 1744 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010455.5729 | 2121649.3164 | 37.806233695246796 | -122.40809790947901 | (37.8062336952468, -122.408097909479) | |||
6698 | 6698 | 1748 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010555.2301 | 2121661.2252 | 37.806271973223794 | -122.407753867308 | (37.8062719732238, -122.407753867308) | |||
6981 | 6981 | 1746 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010500.0739 | 2121656.211 | 37.8062551176462 | -122.40794439194401 | (37.8062551176462, -122.407944391944) | |||
7132 | 7132 | 1750 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010626.0557 | 2121671.8803 | 37.8063051940875 | -122.4075095136 | (37.8063051940875, -122.4075095136) | |||
7500 | 7500 | 1752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010681.2119 | 2121680.6552 | 37.806332374912294 | -122.40731925401899 | (37.8063323749123, -122.407319254019) | |||
8258 | 8258 | 1740 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010239.3355 | 2121619.2312 | 37.8061389791251 | -122.408844115422 | (37.8061389791251, -122.408844115422) | |||
8607 | 8607 | 1751 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010656.7677 | 2121676.8945 | 37.8063206808441 | -122.40740358257901 | (37.8063206808441, -122.407403582579) | |||
8654 | 8654 | 1742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010362.8102 | 2121638.0345 | 37.8061975236724 | -122.408418135849 | (37.8061975236724, -122.408418135849) | |||
8663 | 8663 | 1747 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010526.3985 | 2121656.8377 | 37.80625831218661 | -122.40785333492902 | (37.8062583121866, -122.407853334929) | |||
8833 | 8833 | 1749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010575.9137 | 2121665.6126 | 37.8062851777933 | -122.40768259734502 | (37.8062851777933, -122.407682597345) | |||
15365 | 15365 | 29858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 4X4 | 6014689.41423 | 2099276.62431 | 37.7450394402319 | -122.391880446552 | (37.7450394402319, -122.391880446552) | |||
17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
49118 | 49118 | 1737 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
59669 | 59669 | 116819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.40819321595501 | (37.8062269882557, -122.408193215955) | ||||
79921 | 79921 | 1719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
83489 | 83489 | 116828 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 15 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
83621 | 83621 | 116826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 13 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
84379 | 84379 | 1734 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
85395 | 85395 | 116822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 9 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
86191 | 86191 | 1736 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
92074 | 92074 | 116820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
93526 | 93526 | 116831 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 18 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
94354 | 94354 | 116825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 12 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
96617 | 96617 | 1732 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
97364 | 97364 | 1754 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
97827 | 97827 | 1726 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
99346 | 99346 | 116823 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 10 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
99468 | 99468 | 1756 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
102952 | 102952 | 1725 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12/15/1992 12:00:00 AM | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
107057 | 107057 | 116830 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 17 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
107737 | 107737 | 1722 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
109280 | 109280 | 11700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
110974 | 110974 | 116818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 5 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
111971 | 111971 | 116809 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 1 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
112155 | 112155 | 1731 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
112223 | 112223 | 1724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
114188 | 114188 | 1727 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
115308 | 115308 | 1723 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
118758 | 118758 | 1733 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
119036 | 119036 | 1755 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
121717 | 121717 | 1730 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
124401 | 124401 | 1735 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
125164 | 125164 | 1721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
126108 | 126108 | 116824 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 11 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
126259 | 126259 | 1728 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
127145 | 127145 | 116817 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 4 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
133018 | 133018 | 116821 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 8 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 14 | 6010478.7636 | 2121651.8235 | 37.806241877556 | -122.408017830638 | (37.806241877556, -122.408017830638) | ||||
139776 | 139776 | 116829 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 16 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
142437 | 142437 | 1720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
143982 | 143982 | 1729 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
144844 | 144844 | 116816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 3 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
144887 | 144887 | 116832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Midway St | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010125.275107 | 2121295.55695439 | 37.8052438606833 | -122.409215987298 | (37.8052438606833, -122.409215987298) | |||||
146001 | 146001 | 116815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 2 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
1586 | 1586 | 98725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.42204280683501 | (37.7780191723707, -122.422042806835) | |||
2933 | 2933 | 98726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006198.51355 | 2111464.4034 | 37.7780291926159 | -122.422106195562 | (37.7780291926159, -122.422106195562) | |||
3428 | 3428 | 98728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006156.19882 | 2111456.14926 | 37.778004142027 | -122.42225199096 | (37.778004142027, -122.42225199096) | |||
6003 | 6003 | 98729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006140.89781 | 2111454.63858 | 37.7779991309825 | -122.42230481531901 | (37.7779991309825, -122.422304815319) | |||
6064 | 6064 | 98727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006176.94483 | 2111455.11485 | 37.7780024719703 | -122.422180149508 | (37.7780024719703, -122.422180149508) | |||
9030 | 9030 | 98730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006126.244940001 | 2111454.93961 | 37.777999130991205 | -122.42235552627899 | (37.7779991309912, -122.422355526279) | |||
83093 | 83093 | 98734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
89481 | 89481 | 98733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
107050 | 107050 | 98735 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
113650 | 113650 | 98731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
140997 | 140997 | 113815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4101x 25TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 8 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
145660 | 145660 | 98732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
1899 | 1899 | 25838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.308119999 | 2119220.74162 | 37.7997201038678 | -122.39834219506099 | (37.7997201038678, -122.398342195061) | ||
2090 | 2090 | 25842 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.137069999 | 2119139.97441 | 37.799501334781795 | -122.398150256355 | (37.7995013347818, -122.398150256355) | ||
2826 | 2826 | 28035 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011869.41049 | 2121075.03017 | 37.804735906188796 | -122.403164632367 | (37.8047359061888, -122.403164632367) | ||
3114 | 3114 | 25811 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012315.257619999 | 2120560.3270799997 | 37.8033475454092 | -122.401585526252 | (37.8033475454092, -122.401585526252) | ||
3657 | 3657 | 25806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012234.78854 | 2120695.21971 | 37.8037134372885 | -122.401873481994 | (37.8037134372885, -122.401873481994) | ||
3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
3878 | 3878 | 28034 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011851.06099 | 2121093.24306 | 37.8047848895665 | -122.403229415001 | (37.8047848895665, -122.403229415001) | ||
4198 | 4198 | 25837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.39839810591299 | (37.7997852642353, -122.398398105913) | ||
4234 | 4234 | 28039 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | ||
4885 | 4885 | 25808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012265.91209 | 2120646.37252 | 37.803581051681704 | -122.401762341075 | (37.8035810516817, -122.401762341075) | ||
4943 | 4943 | 25845 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013327.75405 | 2119068.43707 | 37.799307618121 | -122.397977001961 | (37.799307618121, -122.397977001961) | ||
5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
5630 | 5630 | 28043 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012024.04433 | 2120930.34171 | 37.8043472614676 | -122.402619322118 | (37.8043472614676, -122.402619322118) | ||
5672 | 5672 | 25807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012251.480269999 | 2120666.53325 | 37.8036356027669 | -122.40181370136801 | (37.8036356027669, -122.401813701368) |
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");