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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52646 | 52646 | 136218 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002000.868319999 | 2118219.4196099997 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | |||
| 149420 | 149420 | 136190 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002538.23525 | 2118203.76672 | 37.7963266398053 | -122.43525056515499 | (37.7963266398053, -122.435250565155) | |||
| 169456 | 169456 | 136189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002539.896000001 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | |||
| 137208 | 137208 | 46512 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2188 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 8 | Permit Number 44678 | 6002606.94356 | 2118178.75715 | 37.7962618715428 | -122.435011030753 | (37.7962618715428, -122.435011030753) | |
| 188810 | 188810 | 48419 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45797 | 6002578.00127 | 2118175.76067 | 37.796252000589796 | -122.435110962497 | (37.7962520005898, -122.435110962497) | ||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 65412 | 65412 | 136219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002007.17609 | 2118176.89143 | 37.79622267548079 | -122.437086212761 | (37.7962226754808, -122.437086212761) | |||
| 155537 | 155537 | 136195 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2848 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001082.7933 | 2118171.7538799997 | 37.796155982661396 | -122.44028438991 | (37.7961559826614, -122.44028438991) | |||
| 161525 | 161525 | 136220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002011.27576 | 2118147.89877 | 37.7961433022242 | -122.43706995031201 | (37.7961433022242, -122.437069950312) | |||
| 188730 | 188730 | 136221 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002012.26452 | 2118128.8819999998 | 37.7960911433324 | -122.437065166822 | (37.7960911433324, -122.437065166822) | |||
| 41173 | 41173 | 49397 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451@ PACIFIC Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 4 | Permit Number 46412 | 6008850.17473 | 2117891.03277 | 37.7958243657476 | -122.413387728783 | (37.7958243657476, -122.413387728783) | ||
| 155377 | 155377 | 136236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008853.84836 | 2117876.7398200002 | 37.795785327084495 | -122.413374006003 | (37.7957853270845, -122.413374006003) | |||
| 93103 | 93103 | 88423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
| 108755 | 108755 | 88422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
| 83625 | 83625 | 58781 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2064 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | Permit Number 18024 | 6006472.52256241 | 2117868.87652577 | 37.7956297477373 | -122.42161328699801 | (37.7956297477373, -122.421613286998) | ||
| 71775 | 71775 | 143127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006472.0934 | 2117865.3206 | 37.7956199598585 | -122.421614519298 | (37.7956199598585, -122.421614519298) | |||
| 33676 | 33676 | 136238 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1378 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007522.032000001 | 2117818.3708599997 | 37.7955501948379 | -122.41797820753901 | (37.7955501948379, -122.417978207539) | |||
| 41805 | 41805 | 81939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
| 103205 | 103205 | 81979 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
| 102850 | 102850 | 17358 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2221X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | |||
| 175148 | 175148 | 136110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | |||
| 95194 | 95194 | 59283 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | Permit Number 18619 | 6006528.93574422 | 2117463.80018293 | 37.794520690460104 | -122.421389306077 | (37.7945206904601, -122.421389306077) | ||
| 82652 | 82652 | 7989 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2148 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2012 12:00:00 AM | 3 | 3x3 | 6005571.076798901 | 2117355.4773403 | 37.794169211894605 | -122.4246959118 | (37.7941692118946, -122.4246959118) | ||
| 148808 | 148808 | 136271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010208.66727 | 2117064.18713 | 37.7936302286056 | -122.40862871256701 | (37.7936302286056, -122.408628712567) | |||
| 66699 | 66699 | 136270 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 232 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010211.84194 | 2117041.25544 | 37.7935674415409 | -122.40861610945299 | (37.7935674415409, -122.408616109453) | |||
| 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) | |
| 66614 | 66614 | 136269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010214.18023 | 2117016.1329200002 | 37.7934985921435 | -122.408606245692 | (37.7934985921435, -122.408606245692) | |||
| 76655 | 76655 | 136268 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010216.49831 | 2116997.79235 | 37.7934483632051 | -122.40859693051901 | (37.7934483632051, -122.408596930519) | |||
| 88949 | 88949 | 70620 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1644 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.793442925898105 | -122.42033955937599 | (37.7934429258981, -122.420339559376) | ||
| 92485 | 92485 | 73448 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1644 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.793442925898105 | -122.42033955937599 | (37.7934429258981, -122.420339559376) | ||
| 73250 | 73250 | 136267 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010219.360169999 | 2116967.29713 | 37.79336479099371 | -122.408584876014 | (37.7933647909937, -122.408584876014) | |||
| 26220 | 26220 | 136266 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010225.4664 | 2116932.79358 | 37.793270394575295 | -122.40856131286101 | (37.7932703945753, -122.408561312861) | |||
| 28760 | 28760 | 136243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978456999 | (37.7932611216587, -122.42077978457) | |||
| 178821 | 178821 | 136242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | |||
| 157723 | 157723 | 136241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006661.2210800005 | 2116996.6606900003 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | |||
| 148156 | 148156 | 136240 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006640.65595 | 2116994.76492 | 37.7932391350289 | -122.420969421921 | (37.7932391350289, -122.420969421921) | |||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 63638 | 63638 | 136265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010230.84505 | 2116901.45866 | 37.7931846576946 | -122.408540490873 | (37.7931846576946, -122.408540490873) | |||
| 125944 | 125944 | 96720 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008320.0 | 2116937.0 | 37.7931750456071 | -122.41515467261601 | (37.7931750456071, -122.415154672616) | |||||
| 129013 | 129013 | 96719 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008320.0 | 2116937.0 | 37.7931750456071 | -122.41515467261601 | (37.7931750456071, -122.415154672616) | |||||
| 70539 | 70539 | 52633 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006431.88211 | 2116964.74466 | 37.79314493643 | -122.42168966107 | (37.79314493643, -122.42168966107) | ||
| 32762 | 32762 | 96718 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008240.6871 | 2116926.6734700003 | 37.79314223396489 | -122.415428369639 | (37.7931422339649, -122.415428369639) | ||
| 56367 | 56367 | 52632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 6 | Permit Number 48716 | 6006419.56903 | 2116963.2187099997 | 37.793140052215705 | -122.421732156715 | (37.7931400522157, -122.421732156715) | ||
| 119315 | 119315 | 136237 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008213.13941 | 2116925.26925 | 37.7931368299423 | -122.41552358715201 | (37.7931368299423, -122.415523587152) | |||
| 173914 | 173914 | 52631 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.2497900003 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | ||
| 88077 | 88077 | 111906 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 107640 | 107640 | 111908 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 111716 | 111716 | 111910 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 139854 | 139854 | 111907 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 145239 | 145239 | 111909 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 29555 | 29555 | 142821 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1760 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6006596.1444 | 2116951.8546 | 37.7931188048508 | -122.421120386791 | (37.7931188048508, -122.421120386791) | |||
| 65322 | 65322 | 73401 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | ||
| 34565 | 34565 | 58091 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1750 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 2 | Permit Number 53771 | 6006613.15875288 | 2116850.06123449 | 37.7928402647887 | -122.42105428501101 | (37.7928402647887, -122.421054285011) | ||
| 56742 | 56742 | 142824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1731 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6006563.8602 | 2116843.0613 | 37.7928182655861 | -122.42122436333099 | (37.7928182655861, -122.421224363331) | |||
| 99658 | 99658 | 23701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2119X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 130186 | 130186 | 142826 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | |||
| 114882 | 114882 | 102862 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2750X Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | Permit Number 769980 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | |||
| 114505 | 114505 | 69343 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1720 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1994 12:00:00 AM | Permit Number 53930 | 6006626.00049448 | 2116758.13786967 | 37.7925885900314 | -122.421003322231 | (37.7925885900314, -122.421003322231) | |||
| 117017 | 117017 | 95159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2721 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||
| 147690 | 147690 | 136247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006549.579919999 | 2116650.11937 | 37.7922876900734 | -122.421260066609 | (37.7922876900734, -122.421260066609) | |||
| 53362 | 53362 | 136246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006533.72276 | 2116650.00017 | 37.7922864687885 | -122.421314924346 | (37.7922864687885, -122.421314924346) | |||
| 169276 | 169276 | 136245 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | |||
| 71124 | 71124 | 59265 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1693 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | 3 | 3x3 | Permit Number 18600 | 6006592.1641 | 2116638.2998 | 37.7922576371531 | -122.421111884547 | (37.7922576371531, -122.421111884547) |
| 38003 | 38003 | 136244 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1747 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006363.52762 | 2116626.5882200003 | 37.7922125885856 | -122.42190214028099 | (37.7922125885856, -122.421902140281) | |||
| 91793 | 91793 | 32025 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2431 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 7 | 4x4 | Permit Number 35414 | 6002714.02785707 | 2116573.3755444 | 37.7918599877301 | -122.434525653083 | (37.7918599877301, -122.434525653083) | |
| 118793 | 118793 | 24810 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2412 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 6 | 3X3 | 6002765.09996 | 2116553.7465 | 37.791808990451706 | -122.434347539746 | (37.7918089904517, -122.434347539746) | ||
| 106591 | 106591 | 7368 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 7 | 3X3 | 6002726.00787 | 2116542.1867400003 | 37.7917750313387 | -122.43448197129601 | (37.7917750313387, -122.434481971296) | ||
| 6169 | 6169 | 94205 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.791050043982295 | -122.40124050766501 | (37.7910500439823, -122.401240507665) | |
| 86794 | 86794 | 24570 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1996 12:00:00 AM | 6 | 3X3 | 6002830.77987 | 2116250.98173 | 37.7909814038841 | -122.434098634738 | (37.7909814038841, -122.434098634738) | ||
| 43027 | 43027 | 94791 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.79098101110971 | -122.450877583428 | (37.7909810111097, -122.450877583428) | ||
| 136005 | 136005 | 58814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 821 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51604 | 6009972.6793599995 | 2116102.82719 | 37.7909773472645 | -122.40937737748101 | (37.7909773472645, -122.409377377481) | |
| 71265 | 71265 | 52637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2@ PACIFIC Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 8 | Permit Number 48719 | 5997984.07214 | 2116339.1765799997 | 37.7909473027338 | -122.450874333286 | (37.7909473027338, -122.450874333286) | ||
| 129069 | 129069 | 24578 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 6 | 3x3 | 6002768.23016 | 2116232.67907 | 37.7909275993488 | -122.434313744932 | (37.7909275993488, -122.434313744932) | ||
| 44571 | 44571 | 7356 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.79079460631979 | -122.434307574482 | (37.7907946063198, -122.434307574482) | ||
| 105873 | 105873 | 24568 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2261 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6002770.36332 | 2116069.69305 | 37.790480202582 | -122.43429470698 | (37.790480202582, -122.43429470698) | ||
| 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) | |
| 42701 | 42701 | 136231 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009179.0642099995 | 2115849.5687700002 | 37.790237464224894 | -122.412105358482 | (37.7902374642249, -122.412105358482) | |||
| 66176 | 66176 | 62995 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1986 12:00:00 AM | 11 | Permit Number 23397 | 6009184.70363 | 2115820.64878 | 37.7901583733657 | -122.412083801744 | (37.7901583733657, -122.412083801744) | ||
| 156207 | 156207 | 136214 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3601 Jackson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996953.554930001 | 2115974.46386 | 37.7898868527455 | -122.45441350368999 | (37.7898868527455, -122.45441350369) | |||
| 178696 | 178696 | 136211 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | |||
| 178631 | 178631 | 136215 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3631 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996865.8825900005 | 2115961.8994 | 37.7898473257367 | -122.454715932203 | (37.7898473257367, -122.454715932203) | |||
| 60649 | 60649 | 58694 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3633 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1979 12:00:00 AM | 4 | Permit Number 17970 | 5996855.26576 | 2115960.6148599996 | 37.7898431897625 | -122.454752572401 | (37.7898431897625, -122.454752572401) | ||
| 167332 | 167332 | 136212 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997026.477630001 | 2115953.7993900003 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | |||
| 169703 | 169703 | 36194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | |||
| 30190 | 30190 | 136213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.78974632646779 | -122.45415312837099 | (37.7897463264678, -122.454153128371) | |||
| 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) | |||
| 144326 | 144326 | 136235 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008235.611740001 | 2115647.76794 | 37.7896303876902 | -122.41535535186199 | (37.7896303876902, -122.415355351862) | |||
| 156143 | 156143 | 136234 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.41534570573299 | (37.7895893093397, -122.415345705733) | |||
| 52547 | 52547 | 136233 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008241.15126 | 2115615.72807 | 37.789542725373295 | -122.415333916531 | (37.7895427253733, -122.415333916531) | |||
| 165466 | 165466 | 136232 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008243.34435 | 2115601.8020599997 | 37.789504611209004 | -122.415325342399 | (37.789504611209, -122.415325342399) | |||
| 22899 | 22899 | 7340 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2126 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2017 12:00:00 AM | 3 | 3X3 | 6002883.51227 | 2115702.89267 | 37.7894794841288 | -122.433876990144 | (37.7894794841288, -122.433876990144) | ||
| 132749 | 132749 | 136209 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3501 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997993.27095 | 2115789.6423 | 37.7894389544021 | -122.450802865961 | (37.7894389544021, -122.450802865961) | |||
| 36094 | 36094 | 136210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3501 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997980.46007 | 2115787.2108299998 | 37.7894315448801 | -122.450847014574 | (37.7894315448801, -122.450847014574) | |||
| 10059 | 10059 | 24572 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2122 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 3x3 | 6002889.00041 | 2115679.48805 | 37.7894155324538 | -122.433856328234 | (37.7894155324538, -122.433856328234) | ||
| 176131 | 176131 | 65788 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) | ||
| 175573 | 175573 | 142841 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1347 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6006737.9132 | 2115595.2008 | 37.7894017611933 | -122.42053351217 | (37.7894017611933, -122.42053351217) | |||
| 50367 | 50367 | 142842 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.789346792117705 | -122.420526537815 | (37.7893467921177, -122.420526537815) | |||
| 74919 | 74919 | 136206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998023.60869 | 2115735.83366 | 37.7892929467667 | -122.450694020137 | (37.7892929467667, -122.450694020137) | |||
| 92100 | 92100 | 24565 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2117 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 3 | 3X3 | 6002846.69927 | 2115626.75122 | 37.7892683300519 | -122.433998913998 | (37.7892683300519, -122.433998913998) |
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");