Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3958 | 3958 | 49965 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1809 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 7 | Permit Number 47574 | 5999971.572269999 | 2115235.0808 | 37.7880293201371 | -122.443918325478 | (37.7880293201371, -122.443918325478) | ||
5073 | 5073 | 104053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2465 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6002918.10064 | 2116474.72915 | 37.791600712350295 | -122.433812507839 | (37.7916007123503, -122.433812507839) | ||||
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) | ||
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) | ||
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) | ||||
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) | ||
8849 | 8849 | 95551 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1333 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | Permit Number 779044 | 6007189.57448 | 2115360.3539400003 | 37.7887823728581 | -122.41895414822599 | (37.7887823728581, -122.418954148226) | ||
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) | ||
13361 | 13361 | 117223 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013667.943030001 | 2111389.10897 | 37.7782409101283 | -122.39626130683997 | (37.7782409101283, -122.39626130684) | |
13448 | 13448 | 59987 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1546 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19471 | 6015827.92235 | 2097026.6864599998 | 37.738924711310794 | -122.387786695709 | (37.7389247113108, -122.387786695709) | ||
13660 | 13660 | 117220 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013718.755890001 | 2111339.55053 | 37.7781076611892 | -122.39608205125799 | (37.7781076611892, -122.396082051258) | |
13737 | 13737 | 38759 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 325 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | Permit Number 40631 | 6011796.14841 | 2112034.18458 | 37.7799078071241 | -122.40278194745399 | (37.7799078071241, -122.402781947454) | |||
13839 | 13839 | 100181 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Ritch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6013794.16577 | 2112184.81721 | 37.7804327665865 | -122.39588042503999 | (37.7804327665865, -122.39588042504) | ||||
13977 | 13977 | 68166 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | 17 | Permit Number 31935 | 6007378.22718 | 2108942.70993 | 37.7711716911374 | -122.41784633906099 | (37.7711716911374, -122.417846339061) | ||
14091 | 14091 | 31394 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1995 12:00:00 AM | 18 | Permit Number 34987 | 6013462.98605 | 2105398.17838 | 37.7617797472724 | -122.39655027337 | (37.7617797472724, -122.39655027337) | |
14154 | 14154 | 117219 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013733.69082 | 2111323.12296 | 37.7780633857557 | -122.39602923405701 | (37.7780633857557, -122.396029234057) | |
14164 | 14164 | 114473 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6007374.36978 | 2108955.06944 | 37.7712054103423 | -122.41786055823799 | (37.7712054103423, -122.417860558238) | ||||
14214 | 14214 | 69442 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013823.57483 | 2111230.5410599997 | 37.777814177306 | -122.395711802165 | (37.777814177306, -122.395711802165) | |
14549 | 14549 | 117222 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013683.04729 | 2111373.4456700003 | 37.7781987427098 | -122.396207957236 | (37.7781987427098, -122.396207957236) | |
14702 | 14702 | 117215 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013784.57093 | 2111269.26347 | 37.7779183304931 | -122.395849445217 | (37.7779183304931, -122.395849445217) | |
15174 | 15174 | 112196 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 325 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6011775.52702 | 2112050.94015 | 37.7799526626161 | -122.40285446518601 | (37.7799526626161, -122.402854465186) | ||||
15546 | 15546 | 117216 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013770.84151 | 2111284.28441 | 37.7779588107877 | -122.395897993299 | (37.7779588107877, -122.395897993299) | |
15669 | 15669 | 117221 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013696.95586 | 2111359.6496200003 | 37.778161635782396 | -122.39615887494499 | (37.7781616357824, -122.396158874945) | |
15722 | 15722 | 100182 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966001 | (37.7803937971776, -122.39583053966) | ||||
16129 | 16129 | 117218 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013744.24197 | 2111311.0843599997 | 37.7780309175198 | -122.395991889732 | (37.7780309175198, -122.395991889732) | |
16357 | 16357 | 117217 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013756.29755 | 2111297.17195 | 37.77799338791311 | -122.395949209701 | (37.7779933879131, -122.395949209701) | |
16504 | 16504 | 117214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013802.24625 | 2111251.09103 | 37.7778694163842 | -122.395787025958 | (37.7778694163842, -122.395787025958) | |
16778 | 16778 | 111580 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501-1555 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 6012799.17131 | 2106096.7853200003 | 37.7636610021682 | -122.39889519177099 | (37.7636610021682, -122.398895191771) | |||
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 | |||||||||
22818 | 22818 | 61336 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1482 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1984 12:00:00 AM | 19 | Permit Number 21241 | 6011993.29551 | 2101466.3865799997 | 37.7509020100245 | -122.401357057985 | (37.7509020100245, -122.401357057985) | ||
22885 | 22885 | 66779 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1155 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1991 12:00:00 AM | 12 | Permit Number 30045 | 6008543.2648599995 | 2116581.49118 | 37.7922114500393 | -122.41435699379 | (37.7922114500393, -122.41435699379) | ||
22985 | 22985 | 59157 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 543 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1980 12:00:00 AM | 16 | Permit Number 18466 | 5992190.16655 | 2111724.33982 | 37.7779428509149 | -122.470584562939 | (37.7779428509149, -122.470584562939) | ||
23019 | 23019 | 8332 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1115 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6006224.34418 | 2114188.56599 | 37.785510534017 | -122.42221042876301 | (37.785510534017, -122.422210428763) | ||||
23081 | 23081 | 22916 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 290X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1994 12:00:00 AM | 11 | 6006061.92351 | 2107927.0539700002 | 37.7683087767514 | -122.422327315451 | (37.7683087767514, -122.422327315451) | |||
23111 | 23111 | 7884 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1187 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6005973.3508 | 2114075.31974 | 37.7851854273041 | -122.423070740949 | (37.7851854273041, -122.423070740949) | ||||
23589 | 23589 | 57478 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2859 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1976 12:00:00 AM | 13 | Permit Number 16328 | 5999193.93442 | 2118351.69962 | 37.796542342215 | -122.446833151424 | (37.796542342215, -122.446833151424) | ||
23766 | 23766 | 52771 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2260 REVISED Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | 10 | Permit Number 48815 | 6003905.209559999 | 2116656.9411400002 | 37.79215698439629 | -122.43041012884599 | (37.7921569843963, -122.430410128846) | ||
23832 | 23832 | 66290 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1867 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/1990 12:00:00 AM | 10 | Permit Number 29401 | 6000316.855380001 | 2121283.51551 | 37.804656412419206 | -122.443158280554 | (37.8046564124192, -122.443158280554) | ||
24015 | 24015 | 106518 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2510 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6002047.48335 | 2116727.6566 | 37.792245743897 | -122.43684294347 | (37.792245743897, -122.43684294347) | ||||
24457 | 24457 | 61320 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1477 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | 16 | Permit Number 21223 | 6011774.39181 | 2101489.8547799997 | 37.750954232774895 | -122.402115701805 | (37.7509542327749, -122.402115701805) | |
24468 | 24468 | 59700 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3136 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1981 12:00:00 AM | 24 | Permit Number 19130 | 5999679.41864 | 2116072.99431 | 37.7903133418282 | -122.444989381156 | (37.7903133418282, -122.444989381156) | ||
24526 | 24526 | 59246 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2242 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 17 | Permit Number 18577 | 6002201.61867 | 2118815.3248099997 | 37.7979866974971 | -122.436459120009 | (37.7979866974971, -122.436459120009) | ||
24697 | 24697 | 52867 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1907 REVISED Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2006 12:00:00 AM | 13 | Permit Number 48876 | 6007724.12776 | 2118978.20854 | 37.798746192027394 | -122.417361153918 | (37.7987461920274, -122.417361153918) | |
25057 | 25057 | 64913 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 50 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1989 12:00:00 AM | 17 | Permit Number 25940 | 6013531.04785 | 2117009.7875 | 37.793666374161894 | -122.397129100433 | (37.7936663741619, -122.397129100433) | ||
25126 | 25126 | 50436 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2629 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 3 | Permit Number 47088 | 6001610.4622 | 2117489.1021 | 37.794311627823504 | -122.438409620012 | (37.7943116278235, -122.438409620012) | ||
25320 | 25320 | 58031 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3484 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1977 12:00:00 AM | 17 | Permit Number 17000 | 5998226.17455 | 2115213.9962 | 37.7878717121596 | -122.449955544522 | (37.7878717121596, -122.449955544522) | ||
25549 | 25549 | 59281 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1980 12:00:00 AM | 16 | Permit Number 18617 | 6010951.56965 | 2105131.3119200002 | 37.7609069057602 | -122.405217512092 | (37.7609069057602, -122.405217512092) | ||
25577 | 25577 | 61918 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 69 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1985 12:00:00 AM | 12 | Permit Number 21971 | 6012517.75903 | 2119508.9865900003 | 37.8004721160603 | -122.400810852033 | (37.8004721160603, -122.400810852033) | ||
25690 | 25690 | 65750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 128 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28713 | 6001316.024619999 | 2121169.42595 | 37.80440007416821 | -122.439692381506 | (37.8044000741682, -122.439692381506) | ||
26098 | 26098 | 42705 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1035 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42722 | 6008002.308069999 | 2119233.94027 | 37.799464014698 | -122.41641668139499 | (37.799464014698, -122.416416681395) | |
26627 | 26627 | 66045 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2198 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1990 12:00:00 AM | 8 | Permit Number 29084 | 6003732.24173 | 2116962.2763799997 | 37.7929855576878 | -122.431030402055 | (37.7929855576878, -122.431030402055) | ||
26850 | 26850 | 64460 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1988 12:00:00 AM | 6 | Permit Number 25327 | 6012179.87648 | 2116409.873 | 37.7919438405915 | -122.40176210905001 | (37.7919438405915, -122.40176210905) | ||
26864 | 26864 | 58306 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2443 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1978 12:00:00 AM | 12 | Permit Number 17326 | 6001228.926080001 | 2118980.48254 | 37.7983848579411 | -122.43983675505699 | (37.7983848579411, -122.439836755057) | ||
27254 | 27254 | 62687 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 860 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1986 12:00:00 AM | 8 | Permit Number 23023 | 6006625.84704 | 2121524.67899 | 37.8056762993937 | -122.42134249755699 | (37.8056762993937, -122.421342497557) | ||
27385 | 27385 | 111579 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501-1555 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6012776.611819999 | 2106094.90491 | 37.7636545819145 | -122.398973086537 | (37.7636545819145, -122.398973086537) | ||||
27675 | 27675 | 53550 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 433 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 5 | Permit Number 6462 | 6012147.712719999 | 2116753.05985 | 37.7928843551861 | -122.401897531662 | (37.7928843551861, -122.401897531662) | ||
27889 | 27889 | 55098 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2636 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 17 | Permit Number 10996 | 5999209.508830001 | 2119443.11122 | 37.799539956153495 | -122.446857835114 | (37.7995399561535, -122.446857835114) | ||
27945 | 27945 | 53210 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2453@Scott Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 49183 | 6001208.23615 | 2118630.20382 | 37.7974219070641 | -122.439883220338 | (37.7974219070641, -122.439883220338) | |||
27982 | 27982 | 40093 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 718 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1999 12:00:00 AM | 14 | Permit Number 41316 | 6010452.6267 | 2116217.18865 | 37.791318235297 | -122.40772483814501 | (37.791318235297, -122.407724838145) | ||
28022 | 28022 | 189675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 10 | : Yard 23 | Tree 1 | Private 1 | 8 | 6017194.50129 | 2102669.93128 | 37.754495514781496 | -122.383454393407 | (37.7544955147815, -122.383454393407) | ||||
28159 | 28159 | 116806 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991537.4363400005 | 2110683.08947 | 37.7750460962456 | -122.472766623766 | (37.7750460962456, -122.472766623766) | |||
28341 | 28341 | 66603 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1225 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/29/1992 12:00:00 AM | 7 | Permit Number 29798 | 6008039.621 | 2115833.32115 | 37.790128854013 | -122.416046607673 | (37.790128854013, -122.416046607673) | |
28490 | 28490 | 65126 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 222 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 16 | Permit Number 27096 | 5989645.84476 | 2113859.10793 | 37.783656876429205 | -122.479542401246 | (37.7836568764292, -122.479542401246) | |
28493 | 28493 | 92501 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 2 | : 4 | Tree 1 | Private 1 | 24 | 6013077.25048 | 2110692.4491 | 37.7762951549369 | -122.398255852047 | (37.7762951549369, -122.398255852047) | ||||
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) | ||
28747 | 28747 | 46103 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2744 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2001 12:00:00 AM | 13 | Permit Number 44469 | 5999905.69247 | 2117801.50671 | 37.795072293301395 | -122.44433076175899 | (37.7950722933014, -122.444330761759) | ||
28796 | 28796 | 53616 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1986 12:00:00 AM | 8 | Permit Number 23021 | 6011569.0599 | 2116730.65971 | 37.7927905387988 | -122.40389813290301 | (37.7927905387988, -122.403898132903) | ||
28814 | 28814 | 63941 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1601 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1987 12:00:00 AM | 9 | Permit Number 24671 | 6002452.89385 | 2121236.51249 | 37.804648918382895 | -122.43576295658998 | (37.8046489183829, -122.43576295659) | ||
28965 | 28965 | 68584 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1335 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 15 | Permit Number 32481 | 6008309.92013 | 2116907.08816 | 37.793092348579 | -122.415187431374 | (37.793092348579, -122.415187431374) | |
29028 | 29028 | 68177 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 63 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 7 | Permit Number 31948 | 5996332.84265 | 2111732.38304 | 37.7782036117907 | -122.45625425125 | (37.7782036117907, -122.45625425125) | |
29163 | 29163 | 65104 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 179 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 12 | Permit Number 27071 | 5988966.04699 | 2114149.58894 | 37.7844149444345 | -122.481915500518 | (37.7844149444345, -122.481915500518) | |
29221 | 29221 | 69189 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3951 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1994 12:00:00 AM | 5 | Permit Number 33232 | 5995798.24806 | 2115486.1878299997 | 37.788479854444 | -122.45837537755699 | (37.788479854444, -122.458375377557) | ||
29625 | 29625 | 38512 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2737 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1998 12:00:00 AM | 11 | Permit Number 40501 | 6000473.108109999 | 2117486.3443 | 37.79423929714571 | -122.442344787105 | (37.7942392971457, -122.442344787105) | ||
29810 | 29810 | 39866 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 4 | Permit Number 41168 | 5997948.5707 | 2116247.7626900002 | 37.790694272177895 | -122.45099057155198 | (37.7906942721779, -122.450990571552) | |
30198 | 30198 | 64002 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 19 | Permit Number 24749 | 6007961.58195 | 2119970.3867200003 | 37.8014838218701 | -122.416609806295 | (37.8014838218701, -122.416609806295) | |
30205 | 30205 | 55627 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2157 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1973 12:00:00 AM | 17 | Permit Number 11606 | 6003875.11375 | 2116930.6803200003 | 37.79290689757679 | -122.430533801798 | (37.7929068975768, -122.430533801798) | ||
30271 | 30271 | 59997 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3699 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | 10 | Permit Number 31424 | 5997202.971059999 | 2115353.3034099997 | 37.7881956128749 | -122.453505683052 | (37.7881956128749, -122.453505683052) | ||
30806 | 30806 | 55902 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3450 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 17 | Permit Number 29205 | 5999777.27759 | 2120477.37898 | 37.802412197413 | -122.444967549216 | (37.802412197413, -122.444967549216) | ||
30836 | 30836 | 49846 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 12 | Permit Number 46626 | 6013978.58215 | 2112382.57733 | 37.7809860286255 | -122.39525629464599 | (37.7809860286255, -122.395256294646) | ||
30848 | 30848 | 65107 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 182 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27074 | 5989016.12351 | 2114112.182 | 37.784315147689796 | -122.48173951424499 | (37.7843151476898, -122.481739514245) | |
31010 | 31010 | 107367 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 656 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6008166.99608 | 2114164.4122 | 37.7855535971514 | -122.41548769429899 | (37.7855535971514, -122.415487694299) | ||||
31162 | 31162 | 247033 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6002285.13208 | 2099166.02387 | 37.7440393230544 | -122.434764280156 | (37.7440393230544, -122.434764280156) | ||||
31379 | 31379 | 64112 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2370 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1987 12:00:00 AM | 14 | Permit Number 24880 | 5999415.77049 | 2120510.85768 | 37.80248348218029 | -122.446220946954 | (37.8024834821803, -122.446220946954) | ||
31612 | 31612 | 65846 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 45 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 12 | Permit Number 28837 | 6001437.53726 | 2121346.67782 | 37.804893676057205 | -122.439284590205 | (37.8048936760572, -122.439284590205) | |
32131 | 32131 | 59118 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 531 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18422 | 5992805.89105 | 2111840.80293 | 37.77829821164279 | -122.46846304857999 | (37.7782982116428, -122.46846304858) | ||
32918 | 32918 | 33806 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2007 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 7 | Permit Number 37824 | 6004463.72985 | 2117345.0166700003 | 37.7940778868436 | -122.428526707464 | (37.7940778868436, -122.428526707464) | ||
33173 | 33173 | 41425 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1568 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 14 | Permit Number 42032 | 6015102.0577 | 2101304.61846 | 37.750630787079395 | -122.390595272152 | (37.7506307870794, -122.390595272152) | |
33257 | 33257 | 59984 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1562 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19468 | 6015739.3496 | 2097091.61317 | 37.7390980799033 | -122.38809747171899 | (37.7390980799033, -122.388097471719) | ||
33432 | 33432 | 63551 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 222 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1987 12:00:00 AM | 11 | Permit Number 24168 | 6009913.5058699995 | 2114086.3092099996 | 37.785437157429904 | -122.409439740963 | (37.7854371574299, -122.409439740963) | ||
33434 | 33434 | 42248 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 565 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 7 | Permit Number 42494 | 6009953.25863 | 2111737.1400200003 | 37.7789891226943 | -122.409136384353 | (37.7789891226943, -122.409136384353) | |
33612 | 33612 | 30416 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2540 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1956 12:00:00 AM | 14 | Permit Number 72 | 6000847.21294 | 2118636.7452 | 37.797419310715796 | -122.44113292095301 | (37.7974193107158, -122.441132920953) | ||
34074 | 34074 | 58986 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 526 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1980 12:00:00 AM | 13 | Permit Number 18275 | 5995019.60149 | 2111940.7971799998 | 37.77870038891871 | -122.460812308391 | (37.7787003889187, -122.460812308391) | ||
34322 | 34322 | 44062 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2700 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 14 | Permit Number 43588 | 6001633.0165 | 2117719.9764900003 | 37.7949468315795 | -122.43834812796301 | (37.7949468315795, -122.438348127963) | ||
34391 | 34391 | 64955 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2809 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 11 | Permit Number 25986 | 6004773.14771 | 2119232.31756 | 37.7992774386635 | -122.42759061302401 | (37.7992774386635, -122.427590613024) | |
34732 | 34732 | 100681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6012316.03692 | 2116830.7554099998 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | ||||
34764 | 34764 | 246821 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 198 Brewster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6010041.69314 | 2098721.17607 | 37.7432551843714 | -122.407912349468 | (37.7432551843714, -122.407912349468) | ||||
35015 | 35015 | 112913 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3579-3581 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6001161.44018 | 2120923.9189400002 | 37.803717177577795 | -122.440209716521 | (37.8037171775778, -122.440209716521) | ||||
35299 | 35299 | 55896 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3305 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1973 12:00:00 AM | 22 | Permit Number 11953 | 5999805.23357 | 2119943.7832400003 | 37.8009486821054 | -122.444832429667 | (37.8009486821054, -122.444832429667) | ||
35487 | 35487 | 58710 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2167 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1979 12:00:00 AM | 15 | Permit Number 17943 | 6002635.975319999 | 2118482.43939 | 37.797097352517795 | -122.434932304107 | (37.7970973525178, -122.434932304107) | ||
35700 | 35700 | 101413 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2800X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Permit Number 11899 | 6001259.00574 | 2116290.75835 | 37.7910012908294 | -122.439539751276 | (37.7910012908294, -122.439539751276) |
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");