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)
1840 35278 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
1847 57850 Permitted Site 7 Tree(s) :: 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1977 12:00:00 AM     Permit Number 16791                    
1883 55293 Permitted Site 7 Tree(s) :: 17 1278 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11219 5988350.42063123 2106618.18291031 37.7636999785063 -122.483493006804 (37.7636999785063, -122.483493006804) 1 8 3 56 35
1892 124739 DPW Maintained 1 Tree(s) :: 17 999 Brannan St 8 Sidewalk: Curb side : Cutout Tree Private 2           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328) 14 2 9 28853 34
1904 48103 Permitted Site 7 Tree(s) :: 17   212 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1917 46148 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
1934 44589 Permitted Site 7 Tree(s) :: 17   117 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1956 44540 Permitted Site 7 Tree(s) :: 17   29 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1964 48189 Permitted Site 7 Tree(s) :: 17   43 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1968 44918 Permitted Site 7 Tree(s) :: 17   183 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1970 260506 DPW Maintained 1 Tree(s) :: 17 289 08th St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6009625.74334 2110365.68554 37.7752050776892 -122.41017254363 (37.7752050776892, -122.41017254363) 8 2 9 28853 34
1975 48204 Permitted Site 7 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1984 48220 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1986 45957 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1987 44951 Permitted Site 7 Tree(s) :: 17   64 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1988 53775 Permitted Site 7 Tree(s) :: 17 358 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1972 12:00:00 AM     Permit Number 9461 5992772.54452217 2094326.15826887 37.7302056116577 -122.467304539962 (37.7302056116577, -122.467304539962) 9 8 4 59 40
2001 35044 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2010 260603 DPW Maintained 1 Tree(s) :: 17 1162 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013406.09782 2090446.93369 37.7207235989971 -122.395699409803 (37.7207235989971, -122.395699409803) 10 3 8 58 1
2014 54352 Permitted Site 7 Tree(s) :: 17 1225 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/1972 12:00:00 AM     Permit Number 10116 5994514.2261377 2107168.64010197 37.765568215693 -122.462214395283 (37.765568215693, -122.462214395283) 11 5 11 56 12
2022 96361 Permitted Site 7 Tree(s) :: 17 3998 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2011 12:00:00 AM 18 3x3 Permit Number 767776 6003180 2101862 37.7514926068818 -122.43186249165 (37.7514926068818, -122.43186249165) 2 4 5 28862 22
2031 48316 Permitted Site 7 Tree(s) :: 17   182 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2033 35052 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2043 66343 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/1990 12:00:00 AM     Permit Number 29464                    
2045 58189 Permitted Site 7 Tree(s) :: 17 1886 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/1978 12:00:00 AM     Permit Number 17176 5983531.02908859 2102317.07249767 37.751608654204 -122.499843586703 (37.751608654204, -122.499843586703) 1 8 3 56 35
2049 54416 Permitted Site 7 Tree(s) :: 17 1434 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 10189 5993066.16109228 2105705.87123128 37.761468352883 -122.467116526016 (37.761468352883, -122.467116526016) 1 8 4 56 12
2057 111315 Section 806 (d) 5 Tree(s) :: 17 3400x Wawona St 3 Sidewalk: Property side : Cutout Tree Private 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35
2066 55924 Permitted Site 7 Tree(s) :: 17 524 Morgan Aly 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1973 12:00:00 AM     Permit Number 11988                    
2073 61706 Permitted Site 7 Tree(s) :: 17 577 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1984 12:00:00 AM     Permit Number 21705 6005012.13015345 2107778.74606637 37.7678422856405 -122.42594789448 (37.7678422856405, -122.42594789448) 8 4 5 28853 19
2076 44958 Permitted Site 7 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2090 260628 DPW Maintained 1 Tree(s) :: 17 1251 Revere Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6016934.60308 2092996.85523 37.7279208386687 -122.383679778477 (37.7279208386687, -122.383679778477) 10 3 8 58 1
2102 48160 Permitted Site 7 Tree(s) :: 17   270 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2110 42133 Permitted Site 7 Tree(s) :: 17 69 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM     Permit Number 42429 6003074.74673035 2107378.43779911 37.7666334554934 -122.43262047379 (37.7666334554934, -122.43262047379) 15 5 5 28862 3
2113 44856 Permitted Site 7 Tree(s) :: 17   33 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2146 45914 Permitted Site 7 Tree(s) :: 17   33 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2153 100644 Permitted Site 7 Tree(s) :: 17 401X Clementina St 14 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
2161 64075 Permitted Site 7 Tree(s) :: 17 370 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1987 12:00:00 AM     Permit Number 24835 5989375.82342137 2112846.61573071 37.7808611682899 -122.480402425995 (37.7808611682899, -122.480402425995) 11 6 2 55 26
2163 48471 Permitted Site 7 Tree(s) :: 17   15 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
2170 44902 Permitted Site 7 Tree(s) :: 17   136 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2177 44598 Permitted Site 7 Tree(s) :: 17   126 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2183 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard Tree Private 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
2186 63797 Permitted Site 7 Tree(s) :: 17 421 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777883 6008940.7134803 2096355.4647327 37.7366977566747 -122.411552156486 (37.7366977566747, -122.411552156486) 10 7 7 28859 2
2187 46061 Permitted Site 7 Tree(s) :: 17   103 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2189 48278 Permitted Site 7 Tree(s) :: 17   88 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2196 48265 Permitted Site 7 Tree(s) :: 17   129 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2200 54869 Permitted Site 7 Tree(s) :: 17 1967 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1972 12:00:00 AM     Permit Number 10729 5998462.86042081 2109983.76069669 37.773524386553 -122.448759792732 (37.773524386553, -122.448759792732) 15 5 11 29492 16
2201 107549 Significant Tree 6 Tree(s) :: 17 198X Jennings St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
2203 45984 Permitted Site 7 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2210 53264 Permitted Site 7 Tree(s) :: 17 523 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1969 12:00:00 AM     Permit Number 6154 5993474.77624345 2089341.33970508 37.7165590253308 -122.464515046881 (37.7165590253308, -122.464515046881) 9 8 6 64 24
2216 63596 Permitted Site 7 Tree(s) :: 17 253 Wallber St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/1987 12:00:00 AM     Permit Number 24230                    
2225 44536 Permitted Site 7 Tree(s) :: 17   33 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2226 44987 Permitted Site 7 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2230 256764 Undocumented 4 Tree(s) :: 17 25 Serrano Dr 1 Sidewalk: Property side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 6x6 Permit Number 782398 5990027 2090605 37.7198293671123 -122.476524410241 (37.7198293671123, -122.476524410241) 1 8 4 64 14
2247 88999 Permitted Site 7 Tree(s) :: 17 2218 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM   3x3 Permit Number 51747 5999369 2116393 37.7911742716773 -122.446086430907 (37.7911742716773, -122.446086430907) 13 6 1 29490 27
2265 48308 Permitted Site 7 Tree(s) :: 17   174 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2269 58628 Permitted Site 7 Tree(s) :: 17 1240 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1979 12:00:00 AM     Permit Number 17846 5998229.96040674 2106129.9560019 37.7629294984974 -122.449287716214 (37.7629294984974, -122.449287716214) 15 5 11 29492 9
2275 46014 Permitted Site 7 Tree(s) :: 17   200 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2277 44912 Permitted Site 7 Tree(s) :: 17   185 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2287 63935 Permitted Site 7 Tree(s) :: 17 4086 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/1992 12:00:00 AM     Permit Number 31216 6003335.30229838 2100703.31540535 37.7483199335724 -122.431242739217 (37.7483199335724, -122.431242739217) 2 4 5 28862 22
2294 84947 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
2295 193115 Private 9 Tree(s) :: 17 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014511.3912 2096886.32335 37.7384662854853 -122.392328872775 (37.7384662854853, -122.392328872775) 10 3 8 58 1
2318 61432 Permitted Site 7 Tree(s) :: 17 234 La Espiral St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1984 12:00:00 AM     Permit Number 21363                    
2328 57118 Permitted Site 7 Tree(s) :: 17 567 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM     Permit Number 14388 6001433.85993869 2090479.06392424 37.7201385647203 -122.437085957535 (37.7201385647203, -122.437085957535) 9 7 6 28861 5
2335 262272 Undocumented 4 Tree(s) :: 17 99X Glendale St   Unaccepted Street : Yard Tree Private 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
2336 59785 Permitted Site 7 Tree(s) :: 17 237 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1981 12:00:00 AM     Permit Number 19234 6003567.2308667 2106887.18352857 37.7653125069264 -122.430881994524 (37.7653125069264, -122.430881994524) 8 4 5 28862 3
2339 44535 Permitted Site 7 Tree(s) :: 17   34 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2366 45917 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2371 57894 Permitted Site 7 Tree(s) :: 17 972 Terminal Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/1977 12:00:00 AM     Permit Number 16848                    
2375 58506 Permitted Site 7 Tree(s) :: 17 1378 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1979 12:00:00 AM     Permit Number 17681 5999108.40955672 2108391.40839874 37.7691890857648 -122.446412174677 (37.7691890857648, -122.446412174677) 15 5 11 29492 9
2424 61752 Permitted Site 7 Tree(s) :: 17 3014 Rolison Road 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1984 12:00:00 AM     Permit Number 21763                    
2434 44999 Permitted Site 7 Tree(s) :: 17   103 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2436 102404 Undocumented 4 Tree(s) :: 17 95X Harriet St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010704.6 2111649.2 37.7787897224959 -122.406530981243 (37.7787897224959, -122.406530981243) 14 2 9 28853 34
2445 48349 Permitted Site 7 Tree(s) :: 17   152 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2451 44962 Permitted Site 7 Tree(s) :: 17   75 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2478 110785 Permitted Site 7 Tree(s) :: 17 2 Edna St 2 Front Yard : Yard Tree Private 2   05/06/2015 12:00:00 AM 3     5998788.4 2092979.9 37.7268545527586 -122.446410203741 (37.7268545527586, -122.446410203741) 9 7 4 28861 40
2499 55575 Permitted Site 7 Tree(s) :: 17 622 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM     Permit Number 11546 6010538.99497753 2108399.45644768 37.7698574135988 -122.40687477594 (37.7698574135988, -122.40687477594) 8 2 9 28853 19
2516 45863 Permitted Site 7 Tree(s) :: 17   85 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2524 30480 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
2534 48332 Permitted Site 7 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2549 31437 Permitted Site 7 Tree(s) :: 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
2554 48167 Permitted Site 7 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2559 48211 Permitted Site 7 Tree(s) :: 17   54 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2565 208921 DPW Maintained 1 Tree(s) :: 17 135 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2   06/20/2019 12:00:00 AM 3 Width 10ft Permit Number 782931 5992336.36345 2096045.4635 37.7349012047205 -122.46893753225 (37.7349012047205, -122.46893753225) 1 8 4 59 40
2573 60778 Permitted Site 7 Tree(s) :: 17 3933 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1983 12:00:00 AM     Permit Number 20448                    
2586 66958 Permitted Site 7 Tree(s) :: 17 283 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1992 12:00:00 AM     Permit Number 30294 5994190.17633556 2087741.03649596 37.7122061872577 -122.461926308953 (37.7122061872577, -122.461926308953) 9 8 6 28861 24
2598 95032 - 12 Tree(s) :: 17 211 Maynard St   Front Yard : Cutout Landscaping Private 2           6004772 2093802 37.7294517978782 -122.425783519869 (37.7294517978782, -122.425783519869) 9 7 6 28861 5
2612 48088 Permitted Site 7 Tree(s) :: 17   198 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2620 51785 Permitted Site 7 Tree(s) :: 17 420 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2016 12:00:00 AM 3 3x3 Permit Number 778374 6010026.23225515 2092550.41971829 37.7263107399458 -122.407530840994 (37.7263107399458, -122.407530840994) 10 3 7 309 28
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2646 44909 Permitted Site 7 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2656 44646 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2660 62615 Permitted Site 7 Tree(s) :: 17 1868 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1986 12:00:00 AM     Permit Number 22925 5993167.63363514 2102765.07828361 37.7533995564178 -122.466551819518 (37.7533995564178, -122.466551819518) 1 8 4 56 12
2664 45874 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2666 48202 Permitted Site 7 Tree(s) :: 17   45 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2667 66672 Permitted Site 7 Tree(s) :: 17 4307 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM     Permit Number 29892                    
2690 44593 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2691 58348 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/1978 12:00:00 AM     Permit Number 17373                    
2697 49874 Permitted Site 7 Tree(s) :: 17 0@ 14th ST Trainor St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2003 12:00:00 AM     Permit Number 46642                    
2702 48207 Permitted Site 7 Tree(s) :: 17   50 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2705 54005 Permitted Site 7 Tree(s) :: 17 515 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9724 6003024.81931846 2102680.10849791 37.7537301410207 -122.432457552268 (37.7537301410207, -122.432457552268) 2 4 5 28862 22
2710 44606 Permitted Site 7 Tree(s) :: 17   170 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    

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