90 rows where qSpecies_id = 141

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)
801 261069 DPW Maintained 1 Magnolia champaca :: Champa 141 1256 Fitzgerald Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014418 2090762 37.7216449464937 -122.392223572812 (37.7216449464937, -122.392223572812) 10 3 8 58 1
3948 261068 DPW Maintained 1 Magnolia champaca :: Champa 141 1256 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/2019 12:00:00 AM 3 4x6   6014418 2090762 37.7216449464937 -122.392223572812 (37.7216449464937, -122.392223572812) 10 3 8 58 1
6541 60873 Permitted Site 7 Magnolia champaca :: Champa 141 2028 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2012 12:00:00 AM   4x4 Permit Number 768154 6008629.04829533 2119833.32118677 37.8011449901029 -122.414290361568 (37.8011449901029, -122.414290361568) 3 1 10 308 32
6728 115283 Permitted Site 7 Magnolia champaca :: Champa 141 70 Lurline St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 773684 5991870.1 2105051.8 37.7596033336043 -122.471205512413 (37.7596033336043, -122.471205512413) 1 8 4 56 12
7327 123578 DPW Maintained 1 Magnolia champaca :: Champa 141 90 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   5994289.23744 2114960.32648 37.7869491502366 -122.463558099781 (37.7869491502366, -122.463558099781) 11 6 1 54 11
7469 90566 DPW Maintained 1 Magnolia champaca :: Champa 141 1800 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 12/27/2014 12:01:00 PM 3 3x3   5989998.07126 2110625.47725 37.7747986774394 -122.478087352371 (37.7747986774394, -122.478087352371) 11 6 2 55 26
7484 90567 DPW Maintained 1 Magnolia champaca :: Champa 141 1800 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 02/14/2008 12:00:00 AM 3 3x3   5989974.77369 2110623.83605 37.7747928188343 -122.47816782258 (37.7747928188343, -122.47816782258) 11 6 2 55 26
8585 115778 DPW Maintained 1 Magnolia champaca :: Champa 141 1256 Fitzgerald Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 772460 6014418 2090762 37.7216449464937 -122.392223572812 (37.7216449464937, -122.392223572812) 10 3 8 58 1
9457 146702 DPW Maintained 1 Magnolia champaca :: Champa 141 843 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   5985389.01338 2110118.19481 37.7731372161446 -122.493993410689 (37.7731372161446, -122.493993410689) 11 6 2 55 26
11308 51326 DPW Maintained 1 Magnolia champaca :: Champa 141 489 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3   Permit Number 47685 6013940.29088 2112585.38247 37.7815407556469 -122.395402975878 (37.7815407556469, -122.395402975878) 6 2 9 28856 6
12054 65923 DPW Maintained 1 Magnolia champaca :: Champa 141 102 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 4   Permit Number 28939 6014289.96191 2112626.22069 37.7816723300522 -122.394196132467 (37.7816723300522, -122.394196132467) 6 2 9 28856 6
14264 96728 DPW Maintained 1 Magnolia champaca :: Champa 141 1512 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2011 12:00:00 AM 3 3x3   6015795.15205 2096700.49515 37.7380272409624 -122.38787724665 (37.7380272409624, -122.38787724665) 10 3 8 58 1
15050 106111 Undocumented 4 Magnolia champaca :: Champa 141 135 MENDOSA AVE 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
15451 200168 DPW Maintained 1 Magnolia champaca :: Champa 141 1101 Gilman Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   6014990.039 2089901.3883 37.7193136223873 -122.390186075408 (37.7193136223873, -122.390186075408) 10 3 8 58 1
22820 123579 DPW Maintained 1 Magnolia champaca :: Champa 141 90 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   5994289.50047 2114946.6049 37.7869114896689 -122.463556193559 (37.7869114896689, -122.463556193559) 11 6 1 54 11
23386 252904 DPW Maintained 1 Magnolia champaca :: Champa 141 1216 Clay St 1 Front Yard : Cutout Tree Private 2       3x3   6008866 2117029 37.7934583239602 -122.413271980668 (37.7934583239602, -122.413271980668) 5 1 10 28857 21
24011 130430 DPW Maintained 1 Magnolia champaca :: Champa 141 89 Valparaiso St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6008655.47959 2119859.36383 37.8012179813792 -122.414200741082 (37.8012179813792, -122.414200741082) 3 1 10 308 32
24504 93143 DPW Maintained 1 Magnolia champaca :: Champa 141 249 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5990845.47769 2113717.02599 37.78333636898 -122.475381793838 (37.78333636898, -122.475381793838) 11 6 2 54 26
24513 108504 Permitted Site 7 Magnolia champaca :: Champa 141 1445 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773649 5991782.44635 2105596.59043 37.7610941136514 -122.471548358504 (37.7610941136514, -122.471548358504) 1 8 4 56 12
27510 229207 DPW Maintained 1 Magnolia champaca :: Champa 141 75 Montcalm St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010677.34629 2100029.09065 37.7468820009005 -122.405806525749 (37.7468820009005, -122.405806525749) 2 7 7 28859 2
27575 229206 DPW Maintained 1 Magnolia champaca :: Champa 141 3703 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005754.08404 2100791.82852 37.7486997466004 -122.422884932902 (37.7486997466004, -122.422884932902) 2 4 5 28859 19
32539 229213 DPW Maintained 1 Magnolia champaca :: Champa 141 44 Levant St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000267.31674 2106588.21137 37.7643040794818 -122.44227412465 (37.7643040794818, -122.44227412465) 15 5 5 28862 3
32709 121920 DPW Maintained 1 Magnolia champaca :: Champa 141 746 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5990705.75047 2110306.02269 37.7739625940269 -122.475616037623 (37.7739625940269, -122.475616037623) 11 6 2 54 26
39877 229210 DPW Maintained 1 Magnolia champaca :: Champa 141 157 Alma St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5997866.99015 2106170.0935 37.7630189374956 -122.450545992616 (37.7630189374956, -122.450545992616) 15 5 11 29492 9
49852 254213 DPW Maintained 1 Magnolia champaca :: Champa 141 2395 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2018 12:00:00 AM 3 3x3 Permit Number 781237 5992629.69291 2099162.15804 37.7434758049124 -122.468150045235 (37.7434758049124, -122.468150045235) 1 8 4 29491 40
51109 229212 DPW Maintained 1 Magnolia champaca :: Champa 141 67 Belcher St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6003822.24393 2107963.26072 37.768281600153 -122.430076734873 (37.768281600153, -122.430076734873) 7 9 5 28862 3
51855 130431 DPW Maintained 1 Magnolia champaca :: Champa 141 220 Joice St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010221.29362 2116953.37986 37.7933266858222 -122.408577203898 (37.7933266858222, -122.408577203898) 3 1 10 28857 4
52133 229214 DPW Maintained 1 Magnolia champaca :: Champa 141 1 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6002775.66665 2096156.2936 37.7358031366028 -122.432853153354 (37.7358031366028, -122.432853153354) 2 7 5 63 7
54696 58589 Permitted Site 7 Magnolia champaca :: Champa 141 232 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/1979 12:00:00 AM     Permit Number 17789 5997635.76865 2106178.20779874 37.7630279802836 -122.451346290086 (37.7630279802836, -122.451346290086) 15 5 11 29492 9
55269 177280 DPW Maintained 1 Magnolia champaca :: Champa 141 835 Excelsior Ave 2 Sidewalk: Property side : Yard Tree Private 2     16 Width 5ft   6004480.81499 2091450.56223 37.7229788105017 -122.426622797701 (37.7229788105017, -122.426622797701) 9 7 6 28861 5
61853 106112 Undocumented 4 Magnolia champaca :: Champa 141 135 MENDOSA AVE 5 Sidewalk: Property side : Yard Tree Private 2     4   Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
62179 102300 Undocumented 4 Magnolia champaca :: Champa 141 1150 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2014 12:00:00 AM 3 5x5 Permit Number 773621 6003812 2101578 37.7507486162623 -122.42965670576 (37.7507486162623, -122.42965670576) 2 4 5 28862 22
64232 229211 DPW Maintained 1 Magnolia champaca :: Champa 141 69 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003825.75049 2107873.30523 37.7680348027992 -122.430058188146 (37.7680348027992, -122.430058188146) 7 9 5 28862 3
68458 177283 DPW Maintained 1 Magnolia champaca :: Champa 141 184 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003174.52828 2092323.89174 37.7253028412412 -122.431200667976 (37.7253028412412, -122.431200667976) 9 7 6 28861 5
70473 115284 Permitted Site 7 Magnolia champaca :: Champa 141 70 Lurline St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 773684 5991870.1 2105051.8 37.7596033336043 -122.471205512413 (37.7596033336043, -122.471205512413) 1 8 4 56 12
70580 82365 DPW Maintained 1 Magnolia champaca :: Champa 141 74 West View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2010 12:00:00 AM 2 3x3 Permit Number 53884 6007138.42533 2094313.10717 37.7309886304042 -122.417638750344 (37.7309886304042, -122.417638750344) 9 3 7 309 28
74842 53947 DPW Maintained 1 Magnolia champaca :: Champa 141 100 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM 2   Permit Number 9662 6010008.98982 2095241.82801 37.7336998129817 -122.407780142849 (37.7336998129817, -122.407780142849) 10 3 7 309 28
80247 34442 Permitted Site 7 Magnolia champaca :: Champa 141 51 Van Buren St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38186 6002033.25369179 2096285.02553427 37.7361144689001 -122.435429168133 (37.7361144689001, -122.435429168133) 2 7 5 63 7
81708 192807 DPW Maintained 1 Magnolia champaca :: Champa 141 816 Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011469.60353 2109439.42754 37.7727649651647 -122.403728991106 (37.7727649651647, -122.403728991106) 14 2 9 28853 34
81732 177285 DPW Maintained 1 Magnolia champaca :: Champa 141 105 Burrows St 1 Side Yard : Yard Tree Private 2     2     6011169.81083 2093473.60128 37.728909549831 -122.403642451135 (37.728909549831, -122.403642451135) 10 3 7 309 28
82164 117425 DPW Maintained 1 Magnolia champaca :: Champa 141 218 Athens St 1 Sidewalk: Curb side : Yard Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 775470 6004576.76699 2091985.71039 37.724453633907 -122.426329194258 (37.724453633907, -122.426329194258) 9 7 6 28861 5
82444 102301 Undocumented 4 Magnolia champaca :: Champa 141 1150 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2014 12:00:00 AM 3 3x3 Permit Number 773621 6003812 2101578 37.7507486162623 -122.42965670576 (37.7507486162623, -122.42965670576) 2 4 5 28862 22
83789 95560 Permitted Site 7 Magnolia champaca :: Champa 141 708 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767354 6001217 2102264 37.75248492744 -122.438679572623 (37.75248492744, -122.438679572623) 2 4 5 28862 22
89144 110719 Undocumented 4 Magnolia champaca :: Champa 141 250 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993202.3 2102594.8 37.7529340165375 -122.466419562057 (37.7529340165375, -122.466419562057) 1 8 4 56 12
91108 177276 DPW Maintained 1 Magnolia champaca :: Champa 141 57 Danton St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002839.91705 2094626.90551 37.7316074296218 -122.432521808961 (37.7316074296218, -122.432521808961) 9 7 5 28861 25
91202 202200 DPW Maintained 1 Magnolia champaca :: Champa 141 1946 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 7ft   6013086.08016 2093479.71408 37.7290331922147 -122.397018153772 (37.7290331922147, -122.397018153772) 10 3 8 58 1
94789 177287 DPW Maintained 1 Magnolia champaca :: Champa 141 104 Burrows St 4 Side Yard : Yard Tree Private 2     1     6011161.858 2093502.53112 37.7289885408852 -122.403671979495 (37.7289885408852, -122.403671979495) 10 3 7 309 28
95268 208539 DPW Maintained 1 Magnolia champaca :: Champa 141 278 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5994218.38162 2087785.93969 37.7123311045757 -122.461832077791 (37.7123311045757, -122.461832077791) 9 8 6 28861 24
95396 192809 DPW Maintained 1 Magnolia champaca :: Champa 141 1596 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015761.01767 2097422.05642 37.7400066101295 -122.388045606039 (37.7400066101295, -122.388045606039) 10 3 8 58 1
97970 192810 DPW Maintained 1 Magnolia champaca :: Champa 141 699 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6015748.32863 2097474.20418 37.7401490942054 -122.388093118111 (37.7401490942054, -122.388093118111) 10 3 8 58 1
99124 254581 DPW Maintained 1 Magnolia champaca :: Champa 141 500 Ivy St 21 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
100792 229205 DPW Maintained 1 Magnolia champaca :: Champa 141 2670 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010018.96643 2103993.2259 37.7577297952205 -122.408362714678 (37.7577297952205, -122.408362714678) 2 4 7 28859 19
100891 192811 DPW Maintained 1 Magnolia champaca :: Champa 141 699 Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6015760.75938 2097489.04776 37.740190540353 -122.388051172818 (37.740190540353, -122.388051172818) 10 3 8 58 1
105089 177286 DPW Maintained 1 Magnolia champaca :: Champa 141 104 Burrows St 3 Side Yard : Yard Tree Private 2     2     6011163.93479 2093493.48317 37.7289638131138 -122.403664163474 (37.7289638131138, -122.403664163474) 10 3 7 309 28
106924 192808 DPW Maintained 1 Magnolia champaca :: Champa 141 1596 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015772.9846 2097413.5377 37.7399838824604 -122.388003634662 (37.7399838824604, -122.388003634662) 10 3 8 58 1
109319 177277 DPW Maintained 1 Magnolia champaca :: Champa 141 247 Mount Vernon Ave 1 Sidewalk: Property side : Yard Tree Private 2     5     5998677.48032 2089600.90365 37.7175702751156 -122.446550650088 (37.7175702751156, -122.446550650088) 9 7 6 28861 25
114531 97547 Permitted Site 7 Magnolia champaca :: Champa 141 90X Valparaiso St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 769183 6008640 2119879 37.8012710279062 -122.4142556975 (37.8012710279062, -122.4142556975) 3 1 10 308 32
119121 177278 DPW Maintained 1 Magnolia champaca :: Champa 141 247 Mount Vernon Ave 3 Sidewalk: Property side : Yard Tree Private 2     2     5998683.47325 2089596.01015 37.7175571809995 -122.446529583477 (37.7175571809995, -122.446529583477) 9 7 6 28861 25
120459 192812 DPW Maintained 1 Magnolia champaca :: Champa 141 699 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6015782.20079 2097521.5447 37.7402809582086 -122.38797930352 (37.7402809582086, -122.38797930352) 10 3 8 58 1
122278 106109 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 2 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
122601 47439 DPW Maintained 1 Magnolia champaca :: Champa 141 855 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 4   Permit Number 45350 5982911.03807 2109970.63017 37.772586745673 -122.50255398243 (37.772586745673, -122.50255398243) 11 6 2 55 26
132531 120083 DPW Maintained 1 Magnolia champaca :: Champa 141 279 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5987730.93691 2114104.57781 37.784219449415 -122.486185194855 (37.784219449415, -122.486185194855) 11 6 1 55 26
133614 34408 Permitted Site 7 Magnolia champaca :: Champa 141 153 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2005 12:00:00 AM     Permit Number 48126 6004564.73535669 2097520.70439989 37.7396508092604 -122.426764774135 (37.7396508092604, -122.426764774135) 2 7 5 63 7
133627 67995 Permitted Site 7 Magnolia champaca :: Champa 141 242 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1993 12:00:00 AM     Permit Number 31720 5994595.75102873 2089048.56400841 37.7158196896579 -122.460619224226 (37.7158196896579, -122.460619224226) 9 8 6 28861 24
135470 123577 DPW Maintained 1 Magnolia champaca :: Champa 141 90 05th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   5994288.85987 2114975.14753 37.7869898230497 -122.463560482108 (37.7869898230497, -122.463560482108) 11 6 1 54 11
136537 229208 DPW Maintained 1 Magnolia champaca :: Champa 141 125 Mullen Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009844.46496 2099854.56746 37.746356185285 -122.40867425512 (37.746356185285, -122.40867425512) 2 7 7 28859 2
136585 52529 DPW Maintained 1 Magnolia champaca :: Champa 141 142 San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001327.58175 2092279.55294 37.7250762588572 -122.437582197876 (37.7250762588572, -122.437582197876) 9 7 6 28861 25
139275 177284 DPW Maintained 1 Magnolia champaca :: Champa 141 50 Gladstone Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6006368.59869 2094147.86405 37.7304915598166 -122.420288451661 (37.7304915598166, -122.420288451661) 9 7 7 28861 5
141941 106110 Undocumented 4 Magnolia champaca :: Champa 141 135 MENDOSA AVE 3 Sidewalk: Property side : Yard Tree Private 2     4   Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
143482 89097 DPW Maintained 1 Magnolia champaca :: Champa 141 555 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2008 12:00:00 AM 3 3x3   5990302.8549 2111587.58399 37.7774580439741 -122.477103374633 (37.7774580439741, -122.477103374633) 11 6 2 55 26
147360 192804 DPW Maintained 1 Magnolia champaca :: Champa 141 102 South Park 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014277.78619 2112617.17875 37.781646826173 -122.394237621778 (37.781646826173, -122.394237621778) 6 2 9 28856 6
147415 249993 DPW Maintained 1 Magnolia champaca :: Champa 141 230 Filbert St 1 Front Yard : Yard Tree Private 2     15 Width 0ft   6011552.45042 2120107.96265 37.8020628692688 -122.404193406414 (37.8020628692688, -122.404193406414) 3 1 10 308 23
152469 242340 DPW Maintained 1 Magnolia champaca :: Champa 141 232 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5997593.66914 2106162.79262 37.7629832433987 -122.451490785271 (37.7629832433987, -122.451490785271) 15 5 11 29492 9
154196 229209 DPW Maintained 1 Magnolia champaca :: Champa 141 125 Mullen Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009806.83147 2099879.64563 37.7464229365797 -122.408806156877 (37.7464229365797, -122.408806156877) 2 7 7 28859 2
161777 42836 DPW Maintained 1 Magnolia champaca :: Champa 141 1184 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/2000 12:00:00 AM 3   Permit Number 42768 6006179.23317 2120408.85746 37.8025873493742 -122.422808722571 (37.8025873493742, -122.422808722571) 5 9 1 28858 32
162354 115009 DPW Maintained 1 Magnolia champaca :: Champa 141 118 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2016 12:00:00 AM 2   Permit Number 772567 6009049.21321 2093699.6892 37.7294116530064 -122.410989499484 (37.7294116530064, -122.410989499484) 9 3 7 309 28
164948 177279 DPW Maintained 1 Magnolia champaca :: Champa 141 279 Niagara Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5998927.0517 2089991.78935 37.718657809988 -122.445716093636 (37.718657809988, -122.445716093636) 9 7 6 28861 25
166097 177281 DPW Maintained 1 Magnolia champaca :: Champa 141 835 Excelsior Ave 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6004474.64827 2091455.68598 37.7229925305564 -122.426644479486 (37.7229925305564, -122.426644479486) 9 7 6 28861 5
169310 106108 Undocumented 4 Magnolia champaca :: Champa 141 135 MENDOSA AVE 6 Sidewalk: Property side : Yard Tree Private 2         Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
171214 57815 DPW Maintained 1 Magnolia champaca :: Champa 141 154 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1977 12:00:00 AM 5   Permit Number 16752 5988698.71147 2114305.32947 37.7848270128848 -122.482851795657 (37.7848270128848, -122.482851795657) 11 6 2 55 26
172642 177282 DPW Maintained 1 Magnolia champaca :: Champa 141 184 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003183.02796 2092335.82802 37.7253360972661 -122.43117213701 (37.7253360972661, -122.43117213701) 9 7 6 28861 5
172892 192806 DPW Maintained 1 Magnolia champaca :: Champa 141 816 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011545.92894 2109512.95775 37.7729711257451 -122.403470145551 (37.7729711257451, -122.403470145551) 14 2 9 28853 34
173164 229215 DPW Maintained 1 Magnolia champaca :: Champa 141 151 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004588.6646 2097530.93543 37.7396802542509 -122.426682765415 (37.7396802542509, -122.426682765415) 2 7 5 63 7
181363 192805 DPW Maintained 1 Magnolia champaca :: Champa 141 816 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011561.22254 2109527.20961 37.7730111123052 -122.403418245661 (37.7730111123052, -122.403418245661) 14 2 9 28853 34
183783 49471 Permitted Site 7 Magnolia champaca :: Champa 141 3328@ VALENCIA 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/08/2003 12:00:00 AM     Permit Number 46396 6006136.25469951 2103196.12306543 37.7553229433082 -122.421734137516 (37.7553229433082, -122.421734137516) 2 4 5 28859 19
185175 123607 DPW Maintained 1 Magnolia champaca :: Champa 141 172 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994619.74414 2114496.4791 37.785694588746 -122.462380974399 (37.785694588746, -122.462380974399) 11 6 1 54 11
187646 180664 DPW Maintained 1 Magnolia champaca :: Champa 141 339 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 01:55:00 PM 3 Width 6ft   6002468.5653 2086489.08528 37.7092417219876 -122.433224385404 (37.7092417219876, -122.433224385404) 9 7 6 28861 5
188800 106107 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
193363 108532 Permitted Site 7 Magnolia champaca :: Champa 141 70 Lurline St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM 3 3x3 Permit Number 773684 5991847.86236 2105069.58022 37.759650867089 -122.471283716023 (37.759650867089, -122.471283716023) 1 8 4 56 12
193497 51325 DPW Maintained 1 Magnolia champaca :: Champa 141 489 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2004 12:00:00 AM 2   Permit Number 47685 6013925.58695 2112575.54425 37.7815129243211 -122.395453155354 (37.7815129243211, -122.395453155354) 6 2 9 28856 6

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