Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20491 | 20491 | 85214 | Jacaranda mimosifolia :: Jacaranda 52 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.75264132339179 | -122.409722943913 | (37.7526413233918, -122.409722943913) | |
| 310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
| 578 | 578 | 239543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.362369999 | 2097372.9446900003 | 37.7393929694044 | -122.41768982014798 | (37.7393929694044, -122.417689820148) | |
| 581 | 581 | 240741 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.41769458294901 | (37.739334592605, -122.417694582949) | |
| 603 | 603 | 239542 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.739439105535105 | -122.41768862942101 | (37.7394391055351, -122.417688629421) | |
| 1083 | 1083 | 108357 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.4470599997 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | |
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1122 | 1122 | 38279 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.39502820678801 | (37.7580416558018, -122.395028206788) | ||
| 1126 | 1126 | 38276 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.757864288826795 | -122.394852504434 | (37.7578642888268, -122.394852504434) | ||
| 1131 | 1131 | 251458 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 1135 | 1135 | 38277 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013910.55501 | 2103982.27082 | 37.757916871294796 | -122.394903129995 | (37.7579168712948, -122.394903129995) | ||
| 2633 | 2633 | 108358 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.0245900005 | 2118966.98612 | 37.798398653541796 | -122.43674193970399 | (37.7983986535418, -122.436741939704) | |
| 4711 | 4711 | 41645 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 146 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 3 | 3x3 | Permit Number 42118 | 5997898.0776 | 2112825.6252 | 37.7812950956289 | -122.450918408743 | (37.7812950956289, -122.450918408743) |
| 4895 | 4895 | 69228 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 537 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 12 | 7x7 | Permit Number 33281 | 6005209.5873 | 2111278.8914 | 37.7774639950364 | -122.425514041455 | (37.7774639950364, -122.425514041455) |
| 5203 | 5203 | 46584 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2790 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2002 12:00:00 AM | Permit Number 44712 | ||||||||
| 5530 | 5530 | 73673 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 3x3 | Permit Number 49743 | 6009009.07055 | 2116016.5507400003 | 37.790686416582396 | -122.412705335782 | (37.7906864165824, -122.412705335782) | |
| 7958 | 7958 | 108356 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.798416119273206 | -122.436618162405 | (37.7984161192732, -122.436618162405) | |
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 9605 | 9605 | 17889 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | ||
| 9688 | 9688 | 35795 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.75963284616879 | -122.42070069541 | (37.7596328461688, -122.42070069541) | ||
| 13280 | 13280 | 10220 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | |||
| 13316 | 13316 | 94652 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847.0 | 2095961.0 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) |
| 13609 | 13609 | 12227 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.735913201034606 | -122.387848277235 | (37.7359132010346, -122.387848277235) | ||
| 14393 | 14393 | 32960 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) |
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 15703 | 15703 | 108713 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1101 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773108 | 6011675.24376 | 2103231.93963 | 37.7557320816825 | -122.402581058681 | (37.7557320816825, -122.402581058681) |
| 15907 | 15907 | 88471 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1525 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015740.82967 | 2096670.14534 | 37.7379408970519 | -122.388062950362 | (37.7379408970519, -122.388062950362) | |
| 16487 | 16487 | 32962 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 952 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 6x12 | Permit Number 37276 | 6015219.88415 | 2104168.1362900003 | 37.7584999350397 | -122.39038786691299 | (37.7584999350397, -122.390387866913) |
| 18190 | 18190 | 73083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.41841169643601 | (37.7635727856768, -122.418411696436) | ||
| 19430 | 19430 | 68480 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32350 | 6010273.43286101 | 2102111.66598921 | 37.7525776974999 | -122.407350018785 | (37.7525776974999, -122.407350018785) | ||
| 19620 | 19620 | 34336 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 19790 | 19790 | 53252 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | ||
| 19800 | 19800 | 36597 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.40978500985399 | (37.7507339080729, -122.409785009854) | ||
| 19801 | 19801 | 94573 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3978 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116.0 | 2105363.0 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | ||
| 20051 | 20051 | 26498 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.2710700002 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | ||
| 20285 | 20285 | 10083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | ||
| 20293 | 20293 | 91075 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858.0 | 2104570.0 | 37.7591922359052 | -122.41587709061399 | (37.7591922359052, -122.415877090614) | ||
| 20507 | 20507 | 10084 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | ||
| 20984 | 20984 | 52219 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | |||
| 25065 | 25065 | 32969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.759100056248606 | -122.39435585294399 | (37.7591000562486, -122.394355852944) | |
| 25170 | 25170 | 39568 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963433998 | (37.7594620297563, -122.40312963434) | |
| 25919 | 25919 | 40096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | ||
| 26647 | 26647 | 96093 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 27540 | 27540 | 68129 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301001 | (37.7581797826985, -122.39503416301) | |
| 27605 | 27605 | 39569 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.776869999 | 2104583.27285 | 37.7594352029858 | -122.40313076567101 | (37.7594352029858, -122.403130765671) | |
| 28765 | 28765 | 35362 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.436290001 | 2103880.66513 | 37.75752713659001 | -122.401771780343 | (37.75752713659, -122.401771780343) | |
| 28823 | 28823 | 37988 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.39507287703199 | (37.7585156794839, -122.395072877032) | |
| 28840 | 28840 | 37987 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | |
| 30560 | 30560 | 32977 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.76079251737271 | -122.393553179256 | (37.7607925173727, -122.393553179256) | |
| 31195 | 31195 | 35348 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.40080483467301 | (37.7553687870439, -122.400804834673) | |
| 33670 | 33670 | 67525 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | |
| 35605 | 35605 | 49762 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 123@ GIRARD Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46556 | 6011554.1535 | 2090217.48516 | 37.7199903867389 | -122.402084923384 | (37.7199903867389, -122.402084923384) | |
| 35695 | 35695 | 35366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.1446700003 | 37.756647404478 | -122.40189800918999 | (37.756647404478, -122.40189800919) | |
| 36302 | 36302 | 38643 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.39897796896099 | (37.7565441236392, -122.398977968961) | |
| 37401 | 37401 | 35575 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.42314253259501 | (37.7559036789868, -122.423142532595) | |
| 37810 | 37810 | 39586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.756609729177896 | -122.401682552328 | (37.7566097291779, -122.401682552328) | |
| 38020 | 38020 | 32982 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.39513594376899 | (37.7592500775456, -122.395135943769) | |
| 38346 | 38346 | 36010 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.744183746831496 | -122.421946122617 | (37.7441837468315, -122.421946122617) | ||
| 40345 | 40345 | 94180 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 605 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53586 | 6010991.81939 | 2105452.40233 | 37.7617907981332 | -122.40510091500201 | (37.7617907981332, -122.405100915002) | |
| 42129 | 42129 | 108456 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | ||||
| 42743 | 42743 | 108444 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877.0 | 2117007.0 | 37.793733556134896 | -122.39247175850299 | (37.7937335561349, -122.392471758503) | |
| 48448 | 48448 | 37938 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.799319999 | 2105128.09339 | 37.7609678851705 | -122.40089326501499 | (37.7609678851705, -122.400893265015) | |
| 49970 | 49970 | 37676 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40072 | 6008031.0 | 2104525.0 | 37.7590784006599 | -122.41527558618401 | (37.7590784006599, -122.415275586184) | ||
| 50083 | 50083 | 36593 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.40978500985399 | (37.7507339080729, -122.409785009854) | ||
| 51130 | 51130 | 95638 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462.0 | 2107407.0 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | |
| 51133 | 51133 | 35546 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 51557 | 51557 | 52119 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 700 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.77631787229279 | -122.427977208208 | (37.7763178722928, -122.427977208208) | |
| 52736 | 52736 | 46565 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) | ||
| 53105 | 53105 | 47677 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 442 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 7 | 6x7 | Permit Number 45461 | 6014320.2471199995 | 2105057.7059400002 | 37.7608925552604 | -122.39356149707301 | (37.7608925552604, -122.393561497073) |
| 53368 | 53368 | 78724 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53574 | 6011950.73154 | 2102276.22736 | 37.7531232815236 | -122.40156116092699 | (37.7531232815236, -122.401561160927) | |
| 53612 | 53612 | 38251 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | ||
| 60089 | 60089 | 67473 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 880 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 6 | Permit Number 30995 | 6012731.1830400005 | 2103360.24925 | 37.75614328768621 | -122.39893826479499 | (37.7561432876862, -122.398938264795) | |
| 60691 | 60691 | 37945 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.39988268066601 | (37.7581101796629, -122.399882680666) | |
| 63640 | 63640 | 38604 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015379.8321 | 2094216.5354 | 37.7311837737961 | -122.38913983494801 | (37.7311837737961, -122.389139834948) | |
| 63686 | 63686 | 32948 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.76231031129179 | -122.39834906047399 | (37.7623103112918, -122.398349060474) | ||
| 63739 | 63739 | 39570 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | |
| 65946 | 65946 | 52722 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1115 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 5 | Permit Number 48775 | 6011675.49817 | 2103219.4484 | 37.755697797718796 | -122.40257930049201 | (37.7556977977188, -122.402579300492) | ||
| 67156 | 67156 | 81978 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2318 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50641 | 6007584.72207 | 2120320.19239 | 37.8024230981 | -122.417938725504 | (37.8024230981, -122.417938725504) | |
| 67198 | 67198 | 38605 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50557 | 6015347.9546 | 2094242.9168 | 37.731254444632796 | -122.38925188353501 | (37.7312544446328, -122.389251883535) | |
| 70131 | 70131 | 43301 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.6633599997 | 37.7598497302126 | -122.39520105018299 | (37.7598497302126, -122.395201050183) | |
| 70237 | 70237 | 32980 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.0613700002 | 37.7593873374867 | -122.39515493295201 | (37.7593873374867, -122.395154932952) | |
| 70283 | 70283 | 52004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1242 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/2005 12:00:00 AM | 3 | Permit Number 48221 | 6012214.20801 | 2102602.19108 | 37.7540330051314 | -122.400672898747 | (37.7540330051314, -122.400672898747) | |
| 76353 | 76353 | 94663 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614.0 | 2097695.0 | 37.7401321706185 | -122.42660684616101 | (37.7401321706185, -122.426606846161) | |
| 76385 | 76385 | 58933 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.2877700003 | 37.752841084147704 | -122.401525896729 | (37.7528410841477, -122.401525896729) | ||
| 77536 | 77536 | 68105 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.745467388517795 | -122.414298897694 | (37.7454673885178, -122.414298897694) | ||
| 77618 | 77618 | 34735 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851001 | (37.7509115908716, -122.41496434851) | ||
| 77815 | 77815 | 71739 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.745627705832206 | -122.41488645052 | (37.7456277058322, -122.41488645052) | ||
| 78078 | 78078 | 94188 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 456 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2014 12:00:00 AM | 10 | 3x4 | Permit Number 772961 | 5998552.0 | 2106546.0 | 37.7640902659836 | -122.448203856901 | (37.7640902659836, -122.448203856901) | |
| 78138 | 78138 | 40317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.42103015034901 | (37.7569313744996, -122.421030150349) | ||
| 78165 | 78165 | 34059 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | 12 | 6x7 | Permit Number 37961 | 6009447.37701969 | 2106694.23265708 | 37.7651141201322 | -122.410530241296 | (37.7651141201322, -122.410530241296) | |
| 78209 | 78209 | 46116 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 648 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44475 | 6012371.38389312 | 2104918.06745502 | 37.760400658327605 | -122.400291990633 | (37.7604006583276, -122.400291990633) | |||
| 78330 | 78330 | 37758 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.75121419029829 | -122.40794259966002 | (37.7512141902983, -122.40794259966) | ||
| 78669 | 78669 | 108394 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 737 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773728 | 6007947.99445 | 2103637.44207 | 37.756636704384206 | -122.41549982216002 | (37.7566367043842, -122.41549982216) |
| 78984 | 78984 | 97477 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3000 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009497.8 | 2101066.6 | 37.749664736665295 | -122.409958533785 | (37.7496647366653, -122.409958533785) |
| 79066 | 79066 | 52627 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.761318540179204 | -122.40822324587499 | (37.7613185401792, -122.408223245875) | |||
| 79251 | 79251 | 82604 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010041.95956984 | 2101582.34952093 | 37.7511113537145 | -122.40811317009701 | (37.7511113537145, -122.408113170097) | ||
| 79276 | 79276 | 50560 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | |||
| 79377 | 79377 | 37153 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 170 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468001 | (37.7471459516063, -122.42400799468) | |||
| 79398 | 79398 | 82600 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1380-1382 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52212 | 6010324.92053454 | 2101179.2577549 | 37.7500203919907 | -122.40710624684799 | (37.7500203919907, -122.407106246848) | |
| 79557 | 79557 | 111057 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) |
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");