Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12506 | 12506 | 98216 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.50150154301201 | (37.7576365448231, -122.501501543012) | ||
| 81348 | 81348 | 113709 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801x CLEMENT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 4x4 | 5986698.0 | 2113245.0 | 37.78179903933621 | -122.4896955071 | (37.7817990393362, -122.4896955071) | |||
| 84481 | 84481 | 113708 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801x CLEMENT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 4x4 | 5986698.0 | 2113245.0 | 37.78179903933621 | -122.4896955071 | (37.7817990393362, -122.4896955071) | |||
| 110169 | 110169 | 113705 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801x CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 10 | 4x4 | 5986698.0 | 2113245.0 | 37.78179903933621 | -122.4896955071 | (37.7817990393362, -122.4896955071) | ||
| 111553 | 111553 | 113706 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801x CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 4x4 | 5986698.0 | 2113245.0 | 37.78179903933621 | -122.4896955071 | (37.7817990393362, -122.4896955071) | |||
| 115629 | 115629 | 113707 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 4x4 | 5986698.0 | 2113245.0 | 37.78179903933621 | -122.4896955071 | (37.7817990393362, -122.4896955071) | |||
| 23240 | 23240 | 76785 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.757691027540005 | -122.501506182606 | (37.75769102754, -122.501506182606) | |
| 23340 | 23340 | 76382 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | |
| 84343 | 84343 | 47201 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45157 | 5986666.180509999 | 2113215.9234599997 | 37.7817173456419 | -122.489803447111 | (37.7817173456419, -122.489803447111) |
| 106239 | 106239 | 47203 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45157 | 5986727.74959 | 2113216.7702900004 | 37.7817232655044 | -122.48959051227101 | (37.7817232655044, -122.489590512271) |
| 111525 | 111525 | 99343 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 5986574.07493 | 2113086.2305799997 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | ||
| 115776 | 115776 | 47200 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45157 | 5986636.7904199995 | 2113215.6243 | 37.7817148081587 | -122.489905099586 | (37.7817148081587, -122.489905099586) |
| 124662 | 124662 | 99335 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584005 | -122.490084370963 | (37.780844350584, -122.490084370963) | ||
| 138862 | 138862 | 47202 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) |
| 140800 | 140800 | 47197 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | |
| 78767 | 78767 | 12056 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 80819 | 80819 | 12055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 92477 | 92477 | 12059 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 93198 | 93198 | 12058 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 109212 | 109212 | 12062 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 110400 | 110400 | 12057 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 115558 | 115558 | 107125 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350X 30TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6x6 | 6004409.0 | 2098396.0 | 37.7420453649399 | -122.427365577216 | (37.7420453649399, -122.427365577216) | |||
| 117052 | 117052 | 12065 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 117183 | 117183 | 12054 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 120398 | 120398 | 12053 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 121136 | 121136 | 12060 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 104 | 104 | 251210 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | |||||||||
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 389 | 389 | 191855 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 49 | Width 6ft | Cal Trans adjacent; 10 ft ROW | 6009921.77605 | 2108434.69103 | 37.7699196037317 | -122.409012217656 | (37.7699196037317, -122.409012217656) | ||
| 4668 | 4668 | 253644 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/05/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 5380 | 5380 | 23543 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2800X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 9 | 6005659.04127 | 2120027.6333 | 37.8015112413055 | -122.424581715282 | (37.8015112413055, -122.424581715282) | |||
| 6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
| 7152 | 7152 | 29781 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 3 | 6006021.95745 | 2117391.75426 | 37.7942942736085 | -122.42313839334601 | (37.7942942736085, -122.423138393346) | |||
| 8259 | 8259 | 23442 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2100X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005990.50725 | 2117651.28863 | 37.795005114851 | -122.42326567258301 | (37.795005114851, -122.423265672583) | |||
| 10299 | 10299 | 1295 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991914.74417 | 2087134.82891 | 37.710410426081 | -122.46974669545901 | (37.710410426081, -122.469746695459) | |||
| 10727 | 10727 | 1298 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991889.9079 | 2087118.85792 | 37.7103651380077 | -122.46983137204599 | (37.7103651380077, -122.469831372046) | |||
| 10785 | 10785 | 1296 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991907.39965 | 2087130.17274 | 37.710397216839496 | -122.46977174067499 | (37.7103972168395, -122.469771740675) | |||
| 10821 | 10821 | 1299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 10 | 5991881.88808 | 2087114.90346 | 37.7103538164401 | -122.46985880224301 | (37.7103538164401, -122.469858802243) | |||
| 11437 | 11437 | 1297 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991899.37983 | 2087126.21827 | 37.7103858952584 | -122.46979917089199 | (37.7103858952584, -122.469799170892) | |||
| 13240 | 13240 | 187608 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13250 | 13250 | 187606 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13251 | 13251 | 187611 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
| 13256 | 13256 | 187607 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13889 | 13889 | 11219 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/1992 12:00:00 AM | 30 | 3X4 | 6018141.66576 | 2094727.81231 | 37.7327403559813 | -122.379627091035 | (37.7327403559813, -122.379627091035) | ||
| 14018 | 14018 | 99640 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000X Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | City Owned Lot | 6015553.4063 | 2089548.4030000002 | 37.7183756251523 | -122.38821408703001 | (37.7183756251523, -122.38821408703) | ||
| 14069 | 14069 | 11218 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X4 | 6018145.287959999 | 2094715.08165 | 37.73270559986911 | -122.379613683941 | (37.7327055998691, -122.379613683941) | |||
| 14285 | 14285 | 11226 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/1992 12:00:00 AM | 35 | 3X4 | 6018091.97554 | 2094860.3210200001 | 37.7331014580651 | -122.379808087687 | (37.7331014580651, -122.379808087687) | ||
| 14426 | 14426 | 4895 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1993 12:00:00 AM | 12 | 3X4 | 6018140.882180001 | 2094365.07214 | 37.7317442992597 | -122.379604608867 | (37.7317442992597, -122.379604608867) | ||
| 14846 | 14846 | 11225 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/1992 12:00:00 AM | 35 | 3X4 | 6018100.6161400005 | 2094835.81488 | 37.733034645636394 | -122.37977651247101 | (37.7330346456364, -122.379776512471) | ||
| 15149 | 15149 | 22069 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2000 12:00:00 AM | 3 | 3X3 | 6015996.14125 | 2101854.73781 | 37.7521908608401 | -122.387541804919 | (37.7521908608401, -122.387541804919) | ||
| 16239 | 16239 | 22065 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016001.4583 | 2101755.32387 | 37.7519181854896 | -122.387516482698 | (37.7519181854896, -122.387516482698) | ||
| 16356 | 16356 | 11215 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6018142.31163 | 2094695.6186 | 37.732651993985705 | -122.37962262229799 | (37.7326519939857, -122.379622622298) | |||
| 16446 | 16446 | 22064 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016002.11901 | 2101736.21307 | 37.751865747830294 | -122.38751286473301 | (37.7518657478303, -122.387512864733) | ||
| 16458 | 16458 | 11221 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X4 | 6018130.45859 | 2094749.06198 | 37.7327980852604 | -122.379667313208 | (37.7327980852604, -122.379667313208) | |||
| 16971 | 16971 | 4468 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1497 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004583.98516 | 2100211.8834700002 | 37.7470412591526 | -122.426889829809 | (37.7470412591526, -122.426889829809) | |||
| 17146 | 17146 | 2013 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002577.1884699995 | 2095292.92439 | 37.7334212632741 | -122.433477690263 | (37.7334212632741, -122.433477690263) | |||
| 17205 | 17205 | 26909 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997629.54091 | 2089680.9775599998 | 37.71773022584279 | -122.45017865014299 | (37.7177302258428, -122.450178650143) | |||
| 17236 | 17236 | 19195 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 150 Sanchez St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6003512.4095 | 2107418.3103 | 37.76676774608121 | -122.431109521045 | (37.7667677460812, -122.431109521045) | |||
| 17237 | 17237 | 26912 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | |||
| 17421 | 17421 | 4245 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4038 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003639.78589 | 2100421.5344700003 | 37.7475634792894 | -122.430169743652 | (37.7475634792894, -122.430169743652) | |||
| 18452 | 18452 | 10752 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 18851 | 18851 | 22861 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 151 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5999939.19286 | 2099172.51002 | 37.7439236657612 | -122.44287645099199 | (37.7439236657612, -122.442876450992) | |||
| 19083 | 19083 | 26913 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997584.35365 | 2089616.43233 | 37.717550413599795 | -122.45033019131 | (37.7175504135998, -122.45033019131) | |||
| 19195 | 19195 | 26910 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997620.43146 | 2089669.0920400003 | 37.7176970696553 | -122.45020928103399 | (37.7176970696553, -122.450209281034) | |||
| 19231 | 19231 | 2011 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002543.1242 | 2095301.43659 | 37.7334427031002 | -122.433596068029 | (37.7334427031002, -122.433596068029) | |||
| 19342 | 19342 | 26905 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997683.40035 | 2089758.8108400002 | 37.7179470200262 | -122.449998089654 | (37.7179470200262, -122.449998089654) | |||
| 19416 | 19416 | 2014 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002609.44021 | 2095285.23051 | 37.733401967419205 | -122.43336563743799 | (37.7334019674192, -122.433365637438) | |||
| 19420 | 19420 | 12067 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1225X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 19538 | 19538 | 16588 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 88X Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X3 | 6002852.6033 | 2107735.26664 | 37.7676006199961 | -122.43341433031401 | (37.7676006199961, -122.433414330314) | |||
| 19568 | 19568 | 26708 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 88X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3 | 6002857.07874 | 2107723.1475299997 | 37.767567597789295 | -122.43339798423 | (37.7675675977893, -122.43339798423) | |||
| 19977 | 19977 | 29369 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002638.340030001 | 2095276.9082799999 | 37.733380755998894 | -122.43326512830099 | (37.7333807559989, -122.433265128301) | ||
| 20093 | 20093 | 2015 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002627.0989 | 2095279.66022 | 37.733387674484604 | -122.433304188563 | (37.7333876744846, -122.433304188563) | |||
| 20209 | 20209 | 4252 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4072 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003430.396430001 | 2100411.11399 | 37.747523005287206 | -122.430893055767 | (37.7475230052872, -122.430893055767) | |||
| 20603 | 20603 | 26906 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997668.873459999 | 2089736.17467 | 37.717884035095295 | -122.450046671911 | (37.7178840350953, -122.450046671911) | |||
| 20904 | 20904 | 12016 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 21291 | 21291 | 2046 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 701X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001912.87216 | 2095420.3332200001 | 37.733733385587 | -122.43578352768299 | (37.733733385587, -122.435783527683) | |||
| 21305 | 21305 | 26908 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997639.65043 | 2089696.09364 | 37.7177723096208 | -122.45014479517 | (37.7177723096208, -122.45014479517) | |||
| 21568 | 21568 | 2012 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002566.51434 | 2095294.967 | 37.7334262662011 | -122.43351473961599 | (37.7334262662011, -122.433514739616) | |||
| 21645 | 21645 | 26907 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997653.71656 | 2089718.57825 | 37.717834852078205 | -122.45009779478701 | (37.7178348520782, -122.450097794787) | |||
| 21793 | 21793 | 29370 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002650.152480001 | 2095274.05972 | 37.733373604614 | -122.433224085933 | (37.733373604614, -122.433224085933) | ||
| 22187 | 22187 | 4461 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1451 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004572.77209 | 2100404.42204 | 37.74756929159079 | -122.42694231424299 | (37.7475692915908, -122.426942314243) | |||
| 22854 | 22854 | 176359 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350x Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6001093.21408 | 2086592.19305 | 37.7094467152559 | -122.437985185864 | (37.7094467152559, -122.437985185864) | |||
| 23224 | 23224 | 4372 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1007 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6000961.422590001 | 2096155.46194 | 37.7356977864326 | -122.439125632357 | (37.7356977864326, -122.439125632357) | |||
| 32359 | 32359 | 191816 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300x De Haro St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012277.20441 | 2102232.55885 | 37.7530215888816 | -122.40042907904899 | (37.7530215888816, -122.400429079049) | ||||
| 33183 | 33183 | 209132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6001073.50305 | 2095703.1639599998 | 37.7344622582302 | -122.438705728106 | (37.7344622582302, -122.438705728106) | |||
| 35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
| 37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
| 38339 | 38339 | 8592 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 41196 | 41196 | 209133 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6001054.84945 | 2095714.1457200001 | 37.734491350384005 | -122.43877100628 | (37.734491350384, -122.43877100628) | ||||
| 44401 | 44401 | 126600 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1820x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006102.71241 | 2116870.57968 | 37.7928678157445 | -122.42282191472201 | (37.7928678157445, -122.422821914722) | ||||
| 47273 | 47273 | 10756 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 49627 | 49627 | 4480 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004537.43405 | 2099923.54921 | 37.7462469275435 | -122.427030266568 | (37.7462469275435, -122.427030266568) | |||
| 50215 | 50215 | 209138 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000918.34106 | 2095790.55513 | 37.7346933857729 | -122.439248434772 | (37.7346933857729, -122.439248434772) | ||||
| 50311 | 50311 | 209137 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000977.0463 | 2095762.1119400002 | 37.734618627848796 | -122.43904343343 | (37.7346186278488, -122.43904343343) | ||||
| 58168 | 58168 | 209136 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6000997.1554 | 2095746.93377 | 37.7345780962937 | -122.438972822257 | (37.7345780962937, -122.438972822257) | ||||
| 59293 | 59293 | 209131 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 10ft | 6001087.056530001 | 2095697.8346 | 37.734448396084396 | -122.43865848761699 | (37.7344483960844, -122.438658487617) | |||
| 67936 | 67936 | 209179 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 255x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993078.87861 | 2100249.74193 | 37.7464879656554 | -122.46667592616998 | (37.7464879656554, -122.46667592617) | |||
| 72160 | 72160 | 10810 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6017615.78501 | 2094776.3050099998 | 37.7328444878546 | -122.38144858171499 | (37.7328444878546, -122.381448581715) |
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");