trees

Custom SQL query returning 74 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
176909 68818 7 65 122 Detroit St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32765 5999442.86322085 2093551.99082798 37.7284627395009 -122.444188839651 (37.7284627395009, -122.444188839651) 9 7 4 63 40
178793 64789 7 65 214 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/10/1989 12:00:00 AM     Permit Number 25785 6002808.76039687 2109284.75060862 37.7718526350484 -122.433676731328 (37.7718526350484, -122.433676731328) 15 5 11 29492 9
183603 67515 7 65 179 Staples Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31051 5998906.63498153 2093763.92891486 37.7290140653184 -122.446057838601 (37.7290140653184, -122.446057838601) 9 7 4 28861 40
185506 63233 7 65 200x ESMERALDA AVE 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23781 6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
187355 115291 7 65 1811 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/22/2016 12:00:00 AM     Permit Number 775894 5990908.2 2103066.5 37.7540965389008 -122.474387332213 (37.7540965389008, -122.474387332213) 1 8 4 56 12
188694 65036 7 65 69 Scott St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31412 6002360.88534811 2108648.78551282 37.7700810087641 -122.435180464659 (37.7700810087641, -122.435180464659) 15 5 5 29492 9
191256 108773 7 65 500X Lathrop Ave 12 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
193961 63264 7 65 474 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1999 12:00:00 AM     Permit Number 23819 6003326.56560874 2102164.81247283 37.7523323660448 -122.431377264225 (37.7523323660448, -122.431377264225) 2 4 5 28862 22
133256 5134 7 65 2815 Diamond St 1 Sidewalk: Curb side : Cutout Tree 2   06/08/1992 12:00:00 AM 6 3X3   6002450.59942 2095504.85865 37.7339960032757 -122.433930487392 (37.7339960032757, -122.433930487392) 2 7 5 63 7
754 34739 7 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/28/1997 12:00:00 AM   3x3 Permit Number 38389 6007302.61875581 2103939.58827334 37.7574300317864 -122.417753185833 (37.7574300317864, -122.417753185833) 2 4 7 28859 19
3472 95121 7 65 68 Lamartine St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54048 6002661 2094358 37.7308589285589 -122.433121153797 (37.7308589285589, -122.433121153797) 9 7 5 28861 25
20115 97549 7 65 199x FLOOD AVE 1 Sidewalk: Curb side : Cutout Tree 2     20 3x3 Permit Number 42524 5999753 2094070 37.7299027608053 -122.443153872698 (37.7299027608053, -122.443153872698) 9 7 4 63 40
21373 109405 7 65 112 ORTEGA ST 1 Sidewalk: Curb side : Cutout Tree 2   12/29/2015 12:00:00 AM   3x3 Permit Number 775093 5993662.3 2102610.6 37.7530039316177 -122.46482995514 (37.7530039316177, -122.46482995514) 1 8 4 56 12
23012 97550 7 65 199x FLOOD AVE 2 Sidewalk: Curb side : Cutout Tree 2     1 3x3 Permit Number 42524 5999753 2094070 37.7299027608053 -122.443153872698 (37.7299027608053, -122.443153872698) 9 7 4 63 40
31052 109288 7 65 274 Hartford St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/06/2015 12:00:00 AM 3 3x3 Permit Number 773379 6002625.7 2104315.8 37.7581987182413 -122.433954706682 (37.7581987182413, -122.433954706682) 2 4 5 28862 3
43220 32893 7 65 1262 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2   03/24/2015 12:00:00 AM 3 3x3 Permit Number 774785 5993955.18913569 2106899.23772087 37.764796302786 -122.464128405479 (37.764796302786, -122.464128405479) 11 5 11 56 12
48996 94666 7 65 115 Cuvier St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53803 6004020 2095225 37.7333165119994 -122.428484644893 (37.7333165119994, -122.428484644893) 9 7 5 28861 25
52586 109284 7 65 1530 Sloat Blvd 3 Sidewalk: Curb side : Cutout Tree 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
56352 238396 7 65 2221 15th St 1 Sidewalk: Curb side : Cutout Tree 2   11/16/2018 12:00:00 AM 3 3x3 Permit Number 782349 6002719.76824 2107072.27368 37.7657726661007 -122.433826396093 (37.7657726661007, -122.433826396093) 15 5 5 28862 3
57192 258208 7 65 1751 43rd Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 04/17/2019 12:00:00 AM 3 3x3 Permit Number 783177 5982833.22444 2103206.19232 37.7540089544563 -122.50232243849 (37.7540089544563, -122.50232243849) 1 8 3 56 35
67823 103022 7 65 40X Coleridge St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
71957 95120 7 65 67 Lamartine St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54047 6002640 2094338 37.7308028218422 -122.433192325631 (37.7308028218422, -122.433192325631) 9 7 5 28861 25
72547 102082 7 65 577 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/09/2009 12:00:00 AM   3x3 Permit Number 52510 5994678.1 2111611.2 37.7777757479831 -122.461969778855 (37.7777757479831, -122.461969778855) 11 6 2 54 11
73034 94147 7 65 1838 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53552 5992870.9 2102941.4 37.7538665624087 -122.467590799812 (37.7538665624087, -122.467590799812) 1 8 4 56 12
76448 108926 7 65 36 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772355 6007347.4 2099299.8 37.7446927459132 -122.417269529335 (37.7446927459132, -122.417269529335) 2 7 7 28859 2
76736 94821 7 65 1435 15th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53901 5991436.1 2105639 37.7611905159112 -122.472749301819 (37.7611905159112, -122.472749301819) 1 8 4 56 12
87243 109278 7 65 1626 Great Hwy 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773630 5981021.8 2103979.8 37.7560264628403 -122.508644093874 (37.7560264628403, -122.508644093874) 1 8 3 56 35
90858 81824 7 65 465 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49841 5998560.4175518 2097716.54493852 37.7398472336872 -122.447539136623 (37.7398472336872, -122.447539136623) 9 7 4 59 40
93586 102654 7 65 203X Farallones St 3 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5995004 2088355 37.7139388056528 -122.459157943572 (37.7139388056528, -122.459157943572) 9 8 6 28861 24
93872 102475 7 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
95563 38954 7 65 293 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/30/2008 12:00:00 AM   3x3 Permit Number 50374 6000154.66929043 2094929.77821336 37.73228640687 -122.441826941763 (37.73228640687, -122.441826941763) 9 7 4 63 40
95663 108501 7 65 1221 14th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773645 5991730.30424 2107117.25477 37.7652664370978 -122.471839523232 (37.7652664370978, -122.471839523232) 11 8 11 56 12
98528 87814 7 65 2000 10th Ave 5 Sidewalk: Curb side : Cutout Tree 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
101694 94830 7 65 1537 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53908 5994260.8 2105105.8 37.7598895981479 -122.462941258172 (37.7598895981479, -122.462941258172) 1 5 4 56 12
108472 109743 7 65 142 Hartford St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775046 6002641.7 2105066.1 37.7602597694278 -122.433953002704 (37.7602597694278, -122.433953002704) 2 4 5 28862 3
108513 254649 7 65 929 Cayuga Ave 3 Sidewalk: Curb side : Cutout Tree 2 FUF 03/08/2018 12:00:00 AM 3 3x3 Permit Number 781532 6000895.17385 2091578.90462 37.7231278434042 -122.439026791536 (37.7231278434042, -122.439026791536) 9 7 6 28861 25
110025 255477 7 65 2669 Greenwich St   Sidewalk: Curb side : Cutout Tree 2 FUF 05/25/2018 12:00:00 AM 3 3x3 Permit Number 780207 6000139.26098 2118831.12681 37.7979126806609 -122.443596582177 (37.7979126806609, -122.443596582177) 13 9 1 57 17
110235 87815 7 65 2000 10th Ave 4 Sidewalk: Curb side : Cutout Tree 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
110639 83535 7 65 1779 48th Ave   Sidewalk: Curb side : Cutout Tree 2   01/24/2008 12:00:00 AM   3x3 Permit Number 50180 5981283.63190284 2102973.80068941 37.7532797037627 -122.507663961783 (37.7532797037627, -122.507663961783) 1 8 3 56 35
115535 94829 7 65 1531 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53907 5994259.9 2105131.8 37.75996093558 -122.462946257172 (37.75996093558, -122.462946257172) 1 5 4 56 12
122464 94832 7 65 1212 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993646.6 2107243.8 37.7657245899289 -122.465220756233 (37.7657245899289, -122.465220756233) 11 8 11 56 12
124223 108505 7 65 1347 15th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773650 5991435.09722 2106251.41391 37.7628719836646 -122.472797425789 (37.7628719836646, -122.472797425789) 1 8 11 56 12
124672 94831 7 65 1541 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53909 5994261.6 2105082.3 37.759825119308 -122.462936786411 (37.759825119308, -122.462936786411) 1 5 4 56 12
126015 109285 7 65 1530 Sloat Blvd 4 Sidewalk: Curb side : Cutout Tree 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
130795 81299 7 65 109 Bartlett St 1 Sidewalk: Curb side : Cutout Tree 2   06/02/2008 12:00:00 AM 12 3x3 Permit Number 50541 6006708.25661782 2103139.88479614 37.7552007652727 -122.419751988993 (37.7552007652727, -122.419751988993) 2 4 7 28859 19
133428 94661 7 65 246 Chenery St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53798 6004650 2096961 37.7381188082759 -122.426430123703 (37.7381188082759, -122.426430123703) 2 7 5 63 7
133938 106164 7 65 1366 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/07/2015 12:00:00 AM 3 3x3 Permit Number 771080 5993998.9 2106208.9 37.7629033349313 -122.463927108118 (37.7629033349313, -122.463927108118) 1 5 11 56 12
134976 255531 7 65 2130 15th St   Sidewalk: Curb side : Cutout Tree 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782019 6003380.68215 2107148.89983 37.7660205449408 -122.431545908158 (37.7660205449408, -122.431545908158) 15 5 5 28862 3
135999 109068 7 65 1216 COLE ST   Sidewalk: Curb side : Cutout Tree 2 FUF 02/10/2015 12:00:00 AM 3 3x3 Permit Number 774077 5998287 2106143.6 37.762970223958 -122.449091419823 (37.762970223958, -122.449091419823) 15 5 11 29492 9
137107 108890 7 65 350 Hearst Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773349 5999093.24367 2094395.39174 37.7307585689262 -122.445458107682 (37.7307585689262, -122.445458107682) 9 7 4 59 40
147875 254474 7 65 1526 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/15/2018 12:00:00 AM 3 3x3 Permit Number 781401 5994010.7409 2105109.99448 37.7598867084746 -122.463806388501 (37.7598867084746, -122.463806388501) 1 5 4 56 12
149788 105062 7 65 530 07th Ave   Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 771082 5993803.2 2111872 37.7784414265163 -122.465015282122 (37.7784414265163, -122.465015282122) 11 6 2 54 11
152810 94662 7 65 252 Chenery St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53799 6004605 2096922 37.7380091791898 -122.426582934947 (37.7380091791898, -122.426582934947) 2 7 5 63 7
156296 87374 7 65 149 Staples Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 50353 5999085.2 2093741.7 37.7289632252792 -122.445438930282 (37.7289632252792, -122.445438930282) 9 7 4 28861 40
157166 106344 7 65 2428 14th Ave 1 Median : Cutout Tree 2   04/18/2014 12:00:00 AM   3x3   5992079 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
158268 81935 7 65 23 Gaviota Way 1 Sidewalk: Curb side : Cutout Tree 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49833 5998498.7012246 2097562.09988585 37.7394196374476 -122.447741409302 (37.7394196374476, -122.447741409302) 9 7 4 59 40
162088 109283 7 65 1530 Sloat Blvd 2 Sidewalk: Curb side : Cutout Tree 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
166768 83830 7 65 4429 Kirkham St 1 Sidewalk: Curb side : Cutout Tree 2   01/28/2008 12:00:00 AM   3x3 Permit Number 50197 5981144.78735824 2104834.04535283 37.7583792247877 -122.50828217567 (37.7583792247877, -122.50828217567) 1 8 3 56 35
173139 98032 7 65 132 Clement St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5995145 2113574 37.783191941507 -122.460496884135 (37.783191941507, -122.460496884135) 11 6 2 54 11
174480 109282 7 65 1530 Sloat Blvd 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773632 5986383.9 2095952.1 37.7342991443311 -122.489510139546 (37.7342991443311, -122.489510139546) 1 8 3 64 35
178762 108734 7 65 54 Aloha Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 01/05/2015 12:00:00 AM 3 3x3 Permit Number 774639 5991915.16633 2104292.89593 37.7575221893456 -122.470994366205 (37.7575221893456, -122.470994366205) 1 8 4 56 12
178764 83799 7 65 1200 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/23/2008 12:00:00 AM   3x3 Permit Number 53146 5982135.42302083 2106787.40938389 37.7638009337056 -122.505000931873 (37.7638009337056, -122.505000931873) 1 8 3 56 35
185739 106345 7 65 2428 14th Ave 2 Median : Cutout Tree 2   04/18/2014 12:00:00 AM   3x3   5992079 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
186665 87813 7 65 2000 10th Ave 3 Sidewalk: Curb side : Cutout Tree 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
188754 94833 7 65 1208 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53910 5993657.5 2107252.8 37.7657499301273 -122.465183709555 (37.7657499301273, -122.465183709555) 11 8 11 56 12
188964 96074 7 65 439 39th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/28/2011 12:00:00 AM   3x3 Permit Number 767700 5983724.3 2112865.2 37.7805821513852 -122.499954873055 (37.7805821513852, -122.499954873055) 11 6 2 55 26
192665 254027 7 65 1486 46th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/02/2018 12:00:00 AM 3 3x3 Permit Number 781497 5981881.09813 2104983.58381 37.7588331784594 -122.505746816877 (37.7588331784594, -122.505746816877) 1 8 3 56 35
83501 66304 7 65 400 Congo St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/07/1990 12:00:00 AM   3x50 Permit Number 29418 6000123.45614997 2094964.38431909 37.732379648564 -122.44193733537 (37.732379648564, -122.44193733537) 9 7 5 63 40
142834 33539 7 65 253 BOCANA ST 1 Sidewalk: Curb side : Cutout Tree 2   08/06/2015 12:00:00 AM   4x4 Permit Number 775951 6007035 2097463 37.7396317225537 -122.418219548801 (37.7396317225537, -122.418219548801) 2 7 7 28859 2
58635 63004 7 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/22/1986 12:00:00 AM 20 4x6 Permit Number 23414 6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
132523 115548 7 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
69147 33484 7 65 300 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/25/1996 12:00:00 AM 30 6x6 Permit Number 37610 6006227.43678663 2098258.25526822 37.741769825751 -122.421068211473 (37.741769825751, -122.421068211473) 2 7 7 28859 2
163287 160137 7 65 61 Seminole Ave 1 Sidewalk: Curb side : Cutout Tree 2   03/08/2018 12:00:00 AM 3 Width 0ft Permit Number 781533 5999114.78388 2090156.18461 37.7191199185408 -122.445078994094 (37.7191199185408, -122.445078994094) 9 7 6 28861 25
665 203589 7 65 50 Staples Ave 1 Sidewalk: Curb side : Cutout Tree 2   12/28/1993 12:00:00 AM 24 Width 3ft Permit Number 32829 5999730.96004 2093799.89189 37.7291598500324 -122.443210675031 (37.7291598500324, -122.443210675031) 9 7 4 63 40