Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188165 | 188165 | 213870 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 340 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992329.85759 | 2094645.8649 | 37.731057880912104 | -122.468858209345 | (37.7310578809121, -122.468858209345) | |||
75232 | 75232 | 239128 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 346 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006911.82474 | 2096010.5177799999 | 37.7356365938626 | -122.41854246738701 | (37.7356365938626, -122.418542467387) | |||
82032 | 82032 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3524 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||
79435 | 79435 | 113168 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
115104 | 115104 | 113167 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
88696 | 88696 | 16157 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
109184 | 109184 | 16158 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
126834 | 126834 | 16155 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
139515 | 139515 | 16160 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
9634 | 9634 | 59356 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 401 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/1981 12:00:00 AM | Permit Number 770924 | 6003905.57557543 | 2096316.85188886 | 37.7363080142655 | -122.428958058919 | (37.7363080142655, -122.428958058919) | |||
42889 | 42889 | 213890 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 404 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991686.41791 | 2097763.49025 | 37.739580898037204 | -122.47130973604999 | (37.7395808980372, -122.47130973605) | |||
101946 | 101946 | 106725 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 421 CAMBRIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6006955.4 | 2092560.1 | 37.7261649524701 | -122.418147266884 | (37.7261649524701, -122.418147266884) | ||||
60892 | 60892 | 123270 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993763.95635 | 2112364.19662 | 37.7797906029426 | -122.465186799304 | (37.7797906029426, -122.465186799304) | |||
97527 | 97527 | 16188 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999032.780474599 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | |||
111934 | 111934 | 16186 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999032.780474599 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | |||
131717 | 131717 | 239141 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 479 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007510.966109999 | 2096684.13991 | 37.73751992438871 | -122.416518701402 | (37.7375199243887, -122.416518701402) | |||
158578 | 158578 | 239140 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 479 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007508.73883 | 2096670.3114099998 | 37.7374818291124 | -122.416525422908 | (37.7374818291124, -122.416525422908) | |||
75148 | 75148 | 197021 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Lucy St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6014107.2197 | 2093837.90133 | 37.730073491982104 | -122.39351302630199 | (37.7300734919821, -122.393513026302) | |||
35589 | 35589 | 239133 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997104.10967 | 2106248.8991099996 | 37.7631916235237 | -122.45319021077 | (37.7631916235237, -122.45319021077) | |||
47042 | 47042 | 239132 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997107.26688 | 2106225.7182299998 | 37.763128155674295 | -122.45317761755899 | (37.7631281556743, -122.453177617559) | |||
26940 | 26940 | 213898 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 521 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994465.82932 | 2099713.9197 | 37.7450966757864 | -122.461841193329 | (37.7450966757864, -122.461841193329) | |||
29493 | 29493 | 213880 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 531 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992597.19998 | 2104535.76314 | 37.7582284620821 | -122.468653311406 | (37.7582284620821, -122.468653311406) | |||
150668 | 150668 | 197019 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 586 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013514.03834 | 2104373.90914 | 37.7589701689629 | -122.39630191030399 | (37.7589701689629, -122.396301910304) | |||
60149 | 60149 | 213871 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995619.92029 | 2093040.27058 | 37.726838837427394 | -122.457367857563 | (37.7268388374274, -122.457367857563) | |||
64604 | 64604 | 213872 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 59 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995621.30563 | 2093030.0501400002 | 37.7268108541226 | -122.45736232942801 | (37.7268108541226, -122.457362329428) | |||
149842 | 149842 | 213873 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 59 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5995622.40469 | 2093021.42815 | 37.7267872433344 | -122.45735790654301 | (37.7267872433344, -122.457357906543) | |||
120553 | 120553 | 22818 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 60 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 3X3 | 5998904.0126134 | 2099759.7693507997 | 37.745477066338 | -122.446498092976 | (37.745477066338, -122.446498092976) | ||
82103 | 82103 | 101351 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
94717 | 94717 | 101347 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
102247 | 102247 | 101355 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
102702 | 102702 | 101349 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
110407 | 110407 | 101354 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
118971 | 118971 | 101348 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
125359 | 125359 | 101352 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
144865 | 144865 | 101346 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
94639 | 94639 | 110388 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
110197 | 110197 | 110391 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
120421 | 120421 | 110392 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
124276 | 124276 | 110389 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
143071 | 143071 | 110390 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
150664 | 150664 | 239130 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997119.03338 | 2106135.27891 | 37.762880506665894 | -122.453130392348 | (37.7628805066659, -122.453130392348) | |||
160763 | 160763 | 239131 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997117.0518 | 2106149.37077 | 37.762919085762796 | -122.45313826323799 | (37.7629190857628, -122.453138263238) | |||
84527 | 84527 | 22821 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 64 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 5998921.4611914 | 2099744.1843889 | 37.7454352704129 | -122.446436637784 | (37.7454352704129, -122.446436637784) | ||
58772 | 58772 | 241393 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 66 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005160.70352 | 2105758.78708 | 37.7623043550961 | -122.425290238962 | (37.7623043550961, -122.425290238962) | |||
32443 | 32443 | 75280 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 6 | 5990643.53954 | 2110726.24693 | 37.7751128080708 | -122.47586192808001 | (37.7751128080708, -122.47586192808) | ||
66710 | 66710 | 37627 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 7 | Permit Number 40046 | 5990643.14238 | 2110768.20372 | 37.7752279868902 | -122.47586636665599 | (37.7752279868902, -122.475866366656) | ||
150174 | 150174 | 37623 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40046 | 5990638.79232 | 2110815.35438 | 37.775357197462505 | -122.475884858491 | (37.7753571974625, -122.475884858491) | ||
178384 | 178384 | 37625 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40046 | 5990637.59379 | 2110880.1121400003 | 37.7755349350232 | -122.47589373474199 | (37.7755349350232, -122.475893734742) | ||
92010 | 92010 | 18658 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016334.44824 | 2095879.1633400002 | 37.7358018906208 | -122.38595537929599 | (37.7358018906208, -122.385955379296) | |||
114263 | 114263 | 18659 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016312.43294 | 2095882.6817 | 37.7358103329414 | -122.386031740711 | (37.7358103329414, -122.386031740711) | |||
9410 | 9410 | 24298 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016301.484983 | 2096086.6955833 | 37.736369908087795 | -122.38608381002399 | (37.7363699080878, -122.386083810024) | |||
9761 | 9761 | 122592 | Planning Code 138.1 required 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
48141 | 48141 | 213891 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 730 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990628.53589 | 2097727.79467 | 37.7394216362019 | -122.47496479221701 | (37.7394216362019, -122.474964792217) | |||
165037 | 165037 | 213892 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 734 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990616.45042 | 2097727.17 | 37.7394192206197 | -122.475006532441 | (37.7394192206197, -122.475006532441) | |||
165229 | 165229 | 213893 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 738 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990593.74457 | 2097725.59661 | 37.7394135845647 | -122.475084923648 | (37.7394135845647, -122.475084923648) | |||
171128 | 171128 | 213894 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 740 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990581.9781599995 | 2097726.13845 | 37.739414390369 | -122.47512564584 | (37.739414390369, -122.47512564584) | |||
62234 | 62234 | 213895 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 744 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990568.43351 | 2097726.13088 | 37.739413584555 | -122.475172476244 | (37.739413584555, -122.475172476244) | |||
38246 | 38246 | 213896 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 750 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990556.3666 | 2097726.3856099998 | 37.7394135845816 | -122.475214216469 | (37.7394135845816, -122.475214216469) | |||
11816 | 11816 | 56918 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 757 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1974 12:00:00 AM | 8 | 3x3 | Permit Number 14160 | 6002721.67474 | 2088983.8970400002 | 37.716106284944 | -122.432527678806 | (37.716106284944, -122.432527678806) | |
11975 | 11975 | 105023 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 761 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002706.48951 | 2088960.92893 | 37.7160423584316 | -122.432578526497 | (37.7160423584316, -122.432578526497) | |||
71830 | 71830 | 239136 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 79 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997078.63554 | 2106086.03977 | 37.762742993126395 | -122.453266558717 | (37.7627429931264, -122.453266558717) | |||
136390 | 136390 | 239135 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 8 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997054.7082 | 2106607.75583 | 37.76417412116329 | -122.45338698333599 | (37.7641741211633, -122.453386983336) | |||
35517 | 35517 | 213903 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 82 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995638.7479 | 2093177.24169 | 37.727216008587206 | -122.45731267605301 | (37.7272160085872, -122.457312676053) | |||
56473 | 56473 | 213904 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 82 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995638.93402 | 2093163.65377 | 37.727178710112796 | -122.457311050068 | (37.7271787101128, -122.457311050068) | |||
135627 | 135627 | 213863 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 827 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992302.54475 | 2105211.64406 | 37.7600672276448 | -122.469721553127 | (37.7600672276448, -122.469721553127) | |||
83307 | 83307 | 24349 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 85 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 3 | 2x2 | 6006210.36104 | 2108383.4741700003 | 37.769570370002604 | -122.421846308181 | (37.7695703700026, -122.421846308181) | ||
68515 | 68515 | 213907 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 9 Locksley Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994127.50266 | 2104950.54632 | 37.759455632884396 | -122.463390998614 | (37.7594556328844, -122.463390998614) | |||
134659 | 134659 | 213908 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 9 Locksley Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994103.8781 | 2104889.3347400003 | 37.7592862006088 | -122.46346826115101 | (37.7592862006088, -122.463468261151) | |||
172670 | 172670 | 213901 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995124.969409999 | 2093273.24619 | 37.7274500913228 | -122.459095741174 | (37.7274500913228, -122.459095741174) | |||
166454 | 166454 | 241396 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 952 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010191.29772 | 2103654.4580900003 | 37.7568092635594 | -122.407742832678 | (37.7568092635594, -122.407742832678) |
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");