Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147204 | 147204 | 141457 | Undocumented 2 | Tristania conferta :: 79 | 1 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997940.1194 | 2111622.4489 | 37.77799389396429 | -122.450686192278 | (37.7779938939643, -122.450686192278) | |||
| 181304 | 181304 | 141664 | Undocumented 2 | Tristania conferta :: 79 | 1 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998850.0581 | 2112402.9363 | 37.7801889538337 | -122.44759460079399 | (37.7801889538337, -122.447594600794) | |||
| 129916 | 129916 | 140234 | Undocumented 2 | Tristania conferta :: 79 | 1 SHRADER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997242.3128 | 2110421.4899 | 37.7746564060011 | -122.45301342789601 | (37.7746564060011, -122.453013427896) | |||
| 76160 | 76160 | 141440 | Undocumented 2 | Tristania conferta :: 79 | 10 Roselyn Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998236.4031 | 2111655.6366 | 37.7781019737431 | -122.44966363842501 | (37.7781019737431, -122.449663638425) | |||
| 4690 | 4690 | 253527 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | ||
| 20140 | 20140 | 10246 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | |||
| 146658 | 146658 | 138201 | Undocumented 2 | Tristania conferta :: 79 | 100 MASONIC AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998933.3099 | 2112544.5659 | 37.7805825894916 | -122.447316792413 | (37.7805825894916, -122.447316792413) | |||
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 7714 | 7714 | 14450 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.44733032611299 | (37.7806967093816, -122.447330326113) | |||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 9426 | 9426 | 14444 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5998945.1546 | 2112453.5304 | 37.7803333064109 | -122.447269262196 | (37.7803333064109, -122.447269262196) | |||
| 9466 | 9466 | 14453 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5998924.1725 | 2112667.0746 | 37.7809184444903 | -122.447357223078 | (37.7809184444903, -122.447357223078) | |||
| 135560 | 135560 | 139975 | Undocumented 2 | Tristania conferta :: 79 | 1000 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001951.2709 | 2111948.8589 | 37.7791189172983 | -122.436833589276 | (37.7791189172983, -122.436833589276) | |||
| 183794 | 183794 | 139974 | Undocumented 2 | Tristania conferta :: 79 | 1000 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001954.9936 | 2111926.8615 | 37.77905872955721 | -122.436819135829 | (37.7790587295572, -122.436819135829) | |||
| 188026 | 188026 | 142069 | Undocumented 2 | Tristania conferta :: 79 | 1000 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003891.204 | 2112315.3287 | 37.780235215595106 | -122.43014872170099 | (37.7802352155951, -122.430148721701) | |||
| 5527 | 5527 | 23775 | DPW Maintained 3 | Tristania conferta :: 79 | 1000 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 8 | 3X3 | 6003905.7295 | 2112204.2911 | 37.7799311566149 | -122.43009054793801 | (37.7799311566149, -122.430090547938) | ||
| 18778 | 18778 | 7005 | DPW Maintained 3 | Tristania conferta :: 79 | 1001 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6002577.0261 | 2110209.591 | 37.7743788659974 | -122.43454445471201 | (37.7743788659974, -122.434544454712) | ||
| 76477 | 76477 | 140436 | Undocumented 2 | Tristania conferta :: 79 | 1001 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003630.7136 | 2112143.9541 | 37.7797499065425 | -122.431037642518 | (37.7797499065425, -122.431037642518) | |||
| 64571 | 64571 | 139976 | Undocumented 2 | Tristania conferta :: 79 | 1002 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001948.5635 | 2111960.0268 | 37.779149427663796 | -122.436843754953 | (37.7791494276638, -122.436843754953) | |||
| 134736 | 134736 | 139977 | Undocumented 2 | Tristania conferta :: 79 | 1002 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001948.2251 | 2111973.9021 | 37.7791875065071 | -122.436845919175 | (37.7791875065071, -122.436845919175) | |||
| 186887 | 186887 | 141089 | DPW Maintained 3 | Tristania conferta :: 79 | 100x JORDAN AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | |||
| 50978 | 50978 | 138229 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998536.6795 | 2112630.6942 | 37.7807964033341 | -122.448695125032 | (37.7807964033341, -122.448695125032) | |||
| 55539 | 55539 | 138221 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998706.2288 | 2112655.399 | 37.7808739300098 | -122.448110353407 | (37.7808739300098, -122.448110353407) | |||
| 60493 | 60493 | 138227 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | |||
| 66209 | 66209 | 138223 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998623.3155 | 2112642.539 | 37.7808338797166 | -122.448396263517 | (37.7808338797166, -122.448396263517) | |||
| 67707 | 67707 | 138225 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998607.7481 | 2112640.5085 | 37.780827414440296 | -122.448449972246 | (37.7808274144403, -122.448449972246) | |||
| 68412 | 68412 | 138218 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998658.1729999995 | 2112647.6153 | 37.7808498107721 | -122.44827604058099 | (37.7808498107721, -122.448276040581) | |||
| 77076 | 77076 | 138219 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | |||
| 152000 | 152000 | 138217 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998640.9134 | 2112646.2616 | 37.780845107122104 | -122.448335652205 | (37.7808451071221, -122.448335652205) | |||
| 162298 | 162298 | 138226 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998572.2138 | 2112635.4321 | 37.7808114442344 | -122.448572536471 | (37.7808114442344, -122.448572536471) | |||
| 168926 | 168926 | 138224 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998591.1654 | 2112638.1395 | 37.7808199616553 | -122.44850716898199 | (37.7808199616553, -122.448507168982) | |||
| 180469 | 180469 | 138222 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998723.4884 | 2112655.399 | 37.780874916637295 | -122.44805064424999 | (37.7808749166373, -122.44805064425) | |||
| 185860 | 185860 | 138220 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998691.3383 | 2112654.3837 | 37.78087029103521 | -122.448161793593 | (37.7808702910352, -122.448161793593) | |||
| 38875 | 38875 | 245200 | Undocumented 2 | Tristania conferta :: 79 | 101 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001317.1669 | 2109106.4404 | 37.771278291600204 | -122.438823465977 | (37.7712782916002, -122.438823465977) | |||
| 147491 | 147491 | 245201 | Undocumented 2 | Tristania conferta :: 79 | 101 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001321.2048 | 2109086.6996 | 37.7712243180125 | -122.438808083889 | (37.7712243180125, -122.438808083889) | |||
| 50810 | 50810 | 244267 | Undocumented 2 | Tristania conferta :: 79 | 101 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006039.2488 | 2110111.0896 | 37.7743043362973 | -122.42256096017599 | (37.7743043362973, -122.422560960176) | |||
| 149402 | 149402 | 244268 | Undocumented 2 | Tristania conferta :: 79 | 101 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6006040.8149 | 2110087.076 | 37.774238489092 | -122.422553836011 | (37.774238489092, -122.422553836011) | |||
| 22202 | 22202 | 2173 | DPW Maintained 3 | Tristania conferta :: 79 | 1010X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6001288.5645 | 2109046.8136 | 37.77111294397879 | -122.438918128915 | (37.7711129439788, -122.438918128915) | |||
| 63410 | 63410 | 200019 | Undocumented 2 | Tristania conferta :: 79 | 1012 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6018229.2689 | 2092102.4532 | 37.7255364609642 | -122.37914194332399 | (37.7255364609642, -122.379141943324) | |||
| 19234 | 19234 | 2174 | DPW Maintained 3 | Tristania conferta :: 79 | 1012X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001267.8248 | 2109041.6287 | 37.7710975275243 | -122.43898949646601 | (37.7710975275243, -122.438989496466) | |||
| 8816 | 8816 | 17671 | DPW Maintained 3 | Tristania conferta :: 79 | 1015X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/05/1995 12:00:00 AM | 12 | 3X3 | 6002380.7463 | 2112056.356 | 37.779438476782 | -122.43535555227301 | (37.779438476782, -122.435355552273) | ||
| 32382 | 32382 | 200015 | Undocumented 2 | Tristania conferta :: 79 | 1021 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018293.9123 | 2092319.9509 | 37.7261372321338 | -122.37893357191099 | (37.7261372321338, -122.378933571911) | |||
| 9005 | 9005 | 7012 | Permitted Site 1 | Tristania conferta :: 79 | 1030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002476.0968 | 2110247.1221 | 37.774476187107 | -122.43489627219601 | (37.774476187107, -122.434896272196) | ||
| 55174 | 55174 | 244269 | Undocumented 2 | Tristania conferta :: 79 | 104 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6006030.8963 | 2110049.4896 | 37.774134726332996 | -122.42258547485399 | (37.774134726333, -122.422585474854) | |||
| 157504 | 157504 | 199987 | Undocumented 2 | Tristania conferta :: 79 | 1040 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6018098.5001 | 2092201.6353 | 37.7258015841871 | -122.379600891938 | (37.7258015841871, -122.379600891938) | |||
| 43098 | 43098 | 142370 | Undocumented 2 | Tristania conferta :: 79 | 1041 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005599.4645 | 2113294.0647 | 37.7830191883263 | -122.424308687896 | (37.7830191883263, -122.424308687896) | |||
| 6506 | 6506 | 9520 | Permitted Site 1 | Tristania conferta :: 79 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.780148328739706 | -122.42792841204799 | (37.7801483287397, -122.427928412048) | ||
| 69255 | 69255 | 199988 | Undocumented 2 | Tristania conferta :: 79 | 1048 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6018073.2308 | 2092225.0095 | 37.7258643714622 | -122.37968987018299 | (37.7258643714622, -122.379689870183) | |||
| 7459 | 7459 | 7015 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002372.7109 | 2110234.5481 | 37.7744357915241 | -122.435253003778 | (37.7744357915241, -122.435253003778) | ||
| 8597 | 8597 | 7014 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2008 12:00:00 AM | 3 | 3X3 | 6002429.2937 | 2110241.5336 | 37.774458185014296 | -122.43505777310101 | (37.7744581850143, -122.435057773101) | ||
| 41164 | 41164 | 141932 | Undocumented 2 | Tristania conferta :: 79 | 1050 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004095.7926 | 2111864.1542 | 37.7790079875659 | -122.42940877227899 | (37.7790079875659, -122.429408772279) | |||
| 43373 | 43373 | 141927 | Undocumented 2 | Tristania conferta :: 79 | 1050 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004260.1036 | 2111886.4501 | 37.779078507887995 | -122.428841944247 | (37.779078507888, -122.428841944247) | |||
| 56512 | 56512 | 142369 | Undocumented 2 | Tristania conferta :: 79 | 1051 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005596.8056 | 2113324.6423 | 37.7831029967419 | -122.424320062115 | (37.7831029967419, -122.424320062115) | |||
| 3080 | 3080 | 28823 | Permitted Site 1 | Tristania conferta :: 79 | 1054 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002356.6442 | 2110231.7539 | 37.77442720694221 | -122.435308381556 | (37.7744272069422, -122.435308381556) | ||
| 67165 | 67165 | 247370 | Undocumented 2 | Tristania conferta :: 79 | 1060 Oak St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 6001950.1776 | 2109827.7317 | 37.773294771397296 | -122.436685497841 | (37.7732947713973, -122.436685497841) | |||
| 37768 | 37768 | 142368 | Undocumented 2 | Tristania conferta :: 79 | 1061 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005592.1525 | 2113362.5319 | 37.783206769497596 | -122.424338855729 | (37.7832067694976, -122.424338855729) | |||
| 58102 | 58102 | 199983 | Undocumented 2 | Tristania conferta :: 79 | 1065 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6018148.6647 | 2092424.0259999998 | 37.7264149928709 | -122.379442916331 | (37.7264149928709, -122.379442916331) | |||
| 178563 | 178563 | 142367 | Undocumented 2 | Tristania conferta :: 79 | 1071 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005589.4935 | 2113384.4680000003 | 37.7832668504733 | -122.42434961552799 | (37.7832668504733, -122.424349615528) | |||
| 6776 | 6776 | 14454 | DPW Maintained 3 | Tristania conferta :: 79 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | ||
| 131386 | 131386 | 140649 | Undocumented 2 | Tristania conferta :: 79 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | |||
| 4663 | 4663 | 17684 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002398.395 | 2112227.2208 | 37.7799086308334 | -122.435306723377 | (37.7799086308334, -122.435306723377) | |||
| 5483 | 5483 | 17683 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002401.1721 | 2112213.0575 | 37.7798698996827 | -122.43529610278401 | (37.7798698996827, -122.435296102784) | |||
| 6977 | 6977 | 17681 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1990 12:00:00 AM | 12 | 4X4 | 6002407.8372 | 2112172.5118 | 37.779758949887096 | -122.43527014428601 | (37.7797589498871, -122.435270144286) | ||
| 8200 | 8200 | 17682 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 12 | 4X4 | 6002406.1709 | 2112191.9515 | 37.7798122317892 | -122.43527729963002 | (37.7798122317892, -122.43527729963) | ||
| 8907 | 8907 | 17685 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002392.8724 | 2112252.5847 | 37.779977960097 | -122.43532764329201 | (37.779977960097, -122.435327643292) | |||
| 6856 | 6856 | 26449 | DPW Maintained 3 | Tristania conferta :: 79 | 1096 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6005161.0819 | 2113052.9102 | 37.7823322739768 | -122.425808142175 | (37.7823322739768, -122.425808142175) | ||
| 155398 | 155398 | 244212 | Undocumented 2 | Tristania conferta :: 79 | 1097 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002214.1995 | 2110159.2428 | 37.7742200191551 | -122.435795934917 | (37.7742200191551, -122.435795934917) | |||
| 55040 | 55040 | 244270 | Undocumented 2 | Tristania conferta :: 79 | 110 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005991.7437 | 2110043.7472 | 37.7741167501745 | -122.42272050260401 | (37.7741167501745, -122.422720502604) | |||
| 2329 | 2329 | 6184 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | |||
| 2795 | 2795 | 6186 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.42485024282301 | (37.783400948036, -122.424850242823) | |||
| 2965 | 2965 | 6183 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005506.7779 | 2113443.7591 | 37.78342497809621 | -122.424639997895 | (37.7834249780962, -122.424639997895) | |||
| 4438 | 4438 | 6185 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005465.536 | 2113438.1352 | 37.783407206982005 | -122.424782278636 | (37.783407206982, -122.424782278636) | |||
| 6482 | 6482 | 6194 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005201.2129999995 | 2113404.3918 | 37.7832996233389 | -122.42569433072799 | (37.7832996233389, -122.425694330728) | |||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 7364 | 7364 | 6192 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005245.2668 | 2113409.0784 | 37.7833149808402 | -122.425542255616 | (37.7833149808402, -122.425542255616) | |||
| 7430 | 7430 | 6190 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | |||
| 7516 | 7516 | 6182 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005530.6795 | 2113448.9143 | 37.7834404828465 | -122.424557674459 | (37.7834404828465, -122.424557674459) | |||
| 8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | |||
| 8695 | 8695 | 6189 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | |||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 46505 | 46505 | 45601 | Permitted Site 1 | Tristania conferta :: 79 | 1100 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 10 | Permit Number 44335 | 6003419.3416 | 2112114.1133 | 37.7796559917005 | -122.431766739067 | (37.7796559917005, -122.431766739067) | ||
| 25095 | 25095 | 139803 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.0945 | 2112991.4978 | 37.7821909905379 | -122.42412930203699 | (37.7821909905379, -122.424129302037) | |||
| 41255 | 41255 | 139805 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005648.2172 | 2112955.0668 | 37.7820911362793 | -122.42411590723101 | (37.7820911362793, -122.424115907231) | |||
| 53024 | 53024 | 139808 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005655.8504 | 2112888.45 | 37.781908653892 | -122.42408476084101 | (37.781908653892, -122.424084760841) | |||
| 55734 | 55734 | 139804 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.4415 | 2112973.1088 | 37.782140518457105 | -122.424126793395 | (37.7821405184571, -122.424126793395) | |||
| 67479 | 67479 | 139806 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005650.9929 | 2112934.249 | 37.7820341324354 | -122.424104823616 | (37.7820341324354, -122.424104823616) | |||
| 70497 | 70497 | 139810 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005664.1775 | 2112848.2023 | 37.7817986137394 | -122.42405308982599 | (37.7817986137394, -122.424053089826) | |||
| 76025 | 76025 | 139807 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005654.4625 | 2112912.0434 | 37.78197335721 | -122.424091240716 | (37.78197335721, -122.424091240716) | |||
| 126884 | 126884 | 139801 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005638.1553 | 2113040.0726 | 37.78232397319461 | -122.42415676420299 | (37.7823239731946, -122.424156764203) | |||
| 136545 | 136545 | 139811 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005666.9532 | 2112825.9968 | 37.7817377996033 | -122.424041907588 | (37.7817377996033, -122.424041907588) | |||
| 150911 | 150911 | 139802 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005640.931 | 2113014.3973 | 37.782253631856605 | -122.42414533496 | (37.7822536318566, -122.42414533496) | |||
| 8481 | 8481 | 5881 | Permitted Site 1 | Tristania conferta :: 79 | 1106 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005104.874 | 2113043.8892 | 37.7823043280422 | -122.426001954403 | (37.7823043280422, -122.426001954403) | ||
| 59177 | 59177 | 245062 | Undocumented 2 | Tristania conferta :: 79 | 1108 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000757.2591 | 2108969.2279 | 37.7708696699941 | -122.44075036199101 | (37.7708696699941, -122.440750361991) | |||
| 153370 | 153370 | 140523 | Undocumented 2 | Tristania conferta :: 79 | 1110 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003749.9866 | 2111813.2797 | 37.7788487145301 | -122.430601422928 | (37.7788487145301, -122.430601422928) | |||
| 60607 | 60607 | 141855 | Undocumented 2 | Tristania conferta :: 79 | 1111 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004718.7392 | 2112676.2265 | 37.7812729868648 | -122.427311611478 | (37.7812729868648, -122.427311611478) | |||
| 8929 | 8929 | 5882 | DPW Maintained 3 | Tristania conferta :: 79 | 1112 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005074.3413 | 2113041.8074 | 37.782296886294496 | -122.42610743581699 | (37.7822968862945, -122.426107435817) | ||
| 76028 | 76028 | 141362 | Undocumented 2 | Tristania conferta :: 79 | 1116 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002077.2497 | 2110193.7413 | 37.774306963236796 | -122.436272137566 | (37.7743069632368, -122.436272137566) | |||
| 7268 | 7268 | 5883 | Permitted Site 1 | Tristania conferta :: 79 | 1118 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005049.3601 | 2113036.9499 | 37.7822821368488 | -122.426193513801 | (37.7822821368488, -122.426193513801) |
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");