trees
379 rows where qSpecies_id = 86 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5600 | 241053 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Coso Ave | 3 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6007672.87316 | 2099533.13544 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | 2 | 7 | 7 | 28859 | 2 | |||
6275 | 215306 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994798.91109 | 2091839.85894 | 37.7234956059322 | -122.46011911751 | (37.7234956059322, -122.46011911751) | 9 | 8 | 4 | 28861 | 24 | |||
14557 | 179896 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008623.46871 | 2091235.83896 | 37.7226225602776 | -122.412287269767 | (37.7226225602776, -122.412287269767) | 9 | 3 | 7 | 309 | 28 | |||
15056 | 136668 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000716.04305 | 2117375.36701 | 37.793948425839 | -122.44149623986 | (37.793948425839, -122.44149623986) | 13 | 9 | 1 | 57 | 27 | |||
20054 | 179816 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5998896.47943 | 2087985.98749 | 37.713148590116 | -122.445677603554 | (37.713148590116, -122.445677603554) | 9 | 7 | 6 | 28861 | 25 | |||
21045 | 179811 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1367 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 5999338.15399 | 2089837.49101 | 37.7182576053899 | -122.444284002399 | (37.7182576053899, -122.444284002399) | 9 | 7 | 6 | 28861 | 25 | |||
27119 | 215314 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997659.25231 | 2090057.81858 | 37.7187666441474 | -122.450103098091 | (37.7187666441474, -122.450103098091) | 9 | 8 | 6 | 28861 | 24 | |||
33199 | 179907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6010281.08553 | 2091712.86969 | 37.7240252643514 | -122.406590826309 | (37.7240252643514, -122.406590826309) | 10 | 3 | 7 | 309 | 28 | |||
34212 | 136690 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007706.55666 | 2118838.72504 | 37.7983622165993 | -122.417412065427 | (37.7983622165993, -122.417412065427) | 5 | 1 | 10 | 28858 | 32 | |||
35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
44452 | 136673 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000708.53208 | 2117436.75891 | 37.7941165639844 | -122.441526636039 | (37.7941165639844, -122.441526636039) | 13 | 9 | 1 | 57 | 27 | |||
54391 | 179886 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6007455.79909 | 2094011.3835 | 37.7301780166028 | -122.416520168176 | (37.7301780166028, -122.416520168176) | 9 | 3 | 7 | 309 | 28 | |||
61794 | 215293 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5994427.84018 | 2100560.89209 | 37.747420061691 | -122.462033961208 | (37.747420061691, -122.462033961208) | 1 | 8 | 4 | 29491 | 40 | |||
63554 | 241060 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.7350755589952 | -122.421928139697 | (37.7350755589952, -122.421928139697) | 2 | 7 | 7 | 28859 | 2 | |||
63804 | 179827 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002666.48138 | 2089402.27505 | 37.7172519286027 | -122.432748322975 | (37.7172519286027, -122.432748322975) | 9 | 7 | 6 | 28861 | 5 | |||
72527 | 120265 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 24th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | 5988361.48129 | 2115164.47421 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | 11 | 6 | 1 | 55 | 33 | ||||
75958 | 136705 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1120 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6007496.45618 | 2119889.74411 | 37.8012362277192 | -122.418213633845 | (37.8012362277192, -122.418213633845) | 5 | 1 | 1 | 28858 | 32 | ||||
84545 | 136709 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007914.92474 | 2120604.50253 | 37.8032223202271 | -122.416816212417 | (37.8032223202271, -122.416816212417) | 5 | 1 | 1 | 308 | 32 | |||
86661 | 197902 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010935.09599 | 2105618.63993 | 37.7622440780325 | -122.405308806777 | (37.7622440780325, -122.405308806777) | 8 | 3 | 8 | 28856 | 29 | |||
92456 | 215336 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998234.84844 | 2096392.28962 | 37.7361925349403 | -122.448569464424 | (37.7361925349403, -122.448569464424) | 9 | 7 | 4 | 59 | 40 | |||
100575 | 136700 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008170.72961 | 2119215.54579 | 37.7994229777558 | -122.415832578026 | (37.7994229777558, -122.415832578026) | 5 | 1 | 10 | 308 | 32 | |||
103352 | 179813 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999385.00434 | 2089890.92911 | 37.7184070070682 | -122.444125898896 | (37.7184070070682, -122.444125898896) | 9 | 7 | 6 | 28861 | 25 | |||
105158 | 215289 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993555.20621 | 2101912.20382 | 37.7510801396391 | -122.465149580605 | (37.7510801396391, -122.465149580605) | 1 | 8 | 4 | 29491 | 12 | |||
108553 | 179909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002595.51683 | 2086620.13725 | 37.7096087631907 | -122.432794977119 | (37.7096087631907, -122.432794977119) | 9 | 7 | 6 | 28861 | 5 | |||
111535 | 136714 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.8039755150326 | -122.433293789677 | (37.8039755150326, -122.433293789677) | 13 | 9 | 1 | 57 | 17 | |||
114841 | 179851 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998773.25514 | 2089930.66617 | 37.718481197523 | -122.44624330948 | (37.718481197523, -122.44624330948) | 9 | 7 | 6 | 28861 | 25 | |||
121616 | 136698 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6007369.77523 | 2120178.57084 | 37.802022141674 | -122.418672500363 | (37.802022141674, -122.418672500363) | 5 | 1 | 1 | 28858 | 32 | |||
123804 | 179868 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 345 Congdon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6004732.69466 | 2093569.91681 | 37.7288123277178 | -122.425902888604 | (37.7288123277178, -122.425902888604) | 9 | 7 | 6 | 28861 | 5 | |||
128853 | 136661 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 3 | : | Tree | Private 2 | 4 | Width 1ft | 6004511.51487 | 2120814.19666 | 37.8036060681264 | -122.428608775088 | (37.8036060681264, -122.428608775088) | 13 | 9 | 1 | 28858 | 17 | |||
132805 | 136694 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1201 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007018.29249 | 2119785.88696 | 37.8009241359937 | -122.41986091934 | (37.8009241359937, -122.41986091934) | 5 | 1 | 1 | 28858 | 32 | |||
133639 | 121844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 518 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990041.13259 | 2111807.14387 | 37.7780457072257 | -122.478024804476 | (37.7780457072257, -122.478024804476) | 11 | 6 | 2 | 55 | 26 | |||
137276 | 179819 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998682.50802 | 2087825.81458 | 37.7126965728687 | -122.446405642516 | (37.7126965728687, -122.446405642516) | 9 | 7 | 6 | 28861 | 25 | |||
137739 | 241056 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 4864 17th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5997871.31028 | 2105665.38567 | 37.7616333843862 | -122.450494663794 | (37.7616333843862, -122.450494663794) | 15 | 5 | 11 | 29492 | 9 | |||
141539 | 179840 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6002632.59127 | 2093895.12097 | 37.7295863562117 | -122.433186306304 | (37.7295863562117, -122.433186306304) | 9 | 7 | 6 | 28861 | 25 | |||
145014 | 256324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3000X Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
146617 | 136645 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.65751 | 2121656.65619 | 37.8058050076721 | -122.435641584993 | (37.8058050076721, -122.435641584993) | 13 | 9 | 1 | 57 | 17 | |||
148102 | 179864 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6004587.63153 | 2091546.86804 | 37.7232492834105 | -122.4262604078 | (37.7232492834105, -122.4262604078) | 9 | 7 | 6 | 28861 | 5 | |||
148964 | 241064 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002651.6707 | 2100291.95945 | 37.7471516815152 | -122.433577323454 | (37.7471516815152, -122.433577323454) | 2 | 7 | 5 | 63 | 22 | ||||
149391 | 215296 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5997379.68023 | 2094370.54244 | 37.7305923666319 | -122.451380344931 | (37.7305923666319, -122.451380344931) | 9 | 7 | 4 | 28861 | 40 | |||
151400 | 97300 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
152327 | 17449 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012949.37731 | 2096657.76915 | 37.7377518631542 | -122.39771357075 | (37.7377518631542, -122.39771357075) | 10 | 3 | 8 | 58 | 1 | |||
152355 | 136667 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000893.50994 | 2117430.42201 | 37.7941097012578 | -122.440886139797 | (37.7941097012578, -122.440886139797) | 13 | 9 | 1 | 57 | 27 | |||
157310 | 215326 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992028.53266 | 2098327.51469 | 37.7411493498502 | -122.470167922636 | (37.7411493498502, -122.470167922636) | 1 | 8 | 4 | 59 | 40 | |||
168686 | 136707 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1155 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007381.61519 | 2119835.37419 | 37.8010804768418 | -122.418607177199 | (37.8010804768418, -122.418607177199) | 5 | 1 | 1 | 28858 | 32 | |||
171818 | 179910 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5998425.41243 | 2088873.3917 | 37.7155582929503 | -122.447369596148 | (37.7155582929503, -122.447369596148) | 9 | 7 | 6 | 28861 | 25 | |||
172817 | 179824 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998241.3307 | 2088717.20403 | 37.715118916577 | -122.447994624052 | (37.715118916577, -122.447994624052) | 9 | 7 | 6 | 28861 | 25 | |||
175053 | 179875 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007112.5297 | 2091803.34556 | 37.7240959105931 | -122.417550466576 | (37.7240959105931, -122.417550466576) | 9 | 7 | 7 | 309 | 28 | |||
175071 | 179890 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | 9 | 3 | 7 | 309 | 28 | |||
175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
178178 | 197908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012886.87762 | 2106673.42615 | 37.7652492165901 | -122.398632309145 | (37.7652492165901, -122.398632309145) | 14 | 3 | 8 | 28856 | 20 | |||
181270 | 136675 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2127 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003298.06459 | 2117513.66207 | 37.7944749096307 | -122.432572080161 | (37.7944749096307, -122.432572080161) | 13 | 9 | 1 | 29490 | 27 | |||
163182 | 256443 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
1950 | 71713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 782 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983564.60428 | 2110493.72832 | 37.7740614056929 | -122.500331946576 | (37.7740614056929, -122.500331946576) | 11 | 6 | 2 | 55 | 26 | |||
5344 | 102057 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x1 | Permit Number 18946 | 6001387 | 2105809 | 37.7622283076155 | -122.438345635253 | (37.7622283076155, -122.438345635253) | 15 | 5 | 5 | 28862 | 3 | |||
5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
9034 | 179812 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999375.14619 | 2089880.54718 | 37.71837793826 | -122.444159228684 | (37.71837793826, -122.444159228684) | 9 | 7 | 6 | 28861 | 25 | |||
17039 | 136666 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000890.78199 | 2117450.16174 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | 13 | 9 | 1 | 57 | 27 | |||
20460 | 100528 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4.5x6 | 6008351.1313 | 2118382.01094 | 37.7971444383282 | -122.415149288427 | (37.7971444383282, -122.415149288427) | 5 | 1 | 10 | 308 | 21 | |||
23215 | 218419 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5994236.56093 | 2100588.83344 | 37.7474857670642 | -122.462697413572 | (37.7474857670642, -122.462697413572) | 1 | 8 | 4 | 29491 | 40 | |||
23410 | 215313 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997655.06789 | 2090049.20462 | 37.7187427527624 | -122.450116941352 | (37.7187427527624, -122.450116941352) | 9 | 8 | 6 | 28861 | 24 | |||
27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
27037 | 106347 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | |||||
31608 | 136644 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.13752 | 2121660.90327 | 37.8058166394946 | -122.435643688532 | (37.8058166394946, -122.435643688532) | 13 | 9 | 1 | 57 | 17 | |||
34915 | 215298 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000134.87473 | 2094332.54938 | 37.7306454275316 | -122.441852526992 | (37.7306454275316, -122.441852526992) | 9 | 7 | 4 | 63 | 40 | |||
37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
37301 | 241067 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 229 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000638.50789 | 2103037.93604 | 37.7545770419209 | -122.440735600467 | (37.7545770419209, -122.440735600467) | 2 | 4 | 5 | 28862 | 22 | |||
39011 | 179881 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007539.25103 | 2092829.10153 | 37.7269364183715 | -122.416147963965 | (37.7269364183715, -122.416147963965) | 9 | 3 | 7 | 309 | 28 | |||
40383 | 105515 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002668.24171 | 2089385.75875 | 37.7172066783264 | -122.432741059164 | (37.7172066783264, -122.432741059164) | 9 | 7 | 6 | 28861 | 5 | |||
42109 | 215292 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994414.45382 | 2100572.16969 | 37.747450256423 | -122.462081067713 | (37.747450256423, -122.462081067713) | 1 | 8 | 4 | 29491 | 40 | |||
44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
49688 | 136713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011569.99478 | 2119432.50864 | 37.8002092172264 | -122.404085130728 | (37.8002092172264, -122.404085130728) | 3 | 1 | 10 | 308 | 23 | |||
51532 | 179818 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998665.00636 | 2087845.19043 | 37.7127487749191 | -122.446467526652 | (37.7127487749191, -122.446467526652) | 9 | 7 | 6 | 28861 | 25 | |||
54533 | 215301 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001252.93679 | 2094603.03258 | 37.7314517578791 | -122.438006591549 | (37.7314517578791, -122.438006591549) | 9 | 7 | 4 | 63 | 40 | |||
59411 | 179908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002616.49516 | 2086635.08435 | 37.7096509944651 | -122.432723539456 | (37.7096509944651, -122.432723539456) | 9 | 7 | 6 | 28861 | 5 | |||
64521 | 179831 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991499.58423 | 2088662.21507 | 37.7145802532566 | -122.471292774854 | (37.7145802532566, -122.471292774854) | 9 | 8 | 6 | 64 | 24 | |||
65143 | 241059 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005916.72603 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | 2 | 7 | 7 | 28859 | 2 | |||
67559 | 179809 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 114 Niagara Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5999497.59387 | 2089483.70241 | 37.7172952777295 | -122.443707485722 | (37.7172952777295, -122.443707485722) | 9 | 7 | 6 | 28861 | 25 | |||
70544 | 179889 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008314.8677 | 2094310.92324 | 37.7310487635727 | -122.41357142338 | (37.7310487635727, -122.41357142338) | 9 | 3 | 7 | 309 | 28 | |||
71787 | 256414 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
73016 | 120230 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988064.78369 | 2114963.42937 | 37.7865970627596 | -122.485093253087 | (37.7865970627596, -122.485093253087) | 11 | 6 | 1 | 55 | 33 | |||
77632 | 136687 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 915 Bay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006389.37934 | 2121076.02461 | 37.8044310746876 | -122.422128935803 | (37.8044310746876, -122.422128935803) | 5 | 1 | 1 | 28858 | 32 | |||
80235 | 179835 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001963.44434 | 2093526.42722 | 37.7285360253961 | -122.435473248114 | (37.7285360253961, -122.435473248114) | 9 | 7 | 6 | 28861 | 25 | |||
81813 | 241070 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6002148.82258 | 2103426.21289 | 37.7557290518693 | -122.43554031414 | (37.7557290518693, -122.43554031414) | 2 | 4 | 5 | 28862 | 22 | |||
84447 | 241052 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6011089.42148 | 2103864.30149 | 37.7574356836305 | -122.404651544442 | (37.7574356836305, -122.404651544442) | 10 | 4 | 8 | 28859 | 19 | |||
87437 | 179846 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.7286106583386 | -122.440994678056 | (37.7286106583386, -122.440994678056) | 9 | 7 | 6 | 28861 | 25 | |||
92970 | 215331 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2095 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5993556.00602 | 2101376.01116 | 37.7496079377635 | -122.465107874536 | (37.7496079377635, -122.465107874536) | 1 | 8 | 4 | 29491 | 40 | |||
93014 | 136664 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005052.80958 | 2120674.99367 | 37.8032544709705 | -122.42672567836 | (37.8032544709705, -122.42672567836) | 13 | 9 | 1 | 28858 | 17 | |||
94276 | 179895 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008618.46635 | 2091234.88491 | 37.7226196599519 | -122.412304494484 | (37.7226196599519, -122.412304494484) | 9 | 3 | 7 | 309 | 28 | |||
98485 | 104833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6006442.50157 | 2121083.02679 | 37.8044532969577 | -122.421945599118 | (37.8044532969577, -122.421945599118) | 5 | 1 | 1 | 28858 | 32 | ||||
102546 | 179863 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6004588.75772 | 2091549.34292 | 37.7232561425447 | -122.426256690891 | (37.7232561425447, -122.426256690891) | 9 | 7 | 6 | 28861 | 5 | |||
105096 | 179885 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007447.44417 | 2094010.42268 | 37.7301749085276 | -122.416548984266 | (37.7301749085276, -122.416548984266) | 9 | 3 | 7 | 309 | 28 | |||
105099 | 179861 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004531.11595 | 2091836.46353 | 37.7240412542901 | -122.426476381783 | (37.7240412542901, -122.426476381783) | 9 | 7 | 6 | 28861 | 5 | |||
106864 | 103625 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
107371 | 179874 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007111.06937 | 2091808.8773 | 37.7241110173924 | -122.4175559066 | (37.7241110173924, -122.4175559066) | 9 | 7 | 7 | 309 | 28 | |||
114945 | 241055 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 877 Treat Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6008598.03279 | 2103456.37285 | 37.7561760455159 | -122.413238943149 | (37.7561760455159, -122.413238943149) | 2 | 4 | 7 | 28859 | 19 | |||
121368 | 179807 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1441 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5999120.21959 | 2089604.47334 | 37.7176053558696 | -122.445020564272 | (37.7176053558696, -122.445020564272) | 9 | 7 | 6 | 28861 | 25 | |||
122170 | 179839 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002619.90718 | 2093903.00137 | 37.7296072744596 | -122.433230719323 | (37.7296072744596, -122.433230719323) | 9 | 7 | 6 | 28861 | 25 |
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) );