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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30553 | 30553 | 240407 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | |||
| 31206 | 31206 | 246759 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | ||||
| 31223 | 31223 | 184437 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2115 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982295.3096 | 2100678.1438 | 37.7470360206297 | -122.50399540910401 | (37.7470360206297, -122.503995409104) | |||
| 31386 | 31386 | 214044 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999274.87025 | 2093768.2240099998 | 37.729046879900295 | -122.444785134325 | (37.7290468799003, -122.444785134325) | |||
| 31525 | 31525 | 214031 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.45120714359501 | (37.7294247417474, -122.451207143595) | |||
| 31765 | 31765 | 214029 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.59206 | 2094530.6160900001 | 37.7312231430208 | -122.43981069901301 | (37.7312231430208, -122.439810699013) | |||
| 32010 | 32010 | 136323 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 360 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6011675.19116 | 2118742.8856099998 | 37.79832155645679 | -122.403672558643 | (37.7983215564568, -122.403672558643) | |||
| 32269 | 32269 | 69005 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2087 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33006 | 5982594.36064133 | 2100924.19223319 | 37.7477291823956 | -122.50297954562099 | (37.7477291823956, -122.502979545621) | |
| 32460 | 32460 | 214016 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1310 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992104.55451 | 2106488.0935299997 | 37.7635605748926 | -122.47049926614099 | (37.7635605748926, -122.470499266141) | |||
| 32809 | 32809 | 137686 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | |||
| 33040 | 33040 | 185413 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985092.6382 | 2099208.8841 | 37.7431659316065 | -122.49421435006501 | (37.7431659316065, -122.494214350065) | |||
| 33363 | 33363 | 240383 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.770668274943205 | -122.426220805247 | (37.7706682749432, -122.426220805247) | |||
| 33748 | 33748 | 214024 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000768.15588 | 2094464.1173900003 | 37.7310427480136 | -122.43967261170201 | (37.7310427480136, -122.439672611702) | |||
| 33870 | 33870 | 95740 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 61 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767486 | 6004943.22126 | 2091523.89765 | 37.7232063048111 | -122.42502956775499 | (37.7232063048111, -122.425029567755) |
| 34018 | 34018 | 136313 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | |||
| 34675 | 34675 | 31971 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | |
| 34981 | 34981 | 207052 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1266 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993336.085580001 | 2106823.92199 | 37.7645538041289 | -122.46626423270901 | (37.7645538041289, -122.466264232709) | |||
| 35338 | 35338 | 124543 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992464.59444 | 2111330.54171 | 37.776877452914206 | -122.46960655362801 | (37.7768774529142, -122.469606553628) | |||
| 35367 | 35367 | 197333 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014202.148440001 | 2101967.42619 | 37.7524007500093 | -122.39375364352301 | (37.7524007500093, -122.393753643523) | ||||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 35612 | 35612 | 72078 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 5 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | ||
| 35987 | 35987 | 51788 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 339 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52292 | 6012718.572319999 | 2094804.9461700001 | 37.7326515416146 | -122.39838161323 | (37.7326515416146, -122.39838161323) | |
| 36032 | 36032 | 84615 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 26 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50848 | 6001974.9488 | 2119960.7519900003 | 37.8011188571965 | -122.437325522376 | (37.8011188571965, -122.437325522376) | |
| 36052 | 36052 | 240426 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 60 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006672.38997 | 2109529.27096 | 37.772742500096705 | -122.42032950031499 | (37.7727425000967, -122.420329500315) | |||
| 36061 | 36061 | 214023 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000598.84895 | 2094335.4471599997 | 37.7306798113107 | -122.44024870933599 | (37.7306798113107, -122.440248709336) | |||
| 36146 | 36146 | 69007 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | |
| 36460 | 36460 | 122283 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990098.96698 | 2111321.01529 | 37.7767142891731 | -122.477789191669 | (37.7767142891731, -122.477789191669) | |||
| 36999 | 36999 | 122289 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990067.41245 | 2111319.5030799997 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | |||
| 37135 | 37135 | 124541 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | |||
| 37930 | 37930 | 186236 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.75452191688171 | -122.495498186629 | (37.7545219168817, -122.495498186629) | |||
| 38193 | 38193 | 246761 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009235.422669999 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | ||||
| 38309 | 38309 | 120769 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.48008475013701 | (37.7728412569544, -122.480084750137) | |||
| 38403 | 38403 | 197339 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6016827.1128 | 2099574.92506 | 37.745976956489294 | -122.384509368331 | (37.7459769564893, -122.384509368331) | ||||
| 39197 | 39197 | 136301 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997498.90653 | 2116025.43206 | 37.790058058469 | -122.452530326034 | (37.790058058469, -122.452530326034) | |||
| 39381 | 39381 | 74867 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | ||
| 39998 | 39998 | 122277 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | |||
| 40074 | 40074 | 181349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987333.026000001 | 2099936.24 | 37.745293905616705 | -122.48652117681601 | (37.7452939056167, -122.486521176816) | |||
| 40291 | 40291 | 240392 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008038.16649 | 2107910.1392200002 | 37.768373611578205 | -122.415490461517 | (37.7683736115782, -122.415490461517) | |||
| 40556 | 40556 | 32518 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | |
| 40581 | 40581 | 214021 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 75 Fairfield Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993799.03412 | 2093427.92907 | 37.727798498601295 | -122.463690690492 | (37.7277984986013, -122.463690690492) | |||
| 41315 | 41315 | 95661 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 231 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767423 | 6010393.1108800005 | 2093567.05478 | 37.7291227359169 | -122.406334153496 | (37.7291227359169, -122.406334153496) |
| 41367 | 41367 | 197347 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1245 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009016.84079 | 2110503.78617 | 37.775550120588605 | -122.41228864573 | (37.7755501205886, -122.41228864573) | |||
| 41388 | 41388 | 75003 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 5 | 5997399.304819999 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | ||
| 41529 | 41529 | 73403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003121.9233099995 | 2094558.5911 | 37.7314358416937 | -122.43154198316999 | (37.7314358416937, -122.43154198317) | ||
| 41992 | 41992 | 118563 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.50524304882099 | (37.7792296683273, -122.505243048821) | |||
| 42442 | 42442 | 136326 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.797986344959995 | -122.405002616378 | (37.79798634496, -122.405002616378) | |||
| 42735 | 42735 | 69006 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | |
| 43322 | 43322 | 246767 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009322.267109999 | 2098890.11567 | 37.743678751571295 | -122.410411873024 | (37.7436787515713, -122.410411873024) | ||||
| 43449 | 43449 | 69150 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.49728998800501 | (37.7402963417492, -122.497289988005) | |
| 43641 | 43641 | 179373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998557.70629 | 2086647.36142 | 37.709453678716706 | -122.446752254708 | (37.7094536787167, -122.446752254708) | ||||
| 44130 | 44130 | 41755 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42184 | 6008378.01882 | 2118113.9596 | 37.79640994672071 | -122.415037267971 | (37.7964099467207, -122.415037267971) | ||
| 44795 | 44795 | 122290 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990062.61204 | 2111318.0216900003 | 37.7767039596239 | -122.47791473389799 | (37.7767039596239, -122.477914733898) | |||
| 45894 | 45894 | 136306 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008615.340009999 | 2116402.44898 | 37.7917238924876 | -122.414094939449 | (37.7917238924876, -122.414094939449) | |||
| 45898 | 45898 | 78303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985601.84615 | 2111830.0583200003 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | ||
| 46279 | 46279 | 240375 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 Ramona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005227.26292 | 2107315.18034 | 37.7665816008793 | -122.425170785627 | (37.7665816008793, -122.425170785627) | |||
| 46494 | 46494 | 122286 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | |||
| 46879 | 46879 | 52639 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1634 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2006 12:00:00 AM | 3 | Permit Number 48720 | 5981612.27437325 | 2103952.63979264 | 37.7559866741692 | -122.506600058306 | (37.7559866741692, -122.506600058306) | |
| 46883 | 46883 | 214041 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997281.4748599995 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | |||
| 47021 | 47021 | 179382 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 143 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007980.64963 | 2093237.8287400003 | 37.728083504546596 | -122.414650965095 | (37.7280835045466, -122.414650965095) | |||
| 47391 | 47391 | 197344 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012519.5716699995 | 2113947.09446 | 37.785200579973605 | -122.40041369075199 | (37.7852005799736, -122.400413690752) | |||
| 47422 | 47422 | 37962 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.394309999 | 2106347.66255 | 37.7644148813545 | -122.39487221400299 | (37.7644148813545, -122.394872214003) | |
| 47444 | 47444 | 68867 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 32831 | 5999260.75597787 | 2093758.61799029 | 37.7290196985316 | -122.444833238065 | (37.7290196985316, -122.444833238065) | ||
| 47685 | 47685 | 214042 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 22 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5997465.40478 | 2093699.4723200002 | 37.728754675784394 | -122.451035610522 | (37.7287546757844, -122.451035610522) | |||
| 48149 | 48149 | 240393 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Hill St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6006109.51353 | 2103440.5803799997 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | |||
| 48290 | 48290 | 67377 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.776979766827104 | -122.467939896695 | (37.7769797668271, -122.467939896695) | |
| 48473 | 48473 | 92109 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | |
| 48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
| 49623 | 49623 | 43808 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1420 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43438 | 5991181.63114 | 2110671.05879 | 37.77499245989021 | -122.473996541351 | (37.7749924598902, -122.473996541351) | |
| 50005 | 50005 | 181948 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1813 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987556.2457 | 2098923.5959 | 37.742526463070796 | -122.48567502435301 | (37.7425264630708, -122.485675024353) | |||
| 50125 | 50125 | 35432 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.4984800005 | 2102013.02263 | 37.7525225775725 | -122.39396657421499 | (37.7525225775725, -122.393966574215) | |
| 50462 | 50462 | 122282 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990106.33926 | 2111321.3026900003 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | |||
| 50859 | 50859 | 240415 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 751 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.43013411340901 | (37.7675888874331, -122.430134113409) | |||
| 50906 | 50906 | 200055 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1800 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014871.4407 | 2094140.9637 | 37.7309480732984 | -122.390892168964 | (37.7309480732984, -122.390892168964) | |||
| 51677 | 51677 | 81327 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | |
| 52507 | 52507 | 72377 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | ||
| 53292 | 53292 | 217579 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.714346412845295 | -122.46861011007299 | (37.7143464128453, -122.468610110073) | |||
| 53789 | 53789 | 32019 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 900 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.40005739994601 | (37.7704413522571, -122.400057399946) | |||
| 54123 | 54123 | 140855 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.45608143549101 | (37.7838757026194, -122.456081435491) | |||
| 54142 | 54142 | 38882 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 54318 | 54318 | 37648 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.776868890669206 | -122.46971547615499 | (37.7768688906692, -122.469715476155) | ||
| 54592 | 54592 | 32576 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | |
| 54599 | 54599 | 240401 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214004 | -122.440407898332 | (37.749468718214, -122.440407898332) | |||
| 54735 | 54735 | 32597 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | |
| 54931 | 54931 | 136322 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.798334933855294 | -122.40360120733801 | (37.7983349338553, -122.403601207338) | |||
| 55875 | 55875 | 61446 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2005 12:00:00 AM | 4 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | |
| 56127 | 56127 | 136318 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2431 Jones St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.803647329033105 | -122.416686400679 | (37.8036473290331, -122.416686400679) | |||
| 56315 | 56315 | 240406 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | |||
| 56835 | 56835 | 240403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.43257290392799 | (37.7457049727185, -122.432572903928) | |||
| 57928 | 57928 | 54837 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.77435901320929 | -122.447906287477 | (37.7743590132093, -122.447906287477) | |
| 58619 | 58619 | 122287 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990077.48759 | 2111319.8179099998 | 37.776709754904104 | -122.477863406875 | (37.7767097549041, -122.477863406875) | |||
| 58725 | 58725 | 82802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 58739 | 58739 | 240420 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001790.0985900005 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | |||
| 59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
| 59518 | 59518 | 74566 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | ||
| 59699 | 59699 | 197345 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.41268050642599 | (37.7752450102959, -122.412680506426) | |||
| 60527 | 60527 | 32523 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | |
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 61590 | 61590 | 137691 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | |||
| 62196 | 62196 | 240395 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005177.74113 | 2096695.2803099998 | 37.7374190204687 | -122.42458656083201 | (37.7374190204687, -122.424586560832) | |||
| 62331 | 62331 | 70121 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | 5988662.200680001 | 2110577.24438 | 37.7745886129839 | -122.48270481422199 | (37.7745886129839, -122.482704814222) |
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");