Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
| 70424 | 70424 | 124324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996182.48161 | 2113700.3553299997 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | |||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
| 36178 | 36178 | 197095 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.39280290452601 | (37.7527194688438, -122.392802904526) | |||
| 41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
| 45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
| 62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
| 134469 | 134469 | 197089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.39282883379101 | (37.7529508329366, -122.392828833791) | |||
| 149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
| 157085 | 157085 | 197085 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014468.858580001 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | |||
| 160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
| 170402 | 170402 | 197083 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | |||
| 171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
| 181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
| 181973 | 181973 | 197091 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014475.63706 | 2102134.7648099996 | 37.7528754202862 | -122.39281957348601 | (37.7528754202862, -122.392819573486) | |||
| 43382 | 43382 | 246032 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998172.7746 | 2108470.8044 | 37.7693536035765 | -122.44965419238501 | (37.7693536035765, -122.449654192385) | |||
| 36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
| 77015 | 77015 | 197152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016707.19345 | 2095564.5930700002 | 37.734958764918396 | -122.384644735176 | (37.7349587649184, -122.384644735176) | |||
| 175020 | 175020 | 197153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016721.84036 | 2095568.4819 | 37.734970252878796 | -122.384594365947 | (37.7349702528788, -122.384594365947) | |||
| 45950 | 45950 | 197160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Mabrey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016488.26571 | 2095902.24457 | 37.7358737783612 | -122.385425174944 | (37.7358737783612, -122.385425174944) | |||
| 39213 | 39213 | 239316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | |||
| 185144 | 185144 | 239317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6010240.72628 | 2102744.15996 | 37.7543125548829 | -122.407507713025 | (37.7543125548829, -122.407507713025) | |||
| 90598 | 90598 | 43924 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
| 119465 | 119465 | 43925 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
| 25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
| 64389 | 64389 | 197077 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014934.55258 | 2102947.77391 | 37.7551332492083 | -122.391289372524 | (37.7551332492083, -122.391289372524) | |||
| 115937 | 115937 | 197078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014978.14287 | 2102950.87924 | 37.75514419486029 | -122.391138840404 | (37.7551441948603, -122.391138840404) | |||
| 60352 | 60352 | 44270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2001 12:00:00 AM | 6 | 3x3 | Permit Number 43698 | 6009401.249919999 | 2117056.5968 | 37.793564133816794 | -122.411421918689 | (37.7935641338168, -122.411421918689) | |
| 64317 | 64317 | 141943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004162.7275 | 2112162.4936 | 37.77983094307 | -122.42919849613199 | (37.77983094307, -122.429198496132) | |||
| 65185 | 65185 | 141941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004098.4852 | 2112152.8429 | 37.779800807673794 | -122.42942005016 | (37.7798008076738, -122.42942005016) | |||
| 66976 | 66976 | 141938 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004007.1195 | 2112144.3973 | 37.779772444920894 | -122.42973552170099 | (37.7797724449209, -122.429735521701) | |||
| 84362 | 84362 | 85635 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017893.31364 | 2092631.421507 | 37.7269703746724 | -122.38034007025401 | (37.7269703746724, -122.380340070254) | ||
| 161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
| 144529 | 144529 | 4 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5992046.40751 | 2114771.53879 | 37.7863013087655 | -122.471303948198 | (37.7863013087655, -122.471303948198) | |||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 9464 | 9464 | 24167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 110X Whitney Young Cir | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 2 | 3x3 | 6016346.0952597 | 2096044.1423308998 | 37.736255534298 | -122.38592660691401 | (37.736255534298, -122.385926606914) | ||
| 72140 | 72140 | 239356 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.42487771633101 | (37.7429522432585, -122.424877716331) | |||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 108386 | 108386 | 81728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 124741 | 124741 | 81725 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 31491 | 31491 | 239296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1114 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009989.84018 | 2102603.83852 | 37.753913217229 | -122.408365447707 | (37.753913217229, -122.408365447707) | |||
| 102380 | 102380 | 68489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1114-1116 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32364 | 6009979.78982851 | 2102702.84015298 | 37.754184490832706 | -122.40840718703699 | (37.7541844908327, -122.408407187037) | ||
| 165666 | 165666 | 179334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.43511106143801 | (37.7125700310481, -122.435111061438) | |||
| 171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
| 108092 | 108092 | 61119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1120 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 14 | 3x3 | Permit Number 20967 | 6007612.89522655 | 2103123.90329719 | 37.7552078032974 | -122.416622341764 | (37.7552078032974, -122.416622341764) | |
| 96839 | 96839 | 65258 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1121 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 28057 | 6009490.15544197 | 2102642.26317624 | 37.753990728209 | -122.41009619440399 | (37.753990728209, -122.410096194404) | ||
| 78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
| 112025 | 112025 | 12667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5991972.94269 | 2114825.89139 | 37.7864462960863 | -122.471562077277 | (37.7864462960863, -122.471562077277) | |||
| 128132 | 128132 | 12670 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.3919900004 | 37.786439173997 | -122.47174167386801 | (37.786439173997, -122.471741673868) | ||
| 16510 | 16510 | 85610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1132 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017745.1516 | 2092811.7191 | 37.727457260594704 | -122.38086479752899 | (37.7274572605947, -122.380864797529) | ||
| 65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
| 82900 | 82900 | 37011 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39625 | 6009493.89299858 | 2102575.04875629 | 37.753806381943896 | -122.41007852412201 | (37.7538063819439, -122.410078524122) | ||
| 65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
| 70248 | 70248 | 100361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | |||
| 128591 | 128591 | 69392 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.71247138896779 | -122.435199299374 | (37.7124713889678, -122.435199299374) | ||
| 8596 | 8596 | 115210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.789669227607604 | -122.45413840466298 | (37.7896692276076, -122.454138404663) | |||
| 15328 | 15328 | 85611 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) | ||
| 129542 | 129542 | 199942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1151 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017725.4053 | 2092742.7421 | 37.7272667732913 | -122.38092826799401 | (37.7272667732913, -122.380928267994) | |||
| 119086 | 119086 | 69400 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33504 | 6001338.55016435 | 2087735.88894959 | 37.7126010005012 | -122.437219100024 | (37.7126010005012, -122.437219100024) | ||
| 28850 | 28850 | 110361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335318996 | -122.41486676369699 | (37.790269335319, -122.414866763697) | ||||
| 160970 | 160970 | 59713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1981 12:00:00 AM | 7 | 3x3 | Permit Number 19144 | 6008363.54406 | 2115876.33125 | 37.790265156173504 | -122.414928901463 | (37.7902651561735, -122.414928901463) | |
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 167097 | 167097 | 240168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 116 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998899.29279 | 2107504.14215 | 37.766740931067204 | -122.447071634562 | (37.7667409310672, -122.447071634562) | |||
| 75609 | 75609 | 38463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.727590590458604 | -122.38112356357 | (37.7275905904586, -122.38112356357) | ||
| 96513 | 96513 | 85612 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | ||
| 128443 | 128443 | 85636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.6872430001 | 37.727492079674896 | -122.381259184857 | (37.7274920796749, -122.381259184857) | ||
| 138771 | 138771 | 199941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017637.7639999995 | 2092806.0386 | 37.7274357354826 | -122.38123564590401 | (37.7274357354826, -122.381235645904) | |||
| 166740 | 166740 | 239355 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 117 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005097.05649 | 2098708.2685700003 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | |||
| 116614 | 116614 | 85637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017561.518521 | 2092878.7581240002 | 37.7276311998388 | -122.381504284348 | (37.7276311998388, -122.381504284348) | ||
| 136478 | 136478 | 199940 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | |||
| 4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
| 27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
| 123996 | 123996 | 88467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176.0 | 2095454.0 | 37.7343476550611 | -122.40376034751101 | (37.7343476550611, -122.403760347511) | |||
| 88863 | 88863 | 92267 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
| 142371 | 142371 | 92268 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 99583 | 99583 | 9555 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 140317 | 140317 | 9553 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 141722 | 141722 | 9550 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 96891 | 96891 | 41132 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
| 102205 | 102205 | 41131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
| 126432 | 126432 | 26478 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | ||
| 4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 161550 | 161550 | 199972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017032.2494 | 2092637.585 | 37.7269397498685 | -122.38331721142401 | (37.7269397498685, -122.383317211424) | |||
| 92125 | 92125 | 85615 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017380.895351999 | 2093063.294675 | 37.7281279271047 | -122.38214153905899 | (37.7281279271047, -122.382141539059) | ||
| 165380 | 165380 | 85614 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 5 | 3x3 | 6017331.5604 | 2093113.8652 | 37.728264058993396 | -122.382315610259 | (37.7282640589934, -122.382315610259) | ||
| 100710 | 100710 | 61557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1201 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | Permit Number 21517 | 6012259.00108581 | 2102806.05686261 | 37.754595274223206 | -122.400532312162 | (37.7545952742232, -122.400532312162) | ||
| 16538 | 16538 | 85640 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | ||
| 16579 | 16579 | 85638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017293.1497 | 2093067.8806 | 37.728135672587904 | -122.382445200849 | (37.7281356725879, -122.382445200849) | ||
| 16642 | 16642 | 85639 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | ||
| 54800 | 54800 | 213913 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994820.88687 | 2107315.71116 | 37.7659896869053 | -122.46116439324899 | (37.7659896869053, -122.461164393249) | |||
| 160675 | 160675 | 213914 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5994821.63869 | 2107263.01718 | 37.7658450462296 | -122.46115797296999 | (37.7658450462296, -122.46115797297) | |||
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) |
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");