Street_Tree_List

Data source: data.sfgov.org

315 rows where qSpecies = 85 sorted by qAddress descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress ▲ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
145231 145231 68365 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 945 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM     Permit Number 32186 6010298.82314684 2116844.8632648997 37.7930330672197 -122.40830128766501 (37.7930330672197, -122.408301287665)
66960 66960 200333 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 903 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6015264.35575 2104459.34943 37.7593020107061 -122.39025440841002 (37.7593020107061, -122.39025440841)
23670 23670 129807 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6010390.20829 2116866.53247 37.793097682469394 -122.407986617304 (37.7930976824694, -122.407986617304)
28250 28250 129809 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 8 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.40789173971399 (37.7931091785103, -122.407891739714)
35863 35863 129806 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6010377.17129 2116863.70379 37.793089185679705 -122.40803152672702 (37.7930891856797, -122.408031526727)
38087 38087 129808 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   6010404.49438 2116867.87948 37.7931021808659 -122.40793728139201 (37.7931021808659, -122.407937281392)
134397 134397 129803 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6010302.01456 2116853.58579 37.7930571958732 -122.408290860643 (37.7930571958732, -122.408290860643)
149913 149913 129804 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6010351.68054 2116862.21581 37.793083672815705 -122.408119621635 (37.7930836728157, -122.408119621635)
151570 151570 129805 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   6010365.088819999 2116862.85785 37.793086186442 -122.40807327328899 (37.793086186442, -122.408073273289)
184232 184232 129802 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   6010252.4995 2116845.85776 37.79303320378 -122.40846164098801 (37.79303320378, -122.408461640988)
13518 13518 106002 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Minnesota St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6015261.96303 2104498.62679 37.759409725189705 -122.39026542781299 (37.7594097251897, -122.390265427813)
15015 15015 106001 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6015262.44728 2104479.57944 37.75935745211439 -122.390262422266 (37.7593574521144, -122.390262422266)
31300 31300 200349 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 11 : 4 Tree 1 Private 1     8 Width 4ft   6014526.629869999 2097016.7538700001 37.738825266977294 -122.392285304228 (37.7388252669773, -122.392285304228)
40723 40723 200348 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 10 : 4 Tree 1 Private 1     9 Width 4ft   6014546.28219 2097041.8855599998 37.738895364638 -122.39221911232599 (37.738895364638, -122.392219112326)
57768 57768 200357 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6014316.3111 2096732.3588400001 37.73803269625021 -122.392992601233 (37.7380326962502, -122.392992601233)
57963 57963 200352 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 16 : 4 Tree 1 Private 1     14 Width 5ft   6014405.80816 2096853.92235 37.7383714555731 -122.392691664697 (37.7383714555731, -122.392691664697)
105063 105063 200347 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 9 : 4 Tree 1 Private 1     11 Width 4ft   6014556.031830001 2097054.78425 37.7389313231291 -122.392186304173 (37.7389313231291, -122.392186304173)
133126 133126 200353 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 17 : 4 Tree 1 Private 1     11 Width 5ft   6014392.43301 2096834.63166 37.738317744462 -122.392736560653 (37.738317744462, -122.392736560653)
134636 134636 200355 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 19 : 4 Tree 1 Private 1     11 Width 5ft   6014345.08354 2096773.3910700001 37.7381469605042 -122.392895989784 (37.7381469605042, -122.392895989784)
135542 135542 200351 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6014421.213330001 2096874.8296 37.73842971815 -122.39263986285 (37.73842971815, -122.39263986285)
136918 136918 200356 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6014331.3129900005 2096752.73935 37.7380894902424 -122.39294215736601 (37.7380894902424, -122.392942157366)
146537 146537 200350 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 12 : 4 Tree 1 Private 1     7 Width 4ft   6014508.81125 2096991.75117 37.738755625282394 -122.39234516490299 (37.7387556252824, -122.392345164903)
164517 164517 200354 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168)
168594 168594 200346 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 4 : 4 Tree 1 Private 1     9 Width 4ft   6014640.20968 2097167.32462 37.7392450093596 -122.391903121137 (37.7392450093596, -122.391903121137)
175699 175699 200345 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 3 : 4 Tree 1 Private 1     6 Width 4ft   6014658.54117 2097192.95407 37.7393164002222 -122.391841530176 (37.7393164002222, -122.391841530176)
4102 4102 253611 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
25573 25573 129783 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
34108 34108 129780 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6012726.999559999 2119408.50299 37.800207880833895 -122.400079730213 (37.8002078808339, -122.400079730213)
132351 132351 129779 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6012731.79119 2119371.92723 37.800107719749604 -122.400060579146 (37.8001077197496, -122.400060579146)
169203 169203 129777 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6012748.89649 2119266.86751 37.79982020469429 -122.399994005922 (37.7998202046943, -122.399994005922)
170047 170047 129781 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6012720.0769 2119456.93183 37.8003404688016 -122.40010708848 (37.8003404688016, -122.40010708848)
180399 180399 129782 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6012716.05958 2119492.7044900004 37.800438467927606 -122.40012350379601 (37.8004384679276, -122.400123503796)
187504 187504 129778 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Front St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6012744.14452 2119292.42038 37.7998901017986 -122.400012245068 (37.7998901017986, -122.400012245068)
40999 40999 129775 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6012820.869469999 2119255.17116 37.799792101768396 -122.399744129295 (37.7997921017684, -122.399744129295)
75415 75415 129774 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6012849.953480001 2119259.82939 37.7998065134132 -122.39964381442499 (37.7998065134132, -122.399643814425)
75710 75710 129769 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6013010.632 2119281.7619 37.7998756901686 -122.39908934370101 (37.7998756901686, -122.399089343701)
76914 76914 129776 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6012790.20467 2119250.54506 37.7997776901326 -122.39984991653601 (37.7997776901326, -122.399849916536)
131501 131501 129770 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6012963.296490001 2119273.7997 37.7998511899251 -122.39925258414499 (37.7998511899251, -122.399252584145)
131803 131803 129772 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6012910.450180001 2119266.99952 37.799829572932296 -122.39943497565099 (37.7998295729323, -122.399434975651)
151663 151663 129773 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6012883.50017 2119263.61 37.799818763986295 -122.399527995233 (37.7998187639863, -122.399527995233)
172062 172062 129771 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 80 Vallejo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6012935.02914 2119270.4372 37.79984038189279 -122.399350164196 (37.7998403818928, -122.399350164196)
2250 2250 200335 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 7 : 4 Tree 1 Purchasing Dept 15     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847)
2256 2256 200334 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 4 : 4 Tree 1 Purchasing Dept 15   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.742565908900204 -122.388913512973 (37.7425659089002, -122.388913512973)
42998 42998 200342 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 25 : 4 Tree 1 Private 1     8 Width 2ft   6015273.793930001 2098017.0765 37.7416134072345 -122.389771789042 (37.7416134072345, -122.389771789042)
72490 72490 200340 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 23 : 4 Tree 1 Private 1     8 Width 2ft   6015300.13853 2098052.9717 37.7417134289277 -122.38968320401399 (37.7417134289277, -122.389683204014)
76523 76523 200341 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 24 : 4 Tree 1 Private 1     8 Width 2ft   6015282.07626 2098027.6206799997 37.74164281866221 -122.389743887597 (37.7416428186622, -122.389743887597)
137367 137367 200339 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 22 : 4 Tree 1 Private 1     5 Width 2ft   6015308.33502 2098065.1650799997 37.741747363937606 -122.389655714464 (37.7417473639376, -122.389655714464)
151751 151751 200344 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 40 : 4 Tree 1 Private 1     4 Width 4ft   6015132.05324 2097828.30985 37.74108723188171 -122.390248699517 (37.7410872318817, -122.390248699517)
159507 159507 200343 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 39 : 4 Tree 1 Private 1     8 Width 4ft   6015141.18947 2097840.20057 37.741120388109294 -122.39021794000799 (37.7411203881093, -122.390217940008)
160126 160126 200338 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 21 : 4 Tree 1 Private 1     9 Width 2ft   6015318.39191 2098076.99567 37.7417804059521 -122.389621766852 (37.7417804059521, -122.389621766852)
166431 166431 200336 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 8 : 4 Tree 1 Private 1     9 Width 3ft   6015493.51667 2098314.62088 37.7424425848476 -122.38903282511002 (37.7424425848476, -122.38903282511)
185785 185785 200337 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Phelps St 9 : 4 Tree 1 Private 1     10 Width 4ft   6015484.2575199995 2098301.13552 37.742405043569796 -122.389063899405 (37.7424050435698, -122.389063899405)
24992 24992 129842 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Battery St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6012477.73931 2118700.3434099997 37.7982495441479 -122.400892491621 (37.7982495441479, -122.400892491621)
57135 57135 65057 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 750 Battery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/1989 12:00:00 AM 14   Permit Number 27011 6012481.29964 2118678.07069 37.7981885871952 -122.400878606079 (37.7981885871952, -122.400878606079)
129659 129659 129843 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Battery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6012472.985859999 2118729.7445099996 37.7983300073669 -122.40091100686399 (37.7983300073669, -122.400911006864)
178038 178038 129844 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6012469.34241 2118758.9010099997 37.7984098608851 -122.40092566398899 (37.7984098608851, -122.400925663989)
160462 160462 177154 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 734 Peru Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6005364.09678 2092392.61851 37.725615388036104 -122.42363641630301 (37.7256153880361, -122.423636416303)
30254 30254 129837 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6012785.655809999 2118614.3901400003 37.79803070759829 -122.399820962885 (37.7980307075983, -122.399820962885)
35454 35454 129838 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6012789.03405 2118594.11911 37.797975236527904 -122.39980784898 (37.7979752365279, -122.39980784898)
55972 55972 129835 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6012779.55401 2118654.25305 37.7981398214472 -122.399844877638 (37.7981398214472, -122.399844877638)
130651 130651 129836 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6012782.07244 2118635.55361 37.7980886176578 -122.399834849323 (37.7980886176578, -122.399834849323)
156540 156540 129834 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6012777.11642 2118676.9470599997 37.7982019978752 -122.399854906882 (37.7982019978752, -122.399854906882)
94681 94681 63072 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 709 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1986 12:00:00 AM     Permit Number 23550 6007407.20126882 2097784.26133742 37.740534778558605 -122.416955389518 (37.7405347785586, -122.416955389518)
155277 155277 228844 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 709 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007473.725769999 2097767.91667 37.7404936415809 -122.416724215363 (37.7404936415809, -122.416724215363)
73201 73201 228843 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 707 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6007452.7290199995 2097768.34677 37.7404936415683 -122.416796844595 (37.7404936415683, -122.416796844595)
173137 173137 227935 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 705 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6008535.61915 2104408.30699 37.7587863358342 -122.413522114462 (37.7587863358342, -122.413522114462)
90452 90452 86806 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 700X Phelps St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
93009 93009 86807 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 700X Phelps St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     6 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
116101 116101 17647 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 650X Phelps St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     6 2x2   6015137.8127243 2097842.4274143996 37.7411263152677 -122.39022977121401 (37.7411263152677, -122.390229771214)
72647 72647 200369 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 650 Townsend St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6011472.2786 2108553.20224 37.7703317423487 -122.403657370911 (37.7703317423487, -122.403657370911)
46581 46581 228841 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 65 Homestead St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6000998.7373 2101290.13943 37.749798521207204 -122.439364559745 (37.7497985212072, -122.439364559745)
85626 85626 17642 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 600X Phelps St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     6 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
94447 94447 17645 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 600X Phelps St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
109408 109408 17643 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 600X Phelps St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
123909 123909 17641 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 600X Phelps St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
145002 145002 17644 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 600X Phelps St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Purchasing Dept 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
166582 166582 142921 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 546 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6009942.6265 2119419.3871 37.800082128353 -122.409715557637 (37.800082128353, -122.409715557637)
3401 3401 29754 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3x3   6009953.7417 2119408.8277 37.800053757708994 -122.40967634888099 (37.800053757709, -122.409676348881)
5782 5782 29753 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6009968.1915 2119398.824 37.8000270997238 -122.409625640361 (37.8000270997238, -122.409625640361)
7889 7889 29752 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3x3   6009988.1989 2119378.2609 37.7999717596155 -122.40955495470502 (37.7999717596155, -122.409554954705)
90132 90132 61067 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2002 12:00:00 AM     Permit Number 46064 6010044.29985327 2119322.50303189 37.7998218055895 -122.40935688621799 (37.7998218055895, -122.409356886218)
127002 127002 29755 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3x3   6010020.30224 2119411.75263 37.800065518477 -122.409446229453 (37.800065518477, -122.409446229453)
118847 118847 108695 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 511 Alvarado St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774625 6003049.10666 2102687.45843 37.7537516993963 -122.432374086122 (37.7537516993963, -122.432374086122)
34082 34082 129826 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 510 Battery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6012620.11049 2117309.3448900003 37.7944381345611 -122.400302091187 (37.7944381345611, -122.400302091187)
31378 31378 129821 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 504 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012337.50928 2117203.47544 37.7941316797929 -122.40127248843201 (37.7941316797929, -122.401272488432)
67539 67539 129822 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 504 Sansome St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6012331.01864 2117278.3358 37.7943368663928 -122.401300210056 (37.7943368663928, -122.401300210056)
45773 45773 129823 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 504 Battery St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6012601.68821 2117444.3368599997 37.7948077631249 -122.40037532116501 (37.7948077631249, -122.400375321165)
156528 156528 129824 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 504 Battery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6012608.14 2117404.20841 37.794697939723704 -122.40035017702499 (37.7946979397237, -122.400350177025)
185432 185432 129825 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 504 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6012609.836569999 2117389.63944 37.79465803140361 -122.400343282842 (37.7946580314036, -122.400343282842)
134068 134068 142927 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 501 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6011089.2103 2118971.3611 37.79891614378229 -122.405716341604 (37.7989161437823, -122.405716341604)
75153 75153 49224 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
88835 88835 49214 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
91400 91400 49223 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
99398 99398 49230 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
111666 111666 49232 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 27 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
116184 116184 49225 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
144578 144578 49226 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 500 Howard St 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
161074 161074 129768 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 489 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6011131.656690001 2118977.1984099997 37.7989345451634 -122.40556987367201 (37.7989345451634, -122.405569873672)
52414 52414 129846 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 485 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 2ft   6011762.70539 2118367.67112 37.797296196209295 -122.40334332133999 (37.7972961962093, -122.40334332134)
188297 188297 129845 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 485 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 2ft   6011739.20457 2118363.85261 37.797284398923004 -122.40342437184201 (37.797284398923, -122.403424371842)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 92.868ms · Data source: data.sfgov.org