trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
502 251299 2 27 2190X Market St 3 Sidewalk: Curb side : Cutout Tree 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
508 113374 4 27 88 HOWARD ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
631 62744 1 27 1440 Harrison St 1 Sidewalk: Curb side : Cutout Tree 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 7 27 5545 03rd St 3 Sidewalk: Curb side : Cutout Tree 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 6 27 397 05th St 3 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
787 110793 4 27 900 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
824 262410 1 27 1975 Market St 2 Sidewalk: Curb side : Cutout Tree 2       Width 0ft   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
898 262453 1 27 2005 Buchanan St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6003839 2115372 37.7886251115209 -122.43054748798 (37.7886251115209, -122.43054748798) 13 9 1 29490 27
1134 262481 4 27 2001 Market St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6004735 2108212 37.769016230753 -122.426937316023 (37.769016230753, -122.426937316023) 8 4 5 28862 3
1191 34003 7 27   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
1227 46197 7 27   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1467 259815 6 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
1605 35819 7 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1607 263607 1 27 6750 California St 3 Sidewalk: Curb side : Cutout Tree 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
2079 263595 1 27 830x Harrison St 6 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
2454 46118 7 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree 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 1 27 341 30th Ave 6 Sidewalk: Curb side : Yard Tree 2       Width 3ft   5986508.67785 2113597.38194 37.7827555237835 -122.490376395298 (37.7827555237835, -122.490376395298) 11 6 2 55 26
2869 260926 1 27 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree 2           5999531 2110546 37.7751291750369 -122.445105382083 (37.7751291750369, -122.445105382083) 15 5 11 29492 16
2988 35689 7 27   12 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
3031 68691 7 27 4639 California St 1 Sidewalk: Curb side : Cutout Tree 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 4 27 2801X 14th Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
3092 261228 1 27 1415 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
3144 113684 4 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3205 259817 6 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3253 33090 7 27   3 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3287 259814 6 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3300 113370 4 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
3407 261413 1 27 784 Broadway 1 Sidewalk: Curb side : Cutout Tree 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
3443 33088 7 27   5 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3686 174952 1 27 399 Webster St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6004101.8175421 2110091.88469153 37.7741421130406 -122.429261520888 (37.7741421130406, -122.429261520888) 7 9 11 29492 10
3932 36559 7 27   8 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4032 263594 1 27 830x Harrison St 5 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4087 264737 1 27 2222 Polk St 1 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6006396 2118554 37.7975066091486 -122.421926761206 (37.7975066091486, -122.421926761206) 13 9 10 28858 32
4095 49027 7 27 199 01st St 6 Sidewalk: Curb side : Cutout Tree 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 6 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
4477 57232 7 27 91 Henry St 1 Sidewalk: Curb side : Cutout Tree 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 7 27   1 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4772 258681 1 27 201 Drumm St 4 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6013623 2117823 37.7959043823773 -122.396867976466 (37.7959043823773, -122.396867976466) 3 1 10 28860 6
4935 263596 1 27 830x Harrison St 7 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4938 260583 6 27 397 05th St 1 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
5036 52410 7 27 1337 California St 1 Sidewalk: Curb side : Cutout Tree 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 1 27 787 Broadway 1 Sidewalk: Curb side : Cutout Tree 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
5049 39250 7 27 3168 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree 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 1 27 6532 California St 2 Sidewalk: Curb side : Yard Tree 2       Width 4ft   5987034.67149 2113964.20827 37.7837934305581 -122.488583673816 (37.7837934305581, -122.488583673816) 11 6 1 55 33
5488 46196 7 27   3 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
5990 262465 1 27 2725 CALIFORNIA ST 2 Sidewalk: Curb side : Cutout Tree 1       Width 0ft   6001363.6521 2115250.4856 37.7881509261214 -122.439103090842 (37.7881509261214, -122.439103090842) 13 6 1 29490 27
6007 261051 4 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6084 263600 1 27 6924 California St 2 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   5986053 2113902 37.7835652928903 -122.491975260314 (37.7835652928903, -122.491975260314) 11 6 2 55 26
6086 263605 1 27 6750 California St 2 Sidewalk: Curb side : Cutout Tree 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
6111 260586 6 27 397 05th St 4 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 6 27 397 05th St 2 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6381 118299 4 27 275 OLYMPIA WAY 10 Sidewalk: Property side : Cutout Tree 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
6413 259813 6 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6427 256700 1 27 2529 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005708 2119103 37.7989751988958 -122.424346493582 (37.7989751988958, -122.424346493582) 13 9 1 57 17
6511 46719 7 27   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
6612 259812 6 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6688 119707 7 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
6860 262588 1 27 2725 CALIFORNIA ST 5 Sidewalk: Curb side : Cutout Tree 1       Width 0ft   6001407.3919 2115257.3022 37.7881721314677 -122.438952247661 (37.7881721314677, -122.438952247661) 13 6 1 29490 27
6956 34828 7 27 1627 18th Ave 1 Sidewalk: Curb side : Cutout Tree 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 1 27 600 Broadway 1 Sidewalk: Curb side : Cutout Tree 2                              
7110 264646 1 27 1036 Mission St 3 Sidewalk: Curb side : Cutout Tree 2       6x6   6009831 2112235 37.7803492789029 -122.409594476247 (37.7803492789029, -122.409594476247) 14 2 9 28853 34
7248 264745 1 27 1083 Market St 2 Sidewalk: Curb side : Cutout Tree 2           6009159.2602 2112391.6718 37.7807417986999 -122.411929420062 (37.7807417986999, -122.411929420062) 14 2 9 28853 34
7549 34002 7 27   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
7643 263592 1 27 830x Harrison St 3 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
7654 254471 1 27 566x Market St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6012330 2115645 37.7898520566818 -122.401188906813 (37.7898520566818, -122.401188906813) 4 1 10 28854 6
7698 259819 6 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
7948 259183 4 27 35 09th St 4 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34
7997 46198 7 27   1 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
8078 260059 6 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8167 103924 1 27 500X The Embarcadero 21 Sidewalk: Curb side : Cutout Tree 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 7 27   1 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
8443 36563 7 27   2 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
8487 261462 1 27 101x King St 2 Median : Cutout Tree 1       3x3   6015505 2111943 37.7798638201711 -122.3899448996 (37.7798638201711, -122.3899448996) 6 2 9 28856 20
8744 261463 1 27 101x King St 3 Median : Cutout Tree 1       3x3   6015505 2111943 37.7798638201711 -122.3899448996 (37.7798638201711, -122.3899448996) 6 2 9 28856 20
8748 261394 1 27 690 Broadway 1 Sidewalk: Curb side : Cutout Tree 2                              
8787 260968 6 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8870 258869 1 27 601 Steiner St 4 Sidewalk: Curb side : Cutout Tree 2 FUF     6x9   6003098.1372 2110364.0779 37.7748326168947 -122.432752873486 (37.7748326168947, -122.432752873486) 15 9 11 29492 10
8960 39903 7 27   1 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
9068 74830 4 27 493 Broadway 2 Sidewalk: Curb side : Cutout Tree 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 1 27 784 Broadway 2 Sidewalk: Curb side : Cutout Tree 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
9160 263598 1 27 5401 California St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5990702 2114069 37.7842944739246 -122.47590387791 (37.7842944739246, -122.47590387791) 11 6 2 54 26
9200 259821 6 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9215 260060 6 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9237 261402 1 27 777 Broadway 2 Sidewalk: Curb side : Cutout Tree 2           6009873.57516 2118448.52327 37.7974125049795 -122.409885931014 (37.7974125049795, -122.409885931014) 3 1 10 308 4
9510 260587 6 27 890x Harrison St 1 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
9675 49505 7 27 702@ INNES Phelps St 1 Sidewalk: Curb side : Cutout Tree 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 1 27 3790 California St 1 Sidewalk: Curb side : Cutout Tree 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
10051 263590 1 27 830x Harrison St 1 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
10135 46240 7 27 160 King St 5 Sidewalk: Curb side : Cutout Tree 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 1 27 6750 California St 4 Sidewalk: Curb side : Cutout Tree 2       3X3   5986674 2113924 37.7836619775759 -122.489828487098 (37.7836619775759, -122.489828487098) 11 6 2 55 26
10346 41480 7 27 2390 Hyde St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 42055 6007082.30805796 2120481.73008774 37.8028383512958 -122.41968879786 (37.8028383512958, -122.41968879786) 5 1 1 28858 32
10386 34217 7 27 110 Frederick St 2 Sidewalk: Curb side : Cutout Tree 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 4 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
10942 36562 7 27   3 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
11053 116828 4 27 111 BAY ST 15 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
11304 118290 4 27 275 OLYMPIA WAY 1 Sidewalk: Property side : Cutout Tree 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
11559 261050 4 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
11566 46721 7 27   1 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
11675 263599 1 27 6924 California St 1 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   5986053 2113902 37.7835652928903 -122.491975260314 (37.7835652928903, -122.491975260314) 11 6 2 55 26
11738 259182 4 27 35 09th St 3 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34