Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10851 | 10851 | 52794 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 10944 | 10944 | 35742 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 63294 | 63294 | 47746 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982405.06542 | 2113061.4232400004 | 37.781043413721704 | -122.50453319829201 | (37.7810434137217, -122.504533198292) | |
| 173420 | 173420 | 184400 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2087 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982288.7103 | 2100911.824 | 37.747677253327 | -122.504035534429 | (37.747677253327, -122.504035534429) | |||
| 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) | |||
| 141514 | 141514 | 87935 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 156274 | 156274 | 40198 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 4 | Permit Number 41381 | 5983564.00887 | 2111698.1064299997 | 37.7773682442298 | -122.500423071675 | (37.7773682442298, -122.500423071675) | |
| 29223 | 29223 | 183217 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3150 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983341.801 | 2100199.14 | 37.7457822914528 | -122.50034138058201 | (37.7457822914528, -122.500341380582) | |||
| 128753 | 128753 | 29219 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 173280 | 173280 | 117792 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.775522188312394 | -122.499749889479 | (37.7755221883124, -122.499749889479) | |||
| 169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
| 135840 | 135840 | 117962 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | |||
| 175872 | 175872 | 78389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985613.90998 | 2111830.68363 | 37.77785237866 | -122.49334166667101 | (37.77785237866, -122.493341666671) | ||
| 182568 | 182568 | 33177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) |
| 169430 | 169430 | 42275 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1522 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | ||
| 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) | |||
| 130949 | 130949 | 181350 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.745211025577895 | -122.48221942866999 | (37.7452110255779, -122.48221942867) | |||
| 149259 | 149259 | 181332 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1458 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988697.9248 | 2105396.3508 | 37.760365379214605 | -122.482201591019 | (37.7603653792146, -122.482201591019) | |||
| 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) | ||
| 185994 | 185994 | 181319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1283 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989233.7879 | 2106609.7025 | 37.7637280687606 | -122.48043712751101 | (37.7637280687606, -122.480437127511) | |||
| 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) | ||
| 159224 | 159224 | 38871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | 2 | Permit Number 40696 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | ||
| 166292 | 166292 | 43230 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1371 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.47819025383801 | (37.7622050471688, -122.478190253838) | |
| 72433 | 72433 | 122278 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.776718780123794 | -122.477666227559 | (37.7767187801238, -122.477666227559) | |||
| 99254 | 99254 | 38032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 89712 | 89712 | 47995 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 1559 | 1559 | 207057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991827.84816 | 2097768.2699700003 | 37.7396022020835 | -122.47082108403099 | (37.7396022020835, -122.470821084031) | |||
| 96644 | 96644 | 40784 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 28149 | 28149 | 214012 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992097.0420699995 | 2105377.93896 | 37.7605119495939 | -122.47044439308998 | (37.7605119495939, -122.47044439309) | |||
| 157585 | 157585 | 37646 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992418.62314 | 2111328.39102 | 37.7768688906569 | -122.46976542425399 | (37.7768688906569, -122.469765424254) | ||
| 80857 | 80857 | 38028 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | |||
| 188758 | 188758 | 217581 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 500 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992611.7697 | 2088555.8456 | 37.714352460703104 | -122.467440914144 | (37.7143524607031, -122.467440914144) | |||
| 143761 | 143761 | 93722 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 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) | |||
| 105407 | 105407 | 25463 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 3 | 3X3 | 5993157.11936 | 2088546.32287 | 37.714357782974204 | -122.46555529463001 | (37.7143577829742, -122.46555529463) | ||
| 121149 | 121149 | 84942 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49348 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.46431934241699 | (37.7637090714706, -122.464319342417) | |||
| 19205 | 19205 | 17244 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | ||
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 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) | |||
| 153152 | 153152 | 141053 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.781890048327206 | -122.45414629097999 | (37.7818900483272, -122.45414629098) | |||
| 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) | ||
| 148155 | 148155 | 136300 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997500.209559999 | 2116012.95103 | 37.790023863549706 | -122.45252491659402 | (37.7900238635497, -122.452524916594) | |||
| 27695 | 27695 | 214032 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997805.133780001 | 2093821.6600400002 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | |||
| 171286 | 171286 | 48668 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3362 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2002 12:00:00 AM | 2 | Permit Number 45951 | 5998735.75428 | 2115612.17598 | 37.788994153303 | -122.44822118308201 | (37.788994153303, -122.448221183082) | ||
| 146312 | 146312 | 50561 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2365 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.44726801598401 | (37.7810296062885, -122.447268015984) | |||
| 126873 | 126873 | 41661 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1376 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 2 | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181286998 | (37.7590943881005, -122.44636181287) | |
| 26602 | 26602 | 89200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51816 | 5999879.096940001 | 2119719.87548 | 37.8003381062886 | -122.444560730091 | (37.8003381062886, -122.444560730091) | |
| 87149 | 87149 | 87870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50837 | 5999889.0 | 2119639.0 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | ||
| 120958 | 120958 | 25184 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 25 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
| 596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
| 122443 | 122443 | 47699 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 297 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458917998 | 37.732285975496104 | -122.44191439219401 | (37.7322859754961, -122.441914392194) | |||
| 174549 | 174549 | 179376 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Cross St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000146.4091300005 | 2088205.43619 | 37.7138224314379 | -122.441373172128 | (37.7138224314379, -122.441373172128) | |||
| 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) | |||
| 142436 | 142436 | 32858 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 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) | |||
| 100543 | 100543 | 38059 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 116622 | 116622 | 214030 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.565880001 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | |||
| 129190 | 129190 | 94659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 97280 | 97280 | 94657 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 30486 | 30486 | 214028 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.43967507764201 | (37.7312270433827, -122.439675077642) | |||
| 72907 | 72907 | 214025 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.8435 | 2094480.0839900002 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | |||
| 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) | |||
| 26432 | 26432 | 141346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.774641176317104 | -122.439506706044 | (37.7746411763171, -122.439506706044) | |||
| 133530 | 133530 | 136299 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001939.11813 | 2119948.35287 | 37.8010827755037 | -122.43744862338 | (37.8010827755037, -122.43744862338) | |||
| 155347 | 155347 | 179374 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 906 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001350.07755 | 2088911.8778 | 37.71583065984 | -122.437263408906 | (37.71583065984, -122.437263408906) | |||
| 145210 | 145210 | 41691 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107593998 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | |||
| 75456 | 75456 | 240418 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001776.14511 | 2096508.8311299998 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | |||
| 130150 | 130150 | 240411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | |||
| 82699 | 82699 | 89314 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2005 12:00:00 AM | 3x3 | Permit Number 48328 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
| 9846 | 9846 | 41266 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2929 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779089 | 6002905.04785 | 2118704.6759200003 | 37.7977228301084 | -122.434017142274 | (37.7977228301084, -122.434017142274) | ||
| 142202 | 142202 | 70387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003118.96111 | 2094567.6101799998 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | ||
| 139989 | 139989 | 41876 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.768250702181504 | -122.430228105724 | (37.7682507021815, -122.430228105724) | ||
| 97182 | 97182 | 32 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.6216400005 | 2107707.01694 | 37.7675779249973 | -122.43006406443999 | (37.7675779249973, -122.43006406444) | ||
| 101774 | 101774 | 8103 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.42932844351601 | (37.7778928009026, -122.429328443516) | ||
| 119135 | 119135 | 48908 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 93181 | 93181 | 86997 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 248 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323.0 | 2098701.0 | 37.742877960826604 | -122.42768466378 | (37.7428779608266, -122.42768466378) | ||
| 1152 | 1152 | 240384 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.769180001 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | |
| 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) | |||
| 77489 | 77489 | 33057 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | |||
| 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) | |||
| 115313 | 115313 | 98671 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898@green Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | ||||
| 186937 | 186937 | 42675 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | ||
| 144874 | 144874 | 41728 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 97529 | 97529 | 42941 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 90 14TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42835 | 6008035.0 | 2107992.0 | 37.768598204141995 | -122.415507210488 | (37.768598204142, -122.415507210488) | ||
| 174144 | 174144 | 240381 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 98 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008070.808569999 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | |||
| 67968 | 67968 | 240378 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008072.764690001 | 2107952.79864 | 37.768492689 | -122.41537380956899 | (37.768492689, -122.415373809569) | |||
| 156395 | 156395 | 136314 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | |||
| 187730 | 187730 | 41756 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | ||
| 137058 | 137058 | 136304 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008621.3641800005 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | |||
| 169762 | 169762 | 240386 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.738762289236895 | -122.41400415558998 | (37.7387622892369, -122.41400415559) | |||
| 149302 | 149302 | 136316 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 895 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009084.75499 | 2119036.14381 | 37.798981726274 | -122.41265702602502 | (37.798981726274, -122.412657026025) | |||
| 1984 | 1984 | 252847 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008908.0 | 2108725.0 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | ||||
| 116221 | 116221 | 41750 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 157856 | 157856 | 197349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008993.795609999 | 2110246.5783 | 37.7748425951336 | -122.412350180929 | (37.7748425951336, -122.412350180929) | |||
| 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) | |||
| 25229 | 25229 | 197350 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 719 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009290.40599 | 2110497.98819 | 37.7755495477154 | -122.411341904202 | (37.7755495477154, -122.411341904202) | |||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
| 173397 | 173397 | 179371 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010448.30169 | 2092366.9553099999 | 37.7258306011814 | -122.40605884135401 | (37.7258306011814, -122.406058841354) | |||
| 98066 | 98066 | 38216 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 137431 | 137431 | 35870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.738167912917106 | -122.405598135739 | (37.7381679129171, -122.405598135739) |
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");