Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||||
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) | |||
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) | |||
25678 | 25678 | 129817 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.40020979915899 | (37.793996430738, -122.400209799159) | |||
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) | |||
28769 | 28769 | 129827 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012617.00039 | 2117213.20404 | 37.7941739812068 | -122.400306096749 | (37.7941739812068, -122.400306096749) | |||
29650 | 29650 | 129819 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012648.9601 | 2117092.8382099997 | 37.793845267304505 | -122.400187054399 | (37.7938452673045, -122.400187054399) | |||
30051 | 30051 | 129811 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012498.509190001 | 2117154.1734 | 37.794005289065794 | -122.40071194282801 | (37.7940052890658, -122.400711942828) | |||
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) | |||
32083 | 32083 | 129818 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.79391739292829 | -122.400190373809 | (37.7939173929283, -122.400190373809) | |||
33596 | 33596 | 227938 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.756022715594604 | -122.426674645426 | (37.7560227155946, -122.426674645426) | |||
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) | |||
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) | |||
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) | |||
38577 | 38577 | 129810 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012477.08259 | 2117150.1123 | 37.7939929431787 | -122.40078579605101 | (37.7939929431787, -122.400785796051) | |||
40031 | 40031 | 129832 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012451.480280001 | 2117191.95794 | 37.7941064133197 | -122.400877324536 | (37.7941064133197, -122.400877324536) | |||
40130 | 40130 | 228846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | |||
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) | |||
41186 | 41186 | 228842 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999127.094409999 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | |||
43828 | 43828 | 208173 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.744339434016794 | -122.460502016448 | (37.7443394340168, -122.460502016448) | |||
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) | |||
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) | |||
47917 | 47917 | 129784 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1600 Montgomery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6011334.32807 | 2120989.68408 | 37.8044716700829 | -122.405010336152 | (37.8044716700829, -122.405010336152) | |||
50680 | 50680 | 129764 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.42190349824101 | (37.7977976222176, -122.421903498241) | |||
57959 | 57959 | 129812 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012517.23545 | 2117156.65433 | 37.794013145532 | -122.40064732203301 | (37.794013145532, -122.400647322033) | |||
59650 | 59650 | 129831 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012476.45918 | 2117195.3094900004 | 37.7941170091435 | -122.40079112993 | (37.7941170091435, -122.40079112993) | |||
62252 | 62252 | 227934 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005814.854180001 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | |||
62703 | 62703 | 129830 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012498.4118 | 2117199.54922 | 37.794129874847606 | -122.400715469043 | (37.7941298748476, -122.400715469043) | |||
65614 | 65614 | 228852 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004131.71858 | 2104545.14122 | 37.7589137859482 | -122.428762589748 | (37.7589137859482, -122.428762589748) | |||
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) | |||
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) | |||
68851 | 68851 | 228850 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.42863130311501 | (37.7589211990752, -122.428631303115) | |||
69203 | 69203 | 129829 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012523.949659999 | 2117203.16491 | 37.7941412269928 | -122.400627358876 | (37.7941412269928, -122.400627358876) | |||
72002 | 72002 | 129820 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012651.85549 | 2117070.09364 | 37.7937829775554 | -122.400175437873 | (37.7937829775554, -122.400175437873) | |||
72713 | 72713 | 208168 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991441.450619999 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | |||
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) | |||
75033 | 75033 | 228849 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.75892367042171 | -122.42857972608499 | (37.7589236704217, -122.428579726085) | |||
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) | |||
75521 | 75521 | 228848 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004199.57922 | 2104548.6925 | 37.7589273774242 | -122.42852814905599 | (37.7589273774242, -122.428528149056) | |||
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) | |||
113875 | 113875 | 129759 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.72856 | 2118745.4751 | 37.7981362718366 | -122.415553596641 | (37.7981362718366, -122.415553596641) | |||
130005 | 130005 | 129813 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012536.38879 | 2117159.9438 | 37.794023245839796 | -122.400581280298 | (37.7940232458398, -122.400581280298) | |||
131468 | 131468 | 129753 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003149.59406 | 2116175.6254 | 37.790792583373104 | -122.43299016506901 | (37.7907925833731, -122.432990165069) | |||
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) | |||
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) | |||
134069 | 134069 | 124474 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.45627485050899 | (37.7748806555631, -122.456274850509) | |||
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) | |||
136849 | 136849 | 208174 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | |||
149570 | 149570 | 129755 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003208.43493 | 2116180.994 | 37.7908106615232 | -122.432786962347 | (37.7908106615232, -122.432786962347) | |||
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) | |||
151478 | 151478 | 228845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001290.00365 | 2104097.6707200003 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | |||
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) | |||
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) | |||
151732 | 151732 | 228851 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004146.65332 | 2104546.1831400003 | 37.7589174920696 | -122.42871101271002 | (37.7589174920696, -122.42871101271) | |||
152362 | 152362 | 129754 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003179.18897 | 2116177.33789 | 37.7907989640458 | -122.43288789058902 | (37.7907989640458, -122.432887890589) | |||
152581 | 152581 | 129751 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000742.15542 | 2119656.12238 | 37.8002122659526 | -122.44156963624201 | (37.8002122659526, -122.441569636242) | |||
153734 | 153734 | 129816 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012609.05006 | 2117170.5257599996 | 37.7940563534572 | -122.400330606896 | (37.7940563534572, -122.400330606896) | |||
154064 | 154064 | 208170 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | |||
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) | |||
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) | |||
158244 | 158244 | 129814 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012557.97886 | 2117161.9578299997 | 37.7940299799473 | -122.40050671752199 | (37.7940299799473, -122.400506717522) | |||
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) | |||
167501 | 167501 | 129749 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000782.42382 | 2119661.2506 | 37.8002286408033 | -122.44143066041599 | (37.8002286408033, -122.441430660416) | |||
168272 | 168272 | 129750 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.800217563850296 | -122.44150624394301 | (37.8002175638503, -122.441506243943) | |||
168728 | 168728 | 129828 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012548.895219999 | 2117204.8631700003 | 37.7941472812331 | -122.400541163364 | (37.7941472812331, -122.400541163364) | |||
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) | |||
169758 | 169758 | 208167 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991441.567009999 | 2097783.56953 | 37.7396218639513 | -122.47215777968201 | (37.7396218639513, -122.472157779682) | |||
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) | |||
170579 | 170579 | 228847 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004213.13115 | 2104548.41319 | 37.758927377407 | -122.42848126022699 | (37.758927377407, -122.428481260227) | |||
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) | |||
174249 | 174249 | 129833 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012379.779080001 | 2117177.7039400004 | 37.794063275551295 | -122.40112441775601 | (37.7940632755513, -122.401124417756) | |||
176983 | 176983 | 129765 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006424.31939 | 2118660.7850599997 | 37.797801411063396 | -122.421836357588 | (37.7978014110634, -122.421836357588) | |||
180032 | 180032 | 129815 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012587.02488 | 2117167.29458 | 37.7940462531923 | -122.400406589716 | (37.7940462531923, -122.400406589716) | |||
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) | |||
181097 | 181097 | 208169 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991440.6028 | 2097828.1323700002 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | |||
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) | |||
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) | |||
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) | |||
187663 | 187663 | 129748 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.800238273442396 | -122.441353858292 | (37.8002382734424, -122.441353858292) |
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");