trees

129 rows where Police Districts = 2 and qSpecies_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
1156 31893 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 8   Permit Number 35323 6008432.94494 2108718.71395 37.7706159506067 -122.414182168285 (37.7706159506067, -122.414182168285) 8 2 9 28853 19
2430 224109 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006481.46308 2109309.64111 37.7721286885111 -122.420974342101 (37.7721286885111, -122.420974342101) 8 2 9 28853 19
9156 73920 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6008409.30532 2108731.32076 37.7706492380987 -122.414264830382 (37.7706492380987, -122.414264830382) 8 2 9 28853 19
9467 191059 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 215 05th St 2 : Tree Private 2     6 Width 5ft   6011805.95608 2111927.87879 37.7796164636776 -122.402740539939 (37.7796164636776, -122.402740539939) 14 2 9 28856 34
9670 85554 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 360X 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008520.7969 2108615.740864 37.7703381448181 -122.413871001048 (37.7703381448181, -122.413871001048) 8 2 9 28853 19
14957 85546 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 250X 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007915.610259 2108965.748791 37.7712651780879 -122.415989137093 (37.7712651780879, -122.415989137093) 8 2 9 28853 19
15417 224105 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 35 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006280.26739 2109523.46395 37.7727044515829 -122.421685485523 (37.7727044515829, -122.421685485523) 8 2 9 28853 19
15449 85521 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2013 12:00:00 AM 3     6008760.539184 2108527.457431 37.7701092002187 -122.413035486584 (37.7701092002187, -122.413035486584) 8 2 9 28853 19
17486 191662 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6013078.45063 2110885.87068 37.776826313422 -122.398265274217 (37.776826313422, -122.398265274217) 6 2 9 28856 34
17998 85553 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 332 12th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6008375 2108695 37.7705475827471 -122.414380922989 (37.7705475827471, -122.414380922989) 8 2 9 28853 19
18144 70989 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6   Permit Number 779764 6008399.52743 2108738.25581 37.770667730873 -122.414299143103 (37.770667730873, -122.414299143103) 8 2 9 28853 19
18922 74929 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 39 Stillman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6014021.82023 2112985.48182 37.7826438712502 -122.395148955186 (37.7826438712502, -122.395148955186) 6 2 9 28856 6
21310 254733 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 398 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM   3x3   6008656 2108503 37.7700361768699 -122.413395357755 (37.7700361768699, -122.413395357755) 8 2 9 28853 19
24502 191066 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 374 05th St 1 : Tree Private 2     1 Width 3ft   6011926.00282 2111797.31864 37.7792646776498 -122.40231606173 (37.7792646776498, -122.40231606173) 14 2 9 28856 34
31166 191060 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 236 Clara St 0 : Tree Private 2     1 Width 2ft   6011653.22625 2111699.06795 37.7789796735174 -122.403252800969 (37.7789796735174, -122.403252800969) 14 2 9 28856 34
32023 85527 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 301X 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008215.27395 2108839.588309 37.7709356143391 -122.414943653714 (37.7709356143391, -122.414943653714) 8 2 9 28853 19
33288 191666 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 13 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6013244.57038 2111045.61556 37.7772741883968 -122.397701819284 (37.7772741883968, -122.397701819284) 6 2 9 28856 34
36375 191665 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 11 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6013224.69067 2111029.20074 37.7772280099979 -122.397769438408 (37.7772280099979, -122.397769438408) 6 2 9 28856 34
42967 173911 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
43105 85526 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 301X 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008215.27395 2108839.588309 37.7709356143391 -122.414943653714 (37.7709356143391, -122.414943653714) 8 2 9 28853 19
46431 173910 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
51660 122788 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1655 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007172 2109097 37.7715837270561 -122.418570631079 (37.7715837270561, -122.418570631079) 8 2 9 28853 19
54350 90432 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 49X Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3x3   6006339.227867 2109481.166325 37.7725916370239 -122.42147852996 (37.7725916370239, -122.42147852996) 8 2 9 28853 19
55451 256092 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1           6007860.62906 2108997.35701 37.7713488754693 -122.416181558888 (37.7713488754693, -122.416181558888) 8 2 9 28853 19
56042 100781 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 211 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007785.14748 2109092.4486 37.7716057300517 -122.416449390639 (37.7716057300517, -122.416449390639) 8 2 9 28853 19
56742 191077 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 334 12th St 1 : Tree Private 2     4 Width 3ft   6008423.37153 2108669.51917 37.7704803355249 -122.414211801833 (37.7704803355249, -122.414211801833) 8 2 9 28853 19
59073 90431 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 49X Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/2014 12:00:00 AM 3 3x3 Permit Number 770519 6006339.227867 2109481.166325 37.7725916370239 -122.42147852996 (37.7725916370239, -122.42147852996) 8 2 9 28853 19
59674 191663 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6013137.81115 2110946.71833 37.7769966935644 -122.398064196625 (37.7769966935644, -122.398064196625) 6 2 9 28856 34
61671 191072 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 396 12th St 4 : Tree Private 2     5 Width 3ft Permit Number 779704 6008614.31812 2108613.9778 37.7703385556015 -122.413547385421 (37.7703385556015, -122.413547385421) 8 2 9 28853 19
62515 90438 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 48X Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3x3   6006368.067431 2109508.884182 37.7726693696552 -122.421380739497 (37.7726693696552, -122.421380739497) 8 2 9 28853 19
62574 191667 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 15 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6013269.51559 2111071.49251 37.7773466296777 -122.397617340561 (37.7773466296777, -122.397617340561) 6 2 9 28856 34
63023 191073 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 352 12th St 1 : Tree Private 2     6 Width 3ft   6008306.80877 2108790.44152 37.7708058118746 -122.41462355284 (37.7708058118746, -122.41462355284) 8 2 9 28853 19
64496 85535 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 5     6007364.04136 2109271.58584 37.7720739081089 -122.41791872548 (37.7720739081089, -122.41791872548) 8 2 9 28853 19
65939 85545 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007812 2109019 37.7714055675706 -122.416351302737 (37.7714055675706, -122.416351302737) 8 2 9 28853 19
66319 251315 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008830 2108632 37.7704001487298 -122.41280261367 (37.7704001487298, -122.41280261367) 8 2 9 28853 19
68081 191061 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 236 Clara St 0 : Tree Private 2     6 Width 3ft   6011653.56606 2111728.79849 37.779061325667 -122.403253717397 (37.779061325667, -122.403253717397) 14 2 9 28856 34
69618 191057 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 351 Saint Francis Pl 2 : Tree Private 2     4 Width 1ft   6013212.85575 2113183.51616 37.78314260738 -122.397961541709 (37.78314260738, -122.397961541709) 6 2 9 28856 6
69970 191076 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 320 12th St 2 : Tree Private 2     5 Width 3ft   6008335.79472 2108708.57829 37.7705826631 -122.414517495805 (37.7705826631, -122.414517495805) 8 2 9 28853 19
70118 85528 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 225X 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007748.883838 2109107.739625 37.771645676205 -122.416575912394 (37.771645676205, -122.416575912394) 8 2 9 28853 19
70902 85555 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 360X 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008520.7969 2108615.740864 37.7703381448181 -122.413871001048 (37.7703381448181, -122.413871001048) 8 2 9 28853 19
71150 191672 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 252 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007932.20387 2108945.73927 37.7712111695782 -122.415930321737 (37.7712111695782, -122.415930321737) 8 2 9 28853 19
72439 246381 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1655 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6006946.7351 2109071.9998 37.7715023978524 -122.419348063063 (37.7715023978524, -122.419348063063) 8 2 9 28853 19
73566 90435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3x3   6006637.011883 2109229.055885 37.7719161875872 -122.420430563972 (37.7719161875872, -122.420430563972) 8 2 9 28853 19
76303 85538 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 180 12th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6007511.05272 2109187.82256 37.7718521865557 -122.417404262918 (37.7718521865557, -122.417404262918) 8 2 9 28853 19
80770 85540 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 180 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6007564 2109156 37.7717677882225 -122.417218858728 (37.7717677882225, -122.417218858728) 8 2 9 28853 19
81603 85537 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007421.29052 2109238.78217 37.7719870587743 -122.417718370032 (37.7719870587743, -122.417718370032) 8 2 9 28853 19
82399 224103 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 46 Gough St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006296.39827 2109605.75372 37.7729313091609 -122.421635532653 (37.7729313091609, -122.421635532653) 8 2 9 28853 19
82966 255270 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 35 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6006259.41691 2109543.76315 37.7727590125447 -122.421759051834 (37.7727590125447, -122.421759051834) 8 2 9 28853 19
88212 191064 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 236 Clara St 3 : Tree Private 2     8 Width 3ft   6011636.45479 2111621.63376 37.7787661204973 -122.403305371746 (37.7787661204973, -122.403305371746) 14 2 9 28856 34
92376 85523 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6008760.539184 2108527.457431 37.7701092002187 -122.413035486584 (37.7701092002187, -122.413035486584) 8 2 9 28853 19
92559 91019 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 30 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/17/2008 12:00:00 AM 3 3x3   6006519.340216 2109351.489576 37.7722457294122 -122.420846293315 (37.7722457294122, -122.420846293315) 8 2 9 28853 19
92791 191062 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 236 Clara St 1 : Tree Private 2     8 Width 3ft   6011643.64166 2111627.47024 37.7787825475055 -122.403280920094 (37.7787825475055, -122.403280920094) 14 2 9 28856 34
93307 224107 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006435.98558 2109358.16079 37.7722593483308 -122.421135098612 (37.7722593483308, -122.421135098612) 8 2 9 28853 19
94102 28997 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 321X 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2005 12:00:00 AM 6 3x3   6008985.04718 2109404.34917 37.7725295406243 -122.412320901705 (37.7725295406243, -122.412320901705) 8 2 9 28853 34
95257 110438 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 224 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2015 12:00:00 AM 3 3x3 Permit Number 775407 6007788.2 2109003.3 37.7713611206973 -122.416432516069 (37.7713611206973, -122.416432516069) 8 2 9 28853 19
96061 90436 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 8 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3x3   6006637.011883 2109229.055885 37.7719161875872 -122.420430563972 (37.7719161875872, -122.420430563972) 8 2 9 28853 19
96936 85544 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007812 2109019 37.7714055675706 -122.416351302737 (37.7714055675706, -122.416351302737) 8 2 9 28853 19
99188 85556 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 360X 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008520.7969 2108615.740864 37.7703381448181 -122.413871001048 (37.7703381448181, -122.413871001048) 8 2 9 28853 19
103270 90433 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 49X Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2008 12:00:00 AM 3 3x3   6006339.227867 2109481.166325 37.7725916370239 -122.42147852996 (37.7725916370239, -122.42147852996) 8 2 9 28853 19
103339 191673 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 252 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007961.75494 2108927.69321 37.771163280688 -122.415826825061 (37.771163280688, -122.415826825061) 8 2 9 28853 19
104675 85543 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007812 2109019 37.7714055675706 -122.416351302737 (37.7714055675706, -122.416351302737) 8 2 9 28853 19
104744 85536 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007398.39847 2109252.27561 37.7720228203246 -122.417798512189 (37.7720228203246, -122.417798512189) 8 2 9 28853 19
104786 191065 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 250 Clara St 1 : Tree Private 2     7 Width 3ft   6011631.45196 2111618.92007 37.7787583899224 -122.403322487638 (37.7787583899224, -122.403322487638) 14 2 9 28856 34
105140 85550 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 250X 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007915.610259 2108965.748791 37.7712651780879 -122.415989137093 (37.7712651780879, -122.415989137093) 8 2 9 28853 19
105371 191674 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 252 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007983.0809 2108917.80929 37.7711373406456 -122.41575235758 (37.7711373406456, -122.41575235758) 8 2 9 28853 19
105700 191671 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 252 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007916.30437 2108953.33208 37.7712311237499 -122.415985856679 (37.7712311237499, -122.415985856679) 8 2 9 28853 19
106066 191079 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1559 Howard St 2 : Tree Private 2     9 Width 3ft   6007858.27887 2109378.13672 37.7723942745191 -122.416216661379 (37.7723942745191, -122.416216661379) 8 2 9 28853 19
106973 85522 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008760.539184 2108527.457431 37.7701092002187 -122.413035486584 (37.7701092002187, -122.413035486584) 8 2 9 28853 19
108528 191677 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007442.31511 2109225.32703 37.7719512972482 -122.417644690367 (37.7719512972482, -122.417644690367) 8 2 9 28853 19
108598 191067 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 374 05th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/14/2014 12:00:00 AM 8 Width 3ft   6011934.76855 2111785.94153 37.779233928048 -122.402284937117 (37.779233928048, -122.402284937117) 14 2 9 28856 34
109402 255703 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 28 06th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2018 12:00:00 AM 3 3x3 Permit Number 782078 6009781.99069 2112750.42942 37.7817617797421 -122.409800416291 (37.7817617797421, -122.409800416291) 14 2 9 28853 34
112674 85547 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 250X 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007915.610259 2108965.748791 37.7712651780879 -122.415989137093 (37.7712651780879, -122.415989137093) 8 2 9 28853 19
113152 85530 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101X 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007333.48731 2109350.50444 37.7722888802537 -122.418030010287 (37.7722888802537, -122.418030010287) 8 2 9 28853 19
113778 224106 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 35 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006301.05377 2109500.02866 37.7726412760089 -122.421611918271 (37.7726412760089, -122.421611918271) 8 2 9 28853 19
114851 192937 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 394 12th St 4 : Tree Private 2     2 Width 3ft   6008622.94883 2108550.94003 37.770165953233 -122.413513072694 (37.770165953233, -122.413513072694) 8 2 9 28853 19
116157 224110 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006506.1757 2109285.60199 37.7720640758221 -122.420887151946 (37.7720640758221, -122.420887151946) 8 2 9 28853 19
116707 85542 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6007856.45059 2108988.34971 37.7713239085987 -122.416195374412 (37.7713239085987, -122.416195374412) 8 2 9 28853 19
118077 85533 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007332.25294 2109288.61069 37.7721188652314 -122.418029891562 (37.7721188652314, -122.418029891562) 8 2 9 28853 19
119852 85539 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 180 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6007548.32218 2109164.73144 37.7717908806656 -122.417273708325 (37.7717908806656, -122.417273708325) 8 2 9 28853 19
123555 44768 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 712 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM 6   Permit Number 43876 6012361.28636 2111165.48886 37.7775541068837 -122.400765825683 (37.7775541068837, -122.400765825683) 14 2 9 28856 34
124170 85525 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 301X 12th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6008215.27395 2108839.588309 37.7709356143391 -122.414943653714 (37.7709356143391, -122.414943653714) 8 2 9 28853 19
124716 91020 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 30 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/17/2008 12:00:00 AM 3 3x3   6006519.340216 2109351.489576 37.7722457294122 -122.420846293315 (37.7722457294122, -122.420846293315) 8 2 9 28853 19
125701 85558 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 396 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008677.32979 2108520.19339 37.7700845834737 -122.413322794134 (37.7700845834737, -122.413322794134) 8 2 9 28853 19
125971 85531 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101X 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 6     6007317.96828 2109362.68703 37.7723214572932 -122.418084555959 (37.7723214572932, -122.418084555959) 8 2 9 28853 19
127278 81551 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 555 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 2 3x3 Permit Number 50132 6009979.0752 2111765.16578 37.7790675210845 -122.409049052091 (37.7790675210845, -122.409049052091) 14 2 9 28853 34
127723 251316 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008830 2108632 37.7704001487298 -122.41280261367 (37.7704001487298, -122.41280261367) 8 2 9 28853 19
128307 191669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 2 Width 3ft   6007874.13645 2108978.90348 37.771298965913 -122.416133528945 (37.771298965913, -122.416133528945) 8 2 9 28853 19
129518 85548 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 250X 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM       6007915.610259 2108965.748791 37.7712651780879 -122.415989137093 (37.7712651780879, -122.415989137093) 8 2 9 28853 19
136185 28906 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 354 05th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2014 12:00:00 AM 5 3X3 Permit Number 779305 6011835.68516 2111895.24936 37.7795285306637 -122.402635398413 (37.7795285306637, -122.402635398413) 14 2 9 28856 34
138977 191071 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 396 12th St 3 : Tree Private 2     3 Width 3ft   6008644.67271 2108598.98896 37.7702991041399 -122.413441328359 (37.7702991041399, -122.413441328359) 8 2 9 28853 19
141455 224101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2x Gough St 5 Median : Yard Tree DPW 1     2 Width 10ft   6006607.58912 2109275.93798 37.7720432565284 -122.420535668101 (37.7720432565284, -122.420535668101) 8 2 9 28853 19
142294 224104 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 35 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006259.41691 2109543.76315 37.7727590125447 -122.421759051834 (37.7727590125447, -122.421759051834) 8 2 9 28853 19
146836 44769 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 712 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43876 6012402.09298601 2111195.83512486 37.7776397067003 -122.400626793323 (37.7776397067003, -122.400626793323) 14 2 9 28856 34
146915 191670 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007891.80002 2108968.36802 37.7712710311727 -122.416071683472 (37.7712710311727, -122.416071683472) 8 2 9 28853 19
146918 191664 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6013199.96962 2111004.76664 37.7771595428277 -122.397853242637 (37.7771595428277, -122.397853242637) 6 2 9 28856 34
148796 191661 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6013060.06963 2110865.5961 37.7767696201591 -122.398327437183 (37.7767696201591, -122.398327437183) 6 2 9 28856 34
149622 85534 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 110 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6007347.01879 2109279.74931 37.7720953650306 -122.417978186861 (37.7720953650306, -122.417978186861) 8 2 9 28853 19
150157 85520 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2007 12:00:00 AM 3     6008760.539184 2108527.457431 37.7701092002187 -122.413035486584 (37.7701092002187, -122.413035486584) 8 2 9 28853 19
150896 191078 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 394 12th St 1 : Tree Private 2     3 Width 3ft   6008574.85023 2108580.21149 37.7702436249715 -122.413681516591 (37.7702436249715, -122.413681516591) 8 2 9 28853 19
152175 251317 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008830 2108632 37.7704001487298 -122.41280261367 (37.7704001487298, -122.41280261367) 8 2 9 28853 19

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