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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188771 | 188771 | 190201 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014306.70716 | 2116527.44421 | 37.7923851217206 | -122.39441144365601 | (37.7923851217206, -122.394411443656) | |||
| 25757 | 25757 | 112703 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010065.02511 | 2121996.61103 | 37.80716540491979 | -122.409473998846 | (37.8071654049198, -122.409473998846) | |||
| 27925 | 27925 | 112700 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010133.84115 | 2122006.13363 | 37.8071954071956 | -122.409236517546 | (37.8071954071956, -122.409236517546) | |||
| 42157 | 42157 | 112698 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010162.10827 | 2122010.9389 | 37.80721018486621 | -122.409139031937 | (37.8072101848662, -122.409139031937) | |||
| 51831 | 51831 | 112704 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6010051.400909999 | 2121995.09516 | 37.807160479332104 | -122.409521041462 | (37.8071604793321, -122.409521041462) | |||
| 60628 | 60628 | 112709 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6009982.61169 | 2121986.87678 | 37.8071340590486 | -122.409758521838 | (37.8071340590486, -122.409758521838) | |||
| 65586 | 65586 | 112702 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010077.3299 | 2121997.6645 | 37.80716898692771 | -122.40943148969102 | (37.8071689869277, -122.409431489691) | |||
| 67362 | 67362 | 112697 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010180.49666 | 2122013.17318 | 37.807217349764 | -122.409075552403 | (37.807217349764, -122.409075552403) | |||
| 132143 | 132143 | 112706 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010019.71915 | 2121991.50115 | 37.8071488358223 | -122.40963042961901 | (37.8071488358223, -122.409630429619) | |||
| 134732 | 134732 | 112705 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010037.29215 | 2121993.9150799997 | 37.8071564485694 | -122.40956978471701 | (37.8071564485694, -122.409569784717) | |||
| 136712 | 136712 | 112707 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010000.18827 | 2121989.4534 | 37.8071421187683 | -122.409697876062 | (37.8071421187683, -122.409697876062) | |||
| 155451 | 155451 | 112696 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010197.932580001 | 2122016.89458 | 37.807228544533295 | -122.409015474098 | (37.8072285445333, -122.409015474098) | |||
| 169955 | 169955 | 112701 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010119.58871 | 2122005.93511 | 37.8071940636195 | -122.409285827389 | (37.8071940636195, -122.409285827389) | |||
| 174059 | 174059 | 112699 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010148.474090001 | 2122008.93385 | 37.8072039156867 | -122.40918607459999 | (37.8072039156867, -122.4091860746) | |||
| 174941 | 174941 | 112710 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6009944.989709999 | 2121981.1208599997 | 37.8071161463469 | -122.40988831469 | (37.8071161463469, -122.40988831469) | |||
| 52881 | 52881 | 225319 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6006215.028530001 | 2110426.4498900003 | 37.7751801547778 | -122.421975311837 | (37.7751801547778, -122.421975311837) | |||
| 48332 | 48332 | 225592 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002850.632730001 | 2108947.74072 | 37.7709296647016 | -122.433507804049 | (37.7709296647016, -122.433507804049) | |||
| 55140 | 55140 | 225591 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002852.39104 | 2108929.65902 | 37.770880116562296 | -122.433500429628 | (37.7708801165623, -122.433500429628) | |||
| 16267 | 16267 | 18305 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010224.24414 | 2107746.60355 | 37.7680472125438 | -122.407917452249 | (37.7680472125438, -122.407917452249) | |||
| 945 | 945 | 26844 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | ||
| 5454 | 5454 | 26842 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006970.057999999 | 2110963.93279 | 37.7766985071661 | -122.419401628405 | (37.7766985071661, -122.419401628405) | ||
| 5579 | 5579 | 26845 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 775213 | 6006964.16578 | 2111032.6003799997 | 37.776886719994295 | -122.41942688403799 | (37.7768867199943, -122.419426884038) | ||
| 7883 | 7883 | 26843 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006968.35618 | 2110982.6622 | 37.7767498377733 | -122.419408844544 | (37.7767498377733, -122.419408844544) | ||
| 31574 | 31574 | 189607 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 06th St | 2 | : 4 | Tree 1 | Private 1 | 25 | Width 3ft | 6011287.74653 | 2111158.98765 | 37.777476320014 | -122.404479121929 | (37.777476320014, -122.404479121929) | |||
| 27706 | 27706 | 128237 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6012352.648469999 | 2119592.62299 | 37.8006925506804 | -122.401388085489 | (37.8006925506804, -122.401388085489) | |||
| 70513 | 70513 | 128236 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012355.01891 | 2119573.7971200002 | 37.800640991643206 | -122.40137855898399 | (37.8006409916432, -122.401378558984) | |||
| 71130 | 71130 | 128239 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012346.02917 | 2119632.64296 | 37.800802066532896 | -122.401413805224 | (37.8008020665329, -122.401413805224) | |||
| 170969 | 170969 | 128238 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012349.16368 | 2119610.78631 | 37.80074222833979 | -122.40140142155701 | (37.8007422283398, -122.401401421557) | |||
| 14501 | 14501 | 103346 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 29899 | 6010363.2937900005 | 2108386.27696 | 37.7698113928049 | -122.40748159581001 | (37.7698113928049, -122.40748159581) | ||
| 14828 | 14828 | 66675 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1991 12:00:00 AM | 10 | 3x3 | Permit Number 29899 | 6010436.295059999 | 2108454.16337 | 37.77000187911629 | -122.407233871257 | (37.7700018791163, -122.407233871257) | |
| 22469 | 22469 | 7866 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006104.07556 | 2113580.8996 | 37.7838352472299 | -122.42258332726801 | (37.7838352472299, -122.422583327268) | |||
| 22475 | 22475 | 7869 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006093.62914 | 2113643.3001 | 37.7840059943141 | -122.422623903791 | (37.7840059943141, -122.422623903791) | |||
| 22534 | 22534 | 7865 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006105.0189 | 2113565.09712 | 37.7837919107224 | -122.42257894036301 | (37.7837919107224, -122.422578940363) | |||
| 22629 | 22629 | 7867 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006097.1257 | 2113612.9246799997 | 37.7839227881431 | -122.42260964772 | (37.7839227881431, -122.42260964772) | |||
| 22708 | 22708 | 7868 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006094.882730001 | 2113627.1755 | 37.7839617908505 | -122.42261842060101 | (37.7839617908505, -122.422618420601) | |||
| 22742 | 22742 | 7864 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006105.6971 | 2113551.82535 | 37.783755507964294 | -122.42257565063998 | (37.7837555079643, -122.42257565064) | |||
| 152271 | 152271 | 127700 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008666.844190001 | 2116036.9958200003 | 37.7907233400461 | -122.413890871591 | (37.7907233400461, -122.413890871591) | |||
| 40029 | 40029 | 127957 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012062.32761 | 2119189.75387 | 37.799570167096896 | -122.402364378726 | (37.7995701670969, -122.402364378726) | |||
| 53971 | 53971 | 127956 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012064.857580001 | 2119176.00834 | 37.799532566420005 | -122.402354657058 | (37.79953256642, -122.402354657058) | |||
| 74960 | 74960 | 127959 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012056.0949800005 | 2119232.28738 | 37.799686605918104 | -122.40238893831699 | (37.7996866059181, -122.402388938317) | |||
| 173214 | 173214 | 127958 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012058.6590599995 | 2119212.94594 | 37.799633642131 | -122.402378704906 | (37.799633642131, -122.402378704906) | |||
| 27758 | 27758 | 127489 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007666.043740001 | 2115128.7135099997 | 37.788173163113896 | -122.41728920633999 | (37.7881731631139, -122.41728920634) | |||
| 66698 | 66698 | 127488 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007674.70811 | 2115131.74841 | 37.78818198366471 | -122.417259444165 | (37.7881819836647, -122.417259444165) | |||
| 187885 | 187885 | 127490 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007656.89689 | 2115128.3654099996 | 37.788171692705795 | -122.41732082828699 | (37.7881716927058, -122.417320828287) | |||
| 40134 | 40134 | 63976 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1987 12:00:00 AM | 18 | Permit Number 24713 | 6008118.773440001 | 2119296.69749 | 37.7996428790721 | -122.416018115343 | (37.7996428790721, -122.416018115343) | |
| 16341 | 16341 | 10572 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011306.3762 | 2111038.8058 | 37.7771473695905 | -122.404406213897 | (37.7771473695905, -122.404406213897) | |||
| 42040 | 42040 | 189611 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1002 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 8ft | 6011365.32335 | 2110994.5569 | 37.7770291662965 | -122.40419918094 | (37.7770291662965, -122.40419918094) | |||
| 33745 | 33745 | 218939 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990690.45077 | 2102431.07242 | 37.752339204007896 | -122.475093970812 | (37.7523392040079, -122.475093970812) | |||
| 51387 | 51387 | 218933 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990778.98274 | 2102431.84048 | 37.7523464435342 | -122.474787872164 | (37.7523464435342, -122.474787872164) | |||
| 52435 | 52435 | 218938 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990704.08635 | 2102431.91459 | 37.7523423066512 | -122.47504687873399 | (37.7523423066512, -122.475046878734) | |||
| 130441 | 130441 | 218936 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990723.76369 | 2102432.25259 | 37.752344375099895 | -122.474978856684 | (37.7523443750999, -122.474978856684) | |||
| 147770 | 147770 | 218934 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990760.83366 | 2102432.22352 | 37.7523464435445 | -122.47485066193 | (37.7523464435445, -122.47485066193) | |||
| 159443 | 159443 | 218935 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990744.94543 | 2102432.18219 | 37.7523454093323 | -122.474905602418 | (37.7523454093323, -122.474905602418) | |||
| 160593 | 160593 | 218937 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990714.31106 | 2102432.45211 | 37.752344375112294 | -122.475011559633 | (37.7523443751123, -122.475011559633) | |||
| 34060 | 34060 | 127757 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1005 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008619.34985 | 2116025.5482799998 | 37.790689240461504 | -122.41405438990401 | (37.7906892404615, -122.414054389904) | |||
| 38018 | 38018 | 127758 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1005 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008623.201330001 | 2116011.5553 | 37.7906510354728 | -122.4140400736 | (37.7906510354728, -122.4140400736) | |||
| 175631 | 175631 | 127759 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1005 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008626.18102 | 2115991.84376 | 37.7905970797476 | -122.41402836894 | (37.7905970797476, -122.41402836894) | |||
| 181479 | 181479 | 61903 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1005 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1985 12:00:00 AM | 13 | Permit Number 21947 | 6008617.2267 | 2116046.34412 | 37.7907462215147 | -122.414063207745 | (37.7907462215147, -122.414063207745) | ||
| 44918 | 44918 | 127816 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1009 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008187.060740001 | 2118913.96163 | 37.7985958209075 | -122.415754700319 | (37.7985958209075, -122.415754700319) | |||
| 23077 | 23077 | 15173 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1009 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/29/1997 12:00:00 AM | 6 | 3X3 | 6009997.61179 | 2112323.5405200003 | 37.780601724933 | -122.409024335124 | (37.780601724933, -122.409024335124) | ||
| 17637 | 17637 | 23045 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1009 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1994 12:00:00 AM | 20 | 3X3 | 6006363.7277 | 2103674.62704 | 37.756649629388 | -122.42098143865299 | (37.756649629388, -122.420981438653) | ||
| 47870 | 47870 | 123905 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5992698.8932300005 | 2114764.9755700002 | 37.786321009590004 | -122.46904605788201 | (37.78632100959, -122.469046057882) | |||
| 44364 | 44364 | 56410 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 18 | Permit Number 12570 | 5990190.56265 | 2114683.73374 | 37.78595269404529 | -122.477718203176 | (37.7859526940453, -122.477718203176) | ||
| 133499 | 133499 | 122057 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5990191.690830001 | 2114652.84953 | 37.785867960139605 | -122.47771204165701 | (37.7858679601396, -122.477712041657) | |||
| 188379 | 188379 | 122058 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5990191.66474 | 2114668.45777 | 37.785910814474704 | -122.477713273252 | (37.7859108144747, -122.477713273252) | |||
| 187262 | 187262 | 31505 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2014 12:00:00 AM | 13 | 3x3 | Permit Number 54070 | 6005154.62899 | 2099588.74591 | 37.7453625153619 | -122.424872264669 | (37.7453625153619, -122.424872264669) | |
| 18442 | 18442 | 5328 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6004844.5773 | 2107740.43574 | 37.7677276240574 | -122.426524712264 | (37.7677276240574, -122.426524712264) | |||
| 23717 | 23717 | 190342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014826.26604 | 2116061.6193 | 37.7911349426626 | -122.39258114252199 | (37.7911349426626, -122.392581142522) | |||
| 71337 | 71337 | 190343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014833.65153 | 2116067.9736900004 | 37.7911528005014 | -122.39255603344499 | (37.7911528005014, -122.392556033445) | |||
| 120061 | 120061 | 190337 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014767.49042 | 2116002.10502 | 37.790968265916796 | -122.392780340547 | (37.7909682659168, -122.392780340547) | |||
| 147364 | 147364 | 190341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014814.94374 | 2116051.9719599998 | 37.7911078245033 | -122.39261964247801 | (37.7911078245033, -122.392619642478) | |||
| 158095 | 158095 | 190339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014796.07981 | 2116028.26498 | 37.791041682965606 | -122.39268325242399 | (37.7910416829656, -122.392683252424) | |||
| 158248 | 158248 | 190338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014779.60174 | 2116014.8679 | 37.7910039825033 | -122.39273932876999 | (37.7910039825033, -122.39273932877) | |||
| 167512 | 167512 | 190336 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014755.210530001 | 2115992.9592 | 37.7909424715624 | -122.392822188693 | (37.7909424715624, -122.392822188693) | |||
| 169534 | 169534 | 190335 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014743.61218 | 2115981.63102 | 37.790910722793 | -122.392861525945 | (37.790910722793, -122.392861525945) | |||
| 186228 | 186228 | 190340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014805.5019 | 2116039.63688 | 37.791073430855796 | -122.392651447929 | (37.7910734308558, -122.392651447929) | |||
| 24034 | 24034 | 128289 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011528.34981 | 2120758.00025 | 37.8038463669751 | -122.404322585929 | (37.8038463669751, -122.404322585929) | |||
| 57608 | 57608 | 128292 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011685.15599 | 2120779.40875 | 37.803913910547294 | -122.403781453055 | (37.8039139105473, -122.403781453055) | |||
| 63708 | 63708 | 128295 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6011737.98777 | 2120794.57425 | 37.8039585025572 | -122.403599691991 | (37.8039585025572, -122.403599691991) | |||
| 76629 | 76629 | 128296 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6011760.219769999 | 2120791.0173 | 37.8039499778675 | -122.403522505873 | (37.8039499778675, -122.403522505873) | |||
| 134592 | 134592 | 128290 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6011563.2081699995 | 2120762.06758 | 37.8038594826879 | -122.40420224226101 | (37.8038594826879, -122.404202242261) | |||
| 136917 | 136917 | 128294 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6011739.96085 | 2120785.45853 | 37.8039335832322 | -122.403592222228 | (37.8039335832322, -122.403592222228) | |||
| 159691 | 159691 | 128287 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011473.93691 | 2120747.64407 | 37.8038148907035 | -122.404510156613 | (37.8038148907035, -122.404510156613) | |||
| 169019 | 169019 | 128293 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011708.71285 | 2120782.03449 | 37.8039224361403 | -122.40370011746599 | (37.8039224361403, -122.403700117466) | |||
| 175262 | 175262 | 128291 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6011656.52084 | 2120774.7371 | 37.8038994836227 | -122.403880218409 | (37.8038994836227, -122.403880218409) | |||
| 176908 | 176908 | 59206 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1980 12:00:00 AM | 11 | Permit Number 18526 | 6011447.01867 | 2120744.84852 | 37.803805710434496 | -122.40460311234399 | (37.8038057104345, -122.404603112344) | ||
| 187542 | 187542 | 128288 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011508.83416 | 2120753.62103 | 37.803833252157396 | -122.404389812943 | (37.8038332521574, -122.404389812943) | |||
| 161265 | 161265 | 127534 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 O'Farrell St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6010622.18881 | 2114505.22793 | 37.7866270909228 | -122.40701743500601 | (37.7866270909228, -122.407017435006) | |||
| 39634 | 39634 | 190118 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010303.28446 | 2107744.33666 | 37.7680454129972 | -122.407643899151 | (37.7680454129972, -122.407643899151) | |||
| 68824 | 68824 | 190117 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6010311.26291 | 2107626.91601 | 37.767723449392 | -122.407608022499 | (37.767723449392, -122.407608022499) | |||
| 83742 | 83742 | 190119 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6010301.8592300005 | 2107798.08422 | 37.7681929117011 | -122.407652618992 | (37.7681929117011, -122.407652618992) | |||
| 64043 | 64043 | 126899 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998937.241880001 | 2116224.4481900004 | 37.7906868078083 | -122.447568156564 | (37.7906868078083, -122.447568156564) | |||
| 154202 | 154202 | 126901 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998943.800919999 | 2116189.62286 | 37.7905915614954 | -122.447542954851 | (37.7905915614954, -122.447542954851) | |||
| 165995 | 165995 | 126900 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998940.26791 | 2116202.46826 | 37.7906266296635 | -122.447556103853 | (37.7906266296635, -122.447556103853) | |||
| 28617 | 28617 | 226531 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Rose St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6006054.679409999 | 2109842.3217700003 | 37.7735672350795 | -122.42248848118 | (37.7735672350795, -122.42248848118) | |||
| 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) | |||
| 1903 | 1903 | 127944 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012622.90875 | 2119176.76577 | 37.7995657819845 | -122.400423640834 | (37.7995657819845, -122.400423640834) | ||
| 1908 | 1908 | 127945 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 2ft | 6012656.99006 | 2119182.6904 | 37.7995839500992 | -122.40030612282601 | (37.7995839500992, -122.400306122826) | ||
| 1924 | 1924 | 127943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012601.19681 | 2119174.02118 | 37.7995570351977 | -122.400498579547 | (37.7995570351977, -122.400498579547) | ||
| 28680 | 28680 | 51923 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Walnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 8 | Permit Number 48124 | 5998456.35251 | 2116110.3853599997 | 37.7903461275183 | -122.44922377968001 | (37.7903461275183, -122.44922377968) |
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");