Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6021 | 6021 | 11047 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1563 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6007413.09908 | 2117743.8873400004 | 37.7953395502211 | -122.41834985148 | (37.7953395502211, -122.41834985148) | |||
| 6046 | 6046 | 69534 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2471 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38589 | 6002877.05945 | 2116466.93377 | 37.7915769792578 | -122.433953952308 | (37.7915769792578, -122.433953952308) | |
| 6094 | 6094 | 11092 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1913 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 5x5 | 6007257.74663 | 2118885.66933 | 37.7984658517671 | -122.41896841955099 | (37.7984658517671, -122.418968419551) | |||
| 6113 | 6113 | 106866 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1892 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6003972.43426 | 2118715.7250900003 | 37.7978136859103 | -122.430324481915 | (37.7978136859103, -122.430324481915) | |||
| 6114 | 6114 | 18942 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2788 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001482.36653 | 2115669.03687 | 37.789306914141704 | -122.43872236373998 | (37.7893069141417, -122.43872236374) | |||
| 6178 | 6178 | 11083 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1853 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007278.4685 | 2118708.01787 | 37.7979792322209 | -122.41888410901001 | (37.7979792322209, -122.41888410901) | |||
| 6208 | 6208 | 11051 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1601 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007396.80616 | 2117887.0680299997 | 37.7957317715643 | -122.418416385103 | (37.7957317715643, -122.418416385103) | |||
| 6211 | 6211 | 106217 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x5 | 6010670.9358 | 2115847.8332700003 | 37.790316292506795 | -122.40694344599301 | (37.7903162925068, -122.406943445993) | |||
| 6246 | 6246 | 44214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2296 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 7 | 3x3 | Permit Number 43661 | 6002622.65854 | 2117834.05168 | 37.7953162919605 | -122.434931989341 | (37.7953162919605, -122.434931989341) | |
| 6250 | 6250 | 92077 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1151 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775152 | 6007038.57451 | 2114995.4175 | 37.7877718433296 | -122.41945068732201 | (37.7877718433296, -122.419450687322) | |
| 6266 | 6266 | 11079 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1827 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007292.79546 | 2118623.6274900003 | 37.7977483240791 | -122.41882854531 | (37.7977483240791, -122.41882854531) | |||
| 6483 | 6483 | 23497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2529 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | |||
| 6487 | 6487 | 27264 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1735 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6006104.02915 | 2116478.43214 | 37.791791150977105 | -122.422789477077 | (37.7917911509771, -122.422789477077) | |||
| 6494 | 6494 | 7364 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002779.17574 | 2116404.82668 | 37.7914008937989 | -122.43428818627198 | (37.7914008937989, -122.434288186272) | |||
| 6581 | 6581 | 18689 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 210 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999128.28109 | 2119816.58855 | 37.800560783808706 | -122.44716580436899 | (37.8005607838087, -122.447165804369) | |||
| 6604 | 6604 | 105538 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2098X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 10x7 | 6003015.95136 | 2119274.793 | 37.7992945167788 | -122.43367415343398 | (37.7992945167788, -122.433674153434) | |||
| 6618 | 6618 | 11039 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1530 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007477.10012 | 2117617.5169599997 | 37.7949961710995 | -122.418119433479 | (37.7949961710995, -122.418119433479) | |||
| 6742 | 6742 | 11038 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1520 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007480.78096 | 2117584.84386 | 37.7949066660644 | -122.41810437973801 | (37.7949066660644, -122.418104379738) | |||
| 6822 | 6822 | 93476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Tree 1 on Leroy. | 6008309.35619 | 2116677.55783 | 37.79246208300879 | -122.41517312764499 | (37.7924620830088, -122.415173127645) | ||
| 6842 | 6842 | 18517 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010074.04531 | 2116083.22982 | 37.7909292164576 | -122.409025270411 | (37.7909292164576, -122.409025270411) | |||
| 6857 | 6857 | 18904 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002312.77813 | 2115782.03277 | 37.789664378452 | -122.435857329676 | (37.789664378452, -122.435857329676) | |||
| 6858 | 6858 | 11115 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2044 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007228.08245 | 2119404.68115 | 37.799889257353705 | -122.419107900836 | (37.7998892573537, -122.419107900836) | |||
| 6866 | 6866 | 11041 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1535 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007427.37776 | 2117642.45986 | 37.7950618593598 | -122.418293249932 | (37.7950618593598, -122.418293249932) | |||
| 6868 | 6868 | 88774 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001246.21661 | 2117291.33076 | 37.79374787431421 | -122.43965576381399 | (37.7937478743142, -122.439655763814) | |
| 6882 | 6882 | 11093 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1920 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007292.220869999 | 2118935.81145 | 37.7986054706223 | -122.41885268582199 | (37.7986054706223, -122.418852685822) | |||
| 6920 | 6920 | 11030 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1456 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007504.98953 | 2117411.4555 | 37.7944319472334 | -122.418008316826 | (37.7944319472334, -122.418008316826) | |||
| 6965 | 6965 | 45818 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2260 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 773615 | 6003397.29034 | 2116914.4207200003 | 37.7928351730475 | -122.43218593195499 | (37.7928351730475, -122.432185931955) | ||
| 7044 | 7044 | 115410 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2025 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5999874.89435 | 2115932.55527 | 37.7899388875113 | -122.444302954718 | (37.7899388875113, -122.444302954718) | |||
| 7046 | 7046 | 23478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2415 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6x6 | 6005787.44434 | 2118746.70558 | 37.798001390610104 | -122.424046238267 | (37.7980013906101, -122.424046238267) | |||
| 7049 | 7049 | 11022 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1414 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6007530.75353 | 2117243.19197 | 37.793971387332704 | -122.417907236642 | (37.7939713873327, -122.417907236642) | |||
| 7200 | 7200 | 11029 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007510.83027 | 2117372.9611299997 | 37.7943265799737 | -122.417985376942 | (37.7943265799737, -122.417985376942) | |||
| 7315 | 7315 | 93472 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1329 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x2 | 6008412.15519 | 2116591.32221 | 37.7922310777524 | -122.414811333085 | (37.7922310777524, -122.414811333085) | |||
| 7383 | 7383 | 11062 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007399.48222 | 2118181.2662299997 | 37.796539717095 | -122.418427996257 | (37.796539717095, -122.418427996257) | |||
| 7416 | 7416 | 106674 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 399 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | 4x6 | Permit Number 773354 | 5998100.3376400005 | 2115239.0542599997 | 37.787933313904 | -122.450392722053 | (37.787933313904, -122.450392722053) | |
| 7426 | 7426 | 113070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3108 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002434.36436 | 2118927.2467400003 | 37.7983072284463 | -122.435661765772 | (37.7983072284463, -122.435661765772) | |||
| 7431 | 7431 | 11084 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1861 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007276.02636 | 2118733.9286 | 37.7980502390811 | -122.41889439817899 | (37.7980502390811, -122.418894398179) | |||
| 7491 | 7491 | 11081 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1844 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007326.98106 | 2118697.88229 | 37.7979541339441 | -122.418715522107 | (37.7979541339441, -122.418715522107) | |||
| 7492 | 7492 | 110964 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2461 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002930.46719 | 2116476.98281 | 37.7916076020582 | -122.43376988089899 | (37.7916076020582, -122.433769880899) | |||
| 7505 | 7505 | 11073 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1800 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007352.3421 | 2118515.8500200002 | 37.797455746746 | -122.418614850203 | (37.797455746746, -122.418614850203) | |||
| 7546 | 7546 | 7345 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2201 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1995 12:00:00 AM | 20 | 3x3 | 6002814.8619099995 | 2115881.6003099997 | 37.789966273667396 | -122.434127293036 | (37.7899662736674, -122.434127293036) | ||
| 7640 | 7640 | 11018 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007538.39019 | 2117184.37476 | 37.793810319634396 | -122.417876641695 | (37.7938103196344, -122.417876641695) | |||
| 7646 | 7646 | 120112 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2602 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6001610.3249699995 | 2116996.65392 | 37.7929594854561 | -122.43837479737499 | (37.7929594854561, -122.438374797375) | |||
| 7648 | 7648 | 100475 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009838.89839 | 2114609.02446 | 37.786868227930604 | -122.40973477074101 | (37.7868682279306, -122.409734770741) | |||
| 7704 | 7704 | 23562 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2935 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005556.47012 | 2120448.2319400003 | 37.8026603041809 | -122.42496659992202 | (37.8026603041809, -122.424966599922) | |||
| 7758 | 7758 | 107629 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2166 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001500.40723 | 2119762.44668 | 37.80054737492579 | -122.438953418459 | (37.8005473749258, -122.438953418459) | |||
| 7832 | 7832 | 7341 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2133 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002836.01293 | 2115704.12201 | 37.7894801640146 | -122.434041420394 | (37.7894801640146, -122.434041420394) | |||
| 7844 | 7844 | 23431 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1946 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006104.866909999 | 2117188.27203 | 37.7937402408798 | -122.42283704849301 | (37.7937402408798, -122.422837048493) | |||
| 7892 | 7892 | 18840 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2085 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6004805.00638 | 2116081.2171099996 | 37.790627119781796 | -122.42725578824499 | (37.7906271197818, -122.427255788245) | |||
| 7915 | 7915 | 11104 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2000 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007257.36758 | 2119194.77806 | 37.7993145653706 | -122.41899166703699 | (37.7993145653706, -122.418991667037) | |||
| 7916 | 7916 | 63582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 7 | 3x3 | Permit Number 24205 | 6006460.0817 | 2118715.02595 | 37.797952359573 | -122.42171646446998 | (37.797952359573, -122.42171646447) |
| 7955 | 7955 | 2559 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010139.86522 | 2115942.29028 | 37.790545917314795 | -122.40878758770201 | (37.7905459173148, -122.408787587702) | |||
| 7986 | 7986 | 7370 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2420 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002758.068969999 | 2116587.9502 | 37.7919025059375 | -122.434374313431 | (37.7919025059375, -122.434374313431) | |||
| 7999 | 7999 | 11096 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1930 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007282.759740001 | 2119000.94501 | 37.798783778305996 | -122.41889004634899 | (37.798783778306, -122.418890046349) | |||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 8011 | 8011 | 9691 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005982.01492 | 2110919.04398 | 37.776519554674294 | -122.422816374886 | (37.7765195546743, -122.422816374886) | |||
| 8014 | 8014 | 99179 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008592.55792 | 2122139.39153 | 37.8074748301781 | -122.414579914146 | (37.8074748301781, -122.414579914146) | |||
| 8053 | 8053 | 11067 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1730 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007383.1618099995 | 2118299.02577 | 37.7968621366329 | -122.418492822987 | (37.7968621366329, -122.418492822987) | |||
| 8123 | 8123 | 11118 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 7x12 | 6007213.8429 | 2119532.44037 | 37.8002392501056 | -122.41916624254601 | (37.8002392501056, -122.419166242546) | |||
| 8188 | 8188 | 27267 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006065.34389 | 2117477.40357 | 37.7945318933823 | -122.42299436150299 | (37.7945318933823, -122.422994361503) | |||
| 8190 | 8190 | 9928 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2209 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005049.699109999 | 2117255.6880200002 | 37.7938657556467 | -122.426492827679 | (37.7938657556467, -122.426492827679) | |||
| 8210 | 8210 | 11069 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1749 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007331.60738 | 2118350.79827 | 37.797001388548296 | -122.41867488715499 | (37.7970013885483, -122.418674887155) | |||
| 8211 | 8211 | 11042 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007470.84511 | 2117656.01984 | 37.7951015383692 | -122.41814380780501 | (37.7951015383692, -122.418143807805) | |||
| 8238 | 8238 | 52038 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3735 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777497 | 5996952.62983 | 2115319.66476 | 37.7880888966189 | -122.45436938564899 | (37.7880888966189, -122.454369385649) | ||
| 8298 | 8298 | 99117 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 480 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6011185.797590001 | 2119018.9032900003 | 37.799052083852295 | -122.40538546587901 | (37.7990520838523, -122.405385465879) | |||
| 8307 | 8307 | 101022 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1979 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003568.32546 | 2118610.54777 | 37.7975019979781 | -122.431715296927 | (37.7975019979781, -122.431715296927) | |||
| 8312 | 8312 | 23512 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2645 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005692.662819999 | 2119431.12255 | 37.7998752737922 | -122.424422916606 | (37.7998752737922, -122.424422916606) | |||
| 8336 | 8336 | 7987 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2123 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005516.51902 | 2117364.58787 | 37.7941911456586 | -122.424885336313 | (37.7941911456586, -122.424885336313) | |||
| 8367 | 8367 | 11026 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1435 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6007476.45198 | 2117303.69577 | 37.794134459589706 | -122.418099417266 | (37.7941344595897, -122.418099417266) | |||
| 8378 | 8378 | 11035 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1516 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007484.17478 | 2117558.36602 | 37.794834155515396 | -122.418090758582 | (37.7948341555154, -122.418090758582) | |||
| 8383 | 8383 | 7343 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2195 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002825.78223 | 2115774.95026 | 37.7896740596703 | -122.43408188267999 | (37.7896740596703, -122.43408188268) | |||
| 8413 | 8413 | 11074 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1801 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6007304.558569999 | 2118539.88123 | 37.7975190401383 | -122.418781899279 | (37.7975190401383, -122.418781899279) | |||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 8531 | 8531 | 103932 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1935 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 7x9 | 6003485.19153 | 2119295.34788 | 37.79937756918579 | -122.432051888901 | (37.7993775691858, -122.432051888901) | |||
| 8559 | 8559 | 18852 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6004015.42398 | 2116022.3127099997 | 37.7904206984174 | -122.42998349495701 | (37.7904206984174, -122.429983494957) | |||
| 8577 | 8577 | 11027 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1441 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | owner Victor Seeto signed agreement 3/10/10 to maintain bricks in tree basin in a safe/accessible manner that does not damage tree or restrict growth. | 6007472.87331 | 2117336.51186 | 37.7942243630038 | -122.418114127466 | (37.7942243630038, -122.418114127466) | ||
| 8598 | 8598 | 100530 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1434 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6008903.531140001 | 2117829.38309 | 37.7956580864982 | -122.413198743428 | (37.7956580864982, -122.413198743428) | ||||
| 8604 | 8604 | 101074 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1969 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003610.72225 | 2118616.0414400003 | 37.797519485292604 | -122.431568985315 | (37.7975194852926, -122.431568985315) | |||
| 8605 | 8605 | 11123 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2112 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007201.8852 | 2119594.93778 | 37.8004101788341 | -122.419212056698 | (37.8004101788341, -122.419212056698) | |||
| 8621 | 8621 | 7342 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2142 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6002873.64296 | 2115779.16456 | 37.7896883471937 | -122.433916590893 | (37.7896883471937, -122.433916590893) | ||
| 8623 | 8623 | 93473 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008345.85317 | 2116585.5339599997 | 37.792211459052794 | -122.415040330141 | (37.7922114590528, -122.415040330141) | |||
| 8640 | 8640 | 18514 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 634 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010129.68207 | 2115990.3316599997 | 37.7906772569989 | -122.408826211779 | (37.7906772569989, -122.408826211779) | |||
| 8697 | 8697 | 113446 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008335.71081 | 2116491.16868 | 37.7919517851958 | -122.415068740628 | (37.7919517851958, -122.415068740628) | |||
| 8708 | 8708 | 11076 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1806 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007347.68888 | 2118546.89266 | 37.797540720094105 | -122.418633154095 | (37.7975407200941, -122.418633154095) | |||
| 8725 | 8725 | 7362 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2329 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6002748.31334 | 2116334.0850400003 | 37.7912049036346 | -122.43438990946999 | (37.7912049036346, -122.43438990947) | |||
| 8771 | 8771 | 59654 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1119 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1981 12:00:00 AM | 22 | Permit Number 19075 | 6009431.860719999 | 2117187.86787 | 37.7939262890147 | -122.41132528024201 | (37.7939262890147, -122.411325280242) | ||
| 8783 | 8783 | 7373 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2440 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002748.17801 | 2116678.1241200003 | 37.7921495389154 | -122.43441498617901 | (37.7921495389154, -122.434414986179) | |||
| 8800 | 8800 | 63349 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3010 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1987 12:00:00 AM | 16 | 4x4 | Permit Number 23924 | 6000255.01215 | 2115823.74708 | 37.7896618081804 | -122.442979967475 | (37.7896618081804, -122.442979967475) | |
| 8889 | 8889 | 43937 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2000 12:00:00 AM | 24 | 3x3 | Permit Number 43525 | 6001410.86266 | 2115802.65362 | 37.7896697231319 | -122.438979337847 | (37.7896697231319, -122.438979337847) | |
| 8896 | 8896 | 20256 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x7 | 6010132.4627 | 2119137.0531200003 | 37.799317544824 | -122.40903871617901 | (37.799317544824, -122.409038716179) | |||
| 8912 | 8912 | 113777 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1753 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776886 | 6004511.02573 | 2119439.59827 | 37.799831748383 | -122.428512428932 | (37.799831748383, -122.428512428932) | |
| 8933 | 8933 | 11077 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1814 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007344.39796 | 2118579.88238 | 37.797631116330294 | -122.418646882241 | (37.7976311163303, -122.418646882241) | |||
| 8934 | 8934 | 11025 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1432 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007519.8663800005 | 2117318.51464 | 37.794177591979796 | -122.417950249398 | (37.7941775919798, -122.417950249398) | |||
| 8941 | 8941 | 107233 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1209 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6007149.8711 | 2118772.43156 | 37.798148854252204 | -122.41933366571001 | (37.7981488542522, -122.41933366571) | |||
| 8954 | 8954 | 25509 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1845 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005217.05884 | 2116064.11045 | 37.7906034433315 | -122.42582889061701 | (37.7906034433315, -122.425828890617) | |||
| 8961 | 8961 | 11020 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1406 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007534.84234 | 2117200.48968 | 37.793854367544206 | -122.417890060478 | (37.7938543675442, -122.417890060478) | |||
| 8996 | 8996 | 23493 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2513 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6005749.93573 | 2119032.39279 | 37.798783697364705 | -122.42419635758499 | (37.7987836973647, -122.424196357585) | |||
| 9212 | 9212 | 60089 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1216 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2016 12:00:00 AM | 3 | Permit Number 19590 | 6007184.48933 | 2118821.16351 | 37.7982846096101 | -122.41921733482799 | (37.7982846096101, -122.419217334828) | ||
| 9826 | 9826 | 5367 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 247 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004885.80801 | 2106938.09523 | 37.7655269200494 | -122.42632496832701 | (37.7655269200494, -122.426324968327) | |||
| 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) | ||
| 10178 | 10178 | 5650 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1306 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005149.82479 | 2100705.7608 | 37.748429310564106 | -122.42496833563601 | (37.7484293105641, -122.424968335636) |
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");