979 rows where qSpecies_id = 13 sorted by Fire Prevention Districts 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)
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
741 262415 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 122 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003235 2094463 37.731179778599 -122.431144235496 (37.731179778599, -122.431144235496) 9 7 5 28861 25
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
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
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
2708 50426 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Howth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778) 9 8 6 28861 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
4347 174997 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 61 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2   10/23/2020 12:00:00 AM 3 Width 4ft   6000632.91251 2088182.32659 37.7137866806885 -122.43968998482 (37.7137866806885, -122.43968998482) 9 7 6 28861 5
4377 88323 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 125 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417 2092629 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952) 9 7 6 28861 5
4664 171655 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 101 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6007664.95872 2093252.16101 37.7281051161408 -122.415743336498 (37.7281051161408, -122.415743336498) 9 3 7 309 5
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
5720 80737 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 186 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6000043.55254 2087718.30936 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357) 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
7003 177395 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 715 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001937.65614 2089768.77997 37.7182169074587 -122.435293726344 (37.7182169074587, -122.435293726344) 9 7 6 28861 5
7661 83659 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 559 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6001685.54257 2090383.45339 37.7198903425557 -122.436209138162 (37.7198903425557, -122.436209138162) 9 7 6 28861 5
8374 208843 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 40 Agua Way 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5997291.06099 2098595.63938 37.7421883896873 -122.451991423486 (37.7421883896873, -122.451991423486) 9 7 4 59 40
9933 264897 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 405 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2020 12:00:00 AM 3 3x3 Permit Number 772749 6002446.89331 2091087.07144 37.7218655485653 -122.433627676211 (37.7218655485653, -122.433627676211) 9 7 6 28861 5
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
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
11300 159230 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 144 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   5998399.17588 2087828.03812 37.712686491475 -122.44738508425 (37.712686491475, -122.44738508425) 9 7 6 28861 25
11517 72252 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 531 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6002585.93283 2090796.9641 37.7210768666757 -122.433126335006 (37.7210768666757, -122.433126335006) 9 7 6 28861 5
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
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
13493 170483 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 118 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003249.09726 2094449.59806 37.7311437787481 -122.431094542601 (37.7311437787481, -122.431094542601) 9 7 5 28861 25
14384 65195 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 277 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 2   Permit Number 27179 6002900.88646 2091805.07241 37.7238627685341 -122.432109587587 (37.7238627685341, -122.432109587587) 9 7 6 28861 5
15021 160935 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 528 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6001887.44706 2090275.94834 37.7196066271205 -122.435503539072 (37.7196066271205, -122.435503539072) 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
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
15945 262454 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 230 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3     6001065 2093436 37.7282366652571 -122.438572735463 (37.7282366652571, -122.438572735463) 9 7 6 28861 25
17107 82354 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM   3x3 Permit Number 50649 6004015.90676212 2089097.25184538 37.7164908413301 -122.428062269463 (37.7164908413301, -122.428062269463) 9 7 6 28861 5
17477 166394 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 842 Monterey Blvd 1 Sidewalk: Property side : Cutout Tree Private 2   08/30/2019 12:00:00 AM 3 Width 3ft   5996498.63435 2094752.41973 37.731590420751 -122.454453810411 (37.731590420751, -122.454453810411) 9 7 4 59 40
17706 264746 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 300x Howth St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2020 12:00:00 AM 3 3x3   5997131 2090234 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186) 9 8 6 28861 24
18090 177402 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 670 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002753.39847 2089622.73249 37.7178621851574 -122.432463629087 (37.7178621851574, -122.432463629087) 9 7 6 28861 5
18162 83433 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 760 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6000998.571 2089370.50235 37.7170699516967 -122.438511216421 (37.7170699516967, -122.438511216421) 9 7 6 28861 5
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
21267 177432 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 66 Gladstone Dr 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6006350.82649 2094014.80407 37.730125204807 -122.420340452271 (37.730125204807, -122.420340452271) 9 7 7 28861 5
23346 177418 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 857 Dartmouth St 1 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6009516.77243 2090302.76478 37.7201106197971 -122.409133494811 (37.7201106197971, -122.409133494811) 9 3 7 309 28
24131 177447 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 762 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002442.74838 2087164.23323 37.7110940664123 -122.433361825211 (37.7110940664123, -122.433361825211) 9 7 6 28861 5
25495 208853 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 54 Martha Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6000650.73977 2095621.13276 37.7342129598544 -122.440161475975 (37.7342129598544, -122.440161475975) 9 7 5 63 40
26576 173651 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 80 Entrada Ct 3 Sidewalk: Property side : Yard Tree Private 2   12/21/2016 12:00:00 AM 3 4x10   5992424.45657 2092194.59394 37.7243327619491 -122.468352901223 (37.7243327619491, -122.468352901223) 9 8 4 59 40
26944 105800 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 207 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2014 12:00:00 AM 3   Permit Number 769635 6010004.04754 2087785.06673 37.71322482385 -122.407271751589 (37.71322482385, -122.407271751589) 9 7 8 309 39
28421 95734 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 626 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767481 6002384.8 2090170.7 37.7193458734928 -122.433776853042 (37.7193458734928, -122.433776853042) 9 7 6 28861 5
29701 88320 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 645 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.7175073196157 -122.432824059512 (37.7175073196157, -122.432824059512) 9 7 6 28861 5
32076 208848 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 281 Lobos St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994210.24416 2088699.7294 37.7148396860693 -122.461926423875 (37.7148396860693, -122.461926423875) 9 8 6 28861 24
32238 177429 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 278 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005195.23308 2094056.19803 37.7301736773527 -122.424338433387 (37.7301736773527, -122.424338433387) 9 7 6 28861 5
33505 110563 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 135 Theresa St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x9   6002082.974 2093709.61136 37.7290457953117 -122.435073124425 (37.7290457953117, -122.435073124425) 9 7 6 28861 25
36556 88319 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 631 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51310 6002604.8 2089521.8 37.7175766192591 -122.432970060785 (37.7175766192591, -122.432970060785) 9 7 6 28861 5
38498 88312 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Athens St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51303 6003514 2090320 37.7198198301278 -122.429884275062 (37.7198198301278, -122.429884275062) 9 7 6 28861 5
38674 177406 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 618 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002461.15734 2090172.80832 37.7193559950662 -122.433513065093 (37.7193559950662, -122.433513065093) 9 7 6 28861 5
38952 177433 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 439 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008733.06168 2093861.61414 37.7298385306021 -122.412093908309 (37.7298385306021, -122.412093908309) 9 3 7 309 28
39763 177405 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 688 Vienna St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002677.69306 2089500.91725 37.7175234141583 -122.432716611994 (37.7175234141583, -122.432716611994) 9 7 6 28861 5
40470 87788 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 114 Theresa St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.434669544642 (37.7289708079503, -122.434669544642) 9 7 6 28861 25
41323 177426 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 125 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6003455.72001 2092686.06716 37.7263132250654 -122.430254442684 (37.7263132250654, -122.430254442684) 9 7 6 28861 5
42370 83565 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 647 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769747 6003095.84203 2089582.30789 37.7177706009018 -122.431277069882 (37.7177706009018, -122.431277069882) 9 7 6 28861 5
44564 177412 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 539 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6003697.34204 2090030.0653 37.719034114214 -122.429229863064 (37.719034114214, -122.429229863064) 9 7 6 28861 5
44619 177424 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 85 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000559.94682 2092109.10715 37.7245645787726 -122.440223605655 (37.7245645787726, -122.440223605655) 9 7 6 28861 25
45409 114908 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 281 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994225 2088676 37.714775380269 -122.461873702271 (37.714775380269, -122.461873702271) 9 8 6 28861 24
47926 110564 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 135 Theresa St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x9   6002092.75194 2093699.46339 37.7290184865087 -122.435038595882 (37.7290184865087, -122.435038595882) 9 7 6 28861 25
48747 177428 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 274 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005170.17326 2094055.30176 37.7301698012868 -122.424425004805 (37.7301698012868, -122.424425004805) 9 7 6 28861 5
49485 95113 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 887 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54041 6001057 2091844.3 37.7238657652599 -122.438486397461 (37.7238657652599, -122.438486397461) 9 7 6 28861 25
50384 208857 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1 Gennessee St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5997408.76137 2093610.56673 37.7285073190505 -122.451225020336 (37.7285073190505, -122.451225020336) 9 7 4 28861 40
50794 69419 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 168 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 9   Permit Number 33524 6001328.44378 2087365.87339 37.7115844451475 -122.437227553813 (37.7115844451475, -122.437227553813) 9 7 6 28861 5
52918 177393 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1657 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   6006855.18138 2087491.99559 37.7122433757141 -122.418134570866 (37.7122433757141, -122.418134570866) 9 7 8 309 39
56875 82146 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1083 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51167 5995391.16373818 2098013.23554983 37.7404802453018 -122.458518484651 (37.7404802453018, -122.458518484651) 9 7 4 59 40
58397 177397 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 650 France Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6002573.73742 2089477.35526 37.7174528218741 -122.433074256169 (37.7174528218741, -122.433074256169) 9 7 6 28861 5
62045 49067 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1298 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50555 5995836.31315767 2092013.47244835 37.7240319217297 -122.45654557668 (37.7240319217297, -122.45654557668) 9 8 4 28861 40
62070 115256 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 277 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 773180 5995612.8 2091840.6 37.7235444201772 -122.457305721784 (37.7235444201772, -122.457305721784) 9 8 4 28861 24
62802 110565 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 135 Theresa St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 3x9   6002103.51268 2093689.48997 37.7289917127743 -122.435000682233 (37.7289917127743, -122.435000682233) 9 7 6 28861 25
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
65658 83995 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2008 12:00:00 AM 4 3x3 Permit Number 51873 6003949.05097 2088987.25376 37.7161850277922 -122.428285520976 (37.7161850277922, -122.428285520976) 9 7 6 28861 5
66514 177408 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 638 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6002397.88484 2090069.70643 37.7190693100882 -122.433724409363 (37.7190693100882, -122.433724409363) 9 7 6 28861 5
66627 104506 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 631 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096) 9 7 6 28861 5
66805 258499 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 379 Arleta Ave 1 Sidewalk: Curb side : Tree DPW 1           6009061.07772 2088406.01218 37.7148769915418 -122.41057481256 (37.7148769915418, -122.41057481256) 9 7 8 309 39
69271 177392 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1654 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   6006773.14965 2087593.0806 37.7125163163365 -122.418425260531 (37.7125163163365, -122.418425260531) 9 7 8 309 39
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
70653 208855 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 358 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5999047.68761 2095262.2243 37.7331360864596 -122.445677914709 (37.7331360864596, -122.445677914709) 9 7 4 59 40
73041 177416 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 538 Madrid St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002518.22292 2090772.40994 37.7210056052925 -122.433358634398 (37.7210056052925, -122.433358634398) 9 7 6 28861 5
73463 208840 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1350 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5995903.35402 2092975.62657 37.7266776159651 -122.456383367909 (37.7266776159651, -122.456383367909) 9 7 4 28861 40
76578 109714 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Trumbull St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2015 12:00:00 AM 3 3x3 Permit Number 772039 6005020.03097 2094315.25797 37.7308751035831 -122.424962554792 (37.7308751035831, -122.424962554792) 9 7 6 28861 5
76797 177417 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1x Rolph St 1 Median : Cutout Tree DPW 1     7 Width 4ft   6000503.4246 2088653.73075 37.7150736797726 -122.440171325345 (37.7150736797726, -122.440171325345) 9 7 6 28861 5
76864 208847 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 422 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995505.44933 2090582.52466 37.7200838784427 -122.457585828931 (37.7200838784427, -122.457585828931) 9 8 6 28861 24
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
80700 253542 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1000 Cayuga Ave 10 Back Yard : Yard Tree DPW 1   10/03/2017 02:42:00 PM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
81820 104632 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 323 Madrid St   Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3   Permit Number 773809 6003337.3 2091944.5 37.7242703388921 -122.430610922244 (37.7242703388921, -122.430610922244) 9 7 6 28861 5
84671 88351 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 700 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51333 6002622.22718 2089414.56654 37.7172831683531 -122.432902166399 (37.7172831683531, -122.432902166399) 9 7 6 28861 5
85856 52415 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 445 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50993 5997805.99655674 2094075.37872241 37.729806319232 -122.449885248514 (37.729806319232, -122.449885248514) 9 7 4 28861 40
85859 258498 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 379 Arleta Ave 1 Sidewalk: Curb side : Tree DPW 1           6009061.07772 2088406.01218 37.7148769915418 -122.41057481256 (37.7148769915418, -122.41057481256) 9 7 8 309 39
88916 95123 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 75 Oneida Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54050 6000595.4 2090675.6 37.7206305128633 -122.439998309146 (37.7206305128633, -122.439998309146) 9 7 6 28861 25
89811 87785 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 114 Theresa St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.434669544642 (37.7289708079503, -122.434669544642) 9 7 6 28861 25
93952 50024 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1704 Felton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM 3   Permit Number 46757 6005953.21642 2092396.45471 37.7256591580411 -122.421600147046 (37.7256591580411, -122.421600147046) 9 7 7 309 5
94665 177430 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 294 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6005292.64234 2094059.99778 37.73018961064 -122.424001946647 (37.73018961064, -122.424001946647) 9 7 6 28861 5
95991 253541 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1000 Cayuga Ave 9 Back Yard : Yard Tree DPW 1   10/03/2017 03:59:00 PM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
96870 87781 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 270 Delano Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50517 5999921.6 2092148.7 37.7246369273224 -122.442433121703 (37.7246369273224, -122.442433121703) 9 7 6 28861 25
96875 177423 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 270 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999939.77666 2092147.85861 37.7246356530907 -122.442370227117 (37.7246356530907, -122.442370227117) 9 7 6 28861 25
98601 88326 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 559 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51315 6001911 2090236 37.7194982755804 -122.435419269027 (37.7194982755804, -122.435419269027) 9 7 6 28861 5
100635 177413 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003506.69699 2090312.38662 37.7197985118857 -122.429908976214 (37.7197985118857, -122.429908976214) 9 7 6 28861 5
102452 177446 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 323 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6003320.62443 2091964.27953 37.7243237043587 -122.43066997804 (37.7243237043587, -122.43066997804) 9 7 6 28861 5
103258 95762 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 417 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 2 3x3 Permit Number 767499 6004100.38912 2090668.84671 37.720810876907 -122.427882177716 (37.720810876907, -122.427882177716) 9 7 6 28861 5
104312 108448 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 90-98X Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3   6004670.84101 2090640.56593 37.7207654791334 -122.425908286356 (37.7207654791334, -122.425908286356) 9 7 6 28861 5
104425 208844 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 335 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   5995829.06738 2094841.15023 37.7317956298598 -122.456775035249 (37.7317956298598, -122.456775035249) 9 7 4 59 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)
);