trees

11,635 rows where qSpecies_id = 27 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)
525 33087 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
637 35060 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 5545 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1999 12:00:00 AM     Permit Number 41350 6014167.69706675 2092844.73590691 37.7273498207281 -122.393234476852 (37.7273498207281, -122.393234476852) 10 3 8 58 1
886 73449 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 238 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6004263.46084 2092033.98232 37.7245684629353 -122.427415688595 (37.7245684629353, -122.427415688595) 9 7 6 28861 5
1191 34003 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
1227 46197 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1501 27903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1524 28207 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1534 28217 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 23 Sidewalk: Curb side : Cutout Tree DPW 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1605 35819 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1765 73918 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 740 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004497.3871 2111109.5855 37.776958856214 -122.42796571067 (37.776958856214, -122.42796571067) 7 9 11 28852 10
1792 195241 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1400x Evans Ave 17 Median : Yard Tree DPW 1     5     6016370.1217 2098002.92096 37.7416352733631 -122.385980035973 (37.7416352733631, -122.385980035973) 10 3 8 58 1
2271 37958 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 701 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 7   Permit Number 40528 6015227.36686 2105129.80279 37.7611408796801 -122.390429180864 (37.7611408796801, -122.390429180864) 10 3 8 28856 29
2454 46118 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
2497 134970 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 4 Sidewalk: Curb side : Yard Tree Private 2     10     6009821.57971 2122377.99729 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359) 3 1 10 308 23
2807 195472 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 450x The Embarcadero 8 Median : Yard Tree DPW 1     7     6014582.56054 2117381.49578 37.7947454787808 -122.393516774681 (37.7947454787808, -122.393516774681) 12 2 10 28860 6
2869 260926 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999531 2110546 37.7751291750369 -122.445105382083 (37.7751291750369, -122.445105382083) 15 5 11 29492 16
2988 35689 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   12 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
3031 68691 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 4639 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM     Permit Number 32601 5993244.83438124 2114136.0623562 37.7846257148972 -122.467111515337 (37.7846257148972, -122.467111515337) 11 6 2 54 11
3043 50727 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3101 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2020 12:00:00 AM 3   Permit Number 47278 5999820.18681 2116042.56859 37.7902378338637 -122.444500147275 (37.7902378338637, -122.444500147275) 13 6 1 29490 27
3147 59705 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3135 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/1981 12:00:00 AM 12   Permit Number 19135 5999682.98481 2116022.48652 37.7901748642281 -122.444973410102 (37.7901748642281, -122.444973410102) 13 6 1 29490 27
3253 33090 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3407 261413 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 784 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
3443 33088 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   5 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3499 30983 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2351 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 6   Permit Number 34770 6004127.32192 2116907.85743 37.7928585158547 -122.429659520472 (37.7928585158547, -122.429659520472) 13 9 1 29490 27
3709 33773 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2640 Baker St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/23/1996 12:00:00 AM 12   Permit Number 37820 5999639.77056 2117940.89784 37.7954398489265 -122.44526091526 (37.7954398489265, -122.44526091526) 13 9 1 57 17
3870 53578 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 123 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1970 12:00:00 AM 9   Permit Number 6502 5993941.76178 2114693.00762 37.7861951385831 -122.464740857622 (37.7861951385831, -122.464740857622) 11 6 2 54 11
3914 195226 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 551 Barneveld Ave 3 Sidewalk: Property side : Yard Tree Private 2     17     6011058.60969 2097355.10944 37.739561139028 -122.404299969763 (37.739561139028, -122.404299969763) 10 3 8 58 1
3932 36559 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   8 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
3956 48783 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 201 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2002 12:00:00 AM 6   Permit Number 46038 6008763.21846 2113151.61883 37.7828062042714 -122.413353282927 (37.7828062042714, -122.413353282927) 7 10 9 28852 36
4095 49027 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 199 01st St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2003 12:00:00 AM     Permit Number 46205 6013823.58160426 2115158.37921296 37.7885991200294 -122.395987099577 (37.7885991200294, -122.395987099577) 6 2 9 28855 6
4190 71445 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 60 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6013056.35208 2118942.99059 37.798948052957 -122.398907344312 (37.798948052957, -122.398907344312) 3 1 10 28860 6
4477 57232 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 91 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/1975 12:00:00 AM     Permit Number 14519 6002939.30874382 2107370.92325937 37.7666051407068 -122.433088392926 (37.7666051407068, -122.433088392926) 15 5 5 28862 3
4642 254121 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
4666 36564 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4725 35344 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 822 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 12   Permit Number 39079 6013033.1221 2103220.47445 37.7557763166346 -122.397884245859 (37.7557763166346, -122.397884245859) 10 3 8 28856 29
4781 254118 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 5 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
4966 37957 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 701 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40192 6015227.61132 2105153.87314 37.7612069852338 -122.390430017258 (37.7612069852338, -122.390430017258) 10 3 8 28856 29
5044 261415 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 787 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
5049 39250 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 3168 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/14/1998 12:00:00 AM     Permit Number 40877 6008614.08848489 2100618.91579037 37.7483859278404 -122.412982801874 (37.7483859278404, -122.412982801874) 2 4 7 28859 19
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
5113 60229 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6242 California St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/26/1982 12:00:00 AM 13   Permit Number 19780 5988145.31285 2114007.56926 37.783977233395 -122.484744500147 (37.783977233395, -122.484744500147) 11 6 2 55 26
5399 42533 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 616 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 10   Permit Number 42640 6009446.62137 2111558.04307 37.7784689692185 -122.410876400723 (37.7784689692185, -122.410876400723) 8 2 9 28853 34
5488 46196 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
5697 100042 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 5 Sidewalk: Curb side : Cutout Tree Private 2     8     6005174.91003 2116356.5458 37.7914040153291 -122.425995549348 (37.7914040153291, -122.425995549348) 13 9 1 28858 27
6353 50331 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 800 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2009 12:00:00 AM 6   Permit Number 53108 6011486.90457 2112973.18308 37.7824688065362 -122.403917861314 (37.7824688065362, -122.403917861314) 12 2 9 28853 34
6495 37955 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 701 Minnesota St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40192 6015222.37613 2105229.81644 37.761415218749 -122.390453430208 (37.761415218749, -122.390453430208) 10 3 8 28856 29
6507 106422 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 900 North Point St 22 Sidewalk: Curb side : Cutout Tree Private 2     6     6006057.80404 2121440.5977 37.8054133915718 -122.423302314572 (37.8054133915718, -122.423302314572) 5 1 1 28858 32
6511 46719 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
6607 28204 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
6688 119707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree Private 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
6956 34828 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1627 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/1997 12:00:00 AM     Permit Number 38458 5990549.21563661 2104310.17201234 37.7574905284103 -122.4757195858 (37.7574905284103, -122.4757195858) 1 8 4 56 12
6996 261387 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 600 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
7248 264745 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1083 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009159.2602 2112391.6718 37.7807417986999 -122.411929420062 (37.7807417986999, -122.411929420062) 14 2 9 28853 34
7463 211983 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 694 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     15     5996957.73544 2094438.14779 37.7307538246289 -122.452843941191 (37.7307538246289, -122.452843941191) 9 7 4 59 40
7549 34002 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
7585 78599 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1721 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6012838.14816 2104697.96448 37.7598223206635 -122.398662212485 (37.7598223206635, -122.398662212485) 10 3 8 28856 29
7997 46198 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
8327 33086 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
8443 36563 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
8748 261394 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 690 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
8867 34881 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 211 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1997 12:00:00 AM 12   Permit Number 38492 6014682.09423 2115822.57014 37.7904705613091 -122.393063242988 (37.7904705613091, -122.393063242988) 6 2 9 28855 6
8960 39903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
9015 30418 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2509 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/1956 12:00:00 AM 12   Permit Number 73 6000919.61601 2118590.12909 37.7972954389769 -122.440879042342 (37.7972954389769, -122.440879042342) 13 9 1 57 17
9077 261414 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 784 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
9222 195471 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 450x The Embarcadero 7 Median : Yard Tree DPW 1     7     6014542.5915 2117352.94839 37.7946648734448 -122.393653075045 (37.7946648734448, -122.393653075045) 12 2 10 28855 6
9237 261402 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 777 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2           6009873.57516 2118448.52327 37.7974125049795 -122.409885931014 (37.7974125049795, -122.409885931014) 3 1 10 308 4
9263 254120 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
9547 32801 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1640 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 7   Permit Number 37163 5999986.448 2110250.0303 37.7743425023806 -122.443508626239 (37.7743425023806, -122.443508626239) 15 5 11 29492 16
9675 49505 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 702@ INNES Phelps St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/22/2003 12:00:00 AM     Permit Number 46416 6015133.81699265 2097838.73838627 37.7411159643244 -122.39024332946 (37.7411159643244, -122.39024332946) 10 3 8 58 1
9880 42534 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 616 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 9   Permit Number 42640 6009431.80804 2111539.80243 37.7784180540966 -122.410926357172 (37.7784180540966, -122.410926357172) 8 2 9 28853 34
9957 78350 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 764 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5985108.45002 2110660.38164 37.7746094864044 -122.495003887719 (37.7746094864044, -122.495003887719) 11 6 2 55 26
10135 46240 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 160 King St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44534 6015164.29463736 2111614.90461458 37.7789440431462 -122.39110062089 (37.7789440431462, -122.39110062089) 6 2 9 28856 20
10346 41480 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2390 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 42055 6007082.30805796 2120481.73008774 37.8028383512958 -122.41968879786 (37.8028383512958, -122.41968879786) 5 1 1 28858 32
10386 34217 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 110 Frederick St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/17/1997 12:00:00 AM     Permit Number 38032 5999469.36873216 2107750.31436605 37.7674494126495 -122.445117544708 (37.7674494126495, -122.445117544708) 15 5 11 29492 9
10848 70116 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1659 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6006256.51205 2117265.43085 37.7939606548043 -122.422317826729 (37.7939606548043, -122.422317826729) 13 9 10 28858 32
10919 68353 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 573 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 9   Permit Number 32173 5991577.36858 2111540.92265 37.777403783844 -122.472691050295 (37.777403783844, -122.472691050295) 11 6 2 54 26
10942 36562 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
11053 116828 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 15 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
11260 28200 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 6 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2014 01:37:00 PM 3     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
11363 78048 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 783 35th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5985063.43296 2110545.25732 37.7742907524801 -122.495151117096 (37.7742907524801, -122.495151117096) 11 6 2 55 26
11566 46721 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
11814 39901 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
11949 34004 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
12187 261401 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 777 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009873.57516 2118448.52327 37.7974125049795 -122.409885931014 (37.7974125049795, -122.409885931014) 3 1 10 308 4
12503 33089 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12540 33092 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   8 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12629 84556 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5986323.51581 2110116.60697 37.7731874908554 -122.490760773642 (37.7731874908554, -122.490760773642) 11 6 2 55 26
12644 261416 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 787 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
12675 35820 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
12780 33093 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   9 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12870 61071 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2611 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/01/1983 12:00:00 AM 10   Permit Number 20905 5999981.3394 2114011.0881 37.7846691114124 -122.44379656236 (37.7846691114124, -122.44379656236) 15 6 11 29490 31
13042 39902 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
13339 49905 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1686 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2003 12:00:00 AM     Permit Number 46673 6006217.29915575 2107312.14837083 37.7666291551697 -122.421746203485 (37.7666291551697, -122.421746203485) 8 4 7 28853 19
13591 60096 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3369 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/19/1982 12:00:00 AM 14   Permit Number 19597 5998144.72497 2116139.23824 37.790407520633 -122.450304065089 (37.790407520633, -122.450304065089) 13 6 1 54 31
13714 116827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 14 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13717 76301 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2 Townsend St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6015739.49733 2112628.79912 37.7817598727711 -122.389181562198 (37.7817598727711, -122.389181562198) 6 2 9 28856 6
13823 81822 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 953 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6014995.08745 2104204.61069 37.7585876135316 -122.391167870527 (37.7585876135316, -122.391167870527) 10 3 8 28856 29
13996 33267 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1000 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/1996 12:00:00 AM     Permit Number 37441 6009551.65503934 2116448.08509162 37.7919017434497 -122.410858505631 (37.7919017434497, -122.410858505631) 5 1 10 28857 21
14289 113566 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 28 Sidewalk: Curb side : Cutout Tree DPW 1           6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
14315 27902 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 32 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015941.319 2112799.309 37.782239240724 -122.388495252967 (37.782239240724, -122.388495252967) 6 2 9 28856 6

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