39,840 rows where qLegalStatus_id = 7 sorted by qLegalStatus_id

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)
30 254372 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 62 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3 3x3 Permit Number 778036 6010859.22958 2088882.34048 37.7162855403434 -122.404393121162 (37.7162855403434, -122.404393121162) 9 7 8 309 39
36 166891 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 174 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3 Permit Number 787855 6003954.63071 2101612.59597 37.7508516839573 -122.429165942869 (37.7508516839573, -122.429165942869) 2 4 5 28862 22
70 264978 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1439 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2020 12:00:00 AM 3 3x3 Permit Number 787884 5989892.86343 2105570.52868 37.7609130564186 -122.47808163393 (37.7609130564186, -122.47808163393) 1 8 3 56 35
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                    
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
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
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
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
341 232113 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 533 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1991 12:00:00 AM 24 4x4 Permit Number 29534 6008027.37409 2096368.31937 37.7366817787289 -122.414710885994 (37.7366817787289, -122.414710885994) 2 7 7 28859 2
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
414 8435 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1730 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1997 12:00:00 AM 13 3X3   6003010.73492 2113853.74303 37.784409407274 -122.433304626878 (37.784409407274, -122.433304626878) 13 9 11 29490 13
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
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
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
499 180799 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Mount Vernon Ave 1 Front Yard : Yard Tree Private 2   10/23/2019 12:00:00 AM 3 8x8 Permit Number 782754 5998557.73755 2089669.84713 37.7177527376786 -122.446969503064 (37.7177527376786, -122.446969503064) 9 7 6 28861 25
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                    
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
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
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
608 40723 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 374 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/1999 12:00:00 AM 11 3x4 Permit Number 41702 6007686.24299886 2097355.04576879 37.739371939893 -122.415960181331 (37.739371939893, -122.415960181331) 2 7 7 28859 2
611 10613 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 34 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1993 12:00:00 AM 18 3X3   6016953.5018076 2095595.9312574 37.7350584319022 -122.383795333225 (37.7350584319022, -122.383795333225) 10 3 8 58 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                    
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
633 9792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
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
645 38285 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 27 Adair St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1998 12:00:00 AM 12 3x12 Permit Number 40369 6007338.83954453 2106937.08827094 37.7656625095236 -122.417840391728 (37.7656625095236, -122.417840391728) 8 4 7 28853 19
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                    
665 203589 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 50 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 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
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
674 231751 Permitted Site 7 Maytenus boaria :: Mayten 58 1015 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 10 Width 4ft Permit Number 14253 6001960.39787 2101086.72992 37.7492946868066 -122.436024547794 (37.7492946868066, -122.436024547794) 2 4 5 28862 22
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                    
711 57691 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 120 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/1976 12:00:00 AM 8 3x3 Permit Number 16595 6001759 2096663 37.7371367196384 -122.436404416578 (37.7371367196384, -122.436404416578) 2 7 5 63 7
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                    
733 218511 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 318 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM 7 Width 3ft Permit Number 43359 5996829.51445 2089654.64111 37.7176120972009 -122.45294206803 (37.7176120972009, -122.45294206803) 9 8 6 28861 24
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
743 236478 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 222 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2020 12:00:00 AM 3 3x3 Permit Number 785288 6007898.7538 2097586.28669 37.7400188220044 -122.415241775611 (37.7400188220044, -122.415241775611) 2 7 7 28859 2
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                    

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