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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125881 | 125881 | 39507 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 127159 | 127159 | 39701 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | ||
| 108082 | 108082 | 39702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 139750 | 139750 | 39894 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.44677199136801 | (37.7687584031098, -122.446771991368) | |||
| 105335 | 105335 | 40071 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.728857218184295 | -122.388698234625 | (37.7288572181843, -122.388698234625) | ||
| 185639 | 185639 | 40169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.44190053998399 | (37.7782227381789, -122.441900539984) | |
| 73601 | 73601 | 40189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | ||
| 31368 | 31368 | 40190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | ||
| 152716 | 152716 | 40191 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.320719999 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | ||
| 127807 | 127807 | 40209 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 546 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41391 | 5982267.21985305 | 2112050.10759861 | 37.778258529647005 | -122.50493510260799 | (37.778258529647, -122.504935102608) | ||
| 120469 | 120469 | 40264 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 37 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41423 | 6006033.37667708 | 2102847.69972308 | 37.7543604515005 | -122.42206517011101 | (37.7543604515005, -122.422065170111) | ||
| 119706 | 119706 | 40294 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41438 | 6006050.88362255 | 2102316.69577887 | 37.75290342464071 | -122.421966907904 | (37.7529034246407, -122.421966907904) | ||
| 34898 | 34898 | 40295 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.42220732508801 | (37.7528895951686, -122.422207325088) | ||
| 98224 | 98224 | 40633 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
| 162381 | 162381 | 40685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 114 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41668 | 6004151.556609999 | 2094012.13266 | 37.7299936942445 | -122.42794342066001 | (37.7299936942445, -122.42794342066) | |
| 70549 | 70549 | 40816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | ||
| 47055 | 47055 | 40817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.785958067470204 | -122.43822613537901 | (37.7859580674702, -122.438226135379) | |
| 180473 | 180473 | 40818 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | ||
| 93188 | 93188 | 40860 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42377 | 6007537.55147065 | 2099272.41006031 | 37.744628235414204 | -122.416610080854 | (37.7446282354142, -122.416610080854) | ||
| 113622 | 113622 | 41148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | ||
| 93386 | 93386 | 41149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | |||
| 46001 | 46001 | 41430 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.39729645077699 | (37.7593731443828, -122.397296450777) | |
| 105423 | 105423 | 41830 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1232 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2001 12:00:00 AM | Permit Number 42216 | 5991454.19182704 | 2107029.2184828 | 37.765008732916705 | -122.472788101582 | (37.7650087329167, -122.472788101582) | ||
| 101981 | 101981 | 41993 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.46447296226299 | (37.7278059137082, -122.464472962263) | ||
| 145378 | 145378 | 42099 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42405 | 5999399.61952202 | 2094185.90721086 | 37.730200858866205 | -122.44438387280898 | (37.7302008588662, -122.444383872809) | ||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 83688 | 83688 | 42111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 102717 | 102717 | 42112 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 105527 | 105527 | 42114 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 108121 | 108121 | 42339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42544 | 5997882.68725291 | 2094126.21532195 | 37.7299502922476 | -122.449623783134 | (37.7299502922476, -122.449623783134) | ||
| 116996 | 116996 | 42372 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 150848 | 150848 | 42651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.8812599997 | 37.7960721541703 | -122.42900719184799 | (37.7960721541703, -122.429007191848) | |
| 35351 | 35351 | 42685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | |
| 30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
| 107693 | 107693 | 42716 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 316 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42729 | 6012832.57789486 | 2094932.06844711 | 37.7330069432561 | -122.397996379955 | (37.7330069432561, -122.397996379955) | ||
| 147832 | 147832 | 42896 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42813 | 5986675.0189 | 2096952.6028 | 37.737063252741706 | -122.488577172427 | (37.7370632527417, -122.488577172427) | |
| 74936 | 74936 | 42897 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | |
| 44369 | 44369 | 42898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2060 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 7 | Permit Number 45580 | 5986523.9754 | 2097068.6969 | 37.737373201510295 | -122.489107923346 | (37.7373732015103, -122.489107923346) | |
| 103248 | 103248 | 43143 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 140 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42956 | 6005786.06556581 | 2093081.91758291 | 37.7275318626033 | -122.42222665307399 | (37.7275318626033, -122.422226653074) | ||
| 111352 | 111352 | 43148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | |||
| 121928 | 121928 | 43149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | |||
| 136137 | 136137 | 43150 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43804 | 6006064.01993 | 2092337.88288 | 37.7255045798588 | -122.42121295024201 | (37.7255045798588, -122.421212950242) | |
| 167841 | 167841 | 43170 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42979 | 6005800.19112 | 2092023.1560099998 | 37.724625531232796 | -122.42210263603701 | (37.7246255312328, -122.422102636037) | |
| 50887 | 50887 | 43172 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 370 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42981 | 6005806.0739 | 2092004.6857099999 | 37.7245751476096 | -122.42208098844101 | (37.7245751476096, -122.422080988441) | |
| 163609 | 163609 | 43173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 382 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42982 | 6005820.96717 | 2091946.15603 | 37.7244152778362 | -122.42202534828999 | (37.7244152778362, -122.42202534829) | |
| 48083 | 48083 | 43179 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2299 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42985 | 6001635.1083 | 2114240.3384 | 37.7853927633961 | -122.438091512505 | (37.7853927633961, -122.438091512505) |
| 93807 | 93807 | 43210 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 350 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 43001 | 6008795.91385 | 2094346.1745799999 | 37.7311725561519 | -122.41191084861299 | (37.7311725561519, -122.411910848613) | |
| 102710 | 102710 | 43223 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1303 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | Permit Number 44301 | 6009289.62355935 | 2101563.81507978 | 37.7510183090213 | -122.410713527989 | (37.7510183090213, -122.410713527989) | ||
| 94386 | 94386 | 43365 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4245 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43115 | 6002281.52408985 | 2101178.21709517 | 37.7495641270708 | -122.434920630419 | (37.7495641270708, -122.434920630419) | ||
| 126154 | 126154 | 43380 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.43646419239201 | (37.751930637944, -122.436464192392) | ||
| 124589 | 124589 | 43381 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.43645969424101 | (37.7518841875031, -122.436459694241) | ||
| 107001 | 107001 | 43661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 370 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43304 | 5992506.56767844 | 2112958.60482073 | 37.781350097045 | -122.46957990283 | (37.781350097045, -122.46957990283) | ||
| 144602 | 144602 | 43706 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 103294 | 103294 | 43707 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 81990 | 81990 | 43708 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 101308 | 101308 | 43731 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | ||
| 75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
| 51454 | 51454 | 44091 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.913930001 | 2104520.92035 | 37.759251716121796 | -122.40388677626001 | (37.7592517161218, -122.40388677626) | ||
| 47710 | 47710 | 44248 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1960 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2001 12:00:00 AM | 8 | Permit Number 43683 | 5999863.264769999 | 2121264.87303 | 37.8045793513217 | -122.44472662894199 | (37.8045793513217, -122.444726628942) | ||
| 99304 | 99304 | 44327 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1586 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2001 12:00:00 AM | 8 | 2x3 | Permit Number 43713 | 5997934.27114243 | 2105194.99069947 | 37.7603454014574 | -122.45024300053001 | (37.7603454014574, -122.45024300053) | |
| 114054 | 114054 | 44335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 416 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2001 12:00:00 AM | Permit Number 43720 | 6002101.70420966 | 2103412.24536884 | 37.7556880241476 | -122.435702264997 | (37.7556880241476, -122.435702264997) | |||
| 153681 | 153681 | 44451 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.710372910849706 | -122.43278970978001 | (37.7103729108497, -122.43278970978) | |
| 120080 | 120080 | 44452 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.3273599995 | 2086901.1112400002 | 37.710380983162395 | -122.43277076016399 | (37.7103809831624, -122.432770760164) | ||
| 37323 | 37323 | 44456 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.710307180311105 | -122.432895389109 | (37.7103071803111, -122.432895389109) | |
| 157511 | 157511 | 44744 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | ||
| 186993 | 186993 | 44745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.42036685635401 | (37.7952406976494, -122.420366856354) | ||
| 108036 | 108036 | 44766 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3043 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/2001 12:00:00 AM | Permit Number 43874 | 6007995.98796905 | 2103248.89285548 | 37.7555725343465 | -122.415306337838 | (37.7555725343465, -122.415306337838) | ||
| 101652 | 101652 | 45035 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2306 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43925 | 6002524.20413383 | 2117822.12502906 | 37.7952779539251 | -122.435271803602 | (37.7952779539251, -122.435271803602) | |||
| 85817 | 85817 | 45250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.188004401 | 2098465.43898756 | 37.7417803963921 | -122.45502778464599 | (37.7417803963921, -122.455027784646) | ||
| 120261 | 120261 | 45313 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 359 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44150 | 5991933.83383604 | 2090925.21902291 | 37.7208190204058 | -122.46995651824301 | (37.7208190204058, -122.469956518243) | ||
| 113556 | 113556 | 45337 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | ||
| 86084 | 86084 | 45525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1700 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | Permit Number 44286 | 5999707.83752219 | 2110208.85696406 | 37.7742135578008 | -122.444469428603 | (37.7742135578008, -122.444469428603) | |||
| 79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
| 100490 | 100490 | 46891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1442 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44947 | 5993067.98197095 | 2105653.75631803 | 37.7613253640923 | -122.46710643924999 | (37.7613253640923, -122.46710643925) | |||
| 119059 | 119059 | 47172 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 310 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45136 | 5992595.84229454 | 2094810.68405906 | 37.731525796784 | -122.46795064653 | (37.731525796784, -122.46795064653) | ||
| 26644 | 26644 | 48033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.761346597247794 | -122.437156358638 | (37.7613465972478, -122.437156358638) | |||
| 68937 | 68937 | 48447 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2600 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 8 | Permit Number 45819 | 5999656.5928 | 2113671.6674 | 37.783718621904896 | -122.44489566584998 | (37.7837186219049, -122.44489566585) | ||
| 121163 | 121163 | 48817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Everson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46044 | 6003284.291752299 | 2097109.16717497 | 37.7384483443847 | -122.431162629878 | (37.7384483443847, -122.431162629878) | |||
| 86515 | 86515 | 48833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.43421140278099 | (37.7535333013465, -122.434211402781) | |||
| 126511 | 126511 | 49185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | |||
| 84795 | 84795 | 49477 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145001 | (37.7976666140298, -122.39835845145) | |||
| 121771 | 121771 | 49478 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560@ Pacific Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145001 | (37.7976666140298, -122.39835845145) | |||
| 124624 | 124624 | 49479 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560@ Pacific Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145001 | (37.7976666140298, -122.39835845145) | |||
| 109529 | 109529 | 49577 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 108705 | 108705 | 49578 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 128456 | 128456 | 49579 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 111771 | 111771 | 49580 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 122865 | 122865 | 49581 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 107521 | 107521 | 49582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 95100 | 95100 | 49583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 95511 | 95511 | 49584 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | ||
| 107975 | 107975 | 49585 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) |
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");