trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 963 ✖
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)
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
349 253694 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 536 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
3159 94569 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100@ Cole Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
3559 55849 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/13/2003 12:00:00 AM     Permit Number 46336 6001333.31634171 2116022.21010841 37.7902681559585 -122.439263383199 (37.7902681559585, -122.439263383199) 13 6 1 29490 27
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 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
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
6288 254356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
7359 121255 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
8959 113224 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001623 2102374 37.7528100494278 -122.437283434624 (37.7528100494278, -122.437283434624) 2 4 5 28862 22
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                    
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
9438 115058 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
10358 120965 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
11487 260838 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 1 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
11874 110985 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
12511 260840 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 3 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
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
14899 110708 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
15941 85313 Significant Tree 6 Ficus nitida :: Laurel Fig 53 610 Brannan St 1 unknown : Cutout Tree Private 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
17892 254355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
18675 101715 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
18772 115057 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
18979 110983 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
19867 48735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1969 12:00:00 AM     Permit Number 46015 6001979.18448022 2107865.24554965 37.7679079189757 -122.436444672891 (37.7679079189757, -122.436444672891) 15 5 5 29492 3
20107 41196 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 8 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
20131 113298 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
20310 112288 Undocumented 4 Ficus nitida :: Laurel Fig 53 895x PAGE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002361 2109458 37.7723029182135 -122.435237957834 (37.7723029182135, -122.435237957834) 15 5 11 29492 9
20820 111597 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
21029 102504 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
21359 87146 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
24098 50784 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4425@ EUREKA 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2004 12:00:00 AM     Permit Number 47310 6001319.3692016 2105218.84665198 37.760604043869 -122.438537258087 (37.760604043869, -122.438537258087) 2 4 5 28862 3
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
25882 40606 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48110 6011762.49765618 2117875.03517526 37.7959435248288 -122.403309366526 (37.7959435248288, -122.403309366526) 3 1 10 28860 4
26170 124732 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
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
27991 97561 Undocumented 4 Ficus nitida :: Laurel Fig 53 1251X 04th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994791.4 2106981 37.7650689602603 -122.461242116604 (37.7650689602603, -122.461242116604) 15 5 11 56 12
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
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28579 116510 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
28662 99265 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
28710 102826 Undocumented 4 Ficus nitida :: Laurel Fig 53 2001X Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997438 2109144 37.7711599615563 -122.452244312179 (37.7711599615563, -122.452244312179) 15 5 11 29492 9
29615 120137 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
29776 44063 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
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
31247 106090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 615 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072) 3 1 10 28860 6
31383 110696 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
32305 173934 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2       9x9   6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
32689 108945 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
32698 58520 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1486 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM   7x7 Permit Number 17697 5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388) 15 5 11 29492 9
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
33102 110710 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
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
35016 120999 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
35952 120884 Undocumented 4 Ficus nitida :: Laurel Fig 53 2140x 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011295 2105636 37.7623118602886 -122.404065249735 (37.7623118602886, -122.404065249735) 8 3 8 28856 29
36005 111369 Undocumented 4 Ficus nitida :: Laurel Fig 53 724 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993485 2106687 37.7641864431876 -122.465739233402 (37.7641864431876, -122.465739233402) 11 8 11 56 12
36076 111627 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
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
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
37838 102503 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
37914 110712 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 18 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
38373 52226 Permitted Site 7 Ficus nitida :: Laurel Fig 53 423 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2005 12:00:00 AM     Permit Number 48405 5997634.34727934 2115023.86499621 37.7873157808513 -122.451989424725 (37.7873157808513, -122.451989424725) 11 6 1 54 31
38468 111626 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
38715 120144 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
38742 113004 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
38950 93145 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2           5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
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
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
39669 95554 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1333@ Larkin Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007121 2115358 37.7887720478953 -122.419191239667 (37.7887720478953, -122.419191239667) 13 9 10 28858 21
40083 49240 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 24 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
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 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
40462 48697 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 9 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
40868 173774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2239 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002625 2107043 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943) 15 5 5 28862 3
41004 99266 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
41773 120139 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
43224 117205 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
43227 110731 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
43330 113005 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
43513 120964 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
43596 112404 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
43639 111595 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
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
44244 110995 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
45439 49260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 2 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
45931 49235 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 8 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
46032 121039 Undocumented 4 Ficus nitida :: Laurel Fig 53 2101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118098 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697) 13 9 10 28858 32

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