trees

1,626 rows where qSpecies_id = 53 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)
139096 51485 Permitted Site 7 Ficus nitida :: Laurel Fig 53 253 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2005 12:00:00 AM     Permit Number 47796 6004792.25802571 2102204.70843345 37.7525248690267 -122.426311501214 (37.7525248690267, -122.426311501214) 2 4 5 28862 22
139295 59013 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3755 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 20   Permit Number 18304 6005291.98683548 2104267.80164023 37.7582178764875 -122.424730106513 (37.7582178764875, -122.424730106513) 2 4 5 28859 19
140268 54410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1248 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/1972 12:00:00 AM     Permit Number 10182 5993332.64911234 2106987.54521442 37.765002872173 -122.46628801063 (37.765002872173, -122.46628801063) 11 8 11 56 12
140677 68840 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1506 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM     Permit Number 32793 6009553.56622839 2100554.07443475 37.7482605801949 -122.4097295193 (37.7482605801949, -122.4097295193) 2 4 7 28859 2
143054 57622 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
143541 28384 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
143577 55394 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2271 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2016 12:00:00 AM 3   Permit Number 778438 6002436.86184357 2107050.31699598 37.765696320564 -122.43480333738 (37.765696320564, -122.43480333738) 15 5 5 28862 3
143637 101724 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 10 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
144032 49294 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
145382 56574 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100x Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     14     6010338.9406 2121168.3232 37.8049064763082 -122.408467587357 (37.8049064763082, -122.408467587357) 3 1 10 308 23
145539 48701 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
147048 47565 Permitted Site 7 Ficus nitida :: Laurel Fig 53 920 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45425 6011901.71412119 2111593.71793264 37.7787042813354 -122.402385767126 (37.7787042813354, -122.402385767126) 14 2 9 28856 34
147296 49297 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
147353 52716 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
148171 110926 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2970 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 775246 5999959.8 2116452.8 37.79137218692 -122.444046586367 (37.79137218692, -122.444046586367) 13 6 1 29490 27
148453 52589 Permitted Site 7 Ficus nitida :: Laurel Fig 53 675 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2006 12:00:00 AM     Permit Number 774039 5997878.20498734 2108284.16023065 37.7688242695831 -122.450659631577 (37.7688242695831, -122.450659631577) 15 5 11 29492 9
149202 93146 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 4 Sidewalk: Curb side : Cutout Tree Private 2           5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
149401 55522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 484 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM     Permit Number 11483 6003594.27279224 2105459.16759406 37.7613930510814 -122.430686551957 (37.7613930510814, -122.430686551957) 15 4 5 28862 3
151649 49289 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
153427 40357 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 10 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
153446 44127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1455 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2000 12:00:00 AM     Permit Number 43631 6007204.94423628 2110535.86362082 37.7755363583765 -122.418558723581 (37.7755363583765, -122.418558723581) 8 2 9 28853 34
155520 58902 Permitted Site 7 Ficus nitida :: Laurel Fig 53 15 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1980 12:00:00 AM     Permit Number 18176 6005036.25199829 2101622.63318287 37.7509404143338 -122.425426308198 (37.7509404143338, -122.425426308198) 2 4 5 28862 22
156118 41200 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
156149 49237 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
157239 44224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43669 6012974 2118691 37.7982515579635 -122.399174613744 (37.7982515579635, -122.399174613744) 3 1 10 28860 6
158929 101720 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
160630 62897 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4123 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/1986 12:00:00 AM 7   Permit Number 23271 6001535.79254212 2105815.28492087 37.7622540264533 -122.437831469331 (37.7622540264533, -122.437831469331) 15 5 5 28862 3
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
161897 253634 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 830 Oak St 1 Sidewalk: Property side : Cutout tree DPW 1           6003018.63904 2109969.70237 37.7737452502421 -122.432999691851 (37.7737452502421, -122.432999691851) 15 5 11 29492 10
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
162853 105343 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2500X Post St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999969.06573 2113691.86409 37.7837919048286 -122.443816082596 (37.7837919048286, -122.443816082596) 15 6 11 29490 31
163580 116126 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
165793 39111 Permitted Site 7 Ficus nitida :: Laurel Fig 53 145 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM 20   Permit Number 40799 6006719.36046982 2102938.94159671 37.7546496469874 -122.41969933167 (37.7546496469874, -122.41969933167) 2 4 7 28859 19
165827 41193 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
166702 57580 Permitted Site 7 Ficus nitida :: Laurel Fig 53 6 Sharon St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1976 12:00:00 AM 10   Permit Number 16447 6003825.41823987 2107112.36179244 37.7659454174839 -122.430005049505 (37.7659454174839, -122.430005049505) 8 4 5 28862 3
168885 48703 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
169319 101719 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
170512 94219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 4 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
170923 109294 Significant Tree 6 Ficus nitida :: Laurel Fig 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
171777 96409 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
172294 110990 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
172671 49251 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
172909 106523 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 3 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
173047 71507 Undocumented 4 Ficus nitida :: Laurel Fig 53 3100 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1988 12:00:00 AM 12     6008781.55607863 2105099.68545767 37.7606985097306 -122.412720425202 (37.7606985097306, -122.412720425202) 2 4 7 28859 19
173070 50573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
174144 116127 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176391 55727 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2153 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM     Permit Number 11753 6003484.39561577 2107108.612602 37.7659158038039 -122.431184308511 (37.7659158038039, -122.431184308511) 15 4 5 28862 3
176915 101718 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
177069 49259 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
177096 51793 Permitted Site 7 Ficus nitida :: Laurel Fig 53 65 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2005 12:00:00 AM     Permit Number 48042 6005279.64463313 2105087.60921781 37.7604681781651 -122.42483111417 (37.7604681781651, -122.42483111417) 2 4 5 28859 19
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
177832 106521 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
177966 106938 Undocumented 4 Ficus nitida :: Laurel Fig 53 1607 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11     5997889 2108175 37.7685251613651 -122.450614421545 (37.7685251613651, -122.450614421545) 15 5 11 29492 9
178044 48952 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3046 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2002 12:00:00 AM 28   Permit Number 46137 6008657.12939462 2102169.92315078 37.7526470627455 -122.412943613067 (37.7526470627455, -122.412943613067) 2 4 7 28859 19
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
179159 101726 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
182282 32648 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
182731 40355 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
184329 173906 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1           6005854.79213 2118988.36383 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644) 13 9 1 28858 32
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
187242 44341 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2294 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM     Permit Number 43725 6002286.29088827 2107094.04279132 37.7658078311453 -122.435327256937 (37.7658078311453, -122.435327256937) 15 5 5 28862 3
189703 66879 Permitted Site 7 Ficus nitida :: Laurel Fig 53 277 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1991 12:00:00 AM     Permit Number 768127 6001144.84674667 2104743.15871911 37.7592879918503 -122.439106757133 (37.7592879918503, -122.439106757133) 2 4 5 28862 3
190125 52718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
190730 110993 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
191709 52838 Permitted Site 7 Ficus nitida :: Laurel Fig 53 795on Trenton Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48857 6010309.20673902 2118158.51574656 37.7966406195852 -122.408358059553 (37.7966406195852, -122.408358059553) 3 1 10 308 4
192243 94600 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1709 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2           5997540 2108126 37.7683706375079 -122.451818041345 (37.7683706375079, -122.451818041345) 15 5 11 29492 9
192777 48866 Permitted Site 7 Ficus nitida :: Laurel Fig 53 129 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM     Permit Number 46075 6006370.62112219 2110394.65908683 37.7751016387897 -122.421434823029 (37.7751016387897, -122.421434823029) 7 9 11 28852 10
193427 106524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 4 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
193861 44757 Permitted Site 7 Ficus nitida :: Laurel Fig 53 480 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43870 6003593.00847933 2105481.98628904 37.7614556341181 -122.430692553071 (37.7614556341181, -122.430692553071) 15 4 5 28862 3
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
105017 13309 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 2 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
107261 18696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 3 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
113625 13308 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 1 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
156516 13310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 3 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
171543 18697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 4 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
103514 4559 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 10x6   6005144.0595933 2101075.0968609 37.7494430966122 -122.425014546007 (37.7494430966122, -122.425014546007) 2 4 5 28862 22
163968 16919 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 500 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 13x6   6004493.27484 2110185.04209 37.7744200538695 -122.427914040239 (37.7744200538695, -122.427914040239) 7 9 11 28852 10
14328 104230 Undocumented 4 Ficus nitida :: Laurel Fig 53 409 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       14x8   5998587.6 2115205.6 37.787869332154 -122.448704479556 (37.787869332154, -122.448704479556) 13 6 1 54 31
160258 6989 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 848 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15x3.5   6003368.38608 2110385.91832 37.7749079085756 -122.431819586637 (37.7749079085756, -122.431819586637) 15 9 11 29492 10
142871 18385 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 812 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 16x5   6010402.1602537 2104496.7929466 37.759133928444 -122.407072960308 (37.759133928444, -122.407072960308) 10 4 7 28859 19
77697 26275 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1770 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 1X1   6000824.4471487 2093863.5491185 37.7293969298827 -122.439434969516 (37.7293969298827, -122.439434969516) 9 7 6 28861 25
13581 113413 Undocumented 4 Ficus nitida :: Laurel Fig 53 16X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2     7 1x1   6008359 2116497 37.7919691052865 -122.414988572568 (37.7919691052865, -122.414988572568) 5 1 10 28858 21
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
129658 5136 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2842 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 1x1   6002395.52907 2095496.33738 37.7339694804636 -122.434120273378 (37.7339694804636, -122.434120273378) 2 7 5 63 7
130690 109005 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
140999 109004 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 5 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
141541 109003 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
184960 109002 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
92133 62276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 124 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/1985 12:00:00 AM 13 21x6 Permit Number 22414 6003841.87853288 2108837.79837285 37.7706839798213 -122.430071215032 (37.7706839798213, -122.430071215032) 7 9 11 29492 10

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