Data source: data.sfgov.org
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) |
JSON shape: default, array, newline-delimited
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");