Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40945 | 40945 | 196597 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1251 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6014153.4442300005 | 2104763.78989 | 37.76007625593729 | -122.39411782218599 | (37.7600762559373, -122.394117822186) | ||||
| 183336 | 183336 | 247915 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 399 Franconia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009998.26355 | 2098850.98079 | 37.7436091683313 | -122.40807167067899 | (37.7436091683313, -122.408071670679) | ||||
| 16929 | 16929 | 16335 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996588.55754 | 2094717.49275 | 37.7314996764704 | -122.454140408353 | (37.7314996764704, -122.454140408353) | ||
| 17060 | 17060 | 16342 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5996198.48565 | 2094691.8474400002 | 37.731406885306704 | -122.455487100866 | (37.7314068853067, -122.455487100866) | |||
| 17099 | 17099 | 16338 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996505.10477 | 2094713.35848 | 37.7314835390346 | -122.454428620411 | (37.7314835390346, -122.454428620411) | ||
| 17126 | 17126 | 16113 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999657.47743 | 2094677.0013700002 | 37.7315639977654 | -122.443527690574 | (37.7315639977654, -122.443527690574) | ||
| 17206 | 17206 | 16009 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001288.3370900005 | 2094653.38984 | 37.731592040430705 | -122.43788781177099 | (37.7315920404307, -122.437887811771) | ||
| 17393 | 17393 | 16115 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999569.73094 | 2094680.4197799999 | 37.7315683792686 | -122.44383129178101 | (37.7315683792686, -122.443831291781) | ||
| 17507 | 17507 | 16015 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000956.04768 | 2094656.76286 | 37.731582400588294 | -122.43903684047899 | (37.7315824005883, -122.439036840479) | |||
| 17516 | 17516 | 16016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000925.306059999 | 2094658.03828 | 37.7315841533775 | -122.43914321141001 | (37.7315841533775, -122.43914321141) | |||
| 18176 | 18176 | 16013 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6001154.39221 | 2094654.56847 | 37.731587658935396 | -122.43835096892201 | (37.7315876589354, -122.438350968922) | |||
| 18343 | 18343 | 16048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 4 | 6000504.30929 | 2094664.8510599998 | 37.7315788950381 | -122.440599164328 | (37.7315788950381, -122.440599164328) | ||
| 18764 | 18764 | 16103 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/2012 12:00:00 AM | 2 | 5 | 6000043.907980001 | 2094672.48858 | 37.7315736376005 | -122.44219140500799 | (37.7315736376005, -122.442191405008) | ||
| 18929 | 18929 | 16187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999317.5789 | 2094684.3827099998 | 37.731564874619 | -122.44470331222901 | (37.731564874619, -122.444703312229) | |||
| 19005 | 19005 | 16334 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996621.72685 | 2094716.0654099998 | 37.731497659285104 | -122.45402563328001 | (37.7314976592851, -122.45402563328) | ||
| 19414 | 19414 | 16111 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999725.13349 | 2094678.46865 | 37.7315718848268 | -122.443293896493 | (37.7315718848268, -122.443293896493) | |||
| 19610 | 19610 | 16184 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999406.634869999 | 2094682.7033 | 37.7315653449635 | -122.444395308802 | (37.7315653449635, -122.444395308802) | |||
| 19708 | 19708 | 16012 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001201.17189 | 2094653.91848 | 37.7315885348835 | -122.43818919619301 | (37.7315885348835, -122.438189196193) | ||
| 19907 | 19907 | 16336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996559.751619999 | 2094715.89038 | 37.7314936249086 | -122.454239879686 | (37.7314936249086, -122.454239879686) | ||
| 20214 | 20214 | 16047 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6000544.66834 | 2094663.6950599998 | 37.731578019092396 | -122.440459552683 | (37.7315780190924, -122.440459552683) | ||||
| 20354 | 20354 | 27346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000818.28486 | 2094659.29899 | 37.731581524667504 | -122.43951329411301 | (37.7315815246675, -122.439513294113) | |||
| 20419 | 20419 | 16017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000892.30856 | 2094658.72213 | 37.7315841533843 | -122.43925733896002 | (37.7315841533843, -122.43925733896) | |||
| 20443 | 20443 | 16112 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999693.39114 | 2094677.85118 | 37.7315683792706 | -122.443403591302 | (37.7315683792706, -122.443403591302) | |||
| 20512 | 20512 | 16106 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999928.25024 | 2094674.5701 | 37.731572760761104 | -122.44259140457599 | (37.7315727607611, -122.442591404576) | |||
| 20548 | 20548 | 16117 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999494.77273 | 2094682.2963900003 | 37.7315692561142 | -122.444090570848 | (37.7315692561142, -122.444090570848) | |||
| 20576 | 20576 | 16110 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999765.47289 | 2094676.3542 | 37.731568379273604 | -122.44315428395299 | (37.7315683792736, -122.443154283953) | |||
| 20585 | 20585 | 16345 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5995755.81545 | 2094589.49777 | 37.731100446724206 | -122.457010084748 | (37.7311004467242, -122.457010084748) | ||
| 20748 | 20748 | 16333 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996646.10828 | 2094717.76023 | 37.73150371082821 | -122.45394146482501 | (37.7315037108282, -122.453941464825) | ||
| 20825 | 20825 | 16116 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999533.21631 | 2094681.49769 | 37.7315692561025 | -122.443957606973 | (37.7315692561025, -122.443957606973) | |||
| 20950 | 20950 | 16018 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/17/1999 12:00:00 AM | 3 | 4 | 6000862.51501 | 2094659.33961 | 37.7315841533767 | -122.439360385099 | (37.7315841533767, -122.439360385099) | ||
| 21018 | 21018 | 16105 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999954.50012 | 2094673.06778 | 37.731570132038605 | -122.44250054607001 | (37.7315701320386, -122.44250054607) | |||
| 21150 | 21150 | 16014 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000994.83808 | 2094657.2357700001 | 37.731585906153605 | -122.438902768653 | (37.7315859061536, -122.438902768653) | |||
| 21442 | 21442 | 16337 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996530.991719999 | 2094716.49105 | 37.7314936249203 | -122.45433935097799 | (37.7314936249203, -122.454339350978) | ||
| 21731 | 21731 | 16185 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999375.230880001 | 2094682.54623 | 37.7315631218391 | -122.444503866854 | (37.7315631218391, -122.444503866854) | |||
| 21825 | 21825 | 16108 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999847.20496 | 2094676.5721 | 37.73157363759471 | -122.442871736768 | (37.7315736375947, -122.442871736768) | ||
| 21898 | 21898 | 16003 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/1991 12:00:00 AM | 6 | 8 | 6001466.12546 | 2094649.0700400001 | 37.731590287660204 | -122.437272854464 | (37.7315902876602, -122.437272854464) | ||
| 21903 | 21903 | 16349 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995791.20776 | 2094597.86 | 37.731125439778204 | -122.45688833275699 | (37.7311254397782, -122.456888332757) | ||
| 21947 | 21947 | 16332 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996671.90319 | 2094716.4869400002 | 37.7315016936337 | -122.45385219544599 | (37.7315016936337, -122.453852195446) | ||
| 22037 | 22037 | 16114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999608.79533 | 2094678.6509200002 | 37.731565750540206 | -122.44369611198299 | (37.7315657505402, -122.443696111983) | ||
| 22058 | 22058 | 16104 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 6000001.946959999 | 2094673.6785799998 | 37.7315745135446 | -122.44233655741199 | (37.7315745135446, -122.442336557412) | |||
| 22122 | 22122 | 16045 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5x250 | 6000618.04474 | 2094662.8118599998 | 37.731579771873 | -122.440205813454 | (37.731579771873, -122.440205813454) | |||
| 22125 | 22125 | 16043 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 6000692.70251 | 2094661.9023 | 37.731581524671995 | -122.43994764238701 | (37.731581524672, -122.439947642387) | |||
| 22159 | 22159 | 16044 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000655.54054 | 2094662.67277 | 37.7315815246572 | -122.44007617349399 | (37.7315815246572, -122.440076173494) | |||
| 22999 | 22999 | 16007 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8 | 6001364.53052 | 2094649.25854 | 37.7315850293086 | -122.43762410089799 | (37.7315850293086, -122.437624100898) | |||
| 23095 | 23095 | 16341 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996216.96756 | 2094693.6651599999 | 37.7314129368354 | -122.45542333713999 | (37.7314129368354, -122.45542333714) | ||
| 23159 | 23159 | 16339 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996276.20802 | 2094704.1816900002 | 37.7314452117282 | -122.45521929265 | (37.7314452117282, -122.45521929265) | ||
| 23198 | 23198 | 16002 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3 | 6001503.91519 | 2094647.64932 | 37.7315885348642 | -122.43714210651699 | (37.7315885348642, -122.437142106517) | |||
| 23328 | 23328 | 16189 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 9 | 5 | 5999260.86144 | 2094684.92317 | 37.73156312182861 | -122.444899433678 | (37.7315631218286, -122.444899433678) | ||
| 27159 | 27159 | 213778 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5998914.18909 | 2094690.21596 | 37.7315578635039 | -122.446098323489 | (37.7315578635039, -122.446098323489) | |||
| 41060 | 41060 | 213777 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5998950.72386 | 2094690.09449 | 37.7315596162741 | -122.445972007429 | (37.7315596162741, -122.445972007429) | |||
| 51502 | 51502 | 213776 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5998982.76667 | 2094689.74714 | 37.7315604922086 | -122.445861204645 | (37.7315604922086, -122.445861204645) | |||
| 71532 | 71532 | 213774 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 4ft | 6000159.57208 | 2094670.72644 | 37.731575390387505 | -122.441791406357 | (37.7315753903875, -122.441791406357) | |||
| 130007 | 130007 | 213772 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 4ft | 6000240.95758 | 2094669.6760099998 | 37.7315771431566 | -122.44150996622601 | (37.7315771431566, -122.441509966226) | |||
| 132568 | 132568 | 213779 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 5998879.57 | 2094689.9786099999 | 37.7315552347673 | -122.446217990889 | (37.7315552347673, -122.446217990889) | |||
| 135174 | 135174 | 213771 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 4ft | 6000270.431030001 | 2094669.0644900003 | 37.731577143173105 | -122.441408027169 | (37.7315771431731, -122.441408027169) | |||
| 159951 | 159951 | 213773 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 6000197.388230001 | 2094670.5800599998 | 37.731577143151796 | -122.44166065841002 | (37.7315771431518, -122.44166065841) | |||
| 171663 | 171663 | 213770 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 6000315.2619 | 2094667.17668 | 37.731574513540004 | -122.441252903117 | (37.73157451354, -122.441252903117) | |||
| 182389 | 182389 | 239871 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 322x Elsie St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6006320.05712 | 2096908.09305 | 37.7380678030916 | -122.420652136603 | (37.7380678030916, -122.420652136603) | |||
| 185266 | 185266 | 213775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5999015.12983 | 2094689.3935 | 37.731561369058795 | -122.44574929389799 | (37.7315613690588, -122.445749293898) | |||
| 33874 | 33874 | 196602 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 608 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013520.1448 | 2104276.81958 | 37.758703921979794 | -122.396273986373 | (37.7587039219798, -122.396273986373) | |||
| 57091 | 57091 | 179247 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 353 Prague St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6003781.052759999 | 2089121.49913 | 37.7165441288874 | -122.42887576852199 | (37.7165441288874, -122.428875768522) | |||
| 71563 | 71563 | 196601 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 598 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6013516.47989 | 2104326.37457 | 37.7588397852535 | -122.39629013460501 | (37.7588397852535, -122.396290134605) | |||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 146412 | 146412 | 239773 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 417 Eureka St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6001524.1364 | 2103380.5723200003 | 37.755568234207296 | -122.43769740552601 | (37.7555682342073, -122.437697405526) | |||
| 150261 | 150261 | 136061 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3311 Pacific Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 5998344.32344 | 2116484.47626 | 37.7913668733358 | -122.44963835901699 | (37.7913668733358, -122.449638359017) | |||
| 158526 | 158526 | 239766 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1661 Noe St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 6003395.97584 | 2098595.19502 | 37.7425349632095 | -122.43088250404101 | (37.7425349632095, -122.430882504041) | |||
| 167574 | 167574 | 196603 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 618 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013523.1670699995 | 2104217.2762 | 37.7585405969979 | -122.39625936070101 | (37.7585405969979, -122.396259360701) | |||
| 174712 | 174712 | 239763 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4233 Cesar Chavez St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6002389.599719999 | 2100306.5087200003 | 37.7471767573086 | -122.43448458290199 | (37.7471767573086, -122.434484582902) | |||
| 180105 | 180105 | 238990 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1017 Guerrero St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005766.99533 | 2102918.3127900003 | 37.7545393108464 | -122.422991404546 | (37.7545393108464, -122.422991404546) | |||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 24120 | 24120 | 179207 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006573.63704 | 2087691.58982 | 37.7127755684169 | -122.41912182232402 | (37.7127755684169, -122.419121822324) | |||
| 26179 | 26179 | 179193 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005644.83636 | 2087196.5165400002 | 37.7113638531203 | -122.422296907583 | (37.7113638531203, -122.422296907583) | |||
| 26875 | 26875 | 179199 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | |||
| 26907 | 26907 | 179220 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006068.28025 | 2087832.3093700001 | 37.7131334823856 | -122.420878485149 | (37.7131334823856, -122.420878485149) | |||
| 28202 | 28202 | 179238 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 700 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999059.277319999 | 2090470.23045 | 37.7199790480791 | -122.44529342577499 | (37.7199790480791, -122.445293425775) | |||
| 28265 | 28265 | 179185 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007214.91098 | 2087479.51248 | 37.7122293408956 | -122.41689035163401 | (37.7122293408956, -122.416890351634) | |||
| 28483 | 28483 | 179209 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1772 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6006471.88428 | 2087727.6982 | 37.712868983682604 | -122.419476073376 | (37.7128689836826, -122.419476073376) | |||
| 29074 | 29074 | 213845 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 73 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998199.26355 | 2097275.97243 | 37.7386168814741 | -122.44875612502199 | (37.7386168814741, -122.448756125022) | |||
| 30562 | 30562 | 179219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1901 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6005910.8454 | 2087904.7300099998 | 37.7133234587798 | -122.42142777398399 | (37.7133234587798, -122.421427773984) | |||
| 31551 | 31551 | 179200 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006727.82618 | 2086918.41314 | 37.7106612694605 | -122.418534101884 | (37.7106612694605, -122.418534101884) | |||
| 36922 | 36922 | 179240 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 728 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5998999.67835 | 2090356.64376 | 37.719663762863796 | -122.445491274825 | (37.7196637628638, -122.445491274825) | |||
| 39093 | 39093 | 179201 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006633.11275 | 2086991.19455 | 37.7108557793466 | -122.418866611803 | (37.7108557793466, -122.418866611803) | |||
| 40967 | 40967 | 179215 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6005901.26281 | 2087961.5006799998 | 37.7134787986892 | -122.421464924083 | (37.7134787986892, -122.421464924083) | |||
| 41514 | 41514 | 240089 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4725 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5999807.85553 | 2105040.70574 | 37.7600288158025 | -122.44375208219 | (37.7600288158025, -122.44375208219) | |||
| 42567 | 42567 | 179214 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005943.70452 | 2087934.63592 | 37.7134074266914 | -122.421316323695 | (37.7134074266914, -122.421316323695) | |||
| 44475 | 44475 | 179208 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006534.036859999 | 2087707.31011 | 37.712816502856796 | -122.419259808007 | (37.7128165028568, -122.419259808007) | |||
| 44669 | 44669 | 179195 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005631.155180001 | 2087152.0442 | 37.7112409697606 | -122.422341035527 | (37.7112409697606, -122.422341035527) | |||
| 44818 | 44818 | 241264 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 32 Harry St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003140.40772 | 2097623.29696 | 37.739851871854704 | -122.43169680777399 | (37.7398518718547, -122.431696807774) | |||
| 47532 | 47532 | 213788 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 409 Edna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998741.333869999 | 2094177.6114700001 | 37.73014049957229 | -122.44665904717199 | (37.7301404995723, -122.446659047172) | ||||
| 48309 | 48309 | 179212 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6006336.27941 | 2087779.02675 | 37.713002282110295 | -122.419948408995 | (37.7130022821103, -122.419948408995) | |||
| 49167 | 49167 | 179194 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005636.53153 | 2087165.1563799998 | 37.7112772763038 | -122.422323384518 | (37.7112772763038, -122.422323384518) | |||
| 50936 | 50936 | 179196 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005626.77881 | 2087137.8945099998 | 37.7112018708407 | -122.42235515666599 | (37.7112018708407, -122.422355156666) | |||
| 51449 | 51449 | 179241 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 736 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5998977.898569999 | 2090313.82891 | 37.7195449597169 | -122.44556348228599 | (37.7195449597169, -122.445563482286) | |||
| 51456 | 51456 | 179205 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6006698.43617 | 2087637.4256 | 37.7126338721354 | -122.418686636782 | (37.7126338721354, -122.418686636782) | |||
| 54048 | 54048 | 179198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 122 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6006476.020330001 | 2086698.2398299999 | 37.7100425404106 | -122.41938879147 | (37.7100425404106, -122.41938879147) | |||
| 54258 | 54258 | 179206 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006680.55061 | 2087645.0552700001 | 37.712653814591 | -122.418748995784 | (37.712653814591, -122.418748995784) | |||
| 55470 | 55470 | 179197 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 165 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005726.28272 | 2087133.8162 | 37.7111962851662 | -122.42201095643499 | (37.7111962851662, -122.422010956435) | |||
| 57344 | 57344 | 179191 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005654.25627 | 2087232.43068 | 37.711462997092205 | -122.42226689991999 | (37.7114629970922, -122.42226689992) |
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");