39,840 rows where qLegalStatus_id = 7 sorted by PlotSize

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
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
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
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
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
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                    
589 108776 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 500X Lathrop Ave 15 Sidewalk: Curb side : Cutout Tree Private 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 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                    
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                    
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
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                    
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                    
942 67185 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 154 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 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 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                    
959 49689 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2235 NOTES) Hayes St 20 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   84 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 Permitted Site 7 Tree(s) :: 17   141 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
970 43482 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   8 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
972 58852 Permitted Site 7 Tree(s) :: 17 198 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Tree(s) :: 17   167 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
983 44952 Permitted Site 7 Tree(s) :: 17   65 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
989 40872 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3456 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1475 15th St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 50 Phelan Ave 18 Sidewalk: Curb side : Cutout Tree Private 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

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