Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
25730 | 25730 | 233142 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000859.74729 | 2102942.63257 | 37.754327958491395 | -122.43996366469901 | (37.7543279584914, -122.439963664699) | |||
25825 | 25825 | 233757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.84947 | 2107982.08951 | 37.7682122417201 | -122.437457274854 | (37.7682122417201, -122.437457274854) | |||
30492 | 30492 | 194157 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Rhode Island St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011751.61895 | 2106914.05853 | 37.7658466245494 | -122.40257584440701 | (37.7658466245494, -122.402575844407) | |||
36703 | 36703 | 232957 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5998345.3439 | 2105333.405 | 37.7607489686178 | -122.448831267855 | (37.7607489686178, -122.448831267855) | |||
37783 | 37783 | 131938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006702.042119999 | 2117656.1689 | 37.7950586451804 | -122.420803998799 | (37.7950586451804, -122.420803998799) | |||
41990 | 41990 | 131872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6000857.63079 | 2121697.12511 | 37.805822893385 | -122.441316575098 | (37.805822893385, -122.441316575098) | |||
41998 | 41998 | 232864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2784 23rd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010097.8107199995 | 2102827.94887 | 37.7545346199892 | -122.408007862 | (37.7545346199892, -122.408007862) | |||
44274 | 44274 | 124649 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995460.1391900005 | 2115780.29786 | 37.7892679654039 | -122.459566483421 | (37.7892679654039, -122.459566483421) | |||
46684 | 46684 | 131871 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6000836.15896 | 2121693.63297 | 37.8058120817332 | -122.441390630693 | (37.8058120817332, -122.441390630693) | |||
47035 | 47035 | 194173 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 612 Arkansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6012968.318519999 | 2104189.69747 | 37.7584339823465 | -122.398176354675 | (37.7584339823465, -122.398176354675) | |||
48644 | 48644 | 124648 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 5ft | 5995458.44608 | 2115807.32553 | 37.7893420787061 | -122.459574299668 | (37.7893420787061, -122.459574299668) | |||
49037 | 49037 | 194154 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 470 Carolina St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6012311.644719999 | 2105752.08257 | 37.762687347553296 | -122.40055718926901 | (37.7626873475533, -122.400557189269) | |||
53458 | 53458 | 233069 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 774 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6001540.64018 | 2099730.3572 | 37.7455465535424 | -122.43737896277901 | (37.7455465535424, -122.437378962779) | |||
54904 | 54904 | 233003 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 724 Anderson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6007739.01279 | 2095540.2064599998 | 37.7343917558762 | -122.415649262915 | (37.7343917558762, -122.415649262915) | |||
59070 | 59070 | 232958 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5998343.545080001 | 2105338.45207 | 37.760762723739795 | -122.448837852691 | (37.7607627237398, -122.448837852691) | |||
59477 | 59477 | 131848 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5999135.0033599995 | 2121188.05982 | 37.804326857662 | -122.44724130424801 | (37.804326857662, -122.447241304248) | |||
65964 | 65964 | 246019 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.44860726821899 | (37.7695913556898, -122.448607268219) | |||
68041 | 68041 | 132012 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 902 Vallejo St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6009174.978759999 | 2118751.12637 | 37.7982042021283 | -122.412324664466 | (37.7982042021283, -122.412324664466) | |||
75906 | 75906 | 232456 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3320 22nd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6006194.14173 | 2103187.50749 | 37.755302551083105 | -122.421533334606 | (37.7553025510831, -122.421533334606) | |||
111306 | 111306 | 52287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 72 Valley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 03/04/2011 12:00:00 AM | Permit Number 54678 | 6005433.61319764 | 2099357.0668783 | 37.7447421315969 | -122.42389111052499 | (37.7447421315969, -122.423891110525) | |||
127022 | 127022 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | ||||
131293 | 131293 | 131941 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006749.6084900005 | 2117663.12634 | 37.795080429464996 | -122.420639905831 | (37.795080429465, -122.420639905831) | |||
136866 | 136866 | 131942 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1657 Hyde St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007350.9768 | 2118106.89456 | 37.7963327803806 | -122.41859055950898 | (37.7963327803806, -122.418590559509) | |||
144632 | 144632 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | |||
146899 | 146899 | 247159 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3998 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002431.63894 | 2105915.71015 | 37.7625806699736 | -122.434740260168 | (37.7625806699736, -122.434740260168) | |||
147054 | 147054 | 233144 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6000861.64535 | 2102916.72773 | 37.7542569381196 | -122.439955243433 | (37.7542569381196, -122.439955243433) | |||
148909 | 148909 | 247160 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3998 17th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6002420.24757 | 2105915.11638 | 37.7625783928991 | -122.43477961627899 | (37.7625783928991, -122.434779616279) | |||
151079 | 151079 | 194156 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 470 Carolina St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6012312.50187 | 2105735.4207900004 | 37.7626416458119 | -122.400553054198 | (37.7626416458119, -122.400553054198) | |||
151228 | 151228 | 194155 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 470 Carolina St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6012312.17929 | 2105744.82219 | 37.7626674419765 | -122.400554830334 | (37.7626674419765, -122.400554830334) | |||
151821 | 151821 | 131847 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 5999134.00853 | 2121203.2067400003 | 37.804368390155204 | -122.44724583773399 | (37.8043683901552, -122.447245837734) | |||
153442 | 153442 | 131943 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1657 Hyde St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007355.06996 | 2118080.96965 | 37.796261827486205 | -122.41857455697901 | (37.7962618274862, -122.418574556979) | |||
157175 | 157175 | 247158 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3998 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6002441.05995 | 2105914.9624900003 | 37.7625791519331 | -122.43470762288 | (37.7625791519331, -122.43470762288) | |||
161369 | 161369 | 131881 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 12 Perine Pl | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6002259.42622 | 2115592.6518099997 | 37.7891413561277 | -122.43602836453998 | (37.7891413561277, -122.43602836454) | |||
161960 | 161960 | 131939 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006716.29035 | 2117657.19868 | 37.795062275769205 | -122.420754770831 | (37.7950622757692, -122.420754770831) | |||
162591 | 162591 | 131937 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1654 Hyde St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007419.38952 | 2118117.401 | 37.796365479747 | -122.418354581903 | (37.796365479747, -122.418354581903) | |||
168752 | 168752 | 177972 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 32 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6004452.10301 | 2093339.7644 | 37.7281645190556 | -122.42685652881201 | (37.7281645190556, -122.426856528812) | |||
168946 | 168946 | 131940 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006735.1241 | 2117659.83455 | 37.7950705747007 | -122.42068979031 | (37.7950705747007, -122.42068979031) | |||
173388 | 173388 | 246017 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 Haight St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 5998426.5454 | 2108592.8445 | 37.7697032096403 | -122.448785206443 | (37.7697032096403, -122.448785206443) | |||
174685 | 174685 | 233118 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1803 Castro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 7ft | 6002653.14547 | 2100266.75628 | 37.7470825632048 | -122.43357042294201 | (37.7470825632048, -122.433570422942) | |||
177151 | 177151 | 232959 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5998346.642990001 | 2105340.90791 | 37.760769644019106 | -122.448827315349 | (37.7607696440191, -122.448827315349) | |||
182815 | 182815 | 246018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 603 Clayton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5998473.1811 | 2108575.8861 | 37.769659312933896 | -122.448622674121 | (37.7696593129339, -122.448622674121) | |||
183015 | 183015 | 124651 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995459.76206 | 2115756.0288299997 | 37.7892013075378 | -122.459566029798 | (37.7892013075378, -122.459566029798) | |||
184216 | 184216 | 233143 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000860.583219999 | 2102930.76024 | 37.7542954075331 | -122.43995992263099 | (37.7542954075331, -122.439959922631) | |||
185975 | 185975 | 210672 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5996018.88182 | 2098492.62213 | 37.7418325783074 | -122.456382749179 | (37.7418325783074, -122.456382749179) | |||
186497 | 186497 | 131936 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1654 Hyde St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007422.60958 | 2118093.1296900003 | 37.796299018046206 | -122.41834171801099 | (37.7962990180462, -122.418341718011) | |||
188025 | 188025 | 233083 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 10ft | 6001990.940119999 | 2099392.0216200002 | 37.7446431530538 | -122.435797694723 | (37.7446431530538, -122.435797694723) |
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");