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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |
| 178416 | 178416 | 129103 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1306x Montgomery St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.40459448426901 | (37.8018982087863, -122.404594484269) | |||
| 166350 | 166350 | 72455 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 548 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 9 | 6010352.2868 | 2119601.9151 | 37.8006062535339 | -122.40831085027901 | (37.8006062535339, -122.408310850279) | ||
| 94481 | 94481 | 107509 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | ||||||
| 24375 | 24375 | 129099 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002192.1868900005 | 2118975.47765 | 37.79842589939221 | -122.43650322546499 | (37.7984258993922, -122.436503225465) | |||
| 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) | |
| 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) | |
| 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) | |
| 162761 | 162761 | 100088 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6003201.40964 | 2118956.6592900003 | 37.7984315255609 | -122.43300966237301 | (37.7984315255609, -122.433009662373) | |||
| 65147 | 65147 | 100089 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.43305523462601 | (37.7984262977915, -122.433055234626) | |||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |
| 172269 | 172269 | 57319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2719 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 2 | Permit Number 16144 | 5999557.8231 | 2113954.6853 | 37.784490078245604 | -122.44525772561501 | (37.7844900782456, -122.445257725615) | ||
| 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) |
| 182379 | 182379 | 80400 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 847 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51000 | 6000427.8652 | 2111924.6617 | 37.778965778909296 | -122.442101918526 | (37.7789657789093, -122.442101918526) | |
| 180912 | 180912 | 123149 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 530 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992851.14917 | 2111838.68412 | 37.77829500806129 | -122.468306331193 | (37.7782950080613, -122.468306331193) | |||
| 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) |
| 136494 | 136494 | 138815 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 456 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005166.9007 | 2111130.9467 | 37.7770553630765 | -122.425651176317 | (37.7770553630765, -122.425651176317) | |||
| 169729 | 169729 | 138814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 456 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005154.2758 | 2111127.9762 | 37.777046493419 | -122.42569463833901 | (37.777046493419, -122.425694638339) | |||
| 161138 | 161138 | 190749 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 111 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008907.60615 | 2111116.85343 | 37.7772273283225 | -122.41270986656201 | (37.7772273283225, -122.412709866562) | |||
| 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) |
| 32128 | 32128 | 138952 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004470.5657 | 2110964.0931 | 37.7765578523866 | -122.428048123596 | (37.7765578523866, -122.428048123596) | |||
| 183146 | 183146 | 129102 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | |||
| 188915 | 188915 | 138953 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876001 | (37.7765203347407, -122.42804020876) | |||
| 163454 | 163454 | 129101 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | |||
| 186181 | 186181 | 142077 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 36 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998850.2457 | 2110939.7307 | 37.776171379653896 | -122.447488599832 | (37.7761713796539, -122.447488599832) | |||
| 168280 | 168280 | 138954 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 719 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004474.5770000005 | 2110934.0085 | 37.7764754744029 | -122.42803210297501 | (37.7764754744029, -122.428032102975) | |||
| 160847 | 160847 | 129100 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.42803626308701 | (37.7764530246232, -122.428036263087) | |||
| 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) | |
| 94132 | 94132 | 52117 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 700 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.77631787229279 | -122.427977208208 | (37.7763178722928, -122.427977208208) | ||
| 99446 | 99446 | 52118 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 700 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.77631787229279 | -122.427977208208 | (37.7763178722928, -122.427977208208) | ||
| 175495 | 175495 | 229865 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 539 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004844.26448 | 2110392.80621 | 37.7750103735616 | -122.426714698547 | (37.7750103735616, -122.426714698547) | |||
| 92205 | 92205 | 105745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771651 | 6002705.0 | 2109971.0 | 37.7737310181147 | -122.43408471033301 | (37.7737310181147, -122.434084710333) | |
| 114710 | 114710 | 105743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 410 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 4x4 | Permit Number 771648 | 6002709.0 | 2109944.0 | 37.773657109816206 | -122.434068943261 | (37.7736571098162, -122.434068943261) | ||
| 84328 | 84328 | 94953 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
| 96180 | 96180 | 94952 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
| 138918 | 138918 | 43006 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 201 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | ||
| 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) |
| 117555 | 117555 | 36721 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.770877924100105 | -122.42383621670099 | (37.7708779241001, -122.423836216701) | ||
| 63954 | 63954 | 228524 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 29 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519303999 | (37.7708619961085, -122.42386519304) | |||
| 37583 | 37583 | 226819 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | |||
| 93534 | 93534 | 50683 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | |||
| 33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
| 70859 | 70859 | 226812 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Belcher St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | |||
| 59202 | 59202 | 226813 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.43028847844101 | (37.7690073251557, -122.430288478441) | |||
| 75004 | 75004 | 229795 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004958.17286 | 2108195.3416 | 37.7689831073039 | -122.426164188445 | (37.7689831073039, -122.426164188445) | |||
| 88016 | 88016 | 64228 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 24 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2012 12:00:00 AM | Permit Number 769264 | 6003122.11049357 | 2108174.45220479 | 37.7688218028269 | -122.43251351352 | (37.7688218028269, -122.43251351352) | |||
| 51857 | 51857 | 229793 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Trainor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008301.706069999 | 2108167.22951 | 37.7690943309545 | -122.414597094793 | (37.7690943309545, -122.414597094793) | |||
| 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) | |||
| 83730 | 83730 | 36062 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | ||
| 88539 | 88539 | 36055 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 89707 | 89707 | 36054 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 103177 | 103177 | 36056 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 104055 | 104055 | 36059 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 104093 | 104093 | 36053 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 105288 | 105288 | 36063 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 108065 | 108065 | 36057 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 112101 | 112101 | 36060 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 115033 | 115033 | 36051 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 117496 | 117496 | 36061 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | ||
| 128156 | 128156 | 36052 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 145576 | 145576 | 36058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 80009 | 80009 | 39079 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2280X Alameda St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | |||
| 112817 | 112817 | 39077 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2280X Alameda St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | |||
| 97278 | 97278 | 52078 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 266 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 3x3 | Permit Number 50281 | 6006938.43131737 | 2107937.41791562 | 37.7683866372255 | -122.41929628737302 | (37.7683866372255, -122.419296287373) | ||
| 40748 | 40748 | 229794 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 270 14th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.768382235178706 | -122.419295689168 | (37.7683822351787, -122.419295689168) | |||
| 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) | |||
| 132827 | 132827 | 190721 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2200 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010462.79733 | 2107890.40635 | 37.7684554148125 | -122.40710245603901 | (37.7684554148125, -122.407102456039) | |||
| 182886 | 182886 | 190722 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2200 Alameda St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010363.6035400005 | 2107883.96222 | 37.7684321691431 | -122.407445105823 | (37.7684321691431, -122.407445105823) | |||
| 150086 | 150086 | 190727 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010484.13409 | 2107848.45184 | 37.768341411351706 | -122.407025696183 | (37.7683414113517, -122.407025696183) | |||
| 59860 | 59860 | 190726 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010460.27046 | 2107847.89076 | 37.7683385353269 | -122.40710819908001 | (37.7683385353269, -122.40710819908) | |||
| 24394 | 24394 | 190725 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.40717911333599 | (37.7683353022519, -122.407179113336) | |||
| 158019 | 158019 | 190724 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2277 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010411.73546 | 2107844.78326 | 37.768327286608404 | -122.40727585879401 | (37.7683272866084, -122.407275858794) | |||
| 51165 | 51165 | 190723 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.768325603974795 | -122.40735974486601 | (37.7683256039748, -122.407359744866) | |||
| 14166 | 14166 | 110369 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.40744851604201 | (37.7683165361048, -122.407448516042) | |||
| 15077 | 15077 | 110368 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | |||
| 181787 | 181787 | 190728 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.768257686259105 | -122.406890823964 | (37.7682576862591, -122.406890823964) | |||
| 132520 | 132520 | 190729 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010522.648990001 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | |||
| 53457 | 53457 | 190730 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.76811967629639 | -122.40687698429599 | (37.7681196762964, -122.406876984296) | |||
| 164271 | 164271 | 190731 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010525.632230001 | 2107742.1208900004 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | |||
| 182053 | 182053 | 190732 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.767985165622605 | -122.40686720957899 | (37.7679851656226, -122.406867209579) | |||
| 48009 | 48009 | 190733 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010530.15081 | 2107694.7357900003 | 37.767921917195004 | -122.406855692832 | (37.767921917195, -122.406855692832) | |||
| 88402 | 88402 | 110371 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
| 101192 | 101192 | 110372 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
| 102388 | 102388 | 110374 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
| 123636 | 123636 | 110373 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
| 143988 | 143988 | 110370 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
| 34566 | 34566 | 190734 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | |||
| 28067 | 28067 | 190735 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | |||
| 74197 | 74197 | 190736 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010534.2694 | 2107640.09784 | 37.7677721243224 | -122.406837595791 | (37.7677721243224, -122.406837595791) | |||
| 54680 | 54680 | 190737 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010533.3608099995 | 2107625.71159 | 37.767732572127294 | -122.406839724475 | (37.7677325721273, -122.406839724475) | |||
| 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) | ||
| 47184 | 47184 | 229792 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | |||
| 168999 | 168999 | 190738 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010533.72626 | 2107613.44503 | 37.767698911404096 | -122.406837595798 | (37.7676989114041, -122.406837595798) |
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");