158 rows where qSpecies_id = 202 sorted by Zip Codes

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
38481 203600 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994977.66041 2089033.88982 37.7158013626108 -122.459298115614 (37.7158013626108, -122.459298115614) 9 8 6 28861 24
41452 203615 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 240 Colon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5996037.38323 2094398.48179 37.7305921283128 -122.456022857589 (37.7305921283128, -122.456022857589) 9 7 4 28861 40
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
51205 203592 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1485x Northwood Dr 1 Median : Yard Tree DPW 1     2     5995892.33391 2093907.44512 37.7292355333897 -122.456488817009 (37.7292355333897, -122.456488817009) 9 7 4 28861 40
55725 203601 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 601 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5995029.86532 2089100.67816 37.7159877489258 -122.459122505898 (37.7159877489258, -122.459122505898) 9 8 6 28861 24
64600 203602 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 601 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5995030.39824 2089062.56731 37.7158831361758 -122.459117905878 (37.7158831361758, -122.459117905878) 9 8 6 28861 24
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
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
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
95445 203599 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994990.66494 2089034.05641 37.7158025676981 -122.459253178313 (37.7158025676981, -122.459253178313) 9 8 6 28861 24
96705 114970 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
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
116243 203604 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 349 Howth St 1 : Tree Private 2     2 Width 3ft   5997115.15384 2090174.96464 37.7190571494366 -122.451992266143 (37.7190571494366, -122.451992266143) 9 8 6 28861 24
116404 114968 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
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
131041 203603 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 533 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995027.64484 2088883.389 37.7153909965718 -122.459114456087 (37.7153909965718, -122.459114456087) 9 8 6 28861 24
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
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
175831 114969 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
177274 203598 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995008.49221 2089033.02481 37.715800760085 -122.459191484793 (37.715800760085, -122.459191484793) 9 8 6 28861 24
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
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
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
190155 203597 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 50 De Montfort Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995113.88228 2091909.79504 37.7237057451058 -122.45903538769 (37.7237057451058, -122.45903538769) 9 8 4 28861 24
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
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
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
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
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
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
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
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
8257 261815 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
9220 261816 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
12158 261817 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
18595 203611 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 146 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5992953.88881 2101207.94105 37.7491117215315 -122.467177780245 (37.7491117215315, -122.467177780245) 1 8 4 29491 12
20819 203614 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2555 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991713.86449 2098047.40615 37.7403620464585 -122.47123551863 (37.7403620464585, -122.47123551863) 1 8 4 29491 40
39893 203608 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2007 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991583.6607 2101714.46197 37.7504233054064 -122.471952911395 (37.7504233054064, -122.471952911395) 1 8 4 29491 12
71411 203618 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994486.24709 2100807.40007 37.7481002729224 -122.461849867291 (37.7481002729224, -122.461849867291) 1 8 4 29491 40
76777 203616 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994461.21943 2100782.80797 37.7480313083953 -122.461934628392 (37.7480313083953, -122.461934628392) 1 8 4 29491 40
99215 203610 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992962.70532 2101209.82571 37.7491174052506 -122.467147429924 (37.7491174052506, -122.467147429924) 1 8 4 29491 12
159601 203607 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2007 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991582.5756 2101730.87003 37.7504682948863 -122.471957859468 (37.7504682948863, -122.471957859468) 1 8 4 29491 12
171239 203609 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 120 Quintara St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993075.95674 2101213.42516 37.7491338250612 -122.466756070139 (37.7491338250612, -122.466756070139) 1 8 4 29491 12
184066 203617 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994473.17466 2100793.87749 37.7480623907666 -122.461894090539 (37.7480623907666, -122.461894090539) 1 8 4 29491 40
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
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
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
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
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
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
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
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
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
43318 115333 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 667 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3   Permit Number 776458 5994991 2111007.6 37.7761364319113 -122.460843601074 (37.7761364319113, -122.460843601074) 11 6 2 54 11
55533 123429 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 690 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5995057.91765 2110847.92629 37.7757018603334 -122.460600543143 (37.7757018603334, -122.460600543143) 11 6 2 54 11
65494 121978 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5991208.06978 2113958.75361 37.7840210969883 -122.474145024774 (37.7840210969883, -122.474145024774) 11 6 2 54 26
84362 121976 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5991206.08725 2113988.74508 37.7841033304005 -122.474154072624 (37.7841033304005, -122.474154072624) 11 6 2 54 26
87180 121977 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5991207.54931 2113971.26516 37.7840554200842 -122.474147738612 (37.7840554200842, -122.474147738612) 11 6 2 54 26
137188 123227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 790 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   5993222.74872 2110119.7569 37.7735967518389 -122.466895847723 (37.7735967518389, -122.466895847723) 11 6 2 54 11
137530 123393 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 667 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5995006.92654 2111007.28114 37.7761364727826 -122.460788484161 (37.7761364727826, -122.460788484161) 11 6 2 54 11
145137 93572 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 757 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2010 12:00:00 AM 14   Permit Number 53252 5994718.18671 2110428.47346 37.7745306031117 -122.46174532831 (37.7745306031117, -122.46174532831) 11 6 2 54 11
160089 97887 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1030 Cabrillo St 1 Sidewalk: Property side : Cutout Tree Private 2   11/23/2011 12:00:00 AM 1   Permit Number 768379 5992385.79681 2110712.74988 37.7751766093559 -122.469834146271 (37.7751766093559, -122.469834146271) 11 6 2 54 11

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