Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 1568 | 1568 | 251592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6007220.0 | 2119146.0 | 37.799178528828 | -122.41911751038602 | (37.799178528828, -122.419117510386) | |||
| 1777 | 1777 | 251693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1783 | 1783 | 251690 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1786 | 1786 | 251694 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 2659 | 2659 | 253154 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | ||||
| 9981 | 9981 | 56353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1973 12:00:00 AM | 5x5 | Permit Number 12495 | 6002706.41661255 | 2104989.75216117 | 37.7600538090993 | -122.43372372180401 | (37.7600538090993, -122.433723721804) | ||
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 20234 | 20234 | 218897 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1285 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 5993290.82714 | 2106725.73936 | 37.7642816090429 | -122.46641363171001 | (37.7642816090429, -122.46641363171) | ||||
| 63660 | 63660 | 109514 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501x FULTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000537.0 | 2110949.0 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | ||||
| 76821 | 76821 | 104835 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4595-4599 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000476.0 | 2105174.0 | 37.760432895524204 | -122.441450863046 | (37.7604328955242, -122.441450863046) | ||||
| 81295 | 81295 | 103032 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769938 | 6014508.3 | 2114897.4 | 37.787920602156 | -122.39359978571501 | (37.787920602156, -122.393599785715) | ||||
| 81879 | 81879 | 67061 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3751 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1992 12:00:00 AM | Permit Number 30442 | 6004747.16045801 | 2102483.32750571 | 37.753287342753204 | -122.42648729345801 | (37.7532873427532, -122.426487293458) | |||
| 83186 | 83186 | 59495 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | Permit Number 18870 | 6005949.30607357 | 2106651.86371307 | 37.764801053792894 | -122.422626220724 | (37.7648010537929, -122.422626220724) | |||
| 84506 | 84506 | 97098 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1096 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008668.0 | 2115966.0 | 37.7905284677514 | -122.41388184826499 | (37.7905284677514, -122.413881848265) | ||||
| 84957 | 84957 | 59971 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1982 12:00:00 AM | Permit Number 770164 | 6008622.11827174 | 2103000.09497074 | 37.7549245619495 | -122.41312338476601 | (37.7549245619495, -122.413123384766) | |||
| 85231 | 85231 | 104439 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200X Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004765.42963 | 2102220.02594 | 37.752565410803705 | -122.42640536894599 | (37.7525654108037, -122.426405368946) | ||||
| 89715 | 89715 | 97616 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 91106 | 91106 | 60170 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3530 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1982 12:00:00 AM | Permit Number 19739 | 6006073.64013371 | 2104949.4412081 | 37.760133615666206 | -122.4220752293 | (37.7601336156662, -122.4220752293) | ||
| 95852 | 95852 | 55438 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2179 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 3x3 | Permit Number 11386 | 6003157.5538321 | 2107090.38264344 | 37.7658472217414 | -122.43231348373301 | (37.7658472217414, -122.432313483733) | ||
| 96314 | 96314 | 97091 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2756@Vallejo Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002132.0 | 2117587.0 | 37.794610081367296 | -122.436612052598 | (37.7946100813673, -122.436612052598) | ||||
| 96479 | 96479 | 97624 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 97441 | 97441 | 99314 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 690X 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 12 | 5993197.5 | 2110786.1 | 37.775424893941796 | -122.46703164043001 | (37.7754248939418, -122.46703164043) | |||
| 98690 | 98690 | 97623 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 98713 | 98713 | 100010 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | ||||
| 99528 | 99528 | 100854 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 496X Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769289 | 6003126.9 | 2103316.7 | 37.755483858187105 | -122.43214999240101 | (37.7554838581871, -122.432149992401) | |||
| 99846 | 99846 | 97621 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 100499 | 100499 | 97662 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1909 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2011 12:00:00 AM | 5x6 | Permit Number 768299 | 5999946.0 | 2115458.0 | 37.7886399393615 | -122.44402282420499 | (37.7886399393615, -122.444022824205) | ||
| 100617 | 100617 | 98031 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 493 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003709.9 | 2105435.7 | 37.7613351647369 | -122.430284971477 | (37.7613351647369, -122.430284971477) | ||||
| 100741 | 100741 | 97102 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1096@Jones Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008668.0 | 2115966.0 | 37.7905284677514 | -122.41388184826499 | (37.7905284677514, -122.413881848265) | ||||
| 101618 | 101618 | 57859 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 243 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16802 | 6008653.70601919 | 2097500.21669417 | 37.7398248927239 | -122.412625369635 | (37.7398248927239, -122.412625369635) | |||
| 101930 | 101930 | 104442 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200X Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004765.42963 | 2102220.02594 | 37.752565410803705 | -122.42640536894599 | (37.7525654108037, -122.426405368946) | ||||
| 102005 | 102005 | 103030 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769938 | 6014508.3 | 2114897.4 | 37.787920602156 | -122.39359978571501 | (37.787920602156, -122.393599785715) | ||||
| 102444 | 102444 | 100852 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1043-1049 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6003181.0 | 2102169.0 | 37.7523356131155 | -122.431880952183 | (37.7523356131155, -122.431880952183) | ||||
| 105782 | 105782 | 58316 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501-1519X 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1978 12:00:00 AM | Permit Number 17339 | 6007402.0 | 2107334.0 | 37.7667558904507 | -122.41765006763599 | (37.7667558904507, -122.417650067636) | |||
| 106243 | 106243 | 101891 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 196X Wool St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 21188 | 6007299.5 | 2097331.3 | 37.739284988220795 | -122.41729568877899 | (37.7392849882208, -122.417295688779) | ||||
| 108594 | 108594 | 104695 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067.0 | 37.7551089013639 | -122.41308909976601 | (37.7551089013639, -122.413089099766) | |||
| 108961 | 108961 | 113238 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006612.86147234 | 2106740.75991177 | 37.7650825555261 | -122.420337459951 | (37.7650825555261, -122.420337459951) | |||||
| 109682 | 109682 | 96930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 649 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2011 12:00:00 AM | 3x3 | Permit Number 768122 | 6009413.8 | 2111202.0 | 37.7774895185086 | -122.410964788592 | (37.7774895185086, -122.410964788592) | ||
| 114436 | 114436 | 97092 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2756@Vallejo Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002132.0 | 2117587.0 | 37.794610081367296 | -122.436612052598 | (37.7946100813673, -122.436612052598) | ||||
| 114802 | 114802 | 97094 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2756@Vallejo Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002132.0 | 2117587.0 | 37.794610081367296 | -122.436612052598 | (37.7946100813673, -122.436612052598) | ||||
| 115323 | 115323 | 55731 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1973 12:00:00 AM | 6x6 | Permit Number 11757 | 6002704.74665442 | 2107117.26012075 | 37.7658953354732 | -122.433881568302 | (37.7658953354732, -122.433881568302) | ||
| 115392 | 115392 | 104839 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 116863 | 116863 | 103956 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4263-4265 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000811.0 | 2102861.0 | 37.7541010401035 | -122.44012639143 | (37.7541010401035, -122.44012639143) | ||||
| 117267 | 117267 | 104840 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 117420 | 117420 | 97620 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 117443 | 117443 | 118688 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4645 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5981105.94918 | 2110928.3269599997 | 37.7751100630106 | -122.508868980798 | (37.7751100630106, -122.508868980798) | ||||
| 118152 | 118152 | 104836 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 118588 | 118588 | 58851 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 615 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/1979 12:00:00 AM | 3x3 | Permit Number 18110 | 6008337.394024299 | 2114564.58255444 | 37.7866619441951 | -122.414926498345 | (37.7866619441951, -122.414926498345) | ||
| 120458 | 120458 | 104441 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200X Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004765.42963 | 2102220.02594 | 37.752565410803705 | -122.42640536894599 | (37.7525654108037, -122.426405368946) | ||||
| 121220 | 121220 | 103033 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300X Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769938 | 6014508.3 | 2114897.4 | 37.787920602156 | -122.39359978571501 | (37.787920602156, -122.393599785715) | ||||
| 121408 | 121408 | 51678 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 672 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | Permit Number 770377 | 6007616.9101817 | 2096263.07678619 | 37.7363697350759 | -122.41612259019199 | (37.7363697350759, -122.416122590192) | |||
| 124607 | 124607 | 98029 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 493 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003709.9 | 2105435.7 | 37.7613351647369 | -122.430284971477 | (37.7613351647369, -122.430284971477) | ||||
| 124680 | 124680 | 97622 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 124781 | 124781 | 100851 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1043-1049 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6003181.0 | 2102169.0 | 37.7523356131155 | -122.431880952183 | (37.7523356131155, -122.431880952183) | ||||
| 124896 | 124896 | 97093 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2756@Vallejo Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002132.0 | 2117587.0 | 37.794610081367296 | -122.436612052598 | (37.7946100813673, -122.436612052598) | ||||
| 125082 | 125082 | 57294 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | Permit Number 16115 | 6006612.86147234 | 2106740.75991177 | 37.7650825555261 | -122.420337459951 | (37.7650825555261, -122.420337459951) | |||
| 127157 | 127157 | 104696 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067.0 | 37.7551089013639 | -122.41308909976601 | (37.7551089013639, -122.413089099766) | |||
| 127537 | 127537 | 105037 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770444 | 6001403.1 | 2096820.4 | 37.7375486740807 | -122.437646191192 | (37.7375486740807, -122.437646191192) | |||
| 127757 | 127757 | 98030 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 493 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003709.9 | 2105435.7 | 37.7613351647369 | -122.430284971477 | (37.7613351647369, -122.430284971477) | ||||
| 128170 | 128170 | 102885 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007175.0 | 2106758.0 | 37.765161553341606 | -122.41839437881399 | (37.7651615533416, -122.418394378814) | ||||
| 129041 | 129041 | 103031 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769938 | 6014508.3 | 2114897.4 | 37.787920602156 | -122.39359978571501 | (37.787920602156, -122.393599785715) | ||||
| 129191 | 129191 | 102882 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2886-2888 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 21288 | 6007521.0 | 2106777.0 | 37.765233194266 | -122.41719899188 | (37.765233194266, -122.41719899188) | ||||
| 142294 | 142294 | 100853 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 490X Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6003181.0 | 2102169.0 | 37.7523356131155 | -122.431880952183 | (37.7523356131155, -122.431880952183) | ||||
| 142381 | 142381 | 98028 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3888-3896 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003694.0 | 2105395.0 | 37.7612225116628 | -122.430337058991 | (37.7612225116628, -122.430337058991) | ||||
| 142928 | 142928 | 57439 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4401 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1976 12:00:00 AM | Permit Number 16282 | 6001390.76806136 | 2105222.86680343 | 37.760619143431896 | -122.438290610369 | (37.7606191434319, -122.438290610369) | |||
| 143505 | 143505 | 104838 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770743 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | |||
| 144715 | 144715 | 104837 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 146313 | 146313 | 101838 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3815-3817 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003483.0 | 2105926.0 | 37.762668556023996 | -122.43110471906799 | (37.762668556024, -122.431104719068) | |||||
| 16214 | 16214 | 15280 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1551 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6007333.49611 | 2109742.48343 | 37.7733651619099 | -122.418057773243 | (37.7733651619099, -122.418057773243) | |||
| 23640 | 23640 | 218911 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Laguna Honda Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995731.43182 | 2099885.12493 | 37.745639539837605 | -122.457477374284 | (37.7456395398376, -122.457477374284) | |||
| 34131 | 34131 | 123093 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 619 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992509.288919999 | 2111212.18975 | 37.776555073530396 | -122.46944332614099 | (37.7765550735304, -122.469443326141) | |||
| 36289 | 36289 | 92948 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3754 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2014 12:00:00 AM | 1 | Permit Number 771810 | 5996901.846390001 | 2115031.16705 | 37.7872938464806 | -122.45452423719699 | (37.7872938464806, -122.454524237197) | ||
| 46864 | 46864 | 218910 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995736.44002 | 2099882.18046 | 37.7456317427251 | -122.457459843802 | (37.7456317427251, -122.457459843802) | |||
| 69018 | 69018 | 218890 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 434 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993124.01114 | 2105981.91795 | 37.762229643904206 | -122.46693651730699 | (37.7622296439042, -122.466936517307) | |||
| 158941 | 158941 | 224848 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3087 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006285.38222 | 2106667.40678 | 37.76486268617621 | -122.421464922278 | (37.7648626861762, -122.421464922278) | |||
| 176593 | 176593 | 84231 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 178 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988065.203290001 | 2114809.31405 | 37.786173930503104 | -122.48508048983 | (37.7861739305031, -122.48508048983) | ||
| 184951 | 184951 | 246679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005202.46496 | 2097607.42576 | 37.739924962478796 | -122.42456594386101 | (37.7399249624788, -122.424565943861) | |||
| 186218 | 186218 | 190267 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6014731.82819 | 2116284.5770799997 | 37.7917418879363 | -122.39292350272801 | (37.7917418879363, -122.392923502728) | |||
| 4314 | 4314 | 100306 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1434 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769213 | 6008902.154180001 | 2117844.1551 | 37.795698569500104 | -122.413204553065 | (37.7956985695001, -122.413204553065) | |
| 23378 | 23378 | 126645 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3001 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001436.68729 | 2118800.8823700002 | 37.79790354707521 | -122.439104960548 | (37.7979035470752, -122.439104960548) | |||
| 27270 | 27270 | 126949 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3439 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998374.58367 | 2115190.1998 | 37.787814864221204 | -122.449440363388 | (37.7878148642212, -122.449440363388) | |||
| 28844 | 28844 | 128476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013054.34541 | 2116659.1488799998 | 37.792677054245296 | -122.398753923573 | (37.7926770542453, -122.398753923573) | |||
| 45695 | 45695 | 189605 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 215 Clara St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011774.59908 | 2111718.41989 | 37.7790395872403 | -122.40283428260099 | (37.7790395872403, -122.402834282601) | |||
| 49215 | 49215 | 192017 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 477 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013661.1963 | 2111441.45458 | 37.7783842638605 | -122.39628831617901 | (37.7783842638605, -122.396288316179) | |||
| 53018 | 53018 | 128375 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 737 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6010401.69926 | 2116151.41193 | 37.7911347772081 | -122.407896406291 | (37.7911347772081, -122.407896406291) | |||
| 53753 | 53753 | 128467 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 339 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012650.63962 | 2116819.58835 | 37.793095081631606 | -122.40016204337 | (37.7930950816316, -122.40016204337) | |||
| 59230 | 59230 | 128769 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 77 Maiden Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6011283.26815 | 2115081.84523 | 37.7882473167144 | -122.40477085840901 | (37.7882473167144, -122.404770858409) | |||
| 61330 | 61330 | 128549 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011550.6903800005 | 2116729.89138 | 37.7927874028707 | -122.403961638521 | (37.7927874028707, -122.403961638521) | |||
| 61824 | 61824 | 128478 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013058.01462 | 2116623.82099 | 37.7925802566268 | -122.398738747488 | (37.7925802566268, -122.398738747488) | |||
| 61852 | 61852 | 127255 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2651 Pierce St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6001599.28415 | 2117567.5021900004 | 37.794526258221396 | -122.43845391703199 | (37.7945262582214, -122.438453917032) | |||
| 63948 | 63948 | 59946 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 670 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1981 12:00:00 AM | 2 | Permit Number 19420 | 6012595.89432 | 2114020.0714 | 37.785405213512796 | -122.40015476333299 | (37.7854052135128, -122.400154763333) | ||
| 69542 | 69542 | 128075 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111 North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009525.60238 | 2121869.5076099997 | 37.806786171612 | -122.411331809333 | (37.806786171612, -122.411331809333) | |||
| 72249 | 72249 | 127256 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2651 Pierce St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6001600.43669 | 2117558.08465 | 37.7945004656696 | -122.438449254053 | (37.7945004656696, -122.438449254053) | |||
| 72759 | 72759 | 128479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013060.804380001 | 2116606.9178400002 | 37.792533999997296 | -122.39872790798599 | (37.7925339999973, -122.398727907986) | |||
| 129586 | 129586 | 190247 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012252.79605 | 2115009.77228 | 37.7881035636755 | -122.40141136625 | (37.7881035636755, -122.40141136625) | |||
| 129976 | 129976 | 190266 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 118 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014977.648630001 | 2116290.90122 | 37.7917729037345 | -122.39207340059299 | (37.7917729037345, -122.392073400593) | |||
| 132284 | 132284 | 126948 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3439 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998366.75607 | 2115188.54408 | 37.7878098702797 | -122.449467325951 | (37.7878098702797, -122.449467325951) |
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");