158 rows where qSpecies_id = 202 sorted by Longitude

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)
73206 187967 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1551 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015595.88641 2096776.81479 37.7382257582057 -122.38857153857 (37.7382257582057, -122.38857153857) 10 3 8 58 1
57327 187966 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 211 Terry A Francois Blvd 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 5ft   6015666.2407 2110622.1949 37.7762461247865 -122.389294834495 (37.7762461247865, -122.389294834495) 14 3 9 310 20
10445 187965 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 211 Terry A Francois Blvd 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 5ft   6015662.09524 2110622.54521 37.7762468568378 -122.38930919937 (37.7762468568378, -122.38930919937) 14 3 9 310 20
29070 187964 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 211 Terry A Francois Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 5ft   6015658.44742 2110621.01823 37.7762424618552 -122.389321711634 (37.7762424618552, -122.389321711634) 14 3 9 310 20
145708 52153 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 525 Phelps St 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 15 5x9 Permit Number 48345 6015376.33052 2098074.72194 37.7417773752369 -122.389421273787 (37.7417773752369, -122.389421273787) 10 3 8 58 1
112042 96192 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1634 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x6   6015129.8118 2097200.08447 37.7393621298546 -122.390212570161 (37.7393621298546, -122.390212570161) 10 3 8 58 1
164248 189235 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1634 Jerrold Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6015126.70903 2097207.07467 37.7393811514086 -122.390223786492 (37.7393811514086, -122.390223786492) 10 3 8 58 1
87270 189221 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1310 Indiana St 14 : Yard Tree Private 2     1     6015010.96324 2102373.36426 37.7535602828051 -122.390984975379 (37.7535602828051, -122.390984975379) 10 3 8 28856 29
153401 113268 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1034 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 774686 6014704.8 2089850.3 37.7191575187873 -122.391168478676 (37.7191575187873, -122.391168478676) 10 3 8 58 1
7320 189222 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 1 Front Yard : Yard Tree Private 2     2     6014335.23001 2106254.12043 37.7641784810862 -122.393593414898 (37.7641784810862, -122.393593414898) 14 3 8 310 29
55921 189223 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 5 Front Yard : Yard Tree Private 2     1     6014330.31355 2106344.51761 37.7644264187655 -122.393616746937 (37.7644264187655, -122.393616746937) 14 3 8 310 29
84172 189224 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 15 Front Yard : Yard Tree Private 2     1     6014323.89166 2106455.06011 37.7647295874116 -122.393646696144 (37.7647295874116, -122.393646696144) 14 3 8 310 29
81425 189225 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 28 Front Yard : Yard Tree Private 2     1     6014307.08555 2106575.78079 37.7650601260485 -122.393713274773 (37.7650601260485, -122.393713274773) 14 3 8 310 29
167158 189226 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 37 Front Yard : Yard Tree Private 2     1     6014251.36443 2106690.81124 37.7653728778851 -122.393914054695 (37.7653728778851, -122.393914054695) 14 3 8 28856 20
157881 94615 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700X Bancroft Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 6   Permit Number 53777 6013900.00533 2092534.62626 37.7264834469268 -122.394138192746 (37.7264834469268, -122.394138192746) 10 3 8 58 1
53648 189236 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700 Bancroft Ave 13 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6013792.02021 2092615.53995 37.7266996169689 -122.394517158935 (37.7266996169689, -122.394517158935) 10 3 8 58 1
19831 189237 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700 Bancroft Ave 16 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6013775.5681 2092627.05351 37.7267303162423 -122.394574839671 (37.7267303162423, -122.394574839671) 10 3 8 58 1
166041 189227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1766 18th St 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 1ft   6012472.41099 2105663.34278 37.7624526523798 -122.399994920552 (37.7624526523798, -122.399994920552) 14 3 8 28856 29
133070 189234 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 9 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012405.15003 2103734.72302 37.7571533378622 -122.400092102164 (37.7571533378622, -122.400092102164) 10 3 8 28856 29
185073 189233 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 8 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6012396.53776 2103734.18422 37.7571513782439 -122.400121849061 (37.7571513782439, -122.400121849061) 10 3 8 28856 29
110052 189232 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 7 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012390.79704 2103733.87239 37.7571502019395 -122.400141680908 (37.7571502019395, -122.400141680908) 10 3 8 28856 29
160605 189231 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 5 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012362.34011 2103730.31063 37.7571388353939 -122.4002398464 (37.7571388353939, -122.4002398464) 10 3 8 28856 29
173458 189230 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6012335.96177 2103730.27512 37.7571372669841 -122.400331070924 (37.7571372669841, -122.400331070924) 10 3 8 28856 29
41702 189228 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1300x De Haro St 16 Median : Yard Tree DPW 1     1     6012274.47933 2102155.74686 37.752810527903 -122.40043310802 (37.752810527903, -122.40043310802) 10 3 8 28856 29
87275 189229 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1459 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     1     6012049.05152 2101579.41636 37.7512154759161 -122.401172188849 (37.7512154759161, -122.401172188849) 10 3 8 28856 29
41840 108726 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 460 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773097 6011176.24234 2106141.01313 37.7636918767911 -122.404511540684 (37.7636918767911, -122.404511540684) 8 3 8 28856 29
162253 108566 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772549 6010648.77476 2091709.27229 37.7240359509768 -122.405319522179 (37.7240359509768, -122.405319522179) 10 3 7 309 28
1907 36575 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2959 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3   Permit Number 773747 6009743.48880831 2101591.28473575 37.7511191714417 -122.409145947985 (37.7511191714417, -122.409145947985) 2 4 7 28859 19
34074 36574 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2959 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3   Permit Number 773747 6009743.48880831 2101591.28473575 37.7511191714417 -122.409145947985 (37.7511191714417, -122.409145947985) 2 4 7 28859 19
1685 221956 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 126 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009115.60345 2096745.48812 37.7377784848985 -122.410975023096 (37.7377784848985, -122.410975023096) 10 7 7 28859 2
23381 221957 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 132 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009113.07033 2096713.66347 37.7376909592647 -122.410981534183 (37.7376909592647, -122.410981534183) 10 7 7 28859 2
190673 175222 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 300 Gaven St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008975.92118 2094875.47718 37.7326360049484 -122.411325907078 (37.7326360049484, -122.411325907078) 9 3 7 309 28
120297 36540 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 3780 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 768357 6008402.05844785 2097287.64414787 37.7392270883895 -122.413480433949 (37.7392270883895, -122.413480433949) 2 7 7 28859 2
28899 221958 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 779 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008100.58194 2095693.3071 37.7348324551576 -122.414410025905 (37.7348324551576, -122.414410025905) 2 7 7 28859 2
20682 246691 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 96 Stoneman St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 4ft   6007854.4475 2099435.64946 37.7450942718828 -122.415525868717 (37.7450942718828, -122.415525868717) 2 7 7 28859 2
8146 221945 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101X Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007717.88408 2096150.9798 37.7360676182281 -122.415765545245 (37.7360676182281, -122.415765545245) 2 7 7 28859 2
5316 221946 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101X Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007705.60833 2096151.45352 37.7360682288544 -122.415808021131 (37.7360682288544, -122.415808021131) 2 7 7 28859 2
17662 221947 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101X Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007672.8407 2096154.79379 37.7360755583335 -122.415921548861 (37.7360755583335, -122.415921548861) 2 7 7 28859 2
18393 221942 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 133 Ellert St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007406.60903 2096997.58914 37.7383747174262 -122.416901715445 (37.7383747174262, -122.416901715445) 2 7 7 28859 2
70180 221941 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 6 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007387.61833 2099831.21968 37.7461541678748 -122.417168110835 (37.7461541678748, -122.417168110835) 2 7 7 28859 2
53421 115385 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 375 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 776680 6007256.8 2096298.8 37.7364475687434 -122.417370175703 (37.7364475687434, -122.417370175703) 2 7 7 28859 2
110813 221961 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007321.68387 2099648.65051 37.745649164396 -122.417383168412 (37.745649164396, -122.417383168412) 2 7 7 28859 2
55128 221948 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 633 Capp St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6007312.78593 2103619.12061 37.7565506733878 -122.417695309584 (37.7565506733878, -122.417695309584) 2 4 7 28859 19
12294 261448 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 311 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006968 2095801 37.7350644665595 -122.418333396749 (37.7350644665595, -122.418333396749) 2 7 7 28859 2
155229 221943 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 237 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006873.22599 2096639.71242 37.7373620502264 -122.418720525044 (37.7373620502264, -122.418720525044) 2 7 7 28859 2
179457 221959 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 40 Coleridge St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006917.95307 2099525.21762 37.7452875218149 -122.418770459905 (37.7452875218149, -122.418770459905) 2 7 7 28859 2
5535 221960 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 75 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006819.46923 2099263.44478 37.7445632069438 -122.419092436978 (37.7445632069438, -122.419092436978) 2 7 7 28859 2
21868 221950 Planning Code 138.1 required 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 31 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 780973 6006097.6775 2099053.58173 37.7439462971915 -122.421573349947 (37.7439462971915, -122.421573349947) 2 7 7 28859 2
12088 221940 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 168 Tiffany Ave 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6006049.87669 2099255.63478 37.7444983936957 -122.421752983209 (37.7444983936957, -122.421752983209) 2 7 5 28859 2
81646 221949 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 130 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6005733.16344 2096370.93476 37.7365597919858 -122.422643161851 (37.7365597919858, -122.422643161851) 2 7 7 28859 2
111830 221962 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 28 Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6005742.72785 2097519.53479 37.7397141298992 -122.422691692893 (37.7397141298992, -122.422691692893) 2 7 7 28859 2
129751 169719 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 163 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 3ft Permit Number 779875 6004059.21605 2097368.19833 37.7392034678777 -122.428501775552 (37.7392034678777, -122.428501775552) 2 7 5 63 7
41523 221967 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 448 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003863.12438 2096025.37276 37.7355052757557 -122.429084054179 (37.7355052757557, -122.429084054179) 2 7 5 63 7
186533 221954 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 10 Mateo St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003651.78928 2096634.42206 37.7371656211922 -122.429858148341 (37.7371656211922, -122.429858148341) 2 7 5 63 7
133708 221965 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 4001 20th St 5 : Yard Tree Private 2     4 Width 3ft   6003646.65326 2104187.92713 37.7579054957544 -122.430414684807 (37.7579054957544, -122.430414684807) 2 4 5 28862 3
99800 221964 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 3783 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003249.85667 2102987.38047 37.7545865954194 -122.431701259406 (37.7545865954194, -122.431701259406) 2 4 5 28862 22
53602 117377 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 3783 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3   Permit Number 775394 6003225.8 2102971.4 37.7545413531892 -122.43178331278 (37.7545413531892, -122.43178331278) 2 4 5 28862 22
89333 101004 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
173627 101003 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
54080 125567 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6003482.8439 2118067.55033 37.7960062212666 -122.431972291689 (37.7960062212666, -122.431972291689) 13 9 1 57 17
53582 125566 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6003481.18787 2118079.55095 37.7960390779962 -122.431978879228 (37.7960390779962, -122.431978879228) 13 9 1 57 17
143401 221955 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 271 Bemis St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6002975.66032 2096224.16146 37.7360008273625 -122.432166542558 (37.7360008273625, -122.432166542558) 2 7 5 63 7
186582 175227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 225 Naylor St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6002635.08266 2086756.92621 37.709986599863 -122.432667995542 (37.709986599863, -122.432667995542) 9 7 6 28861 5
180191 175224 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 762 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002402.88459 2087125.99028 37.710986797965 -122.433496872809 (37.710986797965, -122.433496872809) 9 7 6 28861 5
79067 175225 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 762 Prague St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002385.00148 2087111.82933 37.7109469004454 -122.433557669663 (37.7109469004454, -122.433557669663) 9 7 6 28861 5
44573 175223 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 39 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6002350.25908 2087113.68805 37.7109500327891 -122.433677880228 (37.7109500327891, -122.433677880228) 9 7 6 28861 5
15125 221968 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 155 Farnum St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6002473.47377 2097229.09787 37.7387316655458 -122.433974612434 (37.7387316655458, -122.433974612434) 2 7 5 63 7
73808 221963 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 4086 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002569.41757 2102410.84038 37.7529649603686 -122.434013186153 (37.7529649603686, -122.434013186153) 2 4 5 28862 22
69401 125564 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 165 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 7ft   6002712.8181 2121563.83713 37.805562426341 -122.434886887435 (37.805562426341, -122.434886887435) 13 9 1 57 17
144618 175221 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 127 Cotter St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001956.44701 2093481.30015 37.728411719314 -122.435494211294 (37.728411719314, -122.435494211294) 9 7 6 28861 25
62425 221952 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002001.1942 2099218.33488 37.7441668325278 -122.435749813916 (37.7441668325278, -122.435749813916) 2 7 5 63 22
179588 221951 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002000.14888 2099232.59033 37.7442059152698 -122.435754448124 (37.7442059152698, -122.435754448124) 2 7 5 63 22
11882 81047 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 961 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6001634.70169 2086773.55642 37.7099754779527 -122.436126687404 (37.7099754779527, -122.436126687404) 9 7 6 28861 5
8692 247232 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 760 Duboce Ave 4 : Tree Private 2     3 Width 3ft   6002013.60886 2108293.7767 37.7690865158689 -122.436356276247 (37.7690865158689, -122.436356276247) 15 5 5 29492 9
112583 175217 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 San Jose Ave 2 Sidewalk: Property side : Yard Tree Private 2     1     6001607.87231 2094169.86531 37.7302825582951 -122.436748518241 (37.7302825582951, -122.436748518241) 9 7 6 28861 25
148068 115208 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1014 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 774282 6001957.4 2112096.8 37.7795254745958 -122.436822979652 (37.7795254745958, -122.436822979652) 15 5 11 29490 41
156394 115207 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1014 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 774282 6001957.4 2112096.8 37.7795254745958 -122.436822979652 (37.7795254745958, -122.436822979652) 15 5 11 29490 41
37514 175226 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1150 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6001420.49828 2087082.59126 37.7108118474628 -122.43688912274 (37.7108118474628, -122.43688912274) 9 7 6 28861 5
73720 125559 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001981.60949 2119919.32974 37.8010055012508 -122.437299505878 (37.8010055012508, -122.437299505878) 13 9 1 57 17
148377 125560 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001979.15463 2119935.63772 37.8010501391173 -122.437309169106 (37.8010501391173, -122.437309169106) 13 9 1 57 17
78033 175218 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 93 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001014.57653 2087970.42853 37.7132265721263 -122.438355644521 (37.7132265721263, -122.438355644521) 9 7 6 28861 5
188343 175219 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 100 Morse St 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 1ft   6000840.49126 2087951.89335 37.7131657752649 -122.438956013912 (37.7131657752649, -122.438956013912) 9 7 6 28861 5
168492 221953 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 828 Alvarado St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6000888.70768 2102618.36956 37.753439259225 -122.439840265136 (37.753439259225, -122.439840265136) 2 4 5 28862 22
28532 221966 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 190 Storrie St 7 Front Yard : Yard Tree Private 2     2 Width 3ft   6000752.80061 2105288.06191 37.7607618468996 -122.440501720974 (37.7607618468996, -122.440501720974) 15 4 5 28862 3
169515 175220 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 178 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6000035.73488 2087742.43428 37.7125448266481 -122.441722494022 (37.7125448266481, -122.441722494022) 9 7 6 28861 5
27858 203619 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.38202 2095835.33472 37.7347719253748 -122.441948223841 (37.7347719253748, -122.441948223841) 9 7 5 63 40
71295 204746 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.08456 2095837.9726 37.7347791514248 -122.441949441533 (37.7347791514248, -122.441949441533) 9 7 5 63 40
81720 204747 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6000136.90983 2095840.80392 37.7347868586248 -122.441953706121 (37.7347868586248, -122.441953706121) 9 7 5 63 40
39944 125565 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1907 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   5999924.77973 2115560.64966 37.7889205779801 -122.444103621795 (37.7889205779801, -122.444103621795) 13 6 1 29490 27
15374 125563 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999907.90369 2121547.81116 37.8053587703434 -122.44459250045 (37.8053587703434, -122.44459250045) 13 9 1 57 17
15744 125562 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5999907.00069 2121550.96509 37.8053673786573 -122.444595852214 (37.8053673786573, -122.444595852214) 13 9 1 57 17
115799 125561 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999906.36456 2121555.3188 37.8053792964712 -122.444598366729 (37.8053792964712, -122.444598366729) 13 9 1 57 17
42639 255491 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 139 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/31/2018 12:00:00 AM 3 3x3 Permit Number 781962 5999277.13576 2095481.56921 37.7337514533765 -122.444900415841 (37.7337514533765, -122.444900415841) 9 7 4 59 40
176820 99289 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 2 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998887.79124 2121333.18312 37.8047111982366 -122.448107254257 (37.8047111982366, -122.448107254257) 13 9 1 57 17
50429 99288 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 1 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998881.62913 2121328.006 37.8046966310161 -122.448128205765 (37.8046966310161, -122.448128205765) 13 9 1 57 17
70475 115759 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1718 Cayuga Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998106.99194 2088701.93877 37.7150693216746 -122.448457855865 (37.7150693216746, -122.448457855865) 9 7 6 28861 25
128898 203595 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 423 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5997934.90621 2094082.1225 37.729832211087 -122.44944008102 (37.729832211087, -122.44944008102) 9 7 4 28861 40
47616 203594 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997974.50347 2098199.84414 37.7411407550534 -122.449599788915 (37.7411407550534, -122.449599788915) 9 7 4 59 40
141556 203593 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997967.66384 2098207.91651 37.7411625285389 -122.449624019335 (37.7411625285389, -122.449624019335) 9 7 4 59 40
59906 121643 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       2x4   5997955 2098188 37.741107118117 -122.449666371295 (37.741107118117, -122.449666371295) 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)
);