trees
508 rows where qSpecies_id = 25 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
1568 | 172155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 649 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 6011250.4218 | 2091802.92791 | 37.7243267296922 | -122.403246295306 | (37.7243267296922, -122.403246295306) | 10 | 3 | 7 | 309 | 28 | |||
2212 | 225967 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005877.12817 | 2101963.64024 | 37.7519242145407 | -122.422542702196 | (37.7519242145407, -122.422542702196) | 2 | 4 | 5 | 28859 | 19 | |||
2617 | 247759 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | 15 | 5 | 5 | 29492 | 9 | |||
3438 | 194171 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6011792.75247 | 2105015.27083 | 37.7606352745052 | -122.402300054726 | (37.7606352745052, -122.402300054726) | 10 | 3 | 8 | 28856 | 29 | |||
4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | |||
4939 | 225906 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.7502609561874 | -122.423660939909 | (37.7502609561874, -122.423660939909) | 2 | 4 | 5 | 28859 | 19 | |||
7174 | 225912 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6005698.15966 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | 2 | 4 | 5 | 28859 | 19 | |||
7887 | 152881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3572 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005780.88013 | 2104928.47476 | 37.7600595303512 | -122.42308625784 | (37.7600595303512, -122.42308625784) | 2 | 4 | 5 | 28859 | 19 | |||
10451 | 225947 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003497.57041 | 2095097.96573 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | 9 | 7 | 5 | 28861 | 25 | |||
10559 | 10061 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 490 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | 8 | 4 | 5 | 28859 | 19 | |||
11255 | 70154 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | 11 | 6 | 2 | 54 | 11 | |||
11311 | 73919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007979.77962 | 2109750.06791 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | 8 | 2 | 9 | 28853 | 34 | |||
11951 | 142340 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.7745244442512 | -122.444402018718 | (37.7745244442512, -122.444402018718) | 15 | 5 | 11 | 29492 | 16 | |||
11961 | 115127 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
12728 | 256034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1455 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015659 | 2093559 | 37.729393784799 | -122.388128823531 | (37.729393784799, -122.388128823531) | 10 | 3 | 8 | 58 | 1 | |||
13467 | 70988 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007961.92289 | 2109767.88075 | 37.7734702467743 | -122.415885749526 | (37.7734702467743, -122.415885749526) | 8 | 2 | 9 | 28853 | 34 | |||
13543 | 83275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008740.14676 | 2118614.90766 | 37.7978057691893 | -122.413819676732 | (37.7978057691893, -122.413819676732) | 5 | 1 | 10 | 308 | 21 | |||
14626 | 225965 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.7418599932559 | -122.409770124916 | (37.7418599932559, -122.409770124916) | 10 | 7 | 7 | 28859 | 2 | |||
15108 | 113387 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
15256 | 259564 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
16692 | 78621 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011632.94564 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | 10 | 3 | 8 | 28856 | 29 | |||
16772 | 113034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 251 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993975.1139 | 2113804.1265 | 37.7837564355183 | -122.464560902617 | (37.7837564355183, -122.464560902617) | 11 | 6 | 2 | 54 | 11 | |||
17037 | 264800 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 330 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011202 | 2089015 | 37.7166689455126 | -122.403217660421 | (37.7166689455126, -122.403217660421) | 10 | 7 | 8 | 309 | 39 | ||||
17201 | 72137 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013608.91395 | 2104739.63414 | 37.7599796489713 | -122.395999412568 | (37.7599796489713, -122.395999412568) | 10 | 3 | 8 | 28856 | 29 | |||
17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
18508 | 79749 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.389711390588 | (37.7638512843329, -122.389711390588) | 14 | 3 | 8 | 28856 | 29 | |||
19143 | 83274 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008741.72565 | 2118600.65097 | 37.7977667125146 | -122.41381320433 | (37.7977667125146, -122.41381320433) | 5 | 1 | 10 | 308 | 21 | |||
22071 | 192422 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.7680909933277 | -122.401057281578 | (37.7680909933277, -122.401057281578) | 14 | 3 | 8 | 28856 | 20 | |||
23417 | 128877 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 6 | Median : Yard | Tree | DPW 1 | 3 | 6007635.08843 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | 5 | 1 | 10 | 28858 | 32 | ||||
23576 | 10026 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2x3 | 6005455.03663 | 2107324.13866 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | 8 | 4 | 5 | 28853 | 19 | |||
24456 | 225946 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | 2 | 4 | 5 | 28859 | 19 | |||
25081 | 225931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | 2 | 7 | 7 | 28859 | 2 | |||
25095 | 244549 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.445914799778 | (37.7711525285338, -122.445914799778) | 15 | 5 | 11 | 29492 | 9 | |||
25269 | 128865 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001864.71047 | 2116045.71849 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | 13 | 6 | 1 | 29490 | 27 | |||
25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
27374 | 176498 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.421797376475 | (37.7121905153633, -122.421797376475) | 9 | 7 | 8 | 309 | 18 | |||
27821 | 29763 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
29333 | 225916 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.7583230563848 | -122.425169300823 | (37.7583230563848, -122.425169300823) | 2 | 4 | 5 | 28859 | 19 | |||
29499 | 244210 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | 7 | 9 | 11 | 29492 | 10 | |||
29569 | 105213 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
30350 | 225979 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | 15 | 9 | 11 | 29492 | 10 | |||
30741 | 176516 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | 9 | 7 | 8 | 309 | 39 | |||
31931 | 219011 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995317.53334 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | 9 | 8 | 6 | 28861 | 24 | |||
32183 | 225901 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.7639719400684 | -122.423034081872 | (37.7639719400684, -122.423034081872) | 8 | 4 | 5 | 28859 | 19 | |||
33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
37150 | 176505 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005616.04698 | 2087112.68704 | 37.7111320510829 | -122.422390458676 | (37.7111320510829, -122.422390458676) | 9 | 7 | 8 | 309 | 18 | |||
37585 | 105310 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | 11 | 6 | 2 | 55 | 26 | |||
38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
40882 | 219016 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | 9 | 7 | 4 | 59 | 40 | |||
40896 | 247270 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | 15 | 5 | 11 | 29492 | 9 | |||
41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
42399 | 7700 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.8044437236489 | -122.415905321467 | (37.8044437236489, -122.415905321467) | 5 | 1 | 10 | 308 | 23 | |||
42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
43646 | 176517 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6006489.32827 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | 9 | 7 | 8 | 309 | 39 | |||
43773 | 21413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | ||||
44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
45175 | 225948 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6003779.75499 | 2095097.51754 | 37.7329528756765 | -122.429306150766 | (37.7329528756765, -122.429306150766) | 9 | 7 | 5 | 28861 | 25 | |||
45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 | |||
46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 | |||
48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
49249 | 176502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678 | (37.7116417355373, -122.42221747678) | 9 | 7 | 8 | 309 | 18 | |||
49729 | 192424 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012214.21558 | 2107593.00345 | 37.767736670334 | -122.401023519214 | (37.767736670334, -122.401023519214) | 14 | 3 | 8 | 28856 | 20 | |||
50638 | 192419 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 3 | : | Tree | Private 2 | 8 | Width 5ft | 6013725.78081 | 2104155.14731 | 37.7583812766799 | -122.395554273333 | (37.7583812766799, -122.395554273333) | 10 | 3 | 8 | 28856 | 29 | |||
50795 | 225950 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | 2 | 4 | 5 | 28862 | 22 | |||
51015 | 225924 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6005469.65475 | 2108205.80814 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | 8 | 4 | 5 | 28853 | 19 | |||
51655 | 225914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 611 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009855.21876 | 2105398.04081 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | 2 | 4 | 8 | 28859 | 19 | |||
52777 | 225919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009340.70254 | 2099660.44823 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | 2 | 7 | 7 | 28859 | 2 | |||
53060 | 128866 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.7903441535036 | -122.43764656594 | (37.7903441535036, -122.43764656594) | 13 | 6 | 1 | 29490 | 27 | |||
53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
55179 | 176501 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.422201590246 | (37.7116934016018, -122.422201590246) | 9 | 7 | 8 | 309 | 18 | |||
55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
55505 | 225970 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6009214.74518 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | 2 | 4 | 7 | 28859 | 19 | |||
58299 | 225971 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006565.68979 | 2104973.14116 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | 2 | 4 | 7 | 28859 | 19 | |||
58362 | 142702 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | 3 | 1 | 10 | 308 | 23 | |||
58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
59021 | 221893 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.7510043375848 | -122.413092739446 | (37.7510043375848, -122.413092739446) | 2 | 4 | 7 | 28859 | 19 | |||
61119 | 225949 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.7330390388203 | -122.429314984812 | (37.7330390388203, -122.429314984812) | 9 | 7 | 5 | 28861 | 25 | |||
62095 | 176509 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | 9 | 7 | 8 | 309 | 39 | |||
63017 | 176519 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | 9 | 7 | 8 | 309 | 39 | |||
63451 | 105311 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.7793822053088 | -122.476225875432 | (37.7793822053088, -122.476225875432) | 11 | 6 | 2 | 55 | 26 | |||
63677 | 10032 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) | 8 | 4 | 5 | 28853 | 19 | |||
63701 | 27660 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6005798.59708 | 2101052.03016 | 37.7494167122272 | -122.422749495892 | (37.7494167122272, -122.422749495892) | 2 | 4 | 5 | 28859 | 19 | |||
63945 | 225932 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.408573752301 | (37.743730236853, -122.408573752301) | 2 | 7 | 7 | 28859 | 2 | |||
64250 | 128879 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012011.13763 | 2118129.24016 | 37.7966553941982 | -122.402466903231 | (37.7966553941982, -122.402466903231) | 3 | 1 | 10 | 28860 | 4 | |||
64629 | 142235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | 7 | 9 | 11 | 28852 | 10 | |||
64828 | 225913 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.423560032385 | (37.760182844481, -122.423560032385) | 2 | 4 | 5 | 28859 | 19 | |||
67298 | 225972 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003502.63381 | 2105046.72586 | 37.7602553928045 | -122.430974055914 | (37.7602553928045, -122.430974055914) | 2 | 4 | 5 | 28862 | 3 |
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) );