Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99206 | 99206 | 115258 | Permitted Site 1 | :: 54 | 2150 Jackson St | : Cutout 24 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003858.0 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | ||||
| 125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
| 28131 | 28131 | 200245 | Undocumented 2 | :: 54 | 1075 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.71984155975311 | -122.394424294358 | (37.7198415597531, -122.394424294358) | |||
| 28513 | 28513 | 200177 | Undocumented 2 | :: 54 | 1041 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876001 | (37.7190489123065, -122.39135410876) | |||
| 29647 | 29647 | 200249 | Undocumented 2 | :: 54 | 1067 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | |||
| 29863 | 29863 | 200176 | Undocumented 2 | :: 54 | 1047 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | |||
| 30792 | 30792 | 200164 | Undocumented 2 | :: 54 | 1027 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | |||
| 37581 | 37581 | 200170 | Undocumented 2 | :: 54 | 1001 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.71917119290661 | -122.393261433304 | (37.7191711929066, -122.393261433304) | |||
| 39813 | 39813 | 200248 | Undocumented 2 | :: 54 | 1107 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.719799714154504 | -122.392672078819 | (37.7197997141545, -122.392672078819) | |||
| 40807 | 40807 | 200183 | Undocumented 2 | :: 54 | 1197 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013828.6909 | 2090422.2008 | 37.7206791862384 | -122.39423689451401 | (37.7206791862384, -122.394236894514) | |||
| 42125 | 42125 | 200722 | Undocumented 2 | :: 54 | 1476 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | |||
| 43519 | 43519 | 200180 | Undocumented 2 | :: 54 | 1031 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | |||
| 44928 | 44928 | 200155 | Undocumented 2 | :: 54 | 1091 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.719607610680704 | -122.39235870744899 | (37.7196076106807, -122.392358707449) | |||
| 52467 | 52467 | 200157 | Undocumented 2 | :: 54 | 1091 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.39226030100401 | (37.7195686584119, -122.392260301004) | |||
| 55366 | 55366 | 200178 | Undocumented 2 | :: 54 | 3201 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | |||
| 58301 | 58301 | 200156 | Undocumented 2 | :: 54 | 1047 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | |||
| 61127 | 61127 | 200498 | Undocumented 2 | :: 54 | 1055 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | |||
| 73420 | 73420 | 200232 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | |||
| 74346 | 74346 | 200162 | Undocumented 2 | :: 54 | 1035 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | |||
| 131768 | 131768 | 200212 | Undocumented 2 | :: 54 | 1101 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013545.647999999 | 2090276.655 | 37.720263809593604 | -122.395205102903 | (37.7202638095936, -122.395205102903) | |||
| 133594 | 133594 | 200166 | Undocumented 2 | :: 54 | 1023 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | |||
| 144780 | 144780 | 200169 | Undocumented 2 | :: 54 | 1061 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.719314553356206 | -122.391792274296 | (37.7193145533562, -122.391792274296) | |||
| 147039 | 147039 | 200193 | Undocumented 2 | :: 54 | 975 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | |||
| 150420 | 150420 | 200167 | Undocumented 2 | :: 54 | 1019 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014049.3571 | 2089910.4430000002 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | |||
| 156632 | 156632 | 200165 | Undocumented 2 | :: 54 | 1071 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.39193334918501 | (37.7193896687982, -122.391933349185) | |||
| 157610 | 157610 | 200239 | Undocumented 2 | :: 54 | 1131 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.39311465541401 | (37.7200560674381, -122.393114655414) | |||
| 165416 | 165416 | 200238 | Undocumented 2 | :: 54 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | |||
| 168399 | 168399 | 200213 | Undocumented 2 | :: 54 | 1101 Ingerson Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013590.5861 | 2090251.1677 | 37.7201963256026 | -122.395047981349 | (37.7201963256026, -122.395047981349) | |||
| 168550 | 168550 | 200246 | Undocumented 2 | :: 54 | 1071 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | |||
| 171950 | 171950 | 200244 | Undocumented 2 | :: 54 | 1123 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.39295678576201 | (37.7199591140845, -122.392956785762) | |||
| 173333 | 173333 | 200730 | Undocumented 2 | :: 54 | 1466 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.733263927070006 | -122.387841787924 | (37.73326392707, -122.387841787924) | |||
| 176910 | 176910 | 200204 | Undocumented 2 | :: 54 | 2 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.71864490712711 | -122.392304046142 | (37.7186449071271, -122.392304046142) | |||
| 177358 | 177358 | 200205 | Undocumented 2 | :: 54 | 1003 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.71869518696921 | -122.39077918277701 | (37.7186951869692, -122.390779182777) | |||
| 177805 | 177805 | 200235 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | |||
| 177846 | 177846 | 200172 | Undocumented 2 | :: 54 | 1053 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | |||
| 179075 | 179075 | 200190 | Undocumented 2 | :: 54 | 1027 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | |||
| 179207 | 179207 | 200191 | Undocumented 2 | :: 54 | 981 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.39271586587799 | (37.7188778046353, -122.392715865878) | |||
| 182449 | 182449 | 200194 | Undocumented 2 | :: 54 | 1011 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014781.1104 | 2089713.2519999999 | 37.718785446443206 | -122.390895127615 | (37.7187854464432, -122.390895127615) | |||
| 186420 | 186420 | 200171 | Undocumented 2 | :: 54 | 1059 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | |||
| 187469 | 187469 | 200742 | Undocumented 2 | :: 54 | 1454 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.733146784173606 | -122.38761728786601 | (37.7331467841736, -122.387617287866) | |||
| 188973 | 188973 | 200161 | Undocumented 2 | :: 54 | 1083 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | |||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 89637 | 89637 | 121402 | Undocumented 2 | :: 54 | 346X Duncan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6004011.0 | 2099874.0 | 37.746081094705794 | -122.428847079389 | (37.7460810947058, -122.428847079389) | ||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 33065 | 33065 | 185060 | DPW Maintained 3 | :: 54 | 10x El Mirasol Pl | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | |||
| 36394 | 36394 | 184614 | DPW Maintained 3 | :: 54 | 3600x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | |||
| 40307 | 40307 | 184619 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984675.7685 | 2102938.8014 | 37.7533828605842 | -122.495930852185 | (37.7533828605842, -122.495930852185) | |||
| 40829 | 40829 | 184609 | DPW Maintained 3 | :: 54 | 3400x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | |||
| 44250 | 44250 | 184634 | DPW Maintained 3 | :: 54 | 4100x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981271.0577 | 2102821.0876 | 37.7528596561113 | -122.507696113948 | (37.7528596561113, -122.507696113948) | |||
| 47495 | 47495 | 184900 | DPW Maintained 3 | :: 54 | 3100x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984148.1689 | 2102921.2035 | 37.7533036269678 | -122.49775407488501 | (37.7533036269678, -122.497754074885) | |||
| 71149 | 71149 | 142745 | DPW Maintained 3 | :: 54 | 700x COLUMBUS AVE | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | |||
| 132958 | 132958 | 184627 | DPW Maintained 3 | :: 54 | 3300x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983533.5949 | 2102898.8676 | 37.7532062522999 | -122.499877713808 | (37.7532062522999, -122.499877713808) | |||
| 156043 | 156043 | 184621 | DPW Maintained 3 | :: 54 | 3100x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.75333725996521 | -122.49697636521401 | (37.7533372599652, -122.496976365214) | |||
| 162177 | 162177 | 184618 | DPW Maintained 3 | :: 54 | 3900x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981674.4395 | 2102837.4254 | 37.7529282714167 | -122.506302380507 | (37.7529282714167, -122.506302380507) | |||
| 174998 | 174998 | 184611 | DPW Maintained 3 | :: 54 | 3800x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.753005653234204 | -122.504489538097 | (37.7530056532342, -122.504489538097) | |||
| 188070 | 188070 | 184620 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.753350719104795 | -122.496675818993 | (37.7533507191048, -122.496675818993) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 37254 | 37254 | 140262 | Undocumented 2 | :: 54 | 70 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997786.9682 | 2110316.587 | 37.7743995682404 | -122.451121798449 | (37.7743995682404, -122.451121798449) | |||
| 50533 | 50533 | 247288 | Undocumented 2 | :: 54 | 638 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997017.3270000005 | 2108860.304 | 37.770356897849105 | -122.453678939083 | (37.7703568978491, -122.453678939083) | |||
| 52776 | 52776 | 247289 | Undocumented 2 | :: 54 | 636 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997016.0452 | 2108877.8212 | 37.7704049220759 | -122.45368463790199 | (37.7704049220759, -122.453684637902) | |||
| 89561 | 89561 | 141330 | Undocumented 2 | :: 54 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | |||
| 129766 | 129766 | 246016 | Undocumented 2 | :: 54 | 1605 Haight St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998345.69 | 2108581.6399 | 37.7696678206354 | -122.449064074288 | (37.7696678206354, -122.449064074288) | |||
| 134533 | 134533 | 181882 | Undocumented 2 | :: 54 | 2339 32nd Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5986377.6918 | 2099330.2097 | 37.7435741741127 | -122.48977995723999 | (37.7435741741127, -122.48977995724) | |||
| 134641 | 134641 | 184184 | Undocumented 2 | :: 54 | 1642 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5980990.4302 | 2103889.7643 | 37.7557774014806 | -122.508745894794 | (37.7557774014806, -122.508745894794) | |||
| 158331 | 158331 | 184392 | Undocumented 2 | :: 54 | 2040 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5981213.3751 | 2101162.7638 | 37.748302968665705 | -122.50777253673 | (37.7483029686657, -122.50777253673) | |||
| 165689 | 165689 | 140263 | Undocumented 2 | :: 54 | 60 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997782.8203 | 2110340.7836 | 37.7744657683679 | -122.451137892048 | (37.7744657683679, -122.451137892048) | |||
| 188216 | 188216 | 182185 | Undocumented 2 | :: 54 | 1638 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5988431.9652 | 2104143.1815 | 37.756909042216 | -122.483029559375 | (37.756909042216, -122.483029559375) | |||
| 188653 | 188653 | 246020 | Undocumented 2 | :: 54 | 1629 Haight St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998306.6251 | 2108576.7946 | 37.7696522823625 | -122.449198848796 | (37.7696522823625, -122.449198848796) | |||
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 51976 | 51976 | 181517 | Undocumented 2 | :: 54 | 1400 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984871.9567 | 2105586.7319 | 37.7606648313705 | -122.49544767930401 | (37.7606648313705, -122.495447679304) | |||
| 70132 | 70132 | 186781 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984857.4742 | 2106824.7830000003 | 37.764063324835796 | -122.49558908498399 | (37.7640633248358, -122.495589084984) | |||
| 97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99631 | 99631 | 107208 | Undocumented 2 | :: 54 | 3795 Market St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000195.59748 | 2102713.68465 | 37.7536614933614 | -122.442244022259 | (37.7536614933614, -122.442244022259) | |||||
| 107878 | 107878 | 124714 | Undocumented 2 | :: 54 | 500X 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002346.0 | 2099447.0 | 37.7448142732195 | -122.434573899432 | (37.7448142732195, -122.434573899432) | ||||
| 109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
| 125838 | 125838 | 121591 | Undocumented 2 | :: 54 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000339.0 | 2095263.0 | 37.7332118579221 | -122.44121356967199 | (37.7332118579221, -122.441213569672) | ||||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 168416 | 168416 | 186800 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984846.2035 | 2106925.1049 | 37.7643381205783 | -122.495635466651 | (37.7643381205783, -122.495635466651) | |||
| 169869 | 169869 | 186771 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984865.2362 | 2106774.8154 | 37.7639265823683 | -122.495558553205 | (37.7639265823683, -122.495558553205) | |||
| 185802 | 185802 | 200181 | Undocumented 2 | :: 54 | 1175 Ingerson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 0ft | 6013299.4945 | 2090456.4074 | 37.7207436812319 | -122.396068570714 | (37.7207436812319, -122.396068570714) | |||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 74538 | 74538 | 199648 | Undocumented 2 | :: 54 | 420 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6012151.63129 | 2111560.33 | 37.7786265538123 | -122.401518854125 | (37.7786265538123, -122.401518854125) | |||
| 85374 | 85374 | 114726 | Significant Tree 6 | :: 54 | 520 Townsend St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
| 85903 | 85903 | 105084 | Significant Tree 6 | :: 54 | 344 Fulton St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 86041 | 86041 | 105089 | Significant Tree 6 | :: 54 | 344 Fulton St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 97038 | 97038 | 105091 | Significant Tree 6 | :: 54 | 344 Fulton St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 97519 | 97519 | 114725 | Significant Tree 6 | :: 54 | 520 Townsend St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 104314 | 104314 | 105082 | Significant Tree 6 | :: 54 | 344 Fulton St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 105651 | 105651 | 105081 | Significant Tree 6 | :: 54 | 344 Fulton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 110291 | 110291 | 105085 | Significant Tree 6 | :: 54 | 344 Fulton St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 118218 | 118218 | 104635 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) |
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");