Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63032 | 63032 | 204368 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 504 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993515.009319999 | 2089252.8539 | 37.7163183837543 | -122.46436956170601 | (37.7163183837543, -122.464369561706) | |||
| 137983 | 137983 | 205870 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 27 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997419.74541 | 2089183.0190700002 | 37.7163509392228 | -122.450867930105 | (37.7163509392228, -122.450867930105) | |||
| 52577 | 52577 | 205871 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 111 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991654.88774 | 2089307.44903 | 37.7163608911211 | -122.470802959995 | (37.7163608911211, -122.470802959995) | |||
| 180939 | 180939 | 205850 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.46254122291599 | (37.7164641180118, -122.462541222916) | |||
| 174042 | 174042 | 205849 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 438 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5994041.34174 | 2089295.5439900002 | 37.7164659256374 | -122.46255340963002 | (37.7164659256374, -122.46255340963) | |||
| 26248 | 26248 | 205848 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 438 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994034.73412 | 2089295.68258 | 37.7164659256424 | -122.462576258696 | (37.7164659256424, -122.462576258696) | |||
| 56400 | 56400 | 175657 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5990127.49163 | 2089397.98883 | 37.716521041479204 | -122.476088939347 | (37.7165210414792, -122.476088939347) | ||||
| 56320 | 56320 | 205854 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 293 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994120.5161 | 2089316.03837 | 37.7165267575898 | -122.462281231613 | (37.7165267575898, -122.462281231613) | |||
| 129845 | 129845 | 205853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 295 Montana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994093.801030001 | 2089317.2644900002 | 37.7165285858993 | -122.462373660324 | (37.7165285858993, -122.462373660324) | |||
| 34081 | 34081 | 205855 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 289 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994148.42525 | 2089316.1189700002 | 37.7165285859025 | -122.46218477031799 | (37.7165285859025, -122.462184770318) | |||
| 136383 | 136383 | 205851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 295 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994081.9118099995 | 2089317.7332799998 | 37.7165291884491 | -122.462414789036 | (37.7165291884491, -122.462414789036) | |||
| 148102 | 148102 | 205852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 295 Montana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994085.70454 | 2089317.7212099999 | 37.7165293737121 | -122.462401678704 | (37.7165293737121, -122.462401678704) | |||
| 179107 | 179107 | 205856 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994153.26776 | 2089347.39588 | 37.7166147436609 | -122.462170299322 | (37.7166147436609, -122.462170299322) | |||
| 118109 | 118109 | 175636 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1277 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011793.2641900005 | 2088994.55488 | 37.7166458107269 | -122.401172506308 | (37.7166458107269, -122.401172506308) | |||
| 75000 | 75000 | 204369 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 527 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993483.1627400005 | 2089373.74444 | 37.7166484844088 | -122.46448841072599 | (37.7166484844088, -122.464488410726) | |||
| 39544 | 39544 | 205863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 84 Montana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995979.08585 | 2089323.9074099998 | 37.716655207752204 | -122.455857700672 | (37.7166552077522, -122.455857700672) | |||
| 74014 | 74014 | 205862 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5996022.66258 | 2089323.5104900002 | 37.7166566187968 | -122.455707049864 | (37.7166566187968, -122.455707049864) | |||
| 51475 | 51475 | 205860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 74 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5996072.4315 | 2089323.2406799998 | 37.7166587339933 | -122.455535005044 | (37.7166587339933, -122.455535005044) | |||
| 181693 | 181693 | 205861 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5996047.1738599995 | 2089324.0253299999 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | |||
| 56571 | 56571 | 205859 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 70 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996096.42731 | 2089323.76634 | 37.7166615542625 | -122.455452101947 | (37.7166615542625, -122.455452101947) | |||
| 12443 | 12443 | 1098 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999519.61819 | 2089252.78521 | 37.7166624877513 | -122.44361477910299 | (37.7166624877513, -122.443614779103) | |||
| 114976 | 114976 | 44345 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2001 12:00:00 AM | 3x3 | Permit Number 43728 | 5996130.57054216 | 2089332.51676928 | 37.7166875400006 | -122.45533471853399 | (37.7166875400006, -122.455334718534) | ||
| 132386 | 132386 | 204370 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 531 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993483.30762 | 2089398.8506 | 37.7167174282511 | -122.464489731835 | (37.7167174282511, -122.464489731835) | |||
| 51982 | 51982 | 205872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Monticello St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991705.27348 | 2089452.68215 | 37.71676257961679 | -122.470639376025 | (37.7167625796168, -122.470639376025) | |||
| 57910 | 57910 | 204371 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 535 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993483.802619999 | 2089422.42802 | 37.7167821947225 | -122.464489731828 | (37.7167821947225, -122.464489731828) | |||
| 165611 | 165611 | 205869 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 118 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997252.7619900005 | 2089357.2936200001 | 37.7168198961062 | -122.45145766596501 | (37.7168198961062, -122.451457665965) | |||
| 50323 | 50323 | 55325 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.0764400002 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | ||
| 179687 | 179687 | 204372 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993517.68116 | 2089452.91347 | 37.7168678533586 | -122.464374843447 | (37.7168678533586, -122.464374843447) | |||
| 132945 | 132945 | 205864 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 714 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995928.91835 | 2089403.79858 | 37.716871690765295 | -122.456036876198 | (37.7168716907653, -122.456036876198) | |||
| 52839 | 52839 | 204373 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 543 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993483.886519999 | 2089481.0150400002 | 37.7169430654519 | -122.46449369334 | (37.7169430654519, -122.46449369334) | |||
| 160117 | 160117 | 121487 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 377 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6010852.01501 | 2089133.2163799999 | 37.7169739913337 | -122.40443570715799 | (37.7169739913337, -122.404435707158) | |||
| 44209 | 44209 | 204374 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 546 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993518.36116 | 2089503.4985 | 37.71700678690679 | -122.46437616365 | (37.7170067869068, -122.46437616365) | |||
| 156527 | 156527 | 204361 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 251 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992186.2665 | 2089542.38653 | 37.7170366884615 | -122.468983359893 | (37.7170366884615, -122.468983359893) | |||
| 45416 | 45416 | 175631 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011388.92797 | 2089147.79242 | 37.7170440044489 | -122.40258087252501 | (37.7170440044489, -122.402580872525) | |||
| 165453 | 165453 | 204375 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 550 Head St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993517.97256 | 2089521.38757 | 37.717055883598704 | -122.464378804934 | (37.7170558835987, -122.464378804934) | |||
| 158410 | 158410 | 175632 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 305 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011331.178780001 | 2089183.9160799999 | 37.717139968409704 | -122.402783023943 | (37.7171399684097, -122.402783023943) | |||
| 53937 | 53937 | 175653 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | ||||
| 135194 | 135194 | 175599 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 192 Dublin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6004164.3183699995 | 2089345.24941 | 37.717180184308894 | -122.427566943762 | (37.7171801843089, -122.427566943762) | |||
| 187953 | 187953 | 55331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.3008700002 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | ||
| 148983 | 148983 | 55329 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | ||
| 146873 | 146873 | 204376 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 567 Head St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993486.95229 | 2089627.0413900001 | 37.7173441954665 | -122.464493693328 | (37.7173441954665, -122.464493693328) | |||
| 168076 | 168076 | 175652 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988848.344219999 | 2089725.7642299999 | 37.717346774709505 | -122.480534235175 | (37.7173467747095, -122.480534235175) | ||||
| 133561 | 133561 | 55328 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.540630001 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | ||
| 77122 | 77122 | 55323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | ||
| 62333 | 62333 | 106717 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201X Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011633.0362599995 | 2089278.7671299998 | 37.7174172599795 | -122.401746303446 | (37.7174172599795, -122.401746303446) | |||
| 74799 | 74799 | 61035 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 208 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 13 | Permit Number 20858 | 6011595.89338 | 2089312.04675 | 37.717506566247394 | -122.40187702801 | (37.7175065662474, -122.40187702801) | ||
| 112466 | 112466 | 55327 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | Permit Number 11257 | 6011659.22686105 | 2089335.34929904 | 37.717574084708 | -122.401659748875 | (37.717574084708, -122.401659748875) | |||
| 147863 | 147863 | 205868 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5996845.79725 | 2089640.92362 | 37.717575365281704 | -122.452884796511 | (37.7175753652817, -122.452884796511) | |||
| 26223 | 26223 | 175637 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011646.28852 | 2089340.4245799999 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | |||
| 81671 | 81671 | 31181 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34879 | 5992668.86925851 | 2089822.40668247 | 37.717833427977794 | -122.467335598289 | (37.7178334279778, -122.467335598289) | ||
| 19049 | 19049 | 19343 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992618.01059 | 2089830.6740400002 | 37.7178531919595 | -122.467511993496 | (37.7178531919595, -122.467511993496) | |||
| 22100 | 22100 | 19346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.717938880250394 | -122.46781582943999 | (37.7179388802504, -122.46781582944) | |||
| 168709 | 168709 | 204362 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 304 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992231.07965 | 2089876.61874 | 37.7179569979942 | -122.468852772034 | (37.7179569979942, -122.468852772034) | |||
| 165460 | 165460 | 175598 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 655 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001566.020830001 | 2089685.8945799998 | 37.717968210742704 | -122.43657237970899 | (37.7179682107427, -122.436572379709) | |||
| 128976 | 128976 | 31182 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34880 | 5992624.59921054 | 2089874.97031305 | 37.7179751991794 | -122.467492439169 | (37.7179751991794, -122.467492439169) | ||
| 132305 | 132305 | 204363 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 304 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5992230.03339 | 2089899.4415400003 | 37.7180196034048 | -122.46885804836201 | (37.7180196034048, -122.468858048362) | |||
| 78046 | 78046 | 38922 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | |||
| 82703 | 82703 | 54188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | ||
| 161907 | 161907 | 66267 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.718328712978895 | -122.394793038594 | (37.7183287129789, -122.394793038594) | ||
| 148825 | 148825 | 188249 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013627.87026 | 2089584.4738900003 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | |||
| 162076 | 162076 | 205845 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Jules Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994459.492190001 | 2090019.5139099997 | 37.718477846645605 | -122.46116053335 | (37.7184778466456, -122.46116053335) | |||
| 177247 | 177247 | 205844 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 19 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994418.11304 | 2090057.9120099999 | 37.71858089726889 | -122.46130634491301 | (37.7185808972689, -122.461306344913) | |||
| 61613 | 61613 | 205866 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994049.93117 | 2090081.6235099998 | 37.7186248066558 | -122.462580708559 | (37.7186248066558, -122.462580708559) | |||
| 184082 | 184082 | 205867 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994049.56571 | 2090091.22883 | 37.71865115951571 | -122.462582668169 | (37.7186511595157, -122.462582668169) | |||
| 49753 | 49753 | 205843 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994419.00692 | 2090084.06137 | 37.7186527486105 | -122.461305149717 | (37.7186527486105, -122.461305149717) | |||
| 32992 | 32992 | 175633 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1108 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011834.593230001 | 2089743.09488 | 37.7187034559781 | -122.401082217992 | (37.7187034559781, -122.401082217992) | |||
| 156590 | 156590 | 205842 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 27 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994419.526319999 | 2090108.8413099998 | 37.7187208182988 | -122.46130514971901 | (37.7187208182988, -122.461305149719) | |||
| 56612 | 56612 | 188254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013780.02718 | 2089753.4923900003 | 37.718840340875204 | -122.39435831441001 | (37.7188403408752, -122.39435831441) | ||||
| 60286 | 60286 | 188255 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013785.156280001 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | ||||
| 56478 | 56478 | 205841 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994419.49218 | 2090156.7021700002 | 37.7188522308197 | -122.461308735327 | (37.7188522308197, -122.461308735327) | |||
| 29194 | 29194 | 188256 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013789.26124 | 2089763.6189299999 | 37.7188686596462 | -122.39432710432301 | (37.7188686596462, -122.394327104323) | ||||
| 38650 | 38650 | 175597 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 650 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001092.21629 | 2090034.68248 | 37.7188989677059 | -122.438235084102 | (37.7188989677059, -122.438235084102) | |||
| 41791 | 41791 | 188253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013773.56946 | 2089775.5723 | 37.718900608948395 | -122.394382181502 | (37.7189006089484, -122.394382181502) | ||||
| 134087 | 134087 | 188252 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013770.43233 | 2089778.01595 | 37.718907144335496 | -122.394393196412 | (37.7189071443355, -122.394393196412) | ||||
| 48313 | 48313 | 188250 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6013748.16101 | 2089779.7890700002 | 37.7189107748964 | -122.39447030426099 | (37.7189107748964, -122.394470304261) | ||||
| 34280 | 34280 | 188251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013763.34518 | 2089782.1261 | 37.718918036018295 | -122.394417981716 | (37.7189180360183, -122.394417981716) | ||||
| 131459 | 131459 | 205840 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 39 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994420.753330001 | 2090183.87687 | 37.7189269186341 | -122.461306344918 | (37.7189269186341, -122.461306344918) | |||
| 57235 | 57235 | 175648 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | |||
| 180905 | 180905 | 175649 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | |||
| 67405 | 67405 | 175650 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990453.87404 | 2090277.7472299999 | 37.718955561137705 | -122.475024995517 | (37.7189555611377, -122.475024995517) | |||
| 185753 | 185753 | 175651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008001 | (37.7189698369625, -122.47492674008) | |||
| 42569 | 42569 | 175629 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6009095.75789 | 2089908.2938299999 | 37.719003889795104 | -122.410560964431 | (37.7190038897951, -122.410560964431) | |||
| 155101 | 155101 | 205839 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 43 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994420.71855 | 2090215.2105299998 | 37.7190129513734 | -122.46130873532101 | (37.7190129513734, -122.461308735321) | |||
| 28651 | 28651 | 175628 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6009091.54392 | 2089913.6992400002 | 37.719018495673396 | -122.41057591204701 | (37.7190184956734, -122.410575912047) | |||
| 39440 | 39440 | 175627 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6009089.91396 | 2089921.0786400002 | 37.7190386665864 | -122.410582067034 | (37.7190386665864, -122.410582067034) | |||
| 126520 | 126520 | 47348 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45274 | 5994469.1469604 | 2090229.4816179 | 37.7190549234375 | -122.461142372223 | (37.7190549234375, -122.461142372223) | ||
| 76804 | 76804 | 175626 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009096.33692 | 2089936.65243 | 37.7190817890677 | -122.410560964424 | (37.7190817890677, -122.410560964424) | |||
| 52250 | 52250 | 205838 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994420.67655 | 2090246.19978 | 37.7190980380284 | -122.461311125734 | (37.7190980380284, -122.461311125734) | |||
| 147633 | 147633 | 204392 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Junipero Serra Blvd | 111 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991121.6593 | 2090321.7694700002 | 37.7191151143447 | -122.47271995398 | (37.7191151143447, -122.47271995398) | |||
| 25241 | 25241 | 205846 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994462.98595 | 2090252.1993200001 | 37.7191169462637 | -122.46116531412301 | (37.7191169462637, -122.461165314123) | |||
| 93212 | 93212 | 205837 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994421.47665 | 2090267.8750599998 | 37.7191575992129 | -122.461309930536 | (37.7191575992129, -122.461309930536) | |||
| 38565 | 38565 | 205865 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 565 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994014.3343 | 2090276.58042 | 37.71915806148179 | -122.462717886617 | (37.7191580614818, -122.462717886617) | |||
| 46937 | 46937 | 31866 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35308 | 5994462.19495 | 2090280.44973 | 37.7191944696164 | -122.46117009494301 | (37.7191944696164, -122.461170094943) | ||
| 40811 | 40811 | 175624 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009382.81472 | 2090013.8898 | 37.719309923703605 | -122.409576165411 | (37.7193099237036, -122.409576165411) | |||
| 27949 | 27949 | 175625 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.719321051904295 | -122.40959990662701 | (37.7193210519043, -122.409599906627) | |||
| 68873 | 68873 | 175623 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6009402.84406 | 2090023.10643 | 37.719336352976 | -122.409507581334 | (37.719336352976, -122.409507581334) | |||
| 180833 | 180833 | 175622 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009430.205130001 | 2090028.38757 | 37.7193523869705 | -122.40941337645 | (37.7193523869705, -122.40941337645) | |||
| 49543 | 49543 | 175621 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6009441.92296 | 2090030.92164 | 37.7193600015446 | -122.409373050849 | (37.7193600015446, -122.409373050849) | |||
| 186623 | 186623 | 175620 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009477.4678 | 2090042.2500200002 | 37.719393098398704 | -122.40925098404499 | (37.7193930983987, -122.409250984045) | |||
| 51704 | 51704 | 205847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 67 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996192.14222 | 2090321.7289 | 37.7194072168392 | -122.45519334181299 | (37.7194072168392, -122.455193341813) |
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");