Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18856 | 18856 | 120 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 997 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002297.4140800005 | 2107635.5838200003 | 37.7672954017956 | -122.435327524665 | (37.7672954017956, -122.435327524665) | |||
| 20717 | 20717 | 121 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1010 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6002120.21923 | 2107665.1776900003 | 37.767366594808 | -122.435942533236 | (37.767366594808, -122.435942533236) | |||
| 19166 | 19166 | 122 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1012 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002100.28496 | 2107666.1128700003 | 37.767368030136204 | -122.436011549918 | (37.7673680301362, -122.436011549918) | |||
| 18669 | 18669 | 123 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1032 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3.5 | 6002070.82706 | 2107663.58495 | 37.7673594155415 | -122.436113259617 | (37.7673594155415, -122.436113259617) | |||
| 21344 | 21344 | 124 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002037.12702 | 2107659.05322 | 37.767345057867395 | -122.436229498819 | (37.7673450578674, -122.436229498819) | |||
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 21543 | 21543 | 126 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1034 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001930.03147 | 2107660.22402 | 37.7673421872283 | -122.43660001049801 | (37.7673421872283, -122.436600010498) | |||
| 19032 | 19032 | 127 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1034 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 6 | 3X3 | 6001910.06449 | 2107659.59146 | 37.7673393156847 | -122.436669028078 | (37.7673393156847, -122.436669028078) | ||
| 21520 | 21520 | 128 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1037 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001838.59138 | 2107604.25584 | 37.767183315676796 | -122.436912281202 | (37.7671833156768, -122.436912281202) | |||
| 20804 | 20804 | 129 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1046 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001838.94694 | 2107648.51377 | 37.767304857259 | -122.436914220126 | (37.767304857259, -122.436914220126) | |||
| 121440 | 121440 | 130 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1047 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001815.633124299 | 2107601.5664375 | 37.7671746263475 | -122.436991497714 | (37.7671746263475, -122.436991497714) | |||
| 17467 | 17467 | 131 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001863.23078 | 2107602.69281 | 37.7671804243666 | -122.43682694540199 | (37.7671804243666, -122.436826945402) | |||
| 17874 | 17874 | 132 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6001881.94625 | 2107604.4114599996 | 37.7671862070127 | -122.43676233451099 | (37.7671862070127, -122.436762334511) | |||
| 18051 | 18051 | 133 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001899.56867 | 2107604.3975 | 37.7671871701845 | -122.436701380267 | (37.7671871701845, -122.436701380267) | |||
| 19532 | 19532 | 134 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6001934.13073 | 2107605.43709 | 37.767191988753204 | -122.43658190982201 | (37.7671919887532, -122.436581909822) | |||
| 19437 | 19437 | 135 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6001952.83166 | 2107606.45386 | 37.7671958432489 | -122.436517298951 | (37.7671958432489, -122.436517298951) | |||
| 21415 | 21415 | 136 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.767194880067294 | -122.436453906645 | (37.7671948800673, -122.436453906645) | |||
| 18350 | 18350 | 137 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001997.64675 | 2107609.03625 | 37.7672054803662 | -122.436362475243 | (37.7672054803662, -122.436362475243) | |||
| 20276 | 20276 | 138 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/1990 12:00:00 AM | 8 | 3x3 | 6002019.503880001 | 2107609.28585 | 37.7672074076113 | -122.436286892624 | (37.7672074076113, -122.436286892624) | ||
| 19566 | 19566 | 139 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1993 12:00:00 AM | 16 | 3x3 | 6002038.50641 | 2107607.83995 | 37.7672045171948 | -122.43622106227899 | (37.7672045171948, -122.436221062279) | ||
| 16972 | 16972 | 140 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1997 12:00:00 AM | 7 | 3x3 | 6002065.74261 | 2107612.5408 | 37.7672189719923 | -122.436127192841 | (37.7672189719923, -122.436127192841) | ||
| 20724 | 20724 | 141 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/1997 12:00:00 AM | 5 | 3x3 | 6002093.67612 | 2107616.87647 | 37.767232463635004 | -122.436030885343 | (37.767232463635, -122.436030885343) | ||
| 20010 | 20010 | 142 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6002114.14587 | 2107618.20787 | 37.7672372822096 | -122.435960178842 | (37.7672372822096, -122.435960178842) | |||
| 19949 | 19949 | 143 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002137.11079 | 2107620.89146 | 37.7672459552646 | -122.435880938676 | (37.7672459552646, -122.435880938676) | |||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 21808 | 21808 | 146 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1068 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001685.884319999 | 2107635.99575 | 37.767261785130295 | -122.437442744485 | (37.7672617851303, -122.437442744485) | |||
| 20171 | 20171 | 148 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1069 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2011 12:00:00 AM | 3 | 3x3 | 6001678.29307 | 2107593.03203 | 37.7671433857715 | -122.43746592450701 | (37.7671433857715, -122.437465924507) | ||
| 21707 | 21707 | 149 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1074 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 18 | 3X3 | 6001630.772609999 | 2107637.13692 | 37.7672617851356 | -122.437633449319 | (37.7672617851356, -122.437633449319) | ||
| 17533 | 17533 | 150 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1075 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6001650.88239 | 2107592.64256 | 37.76714075797379 | -122.437560705874 | (37.7671407579738, -122.437560705874) | |||
| 22180 | 22180 | 151 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1080 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2005 12:00:00 AM | 6 | 3X3 | 6001590.292219999 | 2107634.83777 | 37.767253170535795 | -122.437773300197 | (37.7672531705358, -122.437773300197) | ||
| 83027 | 83027 | 152 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1083 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001573.9456807 | 2107585.1760068 | 37.767115882088 | -122.437826283074 | (37.767115882088, -122.437826283074) | |||
| 21992 | 21992 | 153 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1087-1089 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2015 06:27:00 AM | 3 | 3X3 | 6001581.86052 | 2107592.08996 | 37.7671353161574 | -122.43779940213899 | (37.7671353161574, -122.437799402139) | ||
| 18388 | 18388 | 154 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001569.28658 | 2107634.7500400003 | 37.767251735211794 | -122.437845949243 | (37.7672517352118, -122.437845949243) | |||
| 20118 | 20118 | 155 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 12 | 3X3 | 6001544.03852 | 2107632.6582400003 | 37.767244555911496 | -122.437933128614 | (37.7672445559115, -122.437933128614) | ||
| 17828 | 17828 | 156 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001515.67353 | 2107632.19991 | 37.767241684394705 | -122.43803120597401 | (37.7672416843947, -122.438031205974) | |||
| 17301 | 17301 | 158 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1095 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001530.2126 | 2107592.17995 | 37.7671326262835 | -122.437978050639 | (37.7671326262835, -122.437978050639) | |||
| 19293 | 19293 | 159 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1095 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001550.4127 | 2107593.72089 | 37.7671380060373 | -122.437908292048 | (37.7671380060373, -122.437908292048) | |||
| 21167 | 21167 | 160 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1095 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001560.73807 | 2107593.50705 | 37.767138006039204 | -122.437872562892 | (37.7671380060392, -122.437872562892) | |||
| 9511 | 9511 | 161 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5240X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5991235.99739 | 2114119.3924 | 37.784463784314 | -122.474060130881 | (37.784463784314, -122.474060130881) | |||
| 19695 | 19695 | 162 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5119X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1994 12:00:00 AM | 3 | 3X3 | 5991169.13123 | 2112654.48309 | 37.780437675056206 | -122.47418453611401 | (37.7804376750562, -122.474184536114) | ||
| 9320 | 9320 | 163 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 9074 | 9074 | 164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 127245 | 127245 | 165 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 146128 | 146128 | 166 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 185X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/1990 12:00:00 AM | 12 | 3X3 | 6002923.96517 | 2107137.15069 | 37.7659623878091 | -122.43312475898998 | (37.7659623878091, -122.43312475899) | ||
| 78824 | 78824 | 167 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | ||||
| 129349 | 129349 | 169 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 104075 | 104075 | 171 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6X6 | 6002921.63124 | 2107202.49362 | 37.7661416711925 | -122.433137500753 | (37.7661416711925, -122.433137500753) | |||
| 20220 | 20220 | 172 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002270.84899 | 2107104.55604 | 37.7658358209965 | -122.43538141922899 | (37.7658358209965, -122.435381419229) | |||
| 19286 | 19286 | 173 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.35161 | 2107126.41813 | 37.7658955935305 | -122.43539853871201 | (37.7658955935305, -122.435398538712) | |||
| 20544 | 20544 | 174 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.37223 | 2107147.365 | 37.7659531096791 | -122.435399965935 | (37.7659531096791, -122.435399965935) | |||
| 117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
| 9574 | 9574 | 176 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990964.24262 | 2114110.49658 | 37.784423613403504 | -122.474999649931 | (37.7844236134035, -122.474999649931) | |||
| 9525 | 9525 | 177 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990912.96055 | 2114105.91561 | 37.7844080632129 | -122.47517673183799 | (37.7844080632129, -122.475176731838) | |||
| 104572 | 104572 | 178 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 110930 | 110930 | 179 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 105956 | 105956 | 181 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 77322 | 77322 | 182 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 102799 | 102799 | 183 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 121328 | 121328 | 184 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 17968 | 17968 | 186 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3000 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6006757.0691 | 2106751.32667 | 37.765119694430794 | -122.41983943004 | (37.7651196944308, -122.41983943004) | |||
| 98530 | 98530 | 188 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1990X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006778.49785 | 2106815.42312 | 37.765296895397604 | -122.419769861465 | (37.7652968953976, -122.419769861465) | |||
| 145714 | 145714 | 189 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1990X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6006778.46705 | 2106797.52493 | 37.7652477494393 | -122.419768697906 | (37.7652477494393, -122.419768697906) | |||
| 19970 | 19970 | 191 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3016 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2015 03:04:00 PM | 3 | 4X4 | 6006680.54829 | 2106746.56856 | 37.765102318639705 | -122.420103759676 | (37.7651023186397, -122.420103759676) | ||
| 18609 | 18609 | 192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 385X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/09/2013 12:00:00 AM | 3 | 3X3 | 6005547.989469999 | 2106715.71324 | 37.7649537200544 | -122.424018813443 | (37.7649537200544, -122.424018813443) | ||
| 17890 | 17890 | 193 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 423X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2008 12:00:00 AM | 3 | 3X3 | 6005562.55526 | 2106507.52991 | 37.764382920371496 | -122.423953628772 | (37.7643829203715, -122.423953628772) | ||
| 118724 | 118724 | 194 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X3 | 6005567.0759942 | 2106542.8569591 | 37.7644801752938 | -122.423940505082 | (37.7644801752938, -122.423940505082) | |||
| 19818 | 19818 | 195 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 290X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106583.9788 | 37.7644417056271 | -122.433195386565 | (37.7644417056271, -122.433195386565) | ||
| 17800 | 17800 | 196 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 292X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106567.7025 | 37.764397014858 | -122.433194223505 | (37.764397014858, -122.433194223505) | ||
| 17148 | 17148 | 197 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002246.85388 | 2106423.49653 | 37.7639644352284 | -122.43541568967899 | (37.7639644352284, -122.435415689679) | |||
| 100426 | 100426 | 199 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1621X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5990403.2095800005 | 2114714.97277 | 37.7860508060194 | -122.476984794344 | (37.7860508060194, -122.476984794344) | |||
| 107070 | 107070 | 200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5604X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4x4 | 5990186.04567 | 2114081.13509 | 37.784297864805104 | -122.477689766774 | (37.7842978648051, -122.477689766774) | |||
| 88096 | 88096 | 201 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1800X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X6 | 5989853.087040001 | 2114748.48442 | 37.7861108905335 | -122.478890501056 | (37.7861108905335, -122.478890501056) | |||
| 18237 | 18237 | 203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/02/1994 12:00:00 AM | 20 | 2X3 | 5990600.62302 | 2095815.8473599998 | 37.7341702996075 | -122.474921777626 | (37.7341702996075, -122.474921777626) | ||
| 18704 | 18704 | 204 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 20 | 2X3 | 5990598.496180001 | 2095837.8189400001 | 37.7342305047257 | -122.474930733974 | (37.7342305047257, -122.474930733974) | ||
| 21686 | 21686 | 205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2918 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1994 12:00:00 AM | 10 | 2X3 | 5990601.803119999 | 2095779.7077 | 37.734071137676295 | -122.474915060599 | (37.7340711376763, -122.474915060599) | ||
| 12562 | 12562 | 206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2919 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 6 | 2X3 | 5990516.43657 | 2095785.37905 | 37.734081762249296 | -122.475210610191 | (37.7340817622493, -122.475210610191) | ||
| 78109 | 78109 | 207 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | ||
| 20959 | 20959 | 208 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2924 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1994 12:00:00 AM | 7 | 3x3 | 5990600.55143 | 2095720.40284 | 37.7339082290639 | -122.4749150606 | (37.7339082290639, -122.4749150606) | ||
| 21279 | 21279 | 209 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2924 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 5990600.52986 | 2095750.0689299998 | 37.7339896833587 | -122.474917299886 | (37.7339896833587, -122.474917299886) | |||
| 12865 | 12865 | 210 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2929 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 2X3 | 5990521.9439 | 2095739.47468 | 37.7339560397287 | -122.475188219755 | (37.7339560397287, -122.475188219755) | ||
| 12433 | 12433 | 211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2929 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.61376 | 2095726.5411900003 | 37.7339206244383 | -122.475181502724 | (37.7339206244383, -122.475181502724) | |||
| 21373 | 21373 | 212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2930 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 5990603.05334 | 2095685.5251099998 | 37.7338126086681 | -122.474903865842 | (37.7338126086681, -122.474903865842) | |||
| 11219 | 11219 | 213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.08308 | 2095701.4011400002 | 37.7338515654947 | -122.475181502731 | (37.7338515654947, -122.475181502731) | |||
| 11430 | 11430 | 214 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X3 | 5990522.122690001 | 2095686.58843 | 37.7338108378948 | -122.47518374203699 | (37.7338108378948, -122.475183742037) | |||
| 18108 | 18108 | 215 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2940 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990603.87201 | 2095662.9362299999 | 37.733750632784705 | -122.47489938720699 | (37.7337506327847, -122.474899387207) | ||
| 21117 | 21117 | 216 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 3X3 | 5990608.35114 | 2095598.99571 | 37.7335753279252 | -122.474879236093 | (37.7335753279252, -122.474879236093) | ||
| 18299 | 18299 | 217 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990605.54964 | 2095619.69203 | 37.733631992415106 | -122.47489043175501 | (37.7336319924151, -122.474890431755) | ||
| 12021 | 12021 | 219 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | |||
| 17759 | 17759 | 220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2950 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 10 | 3X3 | 5990607.61646 | 2095564.18629 | 37.7334797075204 | -122.474879236111 | (37.7334797075204, -122.474879236111) | ||
| 12873 | 12873 | 221 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2955 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2008 12:00:00 AM | 6 | 2X3 | 5990527.06047 | 2095552.3434400002 | 37.7334425214563 | -122.47515687389799 | (37.7334425214563, -122.475156873898) | ||
| 17208 | 17208 | 223 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2956 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1995 12:00:00 AM | 20 | 2X3 | 5990609.51977 | 2095500.9447299999 | 37.733306172547 | -122.474868041348 | (37.733306172547, -122.474868041348) | ||
| 22150 | 22150 | 224 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2956 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X4 | 5990611.41299 | 2095529.2809 | 37.733384086190796 | -122.474863563627 | (37.7333840861908, -122.474863563627) | |||
| 17413 | 17413 | 225 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.47486804133301 | (37.7331946143326, -122.474868041333) | ||
| 13169 | 13169 | 226 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | |||
| 117409 | 117409 | 227 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2X3 | 5990630.67566 | 2095430.1647700001 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | |||
| 21024 | 21024 | 228 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.732946707226205 | -122.47484341251601 | (37.7329467072262, -122.474843412516) | ||
| 92204 | 92204 | 229 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2974 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5990632.173690001 | 2095387.1701099998 | 37.7329950890785 | -122.474781419889 | (37.7329950890785, -122.474781419889) | |||
| 12538 | 12538 | 230 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.537280001 | 2095454.9094099998 | 37.7331751359068 | -122.475141200505 | (37.7331751359068, -122.475141200505) | |||
| 11508 | 11508 | 231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 16 | 2 | 5990528.9249599995 | 2095425.9012900002 | 37.7330954514847 | -122.475141200519 | (37.7330954514847, -122.475141200519) | ||
| 20582 | 20582 | 233 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 5990616.421680001 | 2095336.99138 | 37.732856398203104 | -122.474832216845 | (37.7328563982031, -122.474832216845) |
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");