trees

11,761 rows where qSpecies_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

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)
855 48153 Permitted Site 7 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
870 65298 Permitted Site 7 Tree(s) :: 17 601 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM     Permit Number 28112 6004986.98138427 2104867.56644754 37.7598474581316 -122.42582763941 (37.7598474581316, -122.42582763941) 2 4 5 28859 19
892 44903 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 Permitted Site 7 Tree(s) :: 17   62 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 Permitted Site 7 Tree(s) :: 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
928 67058 Permitted Site 7 Tree(s) :: 17 180 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1992 12:00:00 AM   3x3 Permit Number 30439 6009767.36044891 2111443.36861251 37.7781720795529 -122.409758741886 (37.7781720795529, -122.409758741886) 8 2 9 28853 34
947 60023 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
960 45842 Permitted Site 7 Tree(s) :: 17   84 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 Permitted Site 7 Tree(s) :: 17   141 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
972 58852 Permitted Site 7 Tree(s) :: 17 198 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/1979 12:00:00 AM     Permit Number 18111 6007897.70750463 2097731.51362688 37.7404175243374 -122.415255671137 (37.7404175243374, -122.415255671137) 2 7 7 28859 2
974 48301 Permitted Site 7 Tree(s) :: 17   167 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
983 44952 Permitted Site 7 Tree(s) :: 17   65 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1007 44545 Permitted Site 7 Tree(s) :: 17   24 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1011 45966 Permitted Site 7 Tree(s) :: 17   157 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1035 44875 Permitted Site 7 Tree(s) :: 17   148 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1052 65988 Permitted Site 7 Tree(s) :: 17 121 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1990 12:00:00 AM     Permit Number 29018 5995709.58889373 2096251.06183698 37.7356600432467 -122.457290053496 (37.7356600432467, -122.457290053496) 9 7 4 59 40
1064 44650 Permitted Site 7 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1066 49147 Permitted Site 7 Tree(s) :: 17 201REVISED Elmira St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2003 12:00:00 AM     Permit Number 46271 6011255.32647148 2095465.44056571 37.7343834996245 -122.40348689328 (37.7343834996245, -122.40348689328) 10 3 8 58 1
1072 227637 DPW Maintained 1 Tree(s) :: 17 326 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2020 12:00:00 AM 3 Width 5ft Permit Number 785527 6006174.20556 2101172.48753 37.7497686457084 -122.421459183712 (37.7497686457084, -122.421459183712) 2 4 5 28859 19
1091 44966 Permitted Site 7 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1100 55205 Permitted Site 7 Tree(s) :: 17 44 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11118                    
1105 106501 Undocumented 4 Tree(s) :: 17 1266 09TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993358 2106830.8 37.764573953722 -122.46618893715 (37.764573953722, -122.46618893715) 11 8 11 56 12
1116 65831 Permitted Site 7 Tree(s) :: 17 2200 North Point 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM     Permit Number 28821                    
1129 44885 Permitted Site 7 Tree(s) :: 17   158 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1135 48105 Permitted Site 7 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1136 57990 Permitted Site 7 Tree(s) :: 17 19 Bausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1977 12:00:00 AM     Permit Number 16955                    
1148 33928 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1162 36561 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
1165 44567 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1185 183249 DPW Maintained 1 Tree(s) :: 17 2100 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 Width 0ft Permit Number 782167 5984206.7159 2100608.9365 37.7469582109652 -122.4973809226 (37.7469582109652, -122.4973809226) 1 8 3 29491 35
1186 45889 Permitted Site 7 Tree(s) :: 17   18 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1208 54959 Permitted Site 7 Tree(s) :: 17 1571 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/1972 12:00:00 AM     Permit Number 10837 5982474.94240495 2104427.27217039 37.7573406377263 -122.503651864556 (37.7573406377263, -122.503651864556) 1 8 3 56 35
1228 65998 Permitted Site 7 Tree(s) :: 17 2551 Beacon St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1990 12:00:00 AM     Permit Number 29030                    
1249 107933 DPW Maintained 1 Tree(s) :: 17 3098X Market St 1 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
1255 66098 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1990 12:00:00 AM     Permit Number 29146                    
1261 45997 Permitted Site 7 Tree(s) :: 17   115 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1275 46058 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1287 48142 Permitted Site 7 Tree(s) :: 17   252 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1292 102259 DPW Maintained 1 Tree(s) :: 17 904 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2013 12:00:00 AM 9 3x3 Permit Number 769677 6003013.4 2111448.1 37.7778042661218 -122.433123466086 (37.7778042661218, -122.433123466086) 15 9 11 29492 41
1314 67685 Permitted Site 7 Tree(s) :: 17 766 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1992 12:00:00 AM     Permit Number 31289 5997024.37469935 2095029.17182905 37.7323804536882 -122.452656198743 (37.7323804536882, -122.452656198743) 9 7 4 59 40
1321 48199 Permitted Site 7 Tree(s) :: 17   58 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1324 109608 DPW Maintained 1 Tree(s) :: 17 30 Curtis St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2018 12:00:00 AM 3 3x3 Permit Number 781648 6000500.58572 2088469.85865 37.7145686465987 -122.440167960077 (37.7145686465987, -122.440167960077) 9 7 6 28861 5
1347 109892 Permitted Site 7 Tree(s) :: 17 205 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2015 12:00:00 AM 3 3x6   5995308.1 2091295.6 37.7220304751495 -122.458319579925 (37.7220304751495, -122.458319579925) 9 8 4 28861 24
1349 208257 DPW Maintained 1 Tree(s) :: 17 15 San Lorenzo Way 1 Sidewalk: Curb side : Yard Tree Private 2   07/14/2020 12:00:00 AM 3 Width 6ft Permit Number 785533 5993769.83021 2097726.79063 37.7396004268184 -122.464103589926 (37.7396004268184, -122.464103589926) 1 8 4 59 40
1356 44935 Permitted Site 7 Tree(s) :: 17   168 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1357 54090 Permitted Site 7 Tree(s) :: 17 115 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9817 5991911.06498332 2095358.19732765 37.7329895631391 -122.47035789011 (37.7329895631391, -122.47035789011) 9 8 4 59 40
1361 105851 Undocumented 4 Tree(s) :: 17 2590 16TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991465.4 2097806.4 37.7396859298071 -122.472077039908 (37.7396859298071, -122.472077039908) 1 8 4 29491 40
1372 48323 Permitted Site 7 Tree(s) :: 17   189 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1381 84767 Permitted Site 7 Tree(s) :: 17 185 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
1386 67784 Permitted Site 7 Tree(s) :: 17 1030 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1992 12:00:00 AM     Permit Number 31421                    
1392 48291 Permitted Site 7 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1395 33932 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1397 44933 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1411 44977 Permitted Site 7 Tree(s) :: 17   49 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1413 48094 Permitted Site 7 Tree(s) :: 17   218 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1430 67640 Permitted Site 7 Tree(s) :: 17 66 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1992 12:00:00 AM     Permit Number 31239 5999465.40351772 2088851.00886819 37.7155562089288 -122.443773323232 (37.7155562089288, -122.443773323232) 9 7 6 28861 25
1431 60090 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1982 12:00:00 AM     Permit Number 19591                    
1446 44592 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1451 44942 Permitted Site 7 Tree(s) :: 17   175 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1459 46036 Permitted Site 7 Tree(s) :: 17   110 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1461 44992 Permitted Site 7 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1465 45986 Permitted Site 7 Tree(s) :: 17   226 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1479 44582 Permitted Site 7 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1498 44556 Permitted Site 7 Tree(s) :: 17   19 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1508 48345 Permitted Site 7 Tree(s) :: 17   162 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1527 155727 DPW Maintained 1 Tree(s) :: 17 251 Upland Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787672 5993647.1889 2094105.14579 37.7296492188193 -122.464264763718 (37.7296492188193, -122.464264763718) 9 8 4 59 40
1552 63329 Permitted Site 7 Tree(s) :: 17 225 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1987 12:00:00 AM     Permit Number 23902                    
1555 61775 Permitted Site 7 Tree(s) :: 17 157 Lacrosse Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/1984 12:00:00 AM     Permit Number 21796                    
1559 68149 Permitted Site 7 Tree(s) :: 17 306 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM     Permit Number 31907 5992597.64738181 2094843.40601485 37.731615747375 -122.467946785243 (37.731615747375, -122.467946785243) 9 8 4 59 40
1575 57819 Permitted Site 7 Tree(s) :: 17 3025 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/1977 12:00:00 AM     Permit Number 16758 5985127.82530714 2105650.40400841 37.7608546360174 -122.494567452266 (37.7608546360174, -122.494567452266) 1 8 3 56 35
1579 45978 Permitted Site 7 Tree(s) :: 17   129 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1583 57636 Permitted Site 7 Tree(s) :: 17 358 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/1976 12:00:00 AM     Permit Number 16534 6001116.64364888 2104248.07049337 37.7579269953626 -122.439168812397 (37.7579269953626, -122.439168812397) 2 4 5 28862 38
1615 44603 Permitted Site 7 Tree(s) :: 17   121 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1626 56962 Permitted Site 7 Tree(s) :: 17 409 Dellbrook Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/1974 12:00:00 AM     Permit Number 14214 5997128.15585412 2102761.97155727 37.7536187770602 -122.452855347756 (37.7536187770602, -122.452855347756) 1 5 4 63 38
1630 208995 DPW Maintained 1 Tree(s) :: 17 21 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2   09/28/2020 12:00:00 AM 3 Width 4ft Permit Number 784904 5993486.0432 2097190.73028 37.7381121792369 -122.465045871672 (37.7381121792369, -122.465045871672) 1 8 4 59 40
1642 92622 Permitted Site 7 Tree(s) :: 17 1150 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2009 12:00:00 AM   3x3 Permit Number 52926 6002360 2112465 37.7805593321564 -122.43545656304 (37.7805593321564, -122.43545656304) 15 5 11 29490 41
1643 44855 Permitted Site 7 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1674 48081 Permitted Site 7 Tree(s) :: 17   245 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1691 63071 Permitted Site 7 Tree(s) :: 17 71 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/1986 12:00:00 AM     Permit Number 23549 6008174.41886116 2098235.80863024 37.741817754914 -122.414334581564 (37.741817754914, -122.414334581564) 2 7 7 28859 2
1700 64639 Permitted Site 7 Tree(s) :: 17 465 Convention Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1988 12:00:00 AM     Permit Number 25552                    
1701 54592 DPW Maintained 1 Tree(s) :: 17 329 Mississippi St 1 Front Yard : Cutout Tree Private 2   03/26/2020 12:00:00 AM 3 3x4 Permit Number 785178 6014074.3359 2105511.64681 37.7621253108683 -122.394443787777 (37.7621253108683, -122.394443787777) 10 3 8 28856 29
1703 48311 Permitted Site 7 Tree(s) :: 17   177 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1730 121323 Undocumented 4 Tree(s) :: 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
1743 55199 Permitted Site 7 Tree(s) :: 17 28 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM     Permit Number 11112                    
1747 44960 Permitted Site 7 Tree(s) :: 17   61 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1748 56640 Permitted Site 7 Tree(s) :: 17 2016 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2           6004277.89575757 2115357.17634953 37.7886092629589 -122.429027916831 (37.7886092629589, -122.429027916831) 13 9 11 29490 27
1752 865 DPW Maintained 1 Tree(s) :: 17 600X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 1X1   6006086.2852895 2094767.6237118 37.7321773712618 -122.421308445577 (37.7321773712618, -122.421308445577) 2 7 7 28861 2
1760 44538 Permitted Site 7 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1766 208988 DPW Maintained 1 Tree(s) :: 17 90 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   09/28/2020 12:00:00 AM 3 Width 4ft Permit Number 784904 5993940 2096795 37.7370517679821 -122.463447618301 (37.7370517679821, -122.463447618301) 1 8 4 59 40
1773 116537 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
1784 44653 Permitted Site 7 Tree(s) :: 17   73 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1795 44610 Permitted Site 7 Tree(s) :: 17   174 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1802 68847 Permitted Site 7 Tree(s) :: 17 2118 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1993 12:00:00 AM     Permit Number 32810                    
1815 44628 Permitted Site 7 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1821 48173 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1829 55200 Permitted Site 7 Tree(s) :: 17 32 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11113                    
1831 48269 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    

Next page

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)
);