Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCareAssistant, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1002 | 1002 | 221998 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 171 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | 6005231.98236 | 2103978.9256700003 | 37.7574213016572 | -122.42491707607999 | (37.7574213016572, -122.42491707608) | ||
7454 | 7454 | 18678 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 145 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999202.7860900005 | 2119633.74554 | 37.8000630027522 | -122.446894823333 | (37.8000630027522, -122.446894823333) | |||
14527 | 14527 | 57071 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 930 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 12 | 6.5x9 | Permit Number 14337 | 6015214.98286 | 2104265.6795099997 | 37.7587674959327 | -122.39041163330499 | (37.7587674959327, -122.390411633305) | |
28491 | 28491 | 222007 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 2 Sharon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003834.24271 | 2107055.63847 | 37.765790168696704 | -122.42997048086599 | (37.7657901686967, -122.429970480866) | |||
31052 | 31052 | 204748 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 280 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000177.433780001 | 2094973.5624099998 | 37.7324079251883 | -122.441751381134 | (37.7324079251883, -122.441751381134) | |||
35078 | 35078 | 175231 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3500 Great Hwy | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5982272.29331 | 2092808.76139 | 37.725427492666505 | -122.503492363109 | (37.7254274926665, -122.503492363109) | |||
35088 | 35088 | 221988 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006638.42684 | 2103473.9657900003 | 37.7561141406682 | -122.420017188263 | (37.7561141406682, -122.420017188263) | |||
40822 | 40822 | 187972 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 75 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6013703.3858900005 | 2095554.5779799998 | 37.734764687625706 | -122.395029332752 | (37.7347646876257, -122.395029332752) | |||
44841 | 44841 | 187973 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 1814 Illinois St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6016258.63636 | 2100595.19225 | 37.7487469466117 | -122.386546230235 | (37.7487469466117, -122.386546230235) | |||
45501 | 45501 | 221986 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006634.40739 | 2103532.5435099998 | 37.7562747551033 | -122.420035245751 | (37.7562747551033, -122.420035245751) | |||
48111 | 48111 | 221996 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 899 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009946.78477 | 2104029.504 | 37.7578253643707 | -122.408614908869 | (37.7578253643707, -122.408614908869) | |||
48246 | 48246 | 221980 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006626.67847 | 2103690.249 | 37.7567073424829 | -122.42007316656401 | (37.7567073424829, -122.420073166564) | |||
49256 | 49256 | 221995 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 898 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009908.08739 | 2104028.96096 | 37.757821705931704 | -122.40874870281401 | (37.7578217059317, -122.408748702814) | |||
51202 | 51202 | 221992 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 990 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008580.26811 | 2102888.63865 | 37.7546161785976 | -122.41326023366899 | (37.7546161785976, -122.413260233669) | |||
52726 | 52726 | 221993 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 990 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008581.63371 | 2102847.3466 | 37.75450287662971 | -122.41325259124599 | (37.7545028766297, -122.413252591246) | |||
62199 | 62199 | 221983 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006631.91711 | 2103614.748 | 37.75650032934 | -122.420049691544 | (37.75650032934, -122.420049691544) | |||
66619 | 66619 | 35389 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 779 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 13 | 9x3 | Permit Number 38843 | 6011312.83562 | 2104732.123 | 37.7598310126183 | -122.403939953189 | (37.7598310126183, -122.403939953189) |
71187 | 71187 | 84814 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 678 PRECITA Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49253 | 6010016.1 | 2100471.5 | 37.7480597580847 | -122.408124260646 | (37.7480597580847, -122.408124260646) | |||
71450 | 71450 | 222006 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 638 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002365.4642900005 | 2100063.19063 | 37.7465072929931 | -122.434550646215 | (37.7465072929931, -122.434550646215) | |||
82596 | 82596 | 48529 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3573-3575 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772739 | 6005786.36751364 | 2104881.42238446 | 37.75993064521779 | -122.423063935166 | (37.7599306452178, -122.423063935166) |
83072 | 83072 | 86706 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
84991 | 84991 | 86705 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | ||
86048 | 86048 | 66550 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 190 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29733 | 6005076.47983531 | 2104016.35626613 | 37.757515292561 | -122.425457529818 | (37.757515292561, -122.425457529818) | ||
86104 | 86104 | 66551 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 171 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29734 | 6005203.58536905 | 2103971.32974572 | 37.757398840996 | -122.42501474382 | (37.757398840996, -122.42501474382) | ||
89603 | 89603 | 84948 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | ||
96818 | 96818 | 86707 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
99813 | 99813 | 86708 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
108431 | 108431 | 36587 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 1281 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42198 | 6009541.01315612 | 2101724.44316629 | 37.751473449709295 | -122.409855531474 | (37.7514734497093, -122.409855531474) | ||
112629 | 112629 | 43308 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 731 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43074 | 6011298.37452427 | 2104952.13824403 | 37.760434317449295 | -122.404005450683 | (37.7604343174493, -122.404005450683) | ||
114247 | 114247 | 106879 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 180X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 6 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
128363 | 128363 | 86709 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | |||
131035 | 131035 | 221999 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 190 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005095.3438 | 2104013.90235 | 37.7575096204881 | -122.42539211596399 | (37.7575096204881, -122.425392115964) | |||
131834 | 131834 | 222002 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009308.24757 | 2101572.23402 | 37.7510424697477 | -122.41064971851499 | (37.7510424697477, -122.410649718515) | |||
132622 | 132622 | 222001 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 410 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 2ft | 6003238.10095 | 2099234.2788400003 | 37.7442807928159 | -122.43147400163299 | (37.7442807928159, -122.431474001633) | |||
132837 | 132837 | 222005 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009336.22722 | 2101572.6754400004 | 37.751045250458105 | -122.410552992838 | (37.7510452504581, -122.410552992838) | |||
134987 | 134987 | 246752 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 184 Ripley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 6009192.58096 | 2099095.15553 | 37.7442344750379 | -122.41087477656299 | (37.7442344750379, -122.410874776563) | |||
135325 | 135325 | 221989 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006640.504480001 | 2103452.44112 | 37.756055155948204 | -122.42000847563699 | (37.7560551559482, -122.420008475637) | |||
135658 | 135658 | 221994 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 898 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009905.4747 | 2104068.34627 | 37.757929702797604 | -122.40876051717599 | (37.7579297027976, -122.408760517176) | |||
137239 | 137239 | 63482 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 1716 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | 8 | Permit Number 29232 | 6014515.8584900005 | 2094870.77995 | 37.7329322641077 | -122.392172506761 | (37.7329322641077, -122.392172506761) | |
146366 | 146366 | 222004 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009328.85625 | 2101572.8259400004 | 37.751045250454396 | -122.410578493127 | (37.7510452504544, -122.410578493127) | |||
147902 | 147902 | 74329 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 121 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/01/2000 12:00:00 AM | 10 | 6004023.71662 | 2093082.18555 | 37.7274330338863 | -122.428319125933 | (37.7274330338863, -122.428319125933) | ||
149410 | 149410 | 221985 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006632.52814 | 2103555.46037 | 37.756337573629 | -122.42004337111601 | (37.756337573629, -122.420043371116) | |||
151390 | 151390 | 221987 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006637.6448 | 2103499.45975 | 37.7561840971364 | -122.42002170193999 | (37.7561840971364, -122.42002170194) | |||
156710 | 156710 | 221990 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006641.795030001 | 2103432.2247 | 37.7559997190345 | -122.420002577883 | (37.7559997190345, -122.420002577883) | |||
159518 | 159518 | 221984 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006632.28944 | 2103594.72205 | 37.7564453636852 | -122.420046982776 | (37.7564453636852, -122.420046982776) | |||
161409 | 161409 | 175229 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3500 Great Hwy | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5982196.22083 | 2092858.10261 | 37.725558497802 | -122.50375898690201 | (37.725558497802, -122.503758986902) | |||
167794 | 167794 | 221982 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006629.08969 | 2103642.3634200003 | 37.7565759956004 | -122.420061429494 | (37.7565759956004, -122.420061429494) | |||
177816 | 177816 | 222000 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3228 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008990.89387 | 2099875.05799 | 37.746364603844796 | -122.411627262689 | (37.7463646038448, -122.411627262689) | |||
178232 | 178232 | 221991 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006643.29491 | 2103405.27783 | 37.755925813651 | -122.419995478603 | (37.755925813651, -122.419995478603) | |||
178283 | 178283 | 175230 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3500 Great Hwy | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5982256.13934 | 2092818.4167900002 | 37.7254530540961 | -122.503548919661 | (37.7254530540961, -122.503548919661) | |||
182865 | 182865 | 175232 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3500 Great Hwy | 20 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5982361.978019999 | 2092682.2058599999 | 37.7250852772585 | -122.503172970672 | (37.7250852772585, -122.503172970672) | |||
183990 | 183990 | 222003 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3027 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009319.31004 | 2101572.2711400003 | 37.751043191894 | -122.410611465844 | (37.751043191894, -122.410611465844) | |||
185763 | 185763 | 221981 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 90 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006627.76439 | 2103666.8286200003 | 37.756643096715706 | -122.420067749029 | (37.7566430967157, -122.420067749029) | |||
188598 | 188598 | 221997 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 3573 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005789.27055 | 2104883.87542 | 37.7599375444968 | -122.423054069317 | (37.7599375444968, -122.423054069317) |
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");