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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 1502 | 1502 | 223929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 610 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001216.05485 | 2100901.84413 | 37.748744719898 | -122.43858524950599 | (37.748744719898, -122.438585249506) | |
| 1567 | 1567 | 251594 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1574 | 1574 | 251596 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1583 | 1583 | 251593 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1592 | 1592 | 251595 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1985 | 1985 | 252841 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163.0 | 2111730.0 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | |||
| 4251 | 4251 | 246122 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1518 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | Permit Number 46036 | 5998379.9097 | 2108286.3815 | 37.768859073318 | -122.448924438468 | (37.768859073318, -122.448924438468) | ||
| 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) | ||
| 4764 | 4764 | 253679 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 94 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x8 | 5997405.0 | 2099153.0 | 37.7437252916895 | -122.45163765514201 | (37.7437252916895, -122.451637655142) | ||||
| 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) | |||
| 5531 | 5531 | 7687 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 521 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008787.0132 | 2121079.8095 | 37.8045764073538 | -122.413831954826 | (37.8045764073538, -122.413831954826) | |||
| 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) | |||
| 8274 | 8274 | 41820 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.683999999 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | |
| 9470 | 9470 | 105079 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3770 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
| 9972 | 9972 | 173766 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9974 | 9974 | 173765 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9975 | 9975 | 173768 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9976 | 9976 | 173769 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9978 | 9978 | 173767 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 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) | |||
| 11387 | 11387 | 104350 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 349 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999840.77458 | 2086361.4281900001 | 37.708741782568104 | -122.44229725703 | (37.7087417825681, -122.44229725703) | |||
| 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) | |||
| 11531 | 11531 | 43168 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) |
| 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) | ||
| 12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
| 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) | ||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 13735 | 13735 | 22066 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 14 | 3X3 | 6015999.04813 | 2101774.12278 | 37.751969669865396 | -122.387526128851 | (37.7519696698654, -122.387526128851) | ||
| 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) | ||
| 14844 | 14844 | 12128 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1400X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016480.84106 | 2095117.09347 | 37.73371749994771 | -122.385396148429 | (37.7337174999477, -122.385396148429) | |||
| 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) | ||
| 15438 | 15438 | 104819 | Planning Code 138.1 required 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | |
| 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) | |||
| 17255 | 17255 | 32525 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 864 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1996 12:00:00 AM | 14 | 3x3 | Permit Number 37027 | 6007539.30835 | 2095267.7389900002 | 37.7336323917164 | -122.41632041617399 | (37.7336323917164, -122.416320416174) | |
| 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) | |||
| 17710 | 17710 | 4470 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1500 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004528.8343 | 2100105.60966 | 37.746746337268206 | -122.42707296863999 | (37.7467463372682, -122.42707296864) | |||
| 17771 | 17771 | 16032 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 155 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993339.50797 | 2095294.7939400002 | 37.7328979594755 | -122.465414825734 | (37.7328979594755, -122.465414825734) | |||
| 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) | |||
| 18999 | 18999 | 4466 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1484 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004525.42539 | 2100206.65772 | 37.747023599154204 | -122.427091952431 | (37.7470235991542, -122.427091952431) | |||
| 19052 | 19052 | 22819 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 61 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X2 | 10/31/08 | 5999145.766480001 | 2099274.26515 | 37.7441577943622 | -122.445627242426 | (37.7441577943622, -122.445627242426) | ||
| 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) | |||
| 19220 | 19220 | 4482 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004606.71516 | 2099825.83197 | 37.7459825358766 | -122.426783743093 | (37.7459825358766, -122.426783743093) | |||
| 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) | |||
| 19560 | 19560 | 103375 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 22 VANDEWATER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Permit Number 770057 | 6009069.0 | 2121391.0 | 37.8054466905223 | -122.41287812458401 | (37.8054466905223, -122.412878124584) | ||||
| 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) | ||
| 21257 | 21257 | 4479 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004543.28364 | 2099929.0819200003 | 37.7462624498637 | -122.427010433384 | (37.7462624498637, -122.427010433384) | |||
| 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) | |||
| 22882 | 22882 | 176369 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.47481676917101 | (37.7159609464097, -122.474816769171) | ||||
| 22909 | 22909 | 209066 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993360.06028 | 2094684.7320599998 | 37.7312240657298 | -122.46529947329901 | (37.7312240657298, -122.465299473299) | |||
| 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) | |||
| 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) | |
| 23439 | 23439 | 209167 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 102 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5992842.6234800005 | 2095968.7682299998 | 37.7347198555328 | -122.46718165450599 | (37.7347198555328, -122.467181654506) | |||
| 23593 | 23593 | 140908 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2313 Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000568.9025 | 2113347.1332 | 37.782879558173 | -122.44171612920601 | (37.782879558173, -122.441716129206) | |||
| 23691 | 23691 | 126591 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2547 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002516.512 | 2116417.22855 | 37.7914200340546 | -122.435197883791 | (37.7914200340546, -122.435197883791) | |||
| 23872 | 23872 | 191975 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017399.67227 | 2095082.1979 | 37.7336724754063 | -122.38221701890801 | (37.7336724754063, -122.382217018908) |
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");