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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
13368 | 13368 | 88155 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 275 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51180 | 6011547.33951 | 2112292.68656 | 37.7806036980511 | -122.403660886343 | (37.7806036980511, -122.403660886343) | |
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) | |
13692 | 13692 | 62022 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 431 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1985 12:00:00 AM | 12 | 3x3 | Permit Number 22095 | 6014279.69319 | 2112909.1990799997 | 37.7824487534429 | -122.394251475825 | (37.7824487534429, -122.394251475825) | |
13836 | 13836 | 116024 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1020 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2016 12:00:00 AM | 3 | 3x3 | 6014238.96376 | 2106224.3911099997 | 37.764091501331 | -122.393924293493 | (37.764091501331, -122.393924293493) | ||
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) | ||
13980 | 13980 | 112143 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 275 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011525.32345 | 2112314.21661 | 37.7806615846968 | -122.40373856619 | (37.7806615846968, -122.40373856619) | |||
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) | |
14119 | 14119 | 15268 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1535 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6007464.35841 | 2109890.1913799997 | 37.7737780973065 | -122.417615572103 | (37.7737780973065, -122.417615572103) | |||
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) | ||||
14199 | 14199 | 62029 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 543 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1985 12:00:00 AM | 12 | 3x3 | Permit Number 22102 | 6014722.83132 | 2112914.29345 | 37.782487363133995 | -122.39271875586 | (37.782487363134, -122.39271875586) | |
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) | |
14224 | 14224 | 97609 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009082.07861 | 2109308.71227 | 37.772272388486 | -122.41197849922399 | (37.772272388486, -122.411978499224) | |||
14496 | 14496 | 843 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010316.34076 | 2107575.5688099996 | 37.7675827459718 | -122.407586838062 | (37.7675827459718, -122.407586838062) | |
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) | |
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) | |
14914 | 14914 | 6792 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016736.55231 | 2097315.7132900003 | 37.739768612644 | -122.384665171383 | (37.739768612644, -122.384665171383) | |||
14941 | 14941 | 6814 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016451.12132 | 2097615.70854 | 37.7405765491786 | -122.38567298313801 | (37.7405765491786, -122.385672983138) | |||
15060 | 15060 | 54523 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 376 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 24 | 7x9 | Permit Number 10317 | 6013465.45079 | 2105340.63894 | 37.761621893763596 | -122.396537715245 | (37.7616218937636, -122.396537715245) | |
15326 | 15326 | 18340 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6010383.00184 | 2106367.01291 | 37.7642680580574 | -122.407271059107 | (37.7642680580574, -122.407271059107) | |||
15425 | 15425 | 112142 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 275 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011537.6076 | 2112303.10611 | 37.7806317640729 | -122.403695287202 | (37.7806317640729, -122.403695287202) | |||
15509 | 15509 | 6804 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x9 | 6016716.56136 | 2097329.28644 | 37.7398047761739 | -122.384735237561 | (37.7398047761739, -122.384735237561) | |||
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) | |
15792 | 15792 | 30661 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 83 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 8 | 3x3 | Permit Number 34594 | 6007673.53493 | 2109511.3804599997 | 37.7727497405427 | -122.416865151724 | (37.7727497405427, -122.416865151724) |
15881 | 15881 | 6819 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016343.96785 | 2097693.33127 | 37.7407837556653 | -122.386048891651 | (37.7407837556653, -122.386048891651) | |||
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) | |
16261 | 16261 | 6803 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016702.460969999 | 2097342.51463 | 37.7398403182643 | -122.384784912507 | (37.7398403182643, -122.384784912507) | |||
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) | |
16439 | 16439 | 54186 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1536 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 20 | 3x3 | Permit Number 9921 | 6015571.57326 | 2096517.43556 | 37.7375122082315 | -122.388637501128 | (37.7375122082315, -122.388637501128) | |
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) | |
16748 | 16748 | 18307 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 18 | 3x3 | Permit Number 777000 | 6010317.92211 | 2107539.48864 | 37.7674837665976 | -122.407578824211 | (37.7674837665976, -122.407578824211) | |
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) | |||
16993 | 16993 | 5362 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.4691 | 2106941.40414 | 37.765531294370106 | -122.42661345466999 | (37.7655312943701, -122.42661345467) | |||
17327 | 17327 | 5361 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004801.1830400005 | 2106961.82172 | 37.7655872834524 | -122.42661935690901 | (37.7655872834524, -122.426619356909) | |||
17431 | 17431 | 5364 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004803.911280001 | 2106914.7530400003 | 37.765458198358495 | -122.42660656853701 | (37.7654581983585, -122.426606568537) | |||
17600 | 17600 | 5600 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1120-1122 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005086.74805 | 2101818.38067 | 37.751480744460295 | -122.42526561553801 | (37.7514807444603, -122.425265615538) | ||
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) | ||
17689 | 17689 | 4453 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1395 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6004550.8518900005 | 2100795.77415 | 37.74864261447971 | -122.427045982684 | (37.7486426144797, -122.427045982684) | |||
17956 | 17956 | 5584 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1070 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005072.3503 | 2102110.66979 | 37.7522824891524 | -122.425336202406 | (37.7522824891524, -122.425336202406) | |||
18207 | 18207 | 5631 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.749564892610394 | -122.425090505838 | (37.7495648926104, -122.425090505838) | |||
18294 | 18294 | 4311 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 704 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002439.77272 | 2095706.35497 | 37.734548651581605 | -122.433982316925 | (37.7345486515816, -122.433982316925) | |||
18413 | 18413 | 4238 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003737.20071 | 2100388.64531 | 37.7474786902894 | -122.429830543661 | (37.7474786902894, -122.429830543661) | |||
18438 | 18438 | 5591 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1088 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778628 | 6005076.53143 | 2102027.71599 | 37.7520549534969 | -122.425315840853 | (37.7520549534969, -122.425315840853) | |
18672 | 18672 | 5363 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.21847 | 2106929.2313599996 | 37.7654978566596 | -122.426613454658 | (37.7654978566596, -122.426613454658) | |||
18934 | 18934 | 5430 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 481 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6004966.9264400005 | 2105556.94593 | 37.761739197733704 | -122.425946073151 | (37.7617391977337, -122.425946073151) | |||
19105 | 19105 | 55726 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2150 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1973 12:00:00 AM | 30 | 4x4 | Permit Number 11752 | 6003240.02272888 | 2107147.06325899 | 37.766007528721104 | -122.43203228921001 | (37.7660075287211, -122.43203228921) | |
19886 | 19886 | 5779 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 496 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003455.82861 | 2108380.6044799997 | 37.7694067653271 | -122.43137392508899 | (37.7694067653271, -122.431373925089) | |||
19890 | 19890 | 5598 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1114 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6005085.74952 | 2101846.15416 | 37.7515569476132 | -122.42527104471901 | (37.7515569476132, -122.425271044719) | |||
20438 | 20438 | 4451 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1378 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6004489.31548 | 2100836.19087 | 37.7487501095263 | -122.427261653602 | (37.7487501095263, -122.427261653602) | |||
21270 | 21270 | 5781 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 492 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 7x4 | 6003508.34359 | 2108380.71805 | 37.769410053253395 | -122.431192286293 | (37.7694100532534, -122.431192286293) | |||
21322 | 21322 | 5360 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004798.07492 | 2106976.61217 | 37.765627718772 | -122.42663116052499 | (37.765627718772, -122.426631160525) | |||
21614 | 21614 | 5746 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1765 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 50 | 3x3 | 6005379.08907 | 2098105.72339 | 37.74130314832521 | -122.42399067635401 | (37.7413031483252, -122.423990676354) | ||
21838 | 21838 | 5756 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 15X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1992 12:00:00 AM | 6 | 3X3 | 6002852.1776 | 2108197.50954 | 37.7688698017364 | -122.43344883911301 | (37.7688698017364, -122.433448839113) | ||
22171 | 22171 | 5329 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 115 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6X8 | 6004845.87922 | 2107712.31593 | 37.767650487414706 | -122.42651820656499 | (37.7676504874147, -122.426518206565) | |||
22380 | 22380 | 9871 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6005453.91763 | 2114704.56484 | 37.786883852758 | -122.424912604636 | (37.786883852758, -122.424912604636) | |||
22398 | 22398 | 16389 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 238 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006251.97502 | 2114055.0165 | 37.7851453984752 | -122.42210534300501 | (37.7851453984752, -122.422105343005) | |||
22455 | 22455 | 23395 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1595 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 50532 | 6006189.13732 | 2115866.26475 | 37.7901150934878 | -122.42245148576401 | (37.7901150934878, -122.422451485764) | ||
22457 | 22457 | 21579 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1499 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005465.56007 | 2114778.74492 | 37.787088190416 | -122.42487760393699 | (37.787088190416, -122.424877603937) | |||
22503 | 22503 | 9870 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6005458.91532 | 2114681.2842099997 | 37.7868202122258 | -122.42489365683599 | (37.7868202122258, -122.424893656836) | |||
22635 | 22635 | 21581 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1499 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005500.0563 | 2114782.6050400003 | 37.787100737741206 | -122.42475852920099 | (37.7871007377412, -122.424758529201) | |||
22648 | 22648 | 9869 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005460.28192 | 2114658.9871799997 | 37.7867590673152 | -122.424887341798 | (37.7867590673152, -122.424887341798) | |||
22681 | 22681 | 21580 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1499 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005481.38046 | 2114779.43516 | 37.7870909792163 | -122.424822917955 | (37.7870909792163, -122.424822917955) | |||
22746 | 22746 | 21582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1499 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005545.80681 | 2114788.2647599997 | 37.7871188617926 | -122.42460064511101 | (37.7871188617926, -122.424600645111) | |||
22775 | 22775 | 9873 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450X Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6005447.50636 | 2114747.87072 | 37.7870023977962 | -122.424937868409 | (37.7870023977962, -122.424937868409) | |||
22792 | 22792 | 16386 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 234 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006282.04371 | 2114060.56367 | 37.785162325522705 | -122.42200170873801 | (37.7851623255227, -122.422001708738) | |||
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) | ||
23118 | 23118 | 81902 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1855X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 6 | 3x3 | Permit Number 769738 | 6014398.74448 | 2099411.75035 | 37.7453943270819 | -122.392894990609 | (37.7453943270819, -122.392894990609) | |
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) | ||||
24043 | 24043 | 96715 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3301 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6x9 | 6003252.88656 | 2119687.16373 | 37.800440220701205 | -122.432883751884 | (37.8004402207012, -122.432883751884) | |||
24311 | 24311 | 95189 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 422 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | Permit Number 767104 | 5993138.35484 | 2112539.16901 | 37.7802349339512 | -122.46736373791401 | (37.7802349339512, -122.467363737914) | ||
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) | ||
25211 | 25211 | 107702 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2708 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 774015 | 5999903.41146 | 2118843.95794 | 37.7979344576772 | -122.444413608215 | (37.7979344576772, -122.444413608215) | ||
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) | |
26372 | 26372 | 38392 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1349 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40449 | 6007168.95941 | 2115981.09541 | 37.79048561507479 | -122.41906952046499 | (37.7904856150748, -122.419069520465) | |
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) | ||
27772 | 27772 | 87883 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50853 | 6002287.185880001 | 2120855.36005 | 37.803592960513605 | -122.436309109488 | (37.8035929605136, -122.436309109488) | |
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) |
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");