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)
74708 52076 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2005 12:00:00 AM     Permit Number 48272 6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
75083 46223 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1888 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
76306 108943 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
77443 111583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
77904 56931 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1909 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 17   Permit Number 14175 6004317.92538 2118019.69798 37.795922137343 -122.429079333669 (37.795922137343, -122.429079333669) 13 9 1 28858 27
78771 41194 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 9 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
79179 41198 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 2 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
79373 29910 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 791x Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12     6008575.10006 2120353.42874 37.8025700449008 -122.414513871045 (37.8025700449008, -122.414513871045) 3 1 10 308 32
79471 59271 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2017 12:00:00 AM 3   Permit Number 18607 6004280.88948873 2109181.36087728 37.7716521728269 -122.428577162778 (37.7716521728269, -122.428577162778) 7 9 11 28852 10
79513 47917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 999 Revised) Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2002 12:00:00 AM     Permit Number 45655 6006486.39229912 2113910.68802822 37.7847623267063 -122.421284078173 (37.7847623267063, -122.421284078173) 13 9 11 28858 41
80144 96411 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2012 12:00:00 AM     Permit Number 768662 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 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
82003 41199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 3 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
82985 51836 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
83229 51761 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2005 12:00:00 AM 8   Permit Number 48028 6011451.43524212 2112543.5849209 37.781287248696 -122.404010328515 (37.781287248696, -122.404010328515) 6 2 9 28853 34
83380 40353 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 13 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
83449 106526 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 6 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
84466 64020 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2344 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 778144 6002015 2107091 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372) 15 5 5 28862 3
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 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
85440 96410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767718 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
85569 48875 Permitted Site 7 Ficus nitida :: Laurel Fig 53 650 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2002 12:00:00 AM     Permit Number 46082 6002579.05689486 2108874.6714316 37.7707136224387 -122.434441965818 (37.7707136224387, -122.434441965818) 15 5 11 29492 9
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
87085 101725 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
87883 120156 Significant Tree 6 Ficus nitida :: Laurel Fig 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
88657 110984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
89965 116128 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 4 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
90078 111115 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2085 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     10     5997903.58032533 2109906.22418863 37.7732794935428 -122.450688824407 (37.7732794935428, -122.450688824407) 15 5 11 29492 16
90722 56236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 147 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/1973 12:00:00 AM 24   Permit Number 12362 6006719.97734959 2102927.77810186 37.7546190293471 -122.419696406291 (37.7546190293471, -122.419696406291) 2 4 7 28859 19
90878 106915 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772728 5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 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
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 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
95808 48700 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 12 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
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 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
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 6
97537 58524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1544 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM     Permit Number 17701 5998255.7040764 2108272.5838384 37.7688140844915 -122.449353060877 (37.7688140844915, -122.449353060877) 15 5 11 29492 9
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
98717 33718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 25 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM 13   Permit Number 37786 6004139.32588988 2108866.31797637 37.7707791293659 -122.429044373837 (37.7707791293659, -122.429044373837) 7 9 11 29492 10
100042 40805 Permitted Site 7 Ficus nitida :: Laurel Fig 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
100521 111578 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
100582 48699 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 11 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
101116 107368 Undocumented 4 Ficus nitida :: Laurel Fig 53 660 OFARRELL ST   Sidewalk: Curb side : Cutout Tree Private 2           6008096 2114145 37.7854963051764 -122.415731945695 (37.7854963051764, -122.415731945695) 13 10 9 28858 36
101430 111584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
102319 61449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330-1332 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/1984 12:00:00 AM     Permit Number 21384 6002514.93546023 2101705.58374617 37.7510254010171 -122.434151182595 (37.7510254010171, -122.434151182595) 2 4 5 28862 22
103473 55732 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2229 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 20   Permit Number 11758 6002695.31984114 2107064.65711257 37.7657503654861 -122.433910413324 (37.7657503654861, -122.433910413324) 15 5 5 28862 3
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 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
104097 62645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 400 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25453 6000705.45672766 2110331.40246789 37.7746069085927 -122.441027287197 (37.7746069085927, -122.441027287197) 15 5 11 29492 10
105203 107284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2260 JACKSON ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6003354.3 2116979.4 37.7930111519645 -122.432339323402 (37.7930111519645, -122.432339323402) 13 9 1 29490 27
105841 93144 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2016 12:00:00 AM 3     5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
105989 101717 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
105995 96408 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
107111 44172 Permitted Site 7 Ficus nitida :: Laurel Fig 53 59 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM     Permit Number 43639 6003760.97911216 2095401.48581894 37.733786440894 -122.429392732684 (37.733786440894, -122.429392732684) 2 7 5 28861 25
107245 58071 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4545 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM 13   Permit Number 17041 6000791.5456109 2105188.83821507 37.7604916091053 -122.440360603481 (37.7604916091053, -122.440360603481) 2 4 5 28862 3
107778 51837 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
110473 49870 Permitted Site 7 Ficus nitida :: Laurel Fig 53 607@ JACKSON Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2003 12:00:00 AM     Permit Number 46636 6012838.36008757 2118235.08187981 37.7969921557212 -122.399611944085 (37.7969921557212, -122.399611944085) 3 1 10 28860 6
111149 53710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4067 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1970 12:00:00 AM 14   Permit Number 6657 6002578.30950532 2104703.42856113 37.7592603634983 -122.434146313573 (37.7592603634983, -122.434146313573) 2 4 5 28862 3
111853 99974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114328 50197 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3279@ DOLORES 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2003 12:00:00 AM     Permit Number 46903 6005006.02996154 2106599.52754391 37.7646040888867 -122.425885045341 (37.7646040888867, -122.425885045341) 8 4 5 28859 19
114688 49239 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 10 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
115288 107652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
115348 50571 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
116014 107653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
116714 59226 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 530 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 779363 5992552.44717 2111818.61025 37.7782226338783 -122.469338181035 (37.7782226338783, -122.469338181035) 11 6 2 54 11
117139 49290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 10 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
118155 49258 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 8 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
118656 96541 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
118796 65046 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2498 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1989 12:00:00 AM 18   Permit Number 26099 6008837.93100399 2103923.47328543 37.7574720629103 -122.412442306383 (37.7574720629103, -122.412442306383) 2 4 7 28859 19
119477 106916 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2015 12:00:00 AM 3     5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
120103 40159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2211 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1999 12:00:00 AM     Permit Number 41353 6009783.18603588 2121626.8328918 37.8061342908169 -122.410423240295 (37.8061342908169, -122.410423240295) 3 1 10 308 23
120502 57735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 364 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 16   Permit Number 31982 6005454.9599493 2101588.78174199 37.7508711140338 -122.423975967283 (37.7508711140338, -122.423975967283) 2 4 5 28859 19
121115 94298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
121552 117206 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
122731 100106 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
122961 53708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 350 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1970 12:00:00 AM 36   Permit Number 6655 6003550.85725641 2106242.74617004 37.7635421097395 -122.430892631532 (37.7635421097395, -122.430892631532) 15 4 5 28862 3
125521 49234 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 29 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
126032 110991 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
127089 108101 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 3 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
128922 49236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 21 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
129156 116906 Permitted Site 7 Ficus nitida :: Laurel Fig 53 358 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2     30     6003554.93862357 2108664.35445356 37.7701914899734 -122.431051362966 (37.7701914899734, -122.431051362966) 15 9 11 29492 10
129369 94220 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 5 Sidewalk: Property side : Pot Tree Private 2         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
129463 49287 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 3 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
129993 49238 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 16 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
130680 59674 Permitted Site 7 Ficus nitida :: Laurel Fig 53 358 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1981 12:00:00 AM 26   Permit Number 19100 6003554.93862357 2108664.35445356 37.7701914899734 -122.431051362966 (37.7701914899734, -122.431051362966) 15 9 11 29492 10
131150 51835 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
131379 50854 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1375 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM     Permit Number 47369 5999134.27629696 2108342.5104784 37.7690563017942 -122.446319185318 (37.7690563017942, -122.446319185318) 15 5 11 29492 9
131538 173716 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1652 Fell St 1 Front Yard : Cutout Tree Private 2           5999516 2109850 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354) 15 5 11 29492 16
132203 48698 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 7 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
132675 45428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM     Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
135125 45390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2001 12:00:00 AM     Permit Number 44202 6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
135459 106967 Undocumented 4 Ficus nitida :: Laurel Fig 53 1225 02ND AVE   Sidewalk: Curb side : Cutout Tree Private 2           5995419.1 2107212.6 37.7657409782079 -122.459087842629 (37.7657409782079, -122.459087842629) 15 5 11 56 12
136446 110992 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
136842 49263 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 17 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
138070 101722 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138111 111582 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
138887 101721 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138984 110996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23

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