39,840 rows where qLegalStatus_id = 7 sorted by DBH

View and edit SQL

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)
74 106076 Permitted Site 7 Tree(s) :: 17 2500 Arelious Walker Dr 13 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
75 74661 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
81 46536 Permitted Site 7 Tree(s) :: 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
108 44866 Permitted Site 7 Tree(s) :: 17   25 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
110 45916 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
112 33929 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
135 99586 Permitted Site 7 Tree(s) :: 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
171 50655 Permitted Site 7 Tree(s) :: 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
203 56596 Permitted Site 7 Tree(s) :: 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
205 61223 Permitted Site 7 Tree(s) :: 17 420 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 2449 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 5322 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
241 57687 Permitted Site 7 Tree(s) :: 17 4124 21st St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
260 56449 Permitted Site 7 Tree(s) :: 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
294 53493 Permitted Site 7 Tree(s) :: 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
308 102295 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
309 40920 Permitted Site 7 Tree(s) :: 17 720 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 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
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
333 44989 Permitted Site 7 Tree(s) :: 17   83 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
340 42995 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 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
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
348 58983 Permitted Site 7 Tree(s) :: 17 585 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 315 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
407 56529 Permitted Site 7 Tree(s) :: 17 4721 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2           5998571.81433707 2105652.41045975 37.7616378261686 -122.448070980729 (37.7616378261686, -122.448070980729) 15 5 11 29492 12
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
453 53634 Permitted Site 7 Tree(s) :: 17 4046 26th St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 1410 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982800.36611702 2105511.04189371 37.7603354906122 -122.502606655486 (37.7603354906122, -122.502606655486) 1 8 3 56 35
462 33949 Permitted Site 7 Tree(s) :: 17 1238 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
495 69056 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1235 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
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                    
528 57932 Permitted Site 7 Tree(s) :: 17 583 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 Permitted Site 7 Tree(s) :: 17   195 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 Permitted Site 7 Tree(s) :: 17   89 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
549 63156 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 1483 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 86 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
571 91075 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 576 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2008 12:00:00 AM   3x3 Permit Number 51977 6007858 2104570 37.7591922359052 -122.415877090614 (37.7591922359052, -122.415877090614) 2 4 7 28859 19
622 48348 Permitted Site 7 Tree(s) :: 17   153 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
627 34919 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
630 106356 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 74 Brady St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2014 12:00:00 AM   3x3 Permit Number 771746 6006716.8 2109464.1 37.7725660586042 -122.420171254703 (37.7725660586042, -122.420171254703) 8 2 9 28853 19
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
650 46071 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
656 37103 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
669 30402 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 8 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   164 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
680 47114 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 65 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3970 20th St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 471 29th St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
721 46041 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 Permitted Site 7 Tree(s) :: 17   234 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
740 105361 Permitted Site 7 :: 45 850 Guerrero St 3 Sidewalk: Property side : Cutout Tree Private 2       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602) 2 4 5 28859 19
742 37975 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1199 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 253 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 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
754 34739 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 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
777 84774 Permitted Site 7 Tree(s) :: 17 185 Berry St 20 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 76 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 1787 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
793 64948 Permitted Site 7 Tree(s) :: 17 263 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
796 36869 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
800 43502 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 401 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 244 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   134 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
845 35702 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   15 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
847 92588 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 11 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
855 48153 Permitted Site 7 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
862 51904 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 168 Caselli Ave 3 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 481 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17 601 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 Permitted Site 7 Tree(s) :: 17   62 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 Permitted Site 7 Tree(s) :: 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
928 67058 Permitted Site 7 Tree(s) :: 17 180 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1992 12:00:00 AM   3x3 Permit Number 30439 6009767.36044891 2111443.36861251 37.7781720795529 -122.409758741886 (37.7781720795529, -122.409758741886) 8 2 9 28853 34
937 95737 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 445 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767484 6003120.3 2091142.7 37.7220564786865 -122.431303852024 (37.7220564786865, -122.431303852024) 9 7 6 28861 5
947 60023 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    

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