979 rows where qSpecies_id = 13 sorted by PermitNotes descending

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)
37880 53932 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 140 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM 1   Permit Number 9646 5993064.17697 2114524.47346 37.7856817557629 -122.467764782699 (37.7856817557629, -122.467764782699) 11 6 2 54 11
16331 230075 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 710 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2020 12:00:00 AM 3 Width 3ft Permit Number 785519 6007486.86917 2097737.12894 37.7404098445288 -122.41667658998 (37.7404098445288, -122.41667658998) 2 7 7 28859 2
1556 158441 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 49 Van Buren St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2020 12:00:00 AM 3 3x3 Permit Number 785489 6002069.34164 2096386.56921 37.7363953338756 -122.435311658815 (37.7363953338756, -122.435311658815) 2 7 5 63 7
1903 220552 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 13 Ohlone Way 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 785489 6002169.64489 2096371.31931 37.7363591568587 -122.434963778568 (37.7363591568587, -122.434963778568) 2 7 5 63 7
17760 158440 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 49 Van Buren St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2020 12:00:00 AM 3 3x3 Permit Number 785489 6002067.69843 2096375.7626 37.7363655681024 -122.435316567307 (37.7363655681024, -122.435316567307) 2 7 5 63 7
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
1002 260458 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 835 Darien Way 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2019 12:00:00 AM 3 6x10 Permit Number 784514 5994066 2094094 37.7296427463027 -122.462816092129 (37.7296427463027, -122.462816092129) 9 8 4 59 40
10378 163649 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 226 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 07/01/2020 12:00:00 AM 3 3x4 Permit Number 784460 5994737.04022 2087470.63166 37.71149518743 -122.460016622663 (37.71149518743, -122.460016622663) 9 8 6 28861 24
1059 262280 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
3880 262281 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
11800 262282 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
11319 255592 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2019 12:00:00 AM 3 3x3 Permit Number 784421 6006714 2105007 37.7603277549802 -122.419864609266 (37.7603277549802, -122.419864609266) 2 4 7 28859 19
14489 255590 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199X San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2019 12:00:00 AM 3 3x3 Permit Number 784421 6006714 2105007 37.7603277549802 -122.419864609266 (37.7603277549802, -122.419864609266) 2 4 7 28859 19
821 261708 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 1 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
12273 261709 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 2 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
18618 170106 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 527 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2   08/18/2020 12:00:00 AM 3 6x10 Permit Number 783167 5997920.28587 2095246.22061 37.7330277118397 -122.449574473879 (37.7330277118397, -122.449574473879) 9 7 4 59 40
126116 236828 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 11 Woodland Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/10/2019 12:00:00 AM 3 Width 3ft Permit Number 783065 5997011.57389 2106623.6128 37.7642151878129 -122.453537316698 (37.7642151878129, -122.453537316698) 15 5 11 29492 12
52039 250725 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
89454 254862 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
73885 123609 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/2018 12:00:00 AM 3 Width 5ft Permit Number 782700 5995062.26821 2114886.47744 37.786790890934 -122.460878253711 (37.786790890934, -122.460878253711) 11 6 1 54 11
12863 154063 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1781 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 4x3 Permit Number 782693 6014599.10763 2096821.84485 37.7382941111836 -122.392021081628 (37.7382941111836, -122.392021081628) 10 3 8 58 1
16680 256664 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 5x5 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
23388 256663 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
103481 127870 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1863 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/2018 12:00:00 AM 3 Width 3ft Permit Number 782589 6007272.90865 2118759.36484 37.798119905069 -122.418906991373 (37.798119905069, -122.418906991373) 5 1 10 28858 32
94680 132274 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2160 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782573 6005107.40746 2116851.05926 37.7927580094371 -122.426264329748 (37.7927580094371, -122.426264329748) 13 9 1 28858 27
139673 127383 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2160 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782573 6005103.8437 2116881.77559 37.792842147287 -122.426278848408 (37.792842147287, -122.426278848408) 13 9 1 28858 27
146912 125204 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2000 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782573 6005093.29974 2116822.56414 37.7926789715987 -122.426311113392 (37.7926789715987, -122.426311113392) 13 9 1 28858 27
191835 136108 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2160 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782573 6005089.07981 2116957.29381 37.7930486667182 -122.426335311432 (37.7930486667182, -122.426335311432) 13 9 1 28858 27
17 164866 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 719 Faxon Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/16/2020 12:00:00 AM 3 4x6 Permit Number 782492 5994853.78052 2092811.30491 37.7261661184654 -122.459999785581 (37.7261661184654, -122.459999785581) 9 7 4 28861 40
4564 264686 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/15/2020 12:00:00 AM 3 3x3 Permit Number 782284 5990129.23032 2098669.31502 37.7419778589065 -122.476759924113 (37.7419778589065, -122.476759924113) 1 8 3 29491 35
194351 265046 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1250 Eucalyptus Dr 4 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
64603 236697 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 38 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2018 12:00:00 AM 3 3x3 Permit Number 781747 6000330.16307 2101460.4358 37.7502280437052 -122.441688731669 (37.7502280437052, -122.441688731669) 2 4 5 28862 22
170390 203239 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 115 Vasquez Ave 1 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995169.40317 2099688.3978 37.7450670773024 -122.459406527086 (37.7450670773024, -122.459406527086) 1 8 4 59 40
126802 254628 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 210 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/2018 12:00:00 AM 3 3x3 Permit Number 781525 6004782.66269 2093766.92621 37.7293560955828 -122.425744162451 (37.7293560955828, -122.425744162451) 9 7 6 28861 5
6755 264922 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
15881 264923 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Urbano Dr 2 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
157993 177434 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 131 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 781326 6010258.4147 2094004.87757 37.7303173692474 -122.406830655731 (37.7303173692474, -122.406830655731) 10 3 7 309 28
4724 262586 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
15827 262585 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
16244 243490 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 956 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2018 12:00:00 AM 3 3x3 Permit Number 780577 6007549.93258 2104087.5144 37.7578501172959 -122.416908354249 (37.7578501172959, -122.416908354249) 2 4 7 28859 19
194426 211685 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2017 12:00:00 AM 3 3x3 Permit Number 780277 5995307.7579 2090507.37878 37.7198661876486 -122.458263740606 (37.7198661876486, -122.458263740606) 9 8 6 28861 24
194433 211684 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 95 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 3x3 Permit Number 780277 5995309.61761 2090529.04665 37.7199257893373 -122.458258879737 (37.7199257893373, -122.458258879737) 9 8 6 28861 24
102182 253344 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2586 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945) 1 8 3 29491 35
86635 32310 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.21346 2105535.41825 37.7620465904907 -122.403382999439 (37.7620465904907, -122.403382999439) 10 3 8 28856 29
94823 102805 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011492.26434 2105507.65774 37.7619704808857 -122.403373953167 (37.7619704808857, -122.403373953167) 10 3 8 28856 29
126713 53079 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.70702 2105522.94409 37.7620123668039 -122.4033804148 (37.7620123668039, -122.4033804148) 10 3 8 28856 29
64837 253415 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 Stoneybrook Ave   Front Yard : Cutout Tree Private 2   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.42686 37.7299849530428 -122.421802746417 (37.7299849530428, -122.421802746417) 9 7 6 28861 5
35612 255646 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1542 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2018 12:00:00 AM 3 3x5 Permit Number 779777 5989956.05847 2104865.26605 37.7589802621415 -122.477811515827 (37.7589802621415, -122.477811515827) 1 8 3 56 35
15356 251313 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 390 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
18657 251312 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1499 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
27321 243475 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 109X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2017 12:00:00 AM 3 3x3 Permit Number 779653 6007857.826 2097024.89565 37.7384750655589 -122.415343555473 (37.7384750655589, -122.415343555473) 2 7 7 28859 2
49934 243477 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 109 Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2017 12:00:00 AM 3 3x3 Permit Number 779653 6007827.74992 2097028.56453 37.7384834490575 -122.415447803985 (37.7384834490575, -122.415447803985) 2 7 7 28859 2
138064 95581 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3881 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2017 12:00:00 AM 3 3x3 Permit Number 779561 6003940 2101864 37.7515411523314 -122.429234461777 (37.7515411523314, -122.429234461777) 2 4 5 28862 22
136502 87851 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 97 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2013 12:00:00 AM   3x3 Permit Number 779093 6007313 2098782 37.7432690474632 -122.417351790512 (37.7432690474632, -122.417351790512) 2 7 7 28859 2
9768 225019 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4326 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2017 12:00:00 AM 3 Width 3ft Permit Number 779083 6001573.01872 2104694.86149 37.7591797334691 -122.437622474895 (37.7591797334691, -122.437622474895) 2 4 5 28862 3
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
139506 254366 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 Ashton Ave 1 Front Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929 5994130.90698 2090445.22251 37.7196278254181 -122.462327167234 (37.7196278254181, -122.462327167234) 9 8 6 28861 24
158442 254367 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 Ashton Ave 2 Front Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929 5994130.90698 2090445.22251 37.7196278254181 -122.462327167234 (37.7196278254181, -122.462327167234) 9 8 6 28861 24
79925 115368 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 ELSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 778647 6007415 2098925 37.7436674318334 -122.417009230148 (37.7436674318334, -122.417009230148) 2 7 7 28859 2
172165 121338 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1543 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2016 12:00:00 AM 3 3x3 Permit Number 778568 5998304.86118 2105256.47064 37.7605354110025 -122.44896573677 (37.7605354110025, -122.44896573677) 15 5 11 29492 12
119007 109908 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1401 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/18/2015 02:04:00 PM 3 3x3 Permit Number 778313 6008340.42119 2109862.66125 37.7737517633724 -122.414583173274 (37.7737517633724, -122.414583173274) 8 2 9 28853 34
34346 99307 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 59 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3 3x3 Permit Number 777839 6006944.8 2099028.3 37.7439246092205 -122.418642395457 (37.7439246092205, -122.418642395457) 2 7 7 28859 2
1859 243453 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 73 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 04/01/2016 12:00:00 AM 0 4x6 Permit Number 777687 6007416.81803 2098970.61704 37.7437927883108 -122.417006175297 (37.7437927883108, -122.417006175297) 2 7 7 28859 2
129691 114755 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 89 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM 1   Permit Number 777135 6010155.72688 2091460.80739 37.7233261394813 -122.407006415641 (37.7233261394813, -122.407006415641) 10 3 7 309 28
157732 114754 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Karen Ct   Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777134 6010271.6 2091687.4 37.7239547991887 -122.406621822462 (37.7239547991887, -122.406621822462) 10 3 7 309 28
58994 114753 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM 1   Permit Number 777133 6010495.97692 2091580.43732 37.7236736527876 -122.405838652231 (37.7236736527876, -122.405838652231) 10 3 7 309 28
163418 113661 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3060 JACKSON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   5x5 Permit Number 776720 5999534 2116404 37.7912138957856 -122.445516329339 (37.7912138957856, -122.445516329339) 13 6 1 29490 27
20416 17382 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1627 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105) 10 3 8 58 1
29086 112523 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995199.36548 2114291.31706 37.7851646286632 -122.460360793578 (37.7851646286632, -122.460360793578) 11 6 2 54 11
98204 112522 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995198.14893 2114301.99699 37.7851938828924 -122.460365776533 (37.7851938828924, -122.460365776533) 11 6 2 54 11
78939 32526 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 871 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2015 12:00:00 AM     Permit Number 776214 6007576.4663397 2095282.92697428 37.7336761840288 -122.416193025137 (37.7336761840288, -122.416193025137) 2 7 7 28859 2
67384 112573 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
144718 112574 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
46287 164504 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1241 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2018 12:00:00 AM 3 4x4 Permit Number 775664 5997725 2106255 37.7632439412228 -122.451043208712 (37.7632439412228, -122.451043208712) 15 5 11 29492 9
38675 109898 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1786 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775112 5987249.9 2103123.1 37.7540393206485 -122.487042615101 (37.7540393206485, -122.487042615101) 1 8 3 56 35
69609 109685 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 266 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 775044 6005143.37702 2093783.49451 37.7294219655289 -122.424498316649 (37.7294219655289, -122.424498316649) 9 7 6 28861 5
47664 109389 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 174X Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2015 12:00:00 AM 3 3x3 Permit Number 774921 6006834.59164 2098690.08898 37.7429897522087 -122.418999487845 (37.7429897522087, -122.418999487845) 2 7 7 28859 2
26931 37803 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/02/2015 12:00:00 AM     Permit Number 774759 6010402.90992445 2091781.87036726 37.7242215408534 -122.406174555323 (37.7242215408534, -122.406174555323) 10 3 7 309 28
53411 114722 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
80677 114721 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
174661 114720 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
131019 114688 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 231 Dwight St 1 Front Yard : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.7232793364177 -122.404549596707 (37.7232793364177, -122.404549596707) 10 3 7 309 28
10118 108815 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 474 Munich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.38143 37.7181966752665 -122.428924204145 (37.7181966752665, -122.428924204145) 9 7 6 28861 5
183971 108814 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 470 Munich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774651 6003792.96606 2089744.94608 37.7182566522639 -122.42887901198 (37.7182566522639, -122.42887901198) 9 7 6 28861 5
79752 43146 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 243 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2015 12:00:00 AM 1   Permit Number 774635 6005976.40354 2092622.55461 37.7262812865364 -122.421536041574 (37.7262812865364, -122.421536041574) 9 7 7 309 5
20705 108706 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1683 Chattanooga St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774629 6004719.93732 2102694.114 37.7538645742471 -122.42659644528 (37.7538645742471, -122.42659644528) 2 4 5 28862 22
117947 108633 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2610 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787) 11 6 1 55 33
187282 108632 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774601 6000898 2105859 37.7623377695764 -122.440040482469 (37.7623377695764, -122.440040482469) 15 5 5 28862 3
156492 108610 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 745 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774595 6007633.33742 2095945.52231 37.7354987236975 -122.416043312411 (37.7354987236975, -122.416043312411) 2 7 7 28859 2
22140 108608 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 46 Mirabel Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774593 6007564.86266 2099909.67409 37.7463795558054 -122.416560777242 (37.7463795558054, -122.416560777242) 2 7 7 28859 2
130803 108592 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 669 Parker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774577 5997227.20075 2110944.62571 37.7760919347852 -122.453103475186 (37.7760919347852, -122.453103475186) 15 6 2 54 16
64208 71505 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 328 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.7581027211657 -122.419885554796 (37.7581027211657, -122.419885554796) 2 4 7 28859 19
87006 113267 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Exeter St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.04437 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496) 10 3 8 58 1
45290 112888 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3980 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2015 12:00:00 AM     Permit Number 774440 5995705.4 2115208.7 37.7877126116995 -122.458676518899 (37.7877126116995, -122.458676518899) 11 6 1 54 31
147550 113269 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1328 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 774425 6016744.9 2093624.7 37.7296342890732 -122.384379303046 (37.7296342890732, -122.384379303046) 10 3 8 58 1
19852 33783 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.92338 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042) 12 2 9 28855 6
81471 33774 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.7914556085404 -122.396022998165 (37.7914556085404, -122.396022998165) 12 2 9 28855 6
97909 33782 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013852.02109 2116179.41654 37.7914042329729 -122.395960281264 (37.7914042329729, -122.395960281264) 12 2 9 28855 6
104923 33800 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013865.37275 2116161.97621 37.7913570887062 -122.395912861799 (37.7913570887062, -122.395912861799) 12 2 9 28855 6
134517 33792 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013856.54517 2116173.60161 37.7913885182281 -122.395944220262 (37.7913885182281, -122.395944220262) 12 2 9 28855 6

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