Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27303 | 27303 | 129201 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002306.14505 | 2121870.94259 | 37.8063825585658 | -122.43631622670799 | (37.8063825585658, -122.436316226708) | |||
| 39856 | 39856 | 129108 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 155 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001855.64531 | 2121684.5263400003 | 37.805845102121296 | -122.43786189781 | (37.8058451021213, -122.43786189781) | |||
| 59790 | 59790 | 129202 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1425 Jefferson St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6002378.47119 | 2121561.31201 | 37.8055365042628 | -122.436043759126 | (37.8055365042628, -122.436043759126) | |||
| 174867 | 174867 | 129183 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999581.37766 | 2121479.41464 | 37.8051523345622 | -122.445717560421 | (37.8051523345622, -122.445717560421) | |||
| 183710 | 183710 | 129184 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999584.03647 | 2121469.20578 | 37.805124455597 | -122.445707624701 | (37.805124455597, -122.445707624701) | |||
| 28788 | 28788 | 129185 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999586.95971 | 2121459.2161 | 37.8050971935371 | -122.445696789672 | (37.8050971935371, -122.445696789672) | |||
| 64054 | 64054 | 129186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999587.90115 | 2121446.76461 | 37.8050630588636 | -122.445692635729 | (37.8050630588636, -122.445692635729) | |||
| 151282 | 151282 | 129146 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000571.83923 | 2121374.34413 | 37.8049203391516 | -122.44228241100001 | (37.8049203391516, -122.442282411) | |||
| 149850 | 149850 | 129342 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6007469.878409999 | 2121230.31772 | 37.804915607819204 | -122.418400712649 | (37.8049156078192, -122.418400712649) | |||
| 35455 | 35455 | 129147 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000543.90951 | 2121371.39176 | 37.8049106408804 | -122.442378852499 | (37.8049106408804, -122.442378852499) | |||
| 187049 | 187049 | 129148 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000531.19503 | 2121369.13302 | 37.8049037142981 | -122.442422689958 | (37.8049037142981, -122.442422689958) | |||
| 170371 | 170371 | 129149 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000512.40261 | 2121367.00013 | 37.80489678681129 | -122.44248756976201 | (37.8048967868113, -122.442487569762) | |||
| 28808 | 28808 | 129341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6007472.08384 | 2121212.09706 | 37.80486570266171 | -122.418391787764 | (37.8048657026617, -122.418391787764) | |||
| 185201 | 185201 | 129340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6007472.2942699995 | 2121203.00534 | 37.8048407509518 | -122.418390414501 | (37.8048407509518, -122.418390414501) | |||
| 133392 | 133392 | 68011 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 4 | Permit Number 31741 | 6007478.84194 | 2121154.66744 | 37.8047083959278 | -122.41836432607501 | (37.8047083959278, -122.418364326075) | ||
| 37364 | 37364 | 129125 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3750 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000188.47224 | 2121175.57148 | 37.8043527059816 | -122.44359480245501 | (37.8043527059816, -122.443594802455) | |||
| 151827 | 151827 | 129189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.44214075790701 | (37.8043326933704, -122.442140757907) | |||
| 176649 | 176649 | 129200 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6002139.18705 | 2121127.02263 | 37.8043304639385 | -122.436840724815 | (37.8043304639385, -122.436840724815) | |||
| 167978 | 167978 | 129126 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3750 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000189.7805 | 2121161.41053 | 37.804313898432206 | -122.443589257237 | (37.8043138984322, -122.443589257237) | |||
| 136378 | 136378 | 129127 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000190.96403 | 2121152.26738 | 37.8042888612987 | -122.44358450433998 | (37.8042888612987, -122.44358450434) | |||
| 59064 | 59064 | 129190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6000610.9168300005 | 2121141.44631 | 37.8042830912635 | -122.44213045078699 | (37.8042830912635, -122.442130450787) | |||
| 65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
| 67190 | 67190 | 129128 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000191.73272 | 2121145.1845299997 | 37.804269457536 | -122.443581335121 | (37.804269457536, -122.443581335121) | |||
| 59190 | 59190 | 129129 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000192.65427 | 2121134.45107 | 37.8042400388971 | -122.44357737451901 | (37.8042400388971, -122.443577374519) | |||
| 74421 | 74421 | 129130 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000197.85447 | 2121076.2118900004 | 37.8040804263317 | -122.443555192722 | (37.8040804263317, -122.443555192722) | |||
| 134405 | 134405 | 62997 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 6 | Permit Number 776580 | 6000198.89461 | 2121071.17508 | 37.8040666559246 | -122.443551231218 | (37.8040666559246, -122.443551231218) | ||
| 26965 | 26965 | 66051 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1632 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1990 12:00:00 AM | 12 | Permit Number 29090 | 6002925.71156 | 2121006.29112 | 37.8040436368686 | -122.434110258988 | (37.8040436368686, -122.434110258988) | ||
| 178710 | 178710 | 129150 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1900 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6001109.3535400005 | 2121039.25511 | 37.8040308943727 | -122.44039824138599 | (37.8040308943727, -122.440398241386) | |||
| 164071 | 164071 | 129151 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1900 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6001092.13272 | 2121036.64706 | 37.8040227528229 | -122.440457647901 | (37.8040227528229, -122.440457647901) | |||
| 66746 | 66746 | 129152 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1900 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6001067.53983 | 2121033.31935 | 37.8040122154669 | -122.44054251423799 | (37.8040122154669, -122.440542514238) | |||
| 186233 | 186233 | 129153 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1900 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001047.32787 | 2121030.07538 | 37.8040021574489 | -122.44061222609699 | (37.8040021574489, -122.440612226097) | |||
| 157817 | 157817 | 129204 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6003066.15854 | 2120964.22459 | 37.803936103130106 | -122.43362122476101 | (37.8039361031301, -122.433621224761) | |||
| 4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
| 8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
| 156299 | 156299 | 129205 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6003070.24764 | 2120944.99181 | 37.8038835269778 | -122.433605698837 | (37.8038835269778, -122.433605698837) | |||
| 156772 | 156772 | 129206 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6003071.01563 | 2120936.8701299997 | 37.8038612705514 | -122.433602460379 | (37.8038612705514, -122.433602460379) | |||
| 38472 | 38472 | 129194 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001552.51444 | 2120931.86169 | 37.8037612434571 | -122.438856955397 | (37.8037612434571, -122.438856955397) | |||
| 156042 | 156042 | 129195 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6001565.25504 | 2120922.94686 | 37.803737490546105 | -122.438812226714 | (37.8037374905461, -122.438812226714) | |||
| 37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
| 45702 | 45702 | 129197 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6001606.6144900005 | 2120894.2374 | 37.8036610149183 | -122.43866704197501 | (37.8036610149183, -122.438667041975) | |||
| 46533 | 46533 | 129358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2431 Jones St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007962.785209999 | 2120702.9106099997 | 37.8034952158822 | -122.41665756479799 | (37.8034952158822, -122.416657564798) | |||
| 169759 | 169759 | 129359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2431 Jones St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007962.685269999 | 2120698.0317700002 | 37.8034818141966 | -122.41665756481702 | (37.8034818141966, -122.416657564817) | |||
| 35741 | 35741 | 129306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006156.05151 | 2120698.06699 | 37.8033801368411 | -122.42290950959101 | (37.8033801368411, -122.422909509591) | |||
| 52974 | 52974 | 129305 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006148.36265 | 2120696.43143 | 37.8033752121629 | -122.422936000907 | (37.8033752121629, -122.422936000907) | |||
| 186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
| 65642 | 65642 | 129304 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005981.054409999 | 2120675.3317400003 | 37.8033078358583 | -122.423513477178 | (37.8033078358583, -122.423513477178) | |||
| 145227 | 145227 | 129303 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005974.10733 | 2120674.6115 | 37.8033054661475 | -122.423537466584 | (37.8033054661475, -122.423537466584) | |||
| 62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
| 36896 | 36896 | 129318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007412.87531 | 2120593.39917 | 37.8031635819044 | -122.418552786177 | (37.8031635819044, -122.418552786177) | |||
| 186852 | 186852 | 129319 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6007409.37859 | 2120592.7001799997 | 37.8031614657978 | -122.41856483710698 | (37.8031614657978, -122.418564837107) | |||
| 149482 | 149482 | 129320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6007405.89372 | 2120592.57904 | 37.8031609369869 | -122.41857688803002 | (37.8031609369869, -122.41857688803) | |||
| 163925 | 163925 | 129203 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3501 Webster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002631.88282 | 2120622.79983 | 37.802973990429294 | -122.43509962745001 | (37.8029739904293, -122.43509962745) | |||
| 175803 | 175803 | 129354 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.40477563290199 | (37.8026870410416, -122.404775632902) | |||
| 75147 | 75147 | 129353 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6011391.406830001 | 2120329.06369 | 37.8026609588854 | -122.404766271855 | (37.8026609588854, -122.404766271855) | |||
| 129688 | 129688 | 129131 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3542 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000280.24975 | 2120491.13146 | 37.8024786510429 | -122.443228011273 | (37.8024786510429, -122.443228011273) | |||
| 166896 | 166896 | 129317 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2644 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006616.02783 | 2120357.98991 | 37.8024723152946 | -122.421293577158 | (37.8024723152946, -122.421293577158) | |||
| 67509 | 67509 | 129357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1181 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006225.24006 | 2120361.15088 | 37.8024589549865 | -122.422646123319 | (37.8024589549865, -122.422646123319) | |||
| 163136 | 163136 | 129352 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6011406.69978 | 2120255.02893 | 37.8024585322873 | -122.404708135188 | (37.8024585322873, -122.404708135188) | |||
| 174140 | 174140 | 49714 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | |
| 135513 | 135513 | 129132 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3542 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000281.80115 | 2120477.64903 | 37.8024417203612 | -122.443221673766 | (37.8024417203612, -122.443221673766) | |||
| 136076 | 136076 | 129316 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2644 Larkin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6006618.63379 | 2120343.47812 | 37.802432616528 | -122.42128352811599 | (37.802432616528, -122.421283528116) | |||
| 185888 | 185888 | 129338 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 928 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007904.15055 | 2120316.35403 | 37.802430530998 | -122.41683307021098 | (37.802430530998, -122.416833070211) | |||
| 69391 | 69391 | 129339 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 928 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007894.75128 | 2120315.04124 | 37.802426397722 | -122.416865503351 | (37.802426397722, -122.416865503351) | |||
| 27010 | 27010 | 61931 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1407 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1985 12:00:00 AM | 11 | Permit Number 21986 | 6011381.98525 | 2120211.6051 | 37.8023379197065 | -122.404790601229 | (37.8023379197065, -122.404790601229) | ||
| 75728 | 75728 | 129145 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999381.832219999 | 2120449.61925 | 37.8023133997084 | -122.446333981843 | (37.8023133997084, -122.446333981843) | |||
| 133496 | 133496 | 129144 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999344.27548 | 2120444.47832 | 37.8022971390685 | -122.44646357594499 | (37.8022971390685, -122.446463575945) | |||
| 53748 | 53748 | 129347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1407 Montgomery St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6011383.96992 | 2120196.49956 | 37.802296554515 | -122.404782669181 | (37.802296554515, -122.404782669181) | |||
| 33330 | 33330 | 129143 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999331.215369999 | 2120442.50933 | 37.8022909867986 | -122.44650862838199 | (37.8022909867986, -122.446508628382) | |||
| 60331 | 60331 | 129142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999327.82814 | 2120441.93946 | 37.802289228618 | -122.44652030878099 | (37.802289228618, -122.446520308781) | |||
| 173057 | 173057 | 129141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5999324.440909999 | 2120441.3696 | 37.8022874704637 | -122.44653198918002 | (37.8022874704637, -122.44653198918) | |||
| 54485 | 54485 | 129140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999315.42401 | 2120440.5968400002 | 37.8022848336387 | -122.44656313629801 | (37.8022848336387, -122.446563136298) | |||
| 59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
| 164147 | 164147 | 129198 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3537 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002132.11244 | 2120360.66499 | 37.8022258462139 | -122.436810313348 | (37.8022258462139, -122.436810313348) | |||
| 154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
| 135341 | 135341 | 129188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5999731.06738 | 2120400.48948 | 37.80219844206879 | -122.44512192772899 | (37.8021984420688, -122.445121927729) | |||
| 26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
| 188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) | |||
| 27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 149522 | 149522 | 129337 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Leavenworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007623.973619999 | 2120107.6373799997 | 37.8018416845956 | -122.41778782015301 | (37.8018416845956, -122.417787820153) | |||
| 62291 | 62291 | 129336 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007624.53894 | 2120096.3685 | 37.8018107749031 | -122.417785064649 | (37.8018107749031, -122.417785064649) | |||
| 6044 | 6044 | 107491 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6011446.048280001 | 2119975.7461599996 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | ||||
| 151655 | 151655 | 129180 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5998992.55112 | 2120173.79871 | 37.8015338304744 | -122.447661212108 | (37.8015338304744, -122.447661212108) | ||||
| 188832 | 188832 | 129179 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5998993.68481 | 2120160.70419 | 37.801497941247895 | -122.44765634587601 | (37.8014979412479, -122.447656345876) | ||||
| 35098 | 35098 | 142469 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 548 VARENNES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010746.4928 | 2119899.9648 | 37.8014466914345 | -122.40696774883999 | (37.8014466914345, -122.40696774884) | |||
| 138216 | 138216 | 129178 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998998.34734 | 2120131.24528 | 37.801417321497794 | -122.447638089651 | (37.8014173214978, -122.447638089651) | ||||
| 175305 | 175305 | 129291 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1351 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 6005939.01276 | 2119972.76765 | 37.8013764014559 | -122.423608983393 | (37.8013764014559, -122.423608983393) | |||
| 32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
| 74501 | 74501 | 129333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007566.1830400005 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | ||||
| 31573 | 31573 | 129332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007563.684280001 | 2119863.77685 | 37.8011687120311 | -122.417979152724 | (37.8011687120311, -122.417979152724) |
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");