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)
74 106076 7 17 2500 Arelious Walker Dr 13 Sidewalk: Curb side : Cutout Tree 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
81 46536 7 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
108 44866 7 17   25 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 7 17   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
110 45916 7 17   51 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 7 17   5 Unaccepted Street : Yard Tree 2                              
112 33929 7 17   4 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
135 99586 7 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
158 100607 7 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
165 104843 7 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
171 50655 7 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
193 100595 7 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 7 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
203 56596 7 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
205 61223 7 17 420 Montgomery St 1 Sidewalk: Curb side : Cutout Tree 2   11/18/1983 12:00:00 AM     Permit Number 21092 6011911.40369591 2116824.99897206 37.793068691891 -122.402720238707 (37.793068691891, -122.402720238707) 4 1 10 28854 6
220 64608 7 17 2449 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2   08/18/1988 12:00:00 AM     Permit Number 25511 6008240.06203716 2104170.72475134 37.75811738928 -122.414527478763 (37.75811738928, -122.414527478763) 2 4 7 28859 19
222 59632 7 17 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree 2   10/07/1982 12:00:00 AM     Permit Number 19874 5999538.23629958 2110533.95574653 37.7750965176114 -122.445079484139 (37.7750965176114, -122.445079484139) 15 5 11 29492 16
223 65500 7 17 5322 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 2   12/19/1989 12:00:00 AM     Permit Number 28384 5990524.68926015 2112731.41132738 37.7806115451711 -122.47641956102 (37.7806115451711, -122.47641956102) 11 6 2 55 26
226 56655 7 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
241 57687 7 17 4124 21st St 1 Sidewalk: Curb side : Cutout Tree 2   12/10/1976 12:00:00 AM     Permit Number 16590 6001721.25492757 2103540.26074256 37.7560179062476 -122.437027141607 (37.7560179062476, -122.437027141607) 2 4 5 28862 3
257 115298 7 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
260 56449 7 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
294 53493 7 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree 2   11/04/1969 12:00:00 AM     Permit Number 6403 5992228.28376051 2089608.56362168 37.717220822263 -122.468842940668 (37.717220822263, -122.468842940668) 9 8 6 64 24
305 56460 7 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
309 40920 7 17 720 Howard St 2 Sidewalk: Curb side : Cutout Tree 2   09/23/1999 12:00:00 AM     Permit Number 41793 6012338.0511994 2113764.09224404 37.7846879743619 -122.401028836502 (37.7846879743619, -122.401028836502) 12 2 9 28853 6
333 44989 7 17   83 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
340 42995 7 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42871 6004515.16540478 2110012.02065503 37.7739462176361 -122.42782598565 (37.7739462176361, -122.42782598565) 7 9 11 28852 10
348 58983 7 17 585 02nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/03/1980 12:00:00 AM     Permit Number 18272 5995294.04081777 2111581.66432509 37.7777300922573 -122.45983690137 (37.7777300922573, -122.45983690137) 11 6 2 54 11
376 33627 7 17 315 Lily St 2 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37728 6005028.27785393 2110030.93274628 37.7740271589488 -122.426052389372 (37.7740271589488, -122.426052389372) 7 9 11 28852 10
382 34903 7 19   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
407 56529 7 17 4721 17th St 1 Sidewalk: Curb side : Cutout Tree 2           5998571.81433707 2105652.41045975 37.7616378261686 -122.448070980729 (37.7616378261686, -122.448070980729) 15 5 11 29492 12
453 53634 7 17 4046 26th St 1 Sidewalk: Curb side : Cutout Tree 2   12/18/1969 12:00:00 AM     Permit Number 6568 6003580.8041803 2100716.80543934 37.7483708836629 -122.430394762659 (37.7483708836629, -122.430394762659) 2 4 5 28862 22
461 56448 7 17 1410 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2           5982800.36611702 2105511.04189371 37.7603354906122 -122.502606655486 (37.7603354906122, -122.502606655486) 1 8 3 56 35
462 33949 7 17 1238 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/09/1997 12:00:00 AM     Permit Number 37907 5999468.65195546 2108623.71254321 37.7698475030127 -122.445182824083 (37.7698475030127, -122.445182824083) 15 5 11 29492 9
492 44943 7 17   176 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
495 69056 7 8 1235 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33064 5992348.34951393 2107046.09564514 37.7651067945026 -122.469696689595 (37.7651067945026, -122.469696689595) 11 8 11 56 12
514 45011 7 17   93 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 7 17   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1956 12:00:00 AM     Permit Number 147                    
521 100638 7 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
528 57932 7 17 583 Brunswick St 1 Sidewalk: Curb side : Cutout Tree 2   06/24/1977 12:00:00 AM     Permit Number 16891 5999047.47505332 2086793.7936429 37.7098837148731 -122.445070058439 (37.7098837148731, -122.445070058439) 9 7 6 28861 5
530 35187 7 14   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 7 17   195 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
542 35050 7 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 7 17   89 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
549 63156 7 44 1483 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/16/1986 12:00:00 AM     Permit Number 23692 5992405.6320278 2105370.20909848 37.7605085633711 -122.4693765688 (37.7605085633711, -122.4693765688) 1 8 4 56 12
554 63105 7 16 86 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23825 6006733.57538349 2099199.19959074 37.7443819667232 -122.41938488452 (37.7443819667232, -122.41938488452) 2 7 7 28859 2
557 44837 7 17   11 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
589 108776 7 65 500X Lathrop Ave 15 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
622 48348 7 17   153 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
627 34919 7 17   5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
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
650 46071 7 17   1 Sidewalk: Curb side : Cutout Tree 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
656 37103 7 16 1200 48th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39701 5981201.77477995 2106888.46207069 37.7640234205488 -122.508237579769 (37.7640234205488, -122.508237579769) 1 8 3 56 35
661 48170 7 17   63 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
669 30402 7 36 2800 Turk St 8 Sidewalk: Curb side : Cutout Tree 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
676 44636 7 17   164 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
680 47114 7 1 65 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45098 6008176.0434029 2098254.72889507 37.7418697970416 -122.414330302805 (37.7418697970416, -122.414330302805) 2 7 7 28859 2
683 38304 7 64 2000 Folsom St 12 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
692 61241 7 22 3970 20th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/14/1984 12:00:00 AM     Permit Number 21113 6003879.55901956 2104241.51200503 37.7580658175007 -122.429613020503 (37.7580658175007, -122.429613020503) 2 4 5 28862 3
693 60435 7 17 471 29th St 1 Sidewalk: Curb side : Cutout Tree 2   11/19/1982 12:00:00 AM     Permit Number 20019 6003532.89070287 2098907.31164333 37.7433997199793 -122.430431357539 (37.7433997199793, -122.430431357539) 2 7 5 63 22
706 44899 7 17   133 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
721 46041 7 17   176 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 7 17   234 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
742 37975 7 135 1199 Tennessee St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
747 59192 7 17 253 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2   06/03/1980 12:00:00 AM     Permit Number 18508 6001467.56641345 2096421.00019604 37.7364556803125 -122.437394709055 (37.7364556803125, -122.437394709055) 2 7 5 63 7
777 84774 7 17 185 Berry St 20 Sidewalk: Curb side : Cutout Tree 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
778 61131 7 17 76 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/26/1983 12:00:00 AM     Permit Number 20983 5998241.83548559 2106883.25514995 37.7649985471459 -122.449300920602 (37.7649985471459, -122.449300920602) 15 5 11 29492 9
783 56824 7 17 1787 Noriega St 1 Sidewalk: Curb side : Cutout Tree 2   08/02/1974 12:00:00 AM     Permit Number 14055 5988492.53915334 2103043.35746657 37.7538927457413 -122.482739478412 (37.7538927457413, -122.482739478412) 1 8 3 56 35
790 55179 7 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
793 64948 7 17 263 Missouri St 1 Sidewalk: Curb side : Cutout Tree 2   04/19/1989 12:00:00 AM     Permit Number 25979 6013492.3823467 2105864.52669583 37.763061873209 -122.39648129263 (37.763061873209, -122.39648129263) 14 3 8 28856 29
794 44541 7 17   28 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
796 36869 7 22   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
800 43502 7 67 401 Gates St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43180 6008272.42807324 2096955.00828501 37.7383064636933 -122.413905114955 (37.7383064636933, -122.413905114955) 2 7 7 28859 2
820 41547 7 31 244 Diamond St 1 Sidewalk: Curb side : Cutout Tree 2   04/21/2000 12:00:00 AM     Permit Number 42070 6001730.08855162 2104417.99791196 37.7584284625233 -122.437059430993 (37.7584284625233, -122.437059430993) 2 4 5 28862 3
841 44570 7 17   134 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 7 11   2 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
845 35702 7 145   15 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
855 48153 7 17   263 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
862 51904 7 146 168 Caselli Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.442410364393 (37.7596792654558, -122.442410364393) 2 4 5 28862 3
865 65062 7 16 481 44th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/31/1989 12:00:00 AM     Permit Number 27018 5982198.4613122 2112526.22921648 37.7795617740877 -122.505208255718 (37.7795617740877, -122.505208255718) 11 6 2 55 26
870 65298 7 17 601 Dolores St 1 Sidewalk: Curb side : Cutout Tree 2   09/13/1989 12:00:00 AM     Permit Number 28112 6004986.98138427 2104867.56644754 37.7598474581316 -122.42582763941 (37.7598474581316, -122.42582763941) 2 4 5 28859 19
892 44903 7 17   137 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 7 17   188 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 7 17   62 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 7 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
942 67185 7 122 154 Carmel St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/06/1992 12:00:00 AM 12   Permit Number 30632 5998076.31886872 2105384.33640813 37.7608734252807 -122.449765371246 (37.7608734252807, -122.449765371246) 15 5 11 29492 12
947 60023 7 17   1 Sidewalk: Curb side : Cutout Tree 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
949 38398 7 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
958 36868 7 11   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
959 49689 7 36 2235 NOTES) Hayes St 20 Sidewalk: Curb side : Cutout Tree 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
960 45842 7 17   84 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 7 17   141 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
970 43482 7 103   8 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
972 58852 7 17 198 Anderson St 1 Sidewalk: Curb side : Cutout Tree 2   12/27/1979 12:00:00 AM     Permit Number 18111 6007897.70750463 2097731.51362688 37.7404175243374 -122.415255671137 (37.7404175243374, -122.415255671137) 2 7 7 28859 2
974 48301 7 17   167 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
983 44952 7 17   65 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
989 40872 7 36 3456 Washington St 8 Sidewalk: Curb side : Cutout Tree 2   09/22/1999 12:00:00 AM     Permit Number 41788 5998239.16759035 2115871.78992415 37.7896785829725 -122.449958017829 (37.7896785829725, -122.449958017829) 13 6 1 54 31
991 38251 7 50 1475 15th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40361 6007534.04468586 2107333.12590687 37.7667609198383 -122.417193284079 (37.7667609198383, -122.417193284079) 8 4 7 28853 19
997 42493 7 10 50 Phelan Ave 18 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42614 5997102.28501 2092861.95301 37.7264342507672 -122.452230525303 (37.7264342507672, -122.452230525303) 9 7 4 28861 40
1000 52636 7 7 185@ BELMONT Edgewood Ave 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 48718 5996563.25999555 2105933.66378054 37.7622950546263 -122.455038038603 (37.7622950546263, -122.455038038603) 15 5 11 29492 12