trees

72 rows where DBH = 4 and qSpecies_id = 50 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

DBH ✖

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
543 100400 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 88 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 6x3   6008223 2099495 37.7452779444232 -122.414255673266 (37.7452779444232, -122.414255673266) 2 7 7 28859 2
1963 229848 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3494 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6005112.08271 2103723.92824 37.7567143652889 -122.425313591669 (37.7567143652889, -122.425313591669) 2 4 5 28859 19
4309 69898 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1019 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6011946.5334 2103437.3528 37.756311243277 -122.401657284058 (37.756311243277, -122.401657284058) 10 3 8 28856 29
12595 229844 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3676 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 4x4   6005793.11557 2104343.58039 37.7584542377953 -122.423002369088 (37.7584542377953, -122.423002369088) 2 4 5 28859 19
14543 48 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6003376.13457 2107738.85817 37.7676401694851 -122.431603760325 (37.7676401694851, -122.431603760325) 15 5 5 28862 3
14660 78429 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 744 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4 3x3   6011805.9335 2104893.37298 37.7603013058687 -122.402245896623 (37.7603013058687, -122.402245896623) 10 3 8 28856 29
15057 229773 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 43 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011446.65854 2102520.54386 37.7537659811344 -122.403321540662 (37.7537659811344, -122.403321540662) 10 4 8 28859 19
16490 233463 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2598 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008858.41145 2103392.91601 37.7560164221241 -122.41233397694 (37.7560164221241, -122.41233397694) 2 4 7 28859 19
18656 229861 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1509 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010132.55959 2100497.58386 37.7481378987515 -122.407723384842 (37.7481378987515, -122.407723384842) 2 7 7 28859 2
29151 229756 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 24 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011464.15557 2102190.87321 37.7528617550894 -122.403237842573 (37.7528617550894, -122.403237842573) 10 4 8 28859 19
32204 116873 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1250 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013484.98836 2106649.50082 37.7652168275233 -122.396561894417 (37.7652168275233, -122.396561894417) 14 3 8 28856 20
33353 229895 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1429 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008018.20821 2099852.67897 37.7462485454514 -122.414989122751 (37.7462485454514, -122.414989122751) 2 7 7 28859 2
34432 229750 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 365 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005497.63156 2101589.27142 37.7508748675982 -122.423828439536 (37.7508748675982, -122.423828439536) 2 4 5 28859 19
36074 229770 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 40 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011448.51225 2102466.33912 37.753617250357 -122.403311317166 (37.753617250357, -122.403311317166) 10 4 8 28859 19
38739 229867 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 474 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002892.54695 2098627.83365 37.7425960442853 -122.432625542146 (37.7425960442853, -122.432625542146) 2 7 5 63 22
44395 226394 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1451 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008031.02829 2099712.86133 37.7458653577975 -122.414934898137 (37.7458653577975, -122.414934898137) 2 7 7 28859 2
46491 226357 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 645 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005980.00754 2099557.6277 37.7453236574624 -122.422016025938 (37.7453236574624, -122.422016025938) 2 7 5 28859 2
54681 229760 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 30 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011458.91565 2102265.65077 37.7530667852271 -122.403261223145 (37.7530667852271, -122.403261223145) 10 4 8 28859 19
55327 229772 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 42 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011446.86383 2102500.86077 37.7537119471592 -122.403319446151 (37.7537119471592, -122.403319446151) 10 4 8 28859 19
57912 229849 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 86 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005369.70063 2103246.31322 37.7554174970228 -122.424388683912 (37.7554174970228, -122.424388683912) 2 4 5 28859 19
64290 226822 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 39 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004297.5525 2098038.31795 37.7410569481125 -122.427725448366 (37.7410569481125, -122.427725448366) 2 7 5 63 7
72353 190688 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1001 Minnesota St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6015295.35609 2103854.98706 37.7576442804869 -122.390104972579 (37.7576442804869, -122.390104972579) 10 3 8 28856 29
75775 226372 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 4222 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002353.94285 2100643.26716 37.748099392475 -122.434631957518 (37.748099392475, -122.434631957518) 2 4 5 28862 22
88747 228551 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1398 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009530.29917 2101073.08548 37.7496843657442 -122.409846607735 (37.7496843657442, -122.409846607735) 2 4 7 28859 19
95325 229771 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 41 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011447.67718 2102483.4305 37.7536641328931 -122.403315407293 (37.7536641328931, -122.403315407293) 10 4 8 28859 19
99690 229838 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 28 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005984.45224 2105323.33984 37.7611552229594 -122.422410255427 (37.7611552229594, -122.422410255427) 2 4 5 28859 19
102465 190690 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1003 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6015296.6982 2103817.69544 37.7575419601034 -122.390097725855 (37.7575419601034, -122.390097725855) 10 3 8 28856 29
104424 226352 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3331 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007311 2105534 37.7618083895094 -122.417837216752 (37.7618083895094, -122.417837216752) 2 4 7 28859 19
108539 219235 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 5 Sequoia Way 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5998215.18129 2097817.79881 37.7401055166597 -122.448740104476 (37.7401055166597, -122.448740104476) 9 7 4 59 40
109114 226436 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 106 Bartlett St 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006661.69832 2103152.67554 37.7552332628263 -122.419913909217 (37.7552332628263, -122.419913909217) 2 4 7 28859 19
110428 229826 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1312 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010048.8848 2101524.58992 37.750953146384 -122.408085148809 (37.750953146384, -122.408085148809) 2 4 7 28859 19
112161 229887 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 87 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008255.99327 2099554.30466 37.745442635078 -122.414145782603 (37.745442635078, -122.414145782603) 2 7 7 28859 2
113872 190697 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013439.7362 2106789.19698 37.7655978837597 -122.396728206045 (37.7655978837597, -122.396728206045) 14 3 8 28856 20
117876 228535 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1000 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009303.88793 2107359.35357 37.766932343692 -122.411073521351 (37.766932343692, -122.411073521351) 8 4 7 28853 19
120093 229753 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 21 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011465.79162 2102125.84808 37.7526833017063 -122.403227610989 (37.7526833017063, -122.403227610989) 10 4 8 28859 19
120945 229754 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 22 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011464.93054 2102145.24186 37.7527365046859 -122.403231952908 (37.7527365046859, -122.403231952908) 10 4 8 28859 19
121316 190737 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 168 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010533.36081 2107625.71159 37.7677325721273 -122.406839724475 (37.7677325721273, -122.406839724475) 8 4 8 28853 19
122297 229767 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 37 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011451.55336 2102410.70185 37.7534646524788 -122.403296886638 (37.7534646524788, -122.403296886638) 10 4 8 28859 19
123168 190683 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1301 Minnesota St 39 Front Yard : Yard Tree Private 2     4     6015372.42654 2102509.76476 37.7539548603504 -122.389744472134 (37.7539548603504, -122.389744472134) 10 3 8 28856 29
127332 229777 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 47 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011441.00674 2102606.02985 37.7540003912143 -122.403347099413 (37.7540003912143, -122.403347099413) 10 4 8 28859 19
127610 226368 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 4252 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6002219.8956 2101222.17774 37.7496813332396 -122.43513688726 (37.7496813332396, -122.43513688726) 2 4 5 28862 22
128146 226420 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 632 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007871.67107 2104237.72294 37.7582806479376 -122.415806280941 (37.7582806479376, -122.415806280941) 2 4 7 28859 19
129660 190687 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1001 Minnesota St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6015294.95519 2103873.52866 37.7576951695231 -122.390107654354 (37.7576951695231, -122.390107654354) 10 3 8 28856 29
130744 190698 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013440.07088 2106805.70814 37.7656432383768 -122.396728206061 (37.7656432383768, -122.396728206061) 14 3 8 28856 20
132381 229787 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1799 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005558.49234 2107230.4627 37.7663676926515 -122.424019094899 (37.7663676926515, -122.424019094899) 8 4 5 28853 19
134330 190745 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1617 Kirkwood Ave 1 : Tree Private 2     4 Width 3ft   6015075.48119 2096817.46152 37.7383085120296 -122.390373696315 (37.7383085120296, -122.390373696315) 10 3 8 58 1
143485 190686 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 801 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6014799.41703 2106205.91343 37.7640718970256 -122.391984541257 (37.7640718970256, -122.391984541257) 14 3 8 28856 29
143926 229768 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 38 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011450.10406 2102428.33109 37.7535129775571 -122.403303138733 (37.7535129775571, -122.403303138733) 10 4 8 28859 19
146544 190691 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1005 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6015298.33049 2103800.67785 37.757495323968 -122.390090891879 (37.757495323968, -122.390090891879) 10 3 8 28856 29
148052 229872 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3731 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004865.55222 2102495.62663 37.7533278053416 -122.426078745663 (37.7533278053416, -122.426078745663) 2 4 5 28862 22
153794 190695 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013444.76571 2106699.32295 37.7653513894931 -122.396704508917 (37.7653513894931, -122.396704508917) 14 3 8 28856 20
154249 228539 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1000 15th St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009212.74652 2107353.73928 37.7669118166657 -122.411388369502 (37.7669118166657, -122.411388369502) 8 4 7 28853 19
159008 190714 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 375 Texas St 2 : Tree Private 2     4 Width 5ft   6013800.48111 2105372.99908 37.7617293870175 -122.395381240171 (37.7617293870175, -122.395381240171) 10 3 8 28856 29
159856 229762 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 32 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011454.29465 2102314.61303 37.7532009667707 -122.403280647606 (37.7532009667707, -122.403280647606) 10 4 8 28859 19
168519 229779 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 49 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011439.17328 2102646.69218 37.75411193863 -122.403356300366 (37.75411193863, -122.403356300366) 10 4 8 28859 19
168980 226358 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 603 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006078.34429 2099888.6136 37.7462380152724 -122.421699497839 (37.7462380152724, -122.421699497839) 2 7 5 28859 2
171733 190694 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013445.19565 2106684.95045 37.7653119497171 -122.396702014197 (37.7653119497171, -122.396702014197) 14 3 8 28856 20
176891 190742 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1617 Kirkwood Ave 1 : Tree Private 2     4 Width 4ft   6015073.9615 2096817.26033 37.7383078753038 -122.390378936647 (37.7383078753038, -122.390378936647) 10 3 8 58 1
177993 228536 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1000 15th St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009279.45147 2107357.51638 37.7669259288053 -122.411157913712 (37.7669259288053, -122.411157913712) 8 4 7 28853 19
191365 226435 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 106 Bartlett St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006660.81941 2103136.07502 37.7551876321062 -122.419915770819 (37.7551876321062, -122.419915770819) 2 4 7 28859 19
193911 229755 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 23 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011464.24481 2102169.9708 37.7528043666378 -122.403236063707 (37.7528043666378, -122.403236063707) 10 4 8 28859 19
68716 50730 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 725 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM 4   Permit Number 47280 6012445.19576 2104545.72863 37.7593824136929 -122.400010559737 (37.7593824136929, -122.400010559737) 10 3 8 28856 29
26909 35338 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 738 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 4   Permit Number 38803 6013013.2913 2103555.40384 37.7566948554054 -122.397976322051 (37.7566948554054, -122.397976322051) 10 3 8 28856 29
109964 38604 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1556 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 4 3x3 Permit Number 50557 6015379.8321 2094216.5354 37.7311837737961 -122.389139834948 (37.7311837737961, -122.389139834948) 10 3 8 58 1
192737 38603 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1556 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 4 3x3 Permit Number 50557 6015358.9468 2094230.8253 37.7312218531881 -122.389213037195 (37.7312218531881, -122.389213037195) 10 3 8 58 1
66331 94180 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 605 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM 4 3x3 Permit Number 53586 6010991.81939 2105452.40233 37.7617907981332 -122.405100915002 (37.7617907981332, -122.405100915002) 10 3 8 28856 29
184626 88048 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1555 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51058 6015584.72865 2096785.64052 37.73824937351 -122.388610732819 (37.73824937351, -122.388610732819) 10 3 8 58 1
93777 32977 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 448 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 4   Permit Number 46744 6014321.91414 2105021.23892 37.7607925173727 -122.393553179256 (37.7607925173727, -122.393553179256) 10 3 8 28856 29
130836 62086 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 508 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM 4   Permit Number 22172 6013224.51154 2104585.93548 37.7595362319382 -122.397318105545 (37.7595362319382, -122.397318105545) 10 3 8 28856 29
139718 34979 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 204 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 4 4.5x5.5 Permit Number 38560 6005404.47969691 2102506.81993306 37.7533889843192 -122.424215816798 (37.7533889843192, -122.424215816798) 2 4 5 28859 19
99584 39586 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1011 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM 4   Permit Number 40997 6011941.43836 2103546.16349 37.7566097291779 -122.401682552328 (37.7566097291779, -122.401682552328) 10 3 8 28856 29
3571 102167 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 677 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769761 6002448.6 2104297.1 37.7581373205651 -122.4345658575 (37.7581373205651, -122.4345658575) 2 4 5 28862 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);