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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94992 | 94992 | 91623 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1376 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6007700.506204 | 2101645.30329 | 37.751152830563996 | -122.416214640532 | (37.751152830564, -122.416214640532) | |||
| 125529 | 125529 | 106710 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3869 19th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit Number 772840 | 6003862.3 | 2104785.7 | 37.7595590509906 | -122.429711522366 | (37.7595590509906, -122.429711522366) | ||||
| 99 | 99 | 7992 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2247 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2007 12:00:00 AM | 3 | 3X3 | 6005467.69382 | 2117725.44397 | 37.7951792074025 | -122.42507996488001 | (37.7951792074025, -122.42507996488) | ||
| 250 | 250 | 24634 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 507 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2011 12:00:00 AM | 3 | 3x3 | 6001641.187000001 | 2110229.9881 | 37.774381702191896 | -122.437783152308 | (37.7743817021919, -122.437783152308) | ||
| 335 | 335 | 244346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005627.7176 | 2110356.4274 | 37.77495474924589 | -122.42400197393101 | (37.7749547492459, -122.424001973931) | |||
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 657 | 657 | 5214 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | |
| 735 | 735 | 24812 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2425 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002709.02465 | 2116620.06864 | 37.7919879109555 | -122.434546304291 | (37.7919879109555, -122.434546304291) | ||
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 906 | 906 | 238924 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1362 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777634 | 6007680.96975 | 2101719.66165 | 37.751355903252 | -122.41628746589 | (37.751355903252, -122.41628746589) | |
| 974 | 974 | 238894 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1169 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | Width 3ft | 6007686.52324 | 2102853.55253 | 37.7544696223947 | -122.416348565858 | (37.7544696223947, -122.416348565858) | ||
| 980 | 980 | 22300 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 5000 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6014732.2229 | 2094948.8267 | 37.7331585757016 | -122.391429927203 | (37.7331585757016, -122.391429927203) | |||
| 985 | 985 | 97601 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 855 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001476.9066 | 2111398.2834 | 37.7775802046297 | -122.43843514847099 | (37.7775802046297, -122.438435148471) | ||
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 1422 | 1422 | 196745 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1201X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45465 | 6012738.02923 | 2107105.72844 | 37.7664279283277 | -122.399177491654 | (37.7664279283277, -122.399177491654) | |
| 1488 | 1488 | 28091 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 550 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 3x3 | 6001688.8969 | 2110354.8179 | 37.7747271663388 | -122.437627056778 | (37.7747271663388, -122.437627056778) | ||
| 1534 | 1534 | 196952 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | |||
| 1552 | 1552 | 196579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6010663.40725 | 2110593.10143 | 37.775887617266605 | -122.406599041617 | (37.7758876172666, -122.406599041617) | |||
| 1856 | 1856 | 196887 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 117 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 02:46:00 PM | 3 | Width 4ft | 6010241.60385 | 2112346.00757 | 37.7806770791096 | -122.408181831346 | (37.7806770791096, -122.408181831346) | ||
| 2146 | 2146 | 87638 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 2197 | 2197 | 24571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2252 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002831.271980001 | 2116073.36845 | 37.7904937512412 | -122.434084229923 | (37.7904937512412, -122.434084229923) | ||
| 2235 | 2235 | 238906 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 814 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007504.98766 | 2104898.95905 | 37.7600756291027 | -122.41712128944201 | (37.7600756291027, -122.417121289442) | ||
| 2484 | 2484 | 5197 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 631 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 3X3 | 6001585.1623 | 2110622.5519999997 | 37.7754563984119 | -122.438005076955 | (37.7754563984119, -122.438005076955) | |
| 2591 | 2591 | 136074 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2401 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 26 | Width 4ft | 6002725.26696 | 2116528.42543 | 37.7917372042589 | -122.43448355047701 | (37.7917372042589, -122.434483550477) | ||
| 2592 | 2592 | 136073 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2411 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 7 | Width 4ft | 6002715.712669999 | 2116586.15023 | 37.79189515937421 | -122.434520737442 | (37.7918951593742, -122.434520737442) | ||
| 2634 | 2634 | 7336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.43379176139601 | (37.789082847149, -122.433791761396) | |
| 2929 | 2929 | 28092 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 528 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/12/2001 12:00:00 AM | 3 | 3X3 | 6001704.4418 | 2110256.1887 | 37.774457239071104 | -122.43756621922199 | (37.7744572390711, -122.437566219222) | |
| 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 | ||||||||
| 3014 | 3014 | 141613 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 705 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001544.5033 | 2110907.0163 | 37.7762351536088 | -122.43816610813299 | (37.7762351536088, -122.438166108133) | |||
| 3054 | 3054 | 7358 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2318 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6002802.77917 | 2116286.9525200003 | 37.791078581270106 | -122.434198088572 | (37.7910785812701, -122.434198088572) | ||
| 3211 | 3211 | 239952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 5 | Width 3ft | Permit Number 42822 | 6008805.731790001 | 2103926.75101 | 37.7574792557704 | -122.412553896246 | (37.7574792557704, -122.412553896246) | |
| 3254 | 3254 | 244746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 98 12th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6007069.86029 | 2109755.10428 | 37.7733849739584 | -122.418970623803 | (37.7733849739584, -122.418970623803) | |||
| 3626 | 3626 | 5935 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1357 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003980.6032 | 2112841.5446 | 37.7816851365454 | -122.429876994211 | (37.7816851365454, -122.429876994211) | |||
| 3651 | 3651 | 240097 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 114 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 7 | Width 3ft | Permit Number 31402 | 6002724.24367 | 2107408.57095 | 37.766696310316796 | -122.433834955823 | (37.7666963103168, -122.433834955823) | |
| 3798 | 3798 | 5199 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 643 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001573.1748 | 2110709.1284 | 37.7756934337528 | -122.43805274745701 | (37.7756934337528, -122.438052747457) | |
| 3877 | 3877 | 38690 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1529 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2013 12:00:00 AM | 8 | 6x5 | Permit Number 40603 | 6000458.9819 | 2110614.4446 | 37.7753700290705 | -122.441900209231 | (37.7753700290705, -122.441900209231) |
| 3905 | 3905 | 196577 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | |||
| 3998 | 3998 | 159324 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 516 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:39:00 AM | 3 | Width 0ft | 5998061.98233 | 2087178.88925 | 37.710884802276205 | -122.44850380581998 | (37.7108848022762, -122.44850380582) | ||
| 4015 | 4015 | 159294 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 118 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:12:00 PM | 3 | Width 0ft | 5998151.37307 | 2087303.3135799998 | 37.7112315538724 | -122.44820380548799 | (37.7112315538724, -122.448203805488) | ||
| 4025 | 4025 | 159222 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 384 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:28:00 AM | 3 | Width 0ft | 5998624.92984 | 2087716.64467 | 37.712393528324206 | -122.446596800611 | (37.7123935283242, -122.446596800611) | ||
| 4042 | 4042 | 179821 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 364 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:07:00 AM | 3 | Width 2ft | 5998698.94465 | 2087786.79601 | 37.712590375508796 | -122.446346027354 | (37.7125903755088, -122.446346027354) | ||
| 4087 | 4087 | 159329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 556 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:09:00 AM | 3 | Width 0ft | 5997921.94288 | 2087046.44589 | 37.7105131349458 | -122.448978278232 | (37.7105131349458, -122.448978278232) | ||
| 4104 | 4104 | 159219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 366 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:32:00 AM | 3 | Width 0ft | 5998673.37335 | 2087760.7240000002 | 37.7125173271842 | -122.446432534932 | (37.7125173271842, -122.446432534932) | ||
| 4119 | 4119 | 159216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 326 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:09:00 AM | 3 | Width 0ft | 5998830.44796 | 2087909.1779599998 | 37.712933918350394 | -122.445900308946 | (37.7129339183504, -122.445900308946) | ||
| 4129 | 4129 | 216706 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 231 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:40:00 AM | 3 | Width 3ft | 5994712.86869 | 2090137.86358 | 37.718817384787606 | -122.460293291921 | (37.7188173847876, -122.460293291921) | ||
| 4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
| 4410 | 4410 | 24569 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2325 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2001 12:00:00 AM | 4 | 3X3 | 6002751.62684 | 2116304.73966 | 37.7911245168302 | -122.43437634589199 | (37.7911245168302, -122.434376345892) | ||
| 4425 | 4425 | 97577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001652.1221 | 2110620.3263 | 37.775454094869296 | -122.43777328811301 | (37.7754540948693, -122.437773288113) | ||
| 4599 | 4599 | 100201 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 255 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51875 | 6008346.927130001 | 2112747.04212 | 37.7816719523255 | -122.414764839028 | (37.7816719523255, -122.414764839028) | ||
| 4717 | 4717 | 240016 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 6 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x6 | 6003449.63845 | 2105676.77669 | 37.7619823582336 | -122.431202314632 | (37.7619823582336, -122.431202314632) | |||
| 4739 | 4739 | 3036 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2607 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X2 | 6001811.8813 | 2115314.7838 | 37.7883529667295 | -122.437556903926 | (37.7883529667295, -122.437556903926) | |||
| 4894 | 4894 | 90500 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 339 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2016 12:00:00 AM | 3 | 3x3 | 5988049.93279 | 2113689.95178 | 37.783099590598 | -122.48505116522 | (37.783099590598, -122.48505116522) | ||
| 5125 | 5125 | 97583 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001590.7259 | 2111040.5 | 37.776604295001 | -122.438015775508 | (37.776604295001, -122.438015775508) | ||
| 5177 | 5177 | 213769 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001465.0 | 2095917.0 | 37.735071666753 | -122.437367503603 | (37.735071666753, -122.437367503603) | |||
| 5608 | 5608 | 106622 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.2478 | 2113322.09 | 37.78258266885771 | -122.455516779687 | (37.7825826688577, -122.455516779687) | ||
| 5619 | 5619 | 28099 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 531 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001632.2486 | 2110287.5913 | 37.77453935789789 | -122.43781819841101 | (37.7745393578979, -122.437818198411) | ||
| 5854 | 5854 | 30037 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2231 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 6005477.24721 | 2117649.17337 | 37.794970327277 | -122.425041479277 | (37.794970327277, -122.425041479277) | ||
| 5871 | 5871 | 97602 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 833 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3xe | 6001492.376 | 2111306.2278 | 37.777328323069796 | -122.438375037891 | (37.7773283230698, -122.438375037891) | ||
| 5874 | 5874 | 97590 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 559 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.3648 | 2110410.2466 | 37.774875178544995 | -122.437885389718 | (37.774875178545, -122.437885389718) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
| 6007 | 6007 | 28723 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003233.5773 | 2114519.7036 | 37.7862506062504 | -122.43258125527099 | (37.7862506062504, -122.432581255271) | |||
| 6072 | 6072 | 24616 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001554.3804 | 2111297.3519 | 37.777307478654706 | -122.438159908991 | (37.7773074786547, -122.438159908991) | |
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 6272 | 6272 | 41118 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1831 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 10 | 3x6 | Permit Number 41864 | 5998988.6196 | 2110750.7439 | 37.7756603770461 | -122.44699632592899 | (37.7756603770461, -122.446996325929) | |
| 6389 | 6389 | 65428 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 720 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1989 12:00:00 AM | 8 | 3x3 | Permit Number 28287 | 6010438.53437 | 2116215.60904 | 37.791313109171206 | -122.40777348606899 | (37.7913131091712, -122.407773486069) | |
| 6544 | 6544 | 8114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 24 | 3X3 | 6003807.6781 | 2111475.048 | 37.7779232822146 | -122.430377706699 | (37.7779232822146, -122.430377706699) | ||
| 6693 | 6693 | 7357 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002807.95732 | 2116239.44488 | 37.7909484313614 | -122.43417677466499 | (37.7909484313614, -122.434176774665) | |||
| 6760 | 6760 | 24628 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 536 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001694.2572 | 2110311.9357 | 37.774609727324204 | -122.437605442785 | (37.7746097273242, -122.437605442785) | |
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7371 | 7371 | 44106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1242 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778937 | 6007599.34177 | 2118533.61268 | 37.797518421388205 | -122.41776142416401 | (37.7975184213882, -122.417761424164) | |
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 7792 | 7792 | 97581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001597.3606 | 2110988.4698 | 37.776461810461704 | -122.43798909643101 | (37.7764618104617, -122.437989096431) | ||
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
| 8237 | 8237 | 18921 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2657 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002082.518999999 | 2115701.12329 | 37.789429139198 | -122.43664820785101 | (37.789429139198, -122.436648207851) | ||
| 8276 | 8276 | 7371 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2430 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6002752.41216 | 2116639.2393 | 37.7920430115354 | -122.43439755460501 | (37.7920430115354, -122.434397554605) | ||
| 8303 | 8303 | 97591 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001649.1323 | 2110166.4258 | 37.7742076278049 | -122.43775111477899 | (37.7742076278049, -122.437751114779) | ||
| 8311 | 8311 | 5206 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 4X4 | 6001519.3329 | 2111090.328 | 37.7767370498578 | -122.438266314655 | (37.7767370498578, -122.438266314655) | |
| 8313 | 8313 | 110973 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2231 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002796.68152 | 2115999.3322 | 37.7902885034734 | -122.434198615596 | (37.7902885034734, -122.434198615596) | |||
| 8394 | 8394 | 97584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 818 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001564.5243 | 2111243.3358 | 37.777159740959895 | -122.43812094768101 | (37.7771597409599, -122.438120947681) | ||
| 8466 | 8466 | 59594 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1447 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | 3x3 | Permit Number 18991 | 6000147.142999999 | 2113940.7254 | 37.7844853693895 | -122.44321788363199 | (37.7844853693895, -122.443217883632) | |
| 8586 | 8586 | 97596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 783 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001525.9433 | 2111041.0042 | 37.7766019950898 | -122.438239913038 | (37.7766019950898, -122.438239913038) | ||||
| 8857 | 8857 | 24567 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2123 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6002841.2397 | 2115668.08623 | 37.789381515596396 | -122.434020759375 | (37.7893815155964, -122.434020759375) | ||
| 9356 | 9356 | 5932 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1355 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6004005.8425 | 2112845.6747 | 37.781697906038 | -122.429789972847 | (37.781697906038, -122.429789972847) | |||
| 9538 | 9538 | 24790 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600X Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | 5983417.22641 | 2112490.7888700003 | 37.7795361021078 | -122.500989471143 | (37.7795361021078, -122.500989471143) | |||
| 9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr 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) | |
| 10268 | 10268 | 49966 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2003 12:00:00 AM | Permit Number 46718 | 6000426.47543442 | 2105220.01428839 | 37.7605564179186 | -122.44162544737301 | (37.7605564179186, -122.441625447373) | |||
| 11740 | 11740 | 108556 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) |
| 11899 | 11899 | 113090 | Section 143 8 | Pyrus calleryana :: Ornamental Pear 9 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.6087200001 | 37.7303322746045 | -122.41230559972999 | (37.7303322746045, -122.41230559973) | ||
| 13363 | 13363 | 91696 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1699 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007461.4288800005 | 2108586.23099 | 37.770197566194504 | -122.41753327153799 | (37.7701975661945, -122.417533271538) | ||
| 13365 | 13365 | 22227 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 3 | 3x3 | 6015350.6152 | 2096709.0679 | 37.7380261434859 | -122.38941484248998 | (37.7380261434859, -122.38941484249) | ||
| 13370 | 13370 | 84837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 13X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 2x3 | Permit No. 49303 | 6010462.24216 | 2111775.7288599997 | 37.779123579430106 | -122.407378318556 | (37.7791235794301, -122.407378318556) | |
| 13506 | 13506 | 22236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015297.7091 | 2096577.2751 | 37.737661333943 | -122.389588564769 | (37.737661333943, -122.389588564769) | |||
| 13551 | 13551 | 22289 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4836 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3X3 | 6014859.2794 | 2095367.428 | 37.734315020944 | -122.39101990239901 | (37.734315020944, -122.391019902399) | ||
| 13619 | 13619 | 22307 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014686.8832 | 2094799.1002 | 37.7327449405845 | -122.391576215676 | (37.7327449405845, -122.391576215676) | ||||
| 13668 | 13668 | 24300 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 10 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016267.21973 | 2096044.36505 | 37.736251780486604 | -122.386199330252 | (37.7362517804866, -122.386199330252) | ||
| 13871 | 13871 | 95055 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5100X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014636.9706 | 2094632.7306 | 37.7322853528356 | -122.39173714895 | (37.7322853528356, -122.39173714895) | |||
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 14054 | 14054 | 95063 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4911 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014862.0973 | 2095159.3952 | 37.7337439615305 | -122.39099562481701 | (37.7337439615305, -122.390995624817) |
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");