trees

39,840 rows where qLegalStatus_id = 7 sorted by PlotSize

✎ 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)
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
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                    
2204 92844 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 198 Anderson St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2009 12:00:00 AM     Permit Number 53065 6007909 2097721 37.7403892908842 -122.415215881965 (37.7403892908842, -122.415215881965) 2 7 7 28859 2
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                    
2228 48000 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1901 16th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45728 5991233.33873947 2102463.46573508 37.752459596695 -122.47321895744 (37.752459596695, -122.47321895744) 1 8 4 29491 12
2241 46289 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
2246 67733 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1373 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1992 12:00:00 AM     Permit Number 31352 5992380.40422552 2106114.34696678 37.7625503119139 -122.469517989556 (37.7625503119139, -122.469517989556) 1 8 11 56 12
2263 31189 Permitted Site 7 :: 45 744 Shields St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572) 9 8 6 64 24
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                    
2267 46716 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
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                    
2283 49626 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
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
2296 32307 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
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                    
2319 34069 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
2323 35205 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   16 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
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
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                    
2356 57206 Permitted Site 7 Myoporum laetum :: Myoporum 62 2202 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1975 12:00:00 AM     Permit Number 774014 6000908.32678769 2115906.78943665 37.7899270475037 -122.44072552972 (37.7899270475037, -122.44072552972) 13 6 1 29490 27
2358 35806 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 48 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39050 6006557.62447631 2105882.41132606 37.7627226190877 -122.420467579489 (37.7627226190877, -122.420467579489) 8 4 7 28859 19
2359 35980 Permitted Site 7 Olea europaea :: Olive Tree 9 349 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39134 6006399.96537133 2097866.62265006 37.740704214618 -122.420443871581 (37.740704214618, -122.420443871581) 2 7 7 28859 2
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
2380 51181 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 2550& VICENTE 24th Ave 32 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2004 12:00:00 AM     Permit Number 47565 5988957.29016327 2097975.36056036 37.7400043920325 -122.480761277613 (37.7400043920325, -122.480761277613) 1 8 3 29491 35
2396 61859 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1160 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1985 12:00:00 AM 8   Permit Number 21899 6010253.66087773 2102459.66274806 37.75353211276 -122.407442925811 (37.75353211276, -122.407442925811) 2 4 7 28859 19
2407 38882 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 101 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067) 11 6 1 54 31
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                    
2425 31630 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2482 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35147 5981478.22688702 2098193.22560061 37.7401650446812 -122.506636494986 (37.7401650446812, -122.506636494986) 1 8 3 29491 35
2426 100409 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
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                    
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                    
2453 49617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
2454 46118 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
2466 68381 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 42 Uranus Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32206 5999268.74613245 2105519.44927205 37.7613125625383 -122.445651023552 (37.7613125625383, -122.445651023552) 15 5 5 28862 3
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
2483 34134 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
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
2508 40281 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 379 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41433 6007237.3550509 2105117.81917656 37.7606615087743 -122.418062420589 (37.7606615087743, -122.418062420589) 2 4 7 28859 19
2509 27941 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 699 The Embarcadero 2 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
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                    
2521 32694 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3732 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37102 6004840.63533052 2102540.6946209 37.7534501432299 -122.426168121736 (37.7534501432299, -122.426168121736) 2 4 5 28862 22
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                    
2539 34247 Permitted Site 7 Auranticarpa rhombifolia :: Queensland Pittosporum 237 156 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1997 12:00:00 AM     Permit Number 38057 5989633.42177993 2114324.27605098 37.7849333758181 -122.479619426106 (37.7849333758181, -122.479619426106) 11 6 2 55 26
2542 32891 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1515 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37234 5994269.30013039 2105266.22888454 37.7603305839468 -122.462923499947 (37.7603305839468, -122.462923499947) 1 5 4 56 12
2544 49162 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 804 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.459789497745 (37.7277062535492, -122.459789497745) 9 7 4 28861 40
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                    
2552 42536 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 95 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42642 6006853.97359683 2109407.99798814 37.7724197439799 -122.419692774816 (37.7724197439799, -122.419692774816) 8 2 9 28853 19
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                    
2566 35200 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2570 60640 Permitted Site 7 Maytenus boaria :: Mayten 58 163 Fairmount St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20267 6004543.66233737 2097218.34669513 37.7388194121969 -122.426816108434 (37.7388194121969, -122.426816108434) 2 7 5 63 7
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                    
2583 34124 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
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
2602 42924 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
2603 50904 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2094 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47411 5991019.11429888 2101160.98347731 37.7488709142667 -122.473864759666 (37.7488709142667, -122.473864759666) 1 8 4 29491 12
2610 31853 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1263 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35300                    
2611 52930 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 36 Havelock St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM     Permit Number 48915 5999971.05699015 2092944.44477133 37.7268246780096 -122.442319255194 (37.7268246780096, -122.442319255194) 9 7 6 28861 25
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                    
2627 44717 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 1991 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM     Permit Number 43839 5989704.86545465 2101822.42727681 37.7506108546658 -122.478457743126 (37.7506108546658, -122.478457743126) 1 8 3 29491 35
2630 47383 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1515 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2003 12:00:00 AM     Permit Number 46367 6006307.07862293 2118296.63950756 37.7967949468883 -122.422216159163 (37.7967949468883, -122.422216159163) 13 9 10 28858 32
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                    
2677 36640 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
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
2708 50426 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Howth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778) 9 8 6 28861 24
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                    
2714 113322 Permitted Site 7 Olea europaea :: Olive Tree 9 100 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709) 7 9 5 28862 3
2715 57888 Permitted Site 7 Tree(s) :: 17 2382 Fost St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/1977 12:00:00 AM     Permit Number 16841                    
2716 48065 Permitted Site 7 Tree(s) :: 17   219 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2722 48074 Permitted Site 7 Tree(s) :: 17   240 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2746 44553 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2756 39703 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 634 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41088 5998596.64163755 2094795.02743762 37.7318275120035 -122.4472036828 (37.7318275120035, -122.4472036828) 9 7 4 59 40
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2763 48152 Permitted Site 7 Tree(s) :: 17   262 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2768 48107 Permitted Site 7 Tree(s) :: 17   202 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    

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