Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 324 | 324 | 244302 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005598.2085 | 2110574.7953 | 37.775552668496104 | -122.424119585265 | (37.7755526684961, -122.424119585265) | |||
| 331 | 331 | 244290 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 201 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005571.2897 | 2110005.1565 | 37.7739870584615 | -122.424172183065 | (37.7739870584615, -122.424172183065) | |||
| 332 | 332 | 244303 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | 6005595.8477 | 2110592.7369 | 37.775601798483 | -122.42412902808998 | (37.775601798483, -122.42412902809) | |||
| 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) | |||
| 336 | 336 | 244304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005592.0705 | 2110609.2621 | 37.775646959405705 | -122.42414326985501 | (37.7756469594057, -122.424143269855) | |||
| 338 | 338 | 244347 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.3569 | 2110371.5361 | 37.774996100795995 | -122.424011214757 | (37.774996100796, -122.424011214757) | |||
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 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) | ||
| 936 | 936 | 136112 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 4 | Width 4ft | 6009117.58988 | 2112797.33195 | 37.7818533069147 | -122.412102255814 | (37.7818533069147, -122.412102255814) | ||
| 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) | |||
| 1170 | 1170 | 238923 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1358 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007679.38316 | 2101739.54997 | 37.751410422860296 | -122.41629436101101 | (37.7514104228603, -122.416294361011) | ||
| 1522 | 1522 | 251579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | ||||
| 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) | |||
| 1544 | 1544 | 196581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.77593015789721 | -122.40664901875 | (37.7759301578972, -122.40664901875) | |||
| 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) | |||
| 1558 | 1558 | 196580 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6010653.5672 | 2110601.04867 | 37.7759088880156 | -122.406633641224 | (37.7759088880156, -122.406633641224) | |||
| 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) | |||
| 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) | ||
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 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) | |
| 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 | ||||||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 4903 | 4903 | 239064 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 68 12th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 10/31/2016 12:00:00 AM | 3 | Width 3ft | 6007045.28032 | 2109725.44965 | 37.77330216528821 | -122.41905354577699 | (37.7733021652882, -122.419053545777) | ||
| 5188 | 5188 | 158290 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 901 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 0ft | 6001465.0 | 2095917.0 | 37.735071666753 | -122.437367503603 | (37.735071666753, -122.437367503603) | |||
| 5389 | 5389 | 27381 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006997.70161 | 2121072.6946 | 37.8044562233376 | -122.42002354287901 | (37.8044562233376, -122.420023542879) | |||
| 5405 | 5405 | 24573 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002899.36519 | 2115591.06429 | 37.789173331540006 | -122.43381414462799 | (37.78917333154, -122.433814144628) | |
| 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) | ||
| 6030 | 6030 | 94373 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1633 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 4x4 | 6003081.472 | 2113940.278 | 37.7846510231483 | -122.43306608604901 | (37.7846510231483, -122.433066086049) | ||
| 6089 | 6089 | 11017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | |||
| 6148 | 6148 | 24577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 5 | 3X3 | 6002897.54633 | 2115611.42006 | 37.7892291200774 | -122.433821893176 | (37.7892291200774, -122.433821893176) | ||
| 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) | |||
| 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) | |||
| 7081 | 7081 | 11436 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1998 12:00:00 AM | 3 | 3X3 | 6005581.912830001 | 2117259.85377 | 37.793907265665496 | -122.424651612384 | (37.7939072656655, -122.424651612384) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 13553 | 13553 | 22248 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015177.6578 | 2096215.1707 | 37.7366604118004 | -122.389978355542 | (37.7366604118004, -122.389978355542) | |||
| 14060 | 14060 | 22317 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 5122 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/1992 12:00:00 AM | 3 | 3x3 | 6014608.749 | 2094535.9425 | 37.7320180256942 | -122.39182795294201 | (37.7320180256942, -122.391827952942) | ||
| 14558 | 14558 | 22291 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/13/1999 12:00:00 AM | 3 | 3x3 | 6014819.739 | 2095230.8817 | 37.733937898392206 | -122.391147066285 | (37.7339378983922, -122.391147066285) | ||
| 14658 | 14658 | 10994 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2013 12:00:00 AM | 3 | 3X3 | 6016116.07134 | 2097158.9292099997 | 37.7393037809554 | -122.38679962052099 | (37.7393037809554, -122.386799620521) | ||
| 14709 | 14709 | 22250 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015190.8442 | 2096262.8930000002 | 37.736792178811996 | -122.389936096639 | (37.736792178812, -122.389936096639) | |||
| 15118 | 15118 | 22247 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015208.4261 | 2096311.2431 | 37.7369259133775 | -122.3898786841 | (37.7369259133775, -122.3898786841) | |||
| 15232 | 15232 | 95293 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4618 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015049.0735 | 2096005.3469 | 37.7360771463621 | -122.390408274564 | (37.7360771463621, -122.390408274564) | |||
| 15386 | 15386 | 22255 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4614 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1996 12:00:00 AM | 6 | 3x3 | 6015052.7639 | 2096021.1630000002 | 37.7361207788628 | -122.390396619988 | (37.7361207788628, -122.390396619988) | ||
| 15851 | 15851 | 95291 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4500 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015158.7323 | 2096375.4452 | 37.73709944325871 | -122.390054982777 | (37.7370994432587, -122.390054982777) | |||
| 15991 | 15991 | 22288 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1998 12:00:00 AM | 3 | 3X3 | 6014865.0787 | 2095383.7713 | 37.7343602181244 | -122.391000994081 | (37.7343602181244, -122.391000994081) | ||
| 16287 | 16287 | 22251 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4522 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1995 12:00:00 AM | 6 | 3x3 | 6015135.007999999 | 2096296.8916 | 37.7368824352823 | -122.390131522919 | (37.7368824352823, -122.390131522919) | ||
| 16823 | 16823 | 22249 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6015186.4487 | 2096240.2877 | 37.7367298654987 | -122.38994971533998 | (37.7367298654987, -122.38994971534) | ||
| 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) | ||
| 17219 | 17219 | 15306 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2012 12:00:00 AM | 12 | 4X4 | 6006908.0519 | 2109118.2179 | 37.7716271230049 | -122.41948515010701 | (37.7716271230049, -122.419485150107) | ||
| 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) | ||
| 17448 | 17448 | 5159 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 280 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 3 | 3x3 | 6001840.8605 | 2109274.7601 | 37.7717702359874 | -122.43702404315799 | (37.7717702359874, -122.437024043158) | ||
| 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) | |||
| 18069 | 18069 | 15305 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006919.2009 | 2109139.6581 | 37.7716866206556 | -122.41944810628799 | (37.7716866206556, -122.419448106288) | |||
| 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) | |||
| 18181 | 18181 | 7048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001113.3036400005 | 2110008.37363 | 37.7737431739315 | -122.43959330500601 | (37.7737431739315, -122.439593305006) | ||||
| 18231 | 18231 | 25584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1100 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008703.17196 | 2097328.50441 | 37.739356184437796 | -122.412442202248 | (37.7393561844378, -122.412442202248) | |||
| 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) | ||
| 18570 | 18570 | 119857 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401 Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 18660 | 18660 | 2548 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 26 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001209.41963 | 2095931.6881 | 37.7350974637785 | -122.438252186489 | (37.7350974637785, -122.438252186489) | ||
| 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) | ||
| 19198 | 19198 | 10243 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 80X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 8 | 3X3 | 6005750.7633 | 2109671.0107 | 37.7730797066295 | -122.423527591987 | (37.7730797066295, -122.423527591987) | ||
| 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) | |||
| 19527 | 19527 | 24348 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 85 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6006216.94974 | 2108473.11084 | 37.7698168624935 | -122.421829886054 | (37.7698168624935, -122.421829886054) | |||
| 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) | ||
| 20107 | 20107 | 4293 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4339 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001695.46709 | 2100282.2377 | 37.747070687663204 | -122.436883097284 | (37.7470706876632, -122.436883097284) | |||
| 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) | ||||
| 20252 | 20252 | 2549 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 30 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001196.7389 | 2095889.2850400002 | 37.7349803135805 | -122.438292991438 | (37.7349803135805, -122.438292991438) | ||
| 20322 | 20322 | 2547 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 20 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2014 12:00:00 AM | 3 | 3x3 | 6001218.37586 | 2095964.9326099998 | 37.7351892548769 | -122.43822360245001 | (37.7351892548769, -122.43822360245) | ||
| 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) | |||
| 20489 | 20489 | 96596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988207.53014 | 2111924.69302 | 37.7782618665825 | -122.48437643702499 | (37.7782618665825, -122.484376437025) | ||
| 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) |
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");