trees

1,626 rows where qSpecies_id = 53 sorted by PermitNotes descending

✎ 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)
9010 253870 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW       Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection                    
36280 110558 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection 6007165.9 2109609 37.7729892139286 -122.418628045346 (37.7729892139286, -122.418628045346) 8 2 9 28853 19
90288 9941 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 5x6 Resulted descion 9/7/16 -DE 6010050.95997 2119172.47111 37.7994102279433 -122.409323246083 (37.7994102279433, -122.409323246083) 3 1 10 308 4
155542 54199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
84820 98591 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2375 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 9808 6002830 2116793 37.7924696026791 -122.434140096981 (37.7924696026791, -122.434140096981) 13 9 1 29490 27
87750 53929 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1700 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM   3x3 Permit Number 9642 6004487.99959123 2114676.46033991 37.786752078395 -122.428252455396 (37.786752078395, -122.428252455396) 13 9 11 28858 27
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
147341 127216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 5 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999932.8876 2117120.87416 37.7932050075595 -122.444187729973 (37.7932050075595, -122.444187729973) 13 9 1 57 27
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
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
122122 127204 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 46 Presidio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 4ft Permit Number 781066 5998981 2116428 37.7912482078936 -122.447431413946 (37.7912482078936, -122.447431413946) 13 6 1 29490 31
90207 6932 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 500 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3 Permit Number 780762 6004980.8762 2110598.20876 37.7755820815859 -122.426256755638 (37.7755820815859, -122.426256755638) 7 9 11 28852 10
142334 12245 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 503 Laguna St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2015 03:15:00 PM 3 5x5 Permit Number 780762 6004995.5845 2110652.4736 37.7757319109571 -122.426209740207 (37.7757319109571, -122.426209740207) 7 9 11 28852 10
158811 225015 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 157 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780170 6002699.82559 2104972.04176 37.7600048066089 -122.433745251143 (37.7600048066089, -122.433745251143) 2 4 5 28862 3
127664 499 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2751 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010232.5569 2102206.4482 37.7528356605554 -122.407498057365 (37.7528356605554, -122.407498057365) 2 4 7 28859 19
159363 58908 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 353 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1980 12:00:00 AM 13 3x3 Permit Number 780019 6009109.47745 2109280.29041 37.7721958858688 -122.411881715065 (37.7721958858688, -122.411881715065) 8 2 9 28853 34
183025 26841 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819) 7 9 9 28852 36
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
44100 115215 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 9x5 Permit Number 779049 6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
140034 95413 Undocumented 4 Ficus nitida :: Laurel Fig 53 691 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2016 12:00:00 AM 12 3x3 Permit Number 779045 6002523 2095666 37.7344425689427 -122.433691689524 (37.7344425689427, -122.433691689524) 2 7 5 63 7
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
32408 54027 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2016 12:00:00 AM 3 6x6 Permit Number 778679 6004696.3346429 2103995.33974478 37.7574361004301 -122.426770728763 (37.7574361004301, -122.426770728763) 2 4 5 28862 3
8496 115992 Undocumented 4 Ficus nitida :: Laurel Fig 53 438 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2016 12:00:00 AM 3   Permit Number 778644 5989723.9 2112354.3 37.7795296278249 -122.479162248453 (37.7795296278249, -122.479162248453) 11 6 2 55 26
26933 120656 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27040 120661 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
91220 120660 Undocumented 4 Ficus nitida :: Laurel Fig 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
114816 120655 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
128659 120663 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
165688 120662 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
127071 104321 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 BEAVER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3 Permit Number 778510 6002416.6 2106828.4 37.7650858403074 -122.434857547122 (37.7650858403074, -122.434857547122) 15 5 5 28862 3
139038 104320 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2016 12:00:00 AM 3 3x3 Permit Number 778510 6002383 2106795 37.7649922243231 -122.434971372236 (37.7649922243231, -122.434971372236) 15 5 5 28862 3
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
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
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
8209 103628 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
92126 103631 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
95503 103635 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 8 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
112964 103629 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
120567 103630 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
122861 103633 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
136552 103634 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
160281 103637 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
164853 103632 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
166088 103636 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
39309 61493 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3149 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1984 12:00:00 AM     Permit Number 777095 5999649.96958977 2116015.59113069 37.7901540469754 -122.445087143888 (37.7901540469754, -122.445087143888) 13 6 1 29490 27
43945 573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2990 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 776380 6009007.86528 2102243.77418 37.7528695228517 -122.411735919997 (37.7528695228517, -122.411735919997) 2 4 7 28859 19
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
13161 4609 Permitted Site 7 Ficus nitida :: Laurel Fig 53 316 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2015 12:00:00 AM 3 3X3 Permit Number 774670 6010771.0363 2118706.95943 37.7981723635161 -122.406798689949 (37.7981723635161, -122.406798689949) 3 1 10 308 23
30376 94524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3322 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774668 5988381 2111924 37.7782700631784 -122.483776297443 (37.7782700631784, -122.483776297443) 11 6 2 55 26
13236 92386 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2810 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2015 12:00:00 AM 3 4x4 Permit Number 774470 6001269 2116290 37.7909997773984 -122.439505117215 (37.7909997773984, -122.439505117215) 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
26376 107654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 3 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
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
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
46064 106808 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 10 LOYOLA TER 2 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 772884 5998469.3 2110801.2 37.7757692329232 -122.448796407891 (37.7757692329232, -122.448796407891) 15 6 2 29492 16
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
52557 106525 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 5 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
72126 106522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 2 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
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
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
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
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
15062 102786 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3345 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4.5x6 Permit Number 772480 6003174.4 2119873.2 37.8009465759098 -122.433168646536 (37.8009465759098, -122.433168646536) 13 9 1 57 17
23596 105340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1401 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2014 12:00:00 AM 12   Permit Number 770950 6000144.5 2113810 37.7841262805256 -122.443217635242 (37.7841262805256, -122.443217635242) 15 6 11 29490 31
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
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
34686 101290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 830 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769326 6001055.4 2088979.9 37.7160006775821 -122.438286819162 (37.7160006775821, -122.438286819162) 9 7 6 28861 5
14874 6756 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3 Permit Number 769095 6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1
45310 11177 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
53504 11175 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
135761 11176 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
61686 100705 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
105004 100707 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
132195 100706 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
182718 100710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
188290 100708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
84337 9917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1905X Gough St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3x3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
52966 66275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1065 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1990 12:00:00 AM   3x3 Permit Number 768678 6007678.31560988 2109516.6646006 37.7727645184447 -122.416848989215 (37.7727645184447, -122.416848989215) 8 2 9 28853 19
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
193266 97278 Permitted Site 7 Ficus nitida :: Laurel Fig 53 60 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768156 5995934.7 2114107.9 37.7847032866401 -122.457803503646 (37.7847032866401, -122.457803503646) 11 6 1 54 31
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
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 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
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
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
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
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
159337 98224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4068 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2012 12:00:00 AM   3x3 Permit Number 56734 6003417.8 2101304.1 37.7499742222019 -122.431000336814 (37.7499742222019, -122.431000336814) 2 4 5 28862 22
43665 94218 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 3 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
59324 94216 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 1 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
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
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
187881 94217 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 2 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
25834 93215 Permitted Site 7 Ficus nitida :: Laurel Fig 53 499 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715 2118034 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832) 3 1 10 28860 4
66108 92850 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3150 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Permit Number 53071 5999589 2116381 37.7911538835614 -122.445324377175 (37.7911538835614, -122.445324377175) 13 6 1 29490 27
33092 92818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 95 Burlwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2009 12:00:00 AM   3x3 Permit Number 53027 5996883 2096019 37.7350901820695 -122.453216393363 (37.7350901820695, -122.453216393363) 9 7 4 59 40
114066 54117 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4356 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM   3x3 Permit Number 52105 6001531.81835159 2105282.89107801 37.7607919769606 -122.437807081492 (37.7607919769606, -122.437807081492) 15 4 5 28862 3
164129 91329 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2885 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52056 6000915 2116200 37.7907325075106 -122.440723481884 (37.7907325075106, -122.440723481884) 13 6 1 29490 27

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