Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |
| 3172 | 3172 | 253340 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004432.85841 | 2102813.20591 | 37.754175338839204 | -122.427597715268 | (37.7541753388392, -122.427597715268) | |
| 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) |
| 5445 | 5445 | 71960 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 6008996.95317 | 2116013.9295900003 | 37.7906785394346 | -122.41274707603701 | (37.7906785394346, -122.412747076037) | |||
| 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) | |
| 9759 | 9759 | 24293 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 302 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 2x2 | 6006647.73618 | 2098006.46065 | 37.741102138158 | -122.41959709154101 | (37.741102138158, -122.419597091541) | ||
| 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) |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 24100 | 24100 | 229778 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011440.8047 | 2102625.1691799997 | 37.754052932322395 | -122.40334914446301 | (37.7540529323224, -122.403349144463) | |||
| 24885 | 24885 | 229758 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.40325406633801 | (37.7529956524374, -122.403254066338) | |||
| 26294 | 26294 | 226376 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.42752859039899 | (37.7377492002742, -122.427528590399) | |||
| 26408 | 26408 | 226356 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2793 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008207.55 | 2106773.70397 | 37.765262744207604 | -122.414824138541 | (37.7652627442076, -122.414824138541) | |||
| 27865 | 27865 | 229765 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011453.422780001 | 2102371.80516 | 37.753357955114396 | -122.40328768569401 | (37.7533579551144, -122.403287685694) | |||
| 31720 | 31720 | 226814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003182.02121 | 2107933.9662599997 | 37.7681648843321 | -122.432289109354 | (37.7681648843321, -122.432289109354) | |||
| 36567 | 36567 | 228540 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2620 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010291.15626 | 2104007.47358 | 37.757784154732 | -122.407422370055 | (37.757784154732, -122.407422370055) | |||
| 37674 | 37674 | 229769 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011449.91996 | 2102448.3530599996 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | |||
| 37979 | 37979 | 229803 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006754.853759999 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | |||
| 43697 | 43697 | 226398 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.745310565138794 | -122.415010803607 | (37.7453105651388, -122.415010803607) | |||
| 44135 | 44135 | 226800 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 611 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003049.61247 | 2104666.39775 | 37.7591854234811 | -122.43251367635901 | (37.7591854234811, -122.432513676359) | |||
| 47175 | 47175 | 229839 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 70 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005996.276219999 | 2105099.28876 | 37.7605406982241 | -122.422353441684 | (37.7605406982241, -122.422353441684) | |||
| 47533 | 47533 | 190685 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 801 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014780.75112 | 2106205.10487 | 37.7640686405785 | -122.392049045151 | (37.7640686405785, -122.392049045151) | |||
| 48765 | 48765 | 226824 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003840.68463 | 2095954.9720599998 | 37.735310701123296 | -122.429156618694 | (37.7353107011233, -122.429156618694) | |||
| 53396 | 53396 | 229797 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 79 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006025.25664 | 2105073.13553 | 37.7604705223053 | -122.422251353344 | (37.7604705223053, -122.422251353344) | |||
| 59146 | 59146 | 229752 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011465.52618 | 2102102.51804 | 37.7526192277045 | -122.403226887931 | (37.7526192277045, -122.403226887931) | |||
| 60031 | 60031 | 226364 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4365 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001531.187530001 | 2100555.7337599997 | 37.747812304611294 | -122.437470743076 | (37.7478123046113, -122.437470743076) | |||
| 60525 | 60525 | 226466 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 7 28th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.42251630979901 | (37.7455065507954, -122.422516309799) | |||
| 61898 | 61898 | 229781 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011437.0323 | 2102686.7718700003 | 37.754221869065795 | -122.40336652384799 | (37.7542218690658, -122.403366523848) | |||
| 62119 | 62119 | 226771 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 822 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003061.622769999 | 2103431.29043 | 37.7557947949988 | -122.432383924871 | (37.7557947949988, -122.432383924871) | |||
| 66800 | 66800 | 226783 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 579 Noe St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | |||
| 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) | |
| 67820 | 67820 | 107160 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1324 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6004955.04875 | 2120587.0969599998 | 37.80300760168571 | -122.42705771883399 | (37.8030076016857, -122.427057718834) | ||||
| 69213 | 69213 | 229855 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005458.16704 | 2101659.72097 | 37.75106607784429 | -122.42396992087 | (37.7510660778443, -122.42396992087) | |||
| 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) | |
| 72903 | 72903 | 229862 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1511 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010167.1335 | 2100435.43231 | 37.747969179639 | -122.40759944746 | (37.747969179639, -122.40759944746) | |||
| 73099 | 73099 | 226465 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2664 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008878.80492 | 2103009.39191 | 37.7549644959368 | -122.41223634384501 | (37.7549644959368, -122.412236343845) | |||
| 73890 | 73890 | 229871 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004840.3014 | 2102492.9572400004 | 37.753319048642396 | -122.42616587826099 | (37.7533190486424, -122.426165878261) | |||
| 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) |
| 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) | |
| 81308 | 81308 | 110460 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.78467328365571 | -122.48812603128799 | (37.7846732836557, -122.488126031288) | |
| 81500 | 81500 | 108489 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 131 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773695 | 6008906.91703 | 2111099.4081599996 | 37.7771793890601 | -122.412711016861 | (37.7771793890601, -122.412711016861) |
| 81555 | 81555 | 108736 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1351 Minna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | ||
| 86020 | 86020 | 63245 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1988 12:00:00 AM | 3 | 3x3 | Permit Number 24178 | 6005805.15699581 | 2104348.35401431 | 37.758468024523395 | -122.422961063691 | (37.7584680245234, -122.422961063691) |
| 87106 | 87106 | 115506 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1501x YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010110.0 | 2100575.0 | 37.748349203538 | -122.40780685360201 | (37.748349203538, -122.407806853602) | |||
| 91269 | 91269 | 115508 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1501x YORK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010110.0 | 2100575.0 | 37.748349203538 | -122.40780685360201 | (37.748349203538, -122.407806853602) | |||
| 98022 | 98022 | 117954 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.990180001 | 2095538.9609400001 | 37.734725676752895 | -122.39478759166599 | (37.7347256767529, -122.394787591666) | |||
| 99009 | 99009 | 35943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2016 12:00:00 AM | 3 | Permit Number 39390 | 6007111.66828124 | 2096780.53419663 | 37.7377621378422 | -122.417906096842 | (37.7377621378422, -122.417906096842) | |
| 99901 | 99901 | 61391 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3006 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009515.29830856 | 2101045.50817637 | 37.749607803885205 | -122.409896535031 | (37.7496078038852, -122.409896535031) |
| 99965 | 99965 | 108469 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2560 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772730 | 6009727.83086 | 2102431.72737 | 37.7534259626799 | -122.409259396677 | (37.7534259626799, -122.409259396677) |
| 99969 | 99969 | 108714 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 443 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773096 | 6014377.05047 | 2105069.75693 | 37.7609288007542 | -122.393365881138 | (37.7609288007542, -122.393365881138) |
| 100346 | 100346 | 97476 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3000 26th St | 1 | 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) |
| 100924 | 100924 | 110461 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.78467328365571 | -122.48812603128799 | (37.7846732836557, -122.488126031288) | |
| 101655 | 101655 | 59029 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 932 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | 3 | Permit Number 29324 | 6007964.96474283 | 2102491.52546087 | 37.7534912319893 | -122.41536001235399 | (37.7534912319893, -122.415360012354) | ||
| 103094 | 103094 | 115507 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1501x YORK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010110.0 | 2100575.0 | 37.748349203538 | -122.40780685360201 | (37.748349203538, -122.407806853602) | |||
| 103552 | 103552 | 117397 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 330X Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | ||
| 112976 | 112976 | 108708 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1220 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.854230001 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | |
| 118131 | 118131 | 95223 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 299 on 16th St Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774713 | 6004880.0 | 2106610.0 | 37.764625720621794 | -122.426321695151 | (37.7646257206218, -122.426321695151) | |
| 120910 | 120910 | 29076 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2299X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009690.9471404 | 2103965.2718708 | 37.7576346655719 | -122.409495172566 | (37.7576346655719, -122.409495172566) | ||
| 121515 | 121515 | 117396 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | ||
| 130158 | 130158 | 226407 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006002.53632 | 2097682.69863 | 37.740176796029296 | -122.421804971219 | (37.7401767960293, -122.421804971219) | |||
| 131722 | 131722 | 226350 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3079 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007751.35411 | 2103240.55496 | 37.7555358882803 | -122.416151769888 | (37.7555358882803, -122.416151769888) | |||
| 132775 | 132775 | 228550 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1376 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009526.3637 | 2101188.14814 | 37.7500000817346 | -122.40986833805 | (37.7500000817346, -122.40986833805) | |||
| 134208 | 134208 | 226341 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006689.89697 | 2103411.7906400003 | 37.7559463217857 | -122.41983477518 | (37.7559463217857, -122.41983477518) | |||
| 135152 | 135152 | 226806 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Storrie St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 6000773.9022 | 2105295.6973200003 | 37.7607840134024 | -122.440429287805 | (37.7607840134024, -122.440429287805) | |||
| 136124 | 136124 | 229774 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011445.35286 | 2102545.22023 | 37.7538336641006 | -122.403327791844 | (37.7538336641006, -122.403327791844) | |||
| 136231 | 136231 | 99510 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1949 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2012 12:00:00 AM | 3 | Permit Number 768796 | 6003707.79876 | 2118284.70068 | 37.7966152106739 | -122.431209412082 | (37.7966152106739, -122.431209412082) | ||
| 136391 | 136391 | 229843 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3731 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005450.41756 | 2104282.65689 | 37.758267612276605 | -122.42418324007099 | (37.7582676122766, -122.424183240071) | |||
| 137686 | 137686 | 226375 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 235 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004677.73219 | 2096935.7156099998 | 37.7380509507014 | -122.426332439909 | (37.7380509507014, -122.426332439909) | |||
| 140513 | 140513 | 67355 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 815 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777973 | 6009933.6561998 | 2104468.00986769 | 37.759028667481 | -122.408691247698 | (37.759028667481, -122.408691247698) | |
| 141357 | 141357 | 99928 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298.0 | 2105556.0 | 37.761868064792296 | -122.417883738243 | (37.7618680647923, -122.417883738243) |
| 148415 | 148415 | 226808 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 26 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003130.24955 | 2108135.8166 | 37.7687161804393 | -122.43248260118601 | (37.7687161804393, -122.432482601186) | |||
| 157180 | 157180 | 226773 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.753041705810396 | -122.43275986580099 | (37.7530417058104, -122.432759865801) | |||
| 158980 | 158980 | 226419 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 932 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007979.648440001 | 2102295.8954 | 37.7529549014529 | -122.415295385088 | (37.7529549014529, -122.415295385088) | |||
| 160620 | 160620 | 190703 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078786995 | -122.40002879800501 | (37.759589078787, -122.400028798005) | |||
| 165123 | 165123 | 226400 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008001.072480001 | 2099553.66374 | 37.745426553388704 | -122.415027215335 | (37.7454265533887, -122.415027215335) | |||
| 171101 | 171101 | 229764 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) | |||
| 178525 | 178525 | 190699 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013438.177180001 | 2106819.03274 | 37.7656797193792 | -122.3967356902 | (37.7656797193792, -122.3967356902) | |||
| 179268 | 179268 | 229775 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.40333892097799 | (37.7538928862632, -122.403338920978) | |||
| 185811 | 185811 | 229836 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 112 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006642.16012 | 2105416.67615 | 37.7614485827148 | -122.420142145449 | (37.7614485827148, -122.420142145449) | |||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) |
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");