trees

11,635 rows where qSpecies_id = 27 sorted by DBH

✎ 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)
502 251299 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 3 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
508 113374 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
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                    
631 62744 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1440 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1986 12:00:00 AM   3x3 Permit Number 23091 6009114.80137277 2108930.88306921 37.7712367935343 -122.411838604602 (37.7712367935343, -122.411838604602) 8 2 9 28853 34
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
684 260585 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
787 110793 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 900 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
824 262410 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1975 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
898 262453 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2005 Buchanan St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003839 2115372 37.7886251115209 -122.43054748798 (37.7886251115209, -122.43054748798) 13 9 1 29490 27
1134 262481 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2001 Market St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004735 2108212 37.769016230753 -122.426937316023 (37.769016230753, -122.426937316023) 8 4 5 28862 3
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                    
1467 259815 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
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                    
1607 263607 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6750 California St 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
2079 263595 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
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
2839 262241 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 341 30th Ave 6 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5986508.67785 2113597.38194 37.7827555237835 -122.490376395298 (37.7827555237835, -122.490376395298) 11 6 2 55 26
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
3085 262583 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2801X 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
3092 261228 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
3144 113684 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3205 259817 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
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                    
3287 259814 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3300 113370 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
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                    
3686 174952 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 399 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004101.8175421 2110091.88469153 37.7741421130406 -122.429261520888 (37.7741421130406, -122.429261520888) 7 9 11 29492 10
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                    
4032 263594 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4087 264737 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2222 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6006396 2118554 37.7975066091486 -122.421926761206 (37.7975066091486, -122.421926761206) 13 9 10 28858 32
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
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
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
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                    
4772 258681 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 201 Drumm St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6013623 2117823 37.7959043823773 -122.396867976466 (37.7959043823773, -122.396867976466) 3 1 10 28860 6
4935 263596 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4938 260583 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
5036 52410 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1337 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2006 12:00:00 AM   3x3 Permit Number 48529 6007932.42258608 2116165.68067346 37.7910354039916 -122.416441058577 (37.7910354039916, -122.416441058577) 13 1 10 28858 21
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
5443 263602 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6532 California St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 4ft   5987034.67149 2113964.20827 37.7837934305581 -122.488583673816 (37.7837934305581, -122.488583673816) 11 6 1 55 33
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                    
5990 262465 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2725 CALIFORNIA ST 2 Sidewalk: Curb side : Cutout Tree DPW 1       Width 0ft   6001363.6521 2115250.4856 37.7881509261214 -122.439103090842 (37.7881509261214, -122.439103090842) 13 6 1 29490 27
6007 261051 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6084 263600 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6924 California St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5986053 2113902 37.7835652928903 -122.491975260314 (37.7835652928903, -122.491975260314) 11 6 2 55 26
6086 263605 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6750 California St 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
6111 260586 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6381 118299 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 10 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
6413 259813 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6427 256700 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2529 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005708 2119103 37.7989751988958 -122.424346493582 (37.7989751988958, -122.424346493582) 13 9 1 57 17
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                    
6612 259812 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
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
6860 262588 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2725 CALIFORNIA ST 5 Sidewalk: Curb side : Cutout Tree DPW 1       Width 0ft   6001407.3919 2115257.3022 37.7881721314677 -122.438952247661 (37.7881721314677, -122.438952247661) 13 6 1 29490 27
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                              
7110 264646 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1036 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6009831 2112235 37.7803492789029 -122.409594476247 (37.7803492789029, -122.409594476247) 14 2 9 28853 34
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
7549 34002 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
7643 263592 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
7654 254471 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 566x Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012330 2115645 37.7898520566818 -122.401188906813 (37.7898520566818, -122.401188906813) 4 1 10 28854 6
7698 259819 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
7948 259183 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 35 09th St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34
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                    
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8167 103924 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 500X The Embarcadero 21 Sidewalk: Curb side : Cutout Tree DPW 1   10/30/1995 12:00:00 AM   4x4   6013544.1 2119061 37.7992992444467 -122.397227842585 (37.7992992444467, -122.397227842585)   1 10 28860 6
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                    
8487 261462 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101x King St 2 Median : Cutout Tree DPW 1       3x3   6015505 2111943 37.7798638201711 -122.3899448996 (37.7798638201711, -122.3899448996) 6 2 9 28856 20
8744 261463 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101x King St 3 Median : Cutout Tree DPW 1       3x3   6015505 2111943 37.7798638201711 -122.3899448996 (37.7798638201711, -122.3899448996) 6 2 9 28856 20
8748 261394 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 690 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
8787 260968 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8870 258869 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 601 Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF     6x9   6003098.1372 2110364.0779 37.7748326168947 -122.432752873486 (37.7748326168947, -122.432752873486) 15 9 11 29492 10
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                    
9068 74830 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 493 Broadway 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/27/2013 12:00:00 AM   6x6 Permit Number 769961 6011188.26118785 2118621.30079081 37.7979605016561 -122.405348925503 (37.7979605016561, -122.405348925503) 3 1 10 308 23
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
9160 263598 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 5401 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990702 2114069 37.7842944739246 -122.47590387791 (37.7842944739246, -122.47590387791) 11 6 2 54 26
9200 259821 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
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
9510 260587 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 890x Harrison St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
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
9870 262590 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3790 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
10051 263590 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
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
10209 263606 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6750 California St 4 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
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
10626 117236 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
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
11304 118290 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
11559 261050 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
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                    
11675 263599 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6924 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5986053 2113902 37.7835652928903 -122.491975260314 (37.7835652928903, -122.491975260314) 11 6 2 55 26

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