Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78086 | 78086 | 24438 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 83108 | 83108 | 24439 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 90479 | 90479 | 24437 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 93710 | 93710 | 24440 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 97951 | 97951 | 24433 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 112421 | 112421 | 24434 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 44218 | 44218 | 232060 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009979.53816 | 2103472.3105599997 | 37.756297270530894 | -122.40846233078399 | (37.7562972705309, -122.408462330784) | |||
| 46460 | 46460 | 232059 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009981.93097 | 2103452.1603 | 37.7562420764311 | -122.408452634282 | (37.7562420764311, -122.408452634282) | |||
| 134775 | 134775 | 232058 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009981.55531 | 2103433.74149 | 37.7561914814659 | -122.40845263427799 | (37.7561914814659, -122.408452634278) | |||
| 106481 | 106481 | 35267 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 986 Burnett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38751 | 5999359.18591782 | 2100369.19379422 | 37.7471763868061 | -122.444967982995 | (37.7471763868061, -122.444967982995) | ||
| 138038 | 138038 | 232110 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 986 Burnett Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5999352.49281 | 2100464.8672700003 | 37.7474387010349 | -122.444998003853 | (37.7474387010349, -122.444998003853) | |||
| 71701 | 71701 | 232071 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 971 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004413.84124 | 2103262.14825 | 37.7554069533912 | -122.42769546588 | (37.7554069533912, -122.42769546588) | |||
| 74995 | 74995 | 193555 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 966 Natoma St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6007972.215030001 | 2109842.69259 | 37.773676240994206 | -122.41585544597 | (37.7736762409942, -122.41585544597) | |||
| 64843 | 64843 | 68171 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 960 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 5 | Permit Number 31942 | 5995973.45789 | 2112246.45528 | 37.7795944815391 | -122.457534690099 | (37.7795944815391, -122.457534690099) | |
| 120150 | 120150 | 87860 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 96 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | ||
| 180181 | 180181 | 201330 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 96 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012534.87131 | 2092831.57863 | 37.727222846157396 | -122.398878267423 | (37.7272228461574, -122.398878267423) | |||
| 20622 | 20622 | 1979 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 72507 | 72507 | 24170 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2004 12:00:00 AM | 8 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 129196 | 129196 | 24175 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 6 | 4x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 63975 | 63975 | 124205 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 95 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996360.35238 | 2111556.36806 | 37.7777219001221 | -122.45614635640499 | (37.7777219001221, -122.456146356405) | |||
| 32573 | 32573 | 201331 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 95 Bitting Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012535.62971 | 2092785.01018 | 37.7270950209928 | -122.39887237867599 | (37.7270950209928, -122.398872378676) | |||
| 142395 | 142395 | 34251 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 945 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38731 | 6006267.52442813 | 2121066.89219972 | 37.8043991257724 | -122.422549976626 | (37.8043991257724, -122.422549976626) | ||
| 67364 | 67364 | 201487 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 934 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6019005.827269999 | 2094664.79095 | 37.732614937414 | -122.37663506546801 | (37.732614937414, -122.376635065468) | |||
| 38920 | 38920 | 31779 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 926 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35253 | 5990034.0009 | 2097707.4772 | 37.73933137655229 | -122.477018926471 | (37.7393313765523, -122.477018926471) | |
| 142611 | 142611 | 65794 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 926 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 49648 | 5990322.56350918 | 2100435.83787483 | 37.746839484526795 | -122.476220447924 | (37.7468394845268, -122.476220447924) | ||
| 131160 | 131160 | 232095 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 92 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000964.078369999 | 2101203.45021 | 37.749558520927295 | -122.439478198057 | (37.7495585209273, -122.439478198057) | |||
| 161272 | 161272 | 201329 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 92 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012558.5544 | 2092814.1354099999 | 37.7271762702634 | -122.398795170956 | (37.7271762702634, -122.398795170956) | |||
| 61282 | 61282 | 201293 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 91 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012605.65207 | 2092980.54373 | 37.727635817521296 | -122.398644026411 | (37.7276358175213, -122.398644026411) | |||
| 187779 | 187779 | 232144 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 91 Clover Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000466.92396 | 2104962.588 | 37.759851893056705 | -122.44146708205 | (37.7598518930567, -122.44146708205) | |||
| 86360 | 86360 | 36928 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 901 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51504 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
| 178434 | 178434 | 232097 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000582.10335 | 2101964.75176 | 37.751627125314606 | -122.44085368146001 | (37.7516271253146, -122.44085368146) | |||
| 133084 | 133084 | 201310 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 9 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012935.48709 | 2092735.05755 | 37.726980133504604 | -122.397486565679 | (37.7269801335046, -122.397486565679) | |||
| 36242 | 36242 | 124204 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 89 Rossi Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996356.37617 | 2111567.7836599997 | 37.7777530161176 | -122.45616093696 | (37.7777530161176, -122.45616093696) | |||
| 186649 | 186649 | 124203 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 89 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996354.21688 | 2111585.45667 | 37.77780141760571 | -122.456169684743 | (37.7778014176057, -122.456169684743) | |||
| 111819 | 111819 | 33434 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 88 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37538 | 6006726.43388019 | 2099186.01333463 | 37.744345358001205 | -122.419408643115 | (37.7443453580012, -122.419408643115) | |||
| 117118 | 117118 | 33435 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37538 | 6006726.43388019 | 2099186.01333463 | 37.744345358001205 | -122.419408643115 | (37.7443453580012, -122.419408643115) | |||
| 137857 | 137857 | 201328 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 88 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012566.393569999 | 2092808.69922 | 37.7271617803826 | -122.39876768949301 | (37.7271617803826, -122.398767689493) | |||
| 1977 | 1977 | 35358 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 861 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2017 12:00:00 AM | 3 | Permit Number 779956 | 6011891.4551800005 | 2104381.4501400003 | 37.758900452609794 | -122.401914128638 | (37.7589004526098, -122.401914128638) | |
| 71442 | 71442 | 210163 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 855 Niagara Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997165.5867800005 | 2090928.2862900002 | 37.72112848326571 | -122.451872256998 | (37.7211284832657, -122.451872256998) | |||
| 53334 | 53334 | 232100 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 855 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000870.3613 | 2102569.98573 | 37.753305364576896 | -122.43990024181002 | (37.7533053645769, -122.43990024181) | |||
| 175439 | 175439 | 35357 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 853 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 19 | Permit Number 38819 | 6011893.15946 | 2104410.58195 | 37.758980537228105 | -122.401910282252 | (37.7589805372281, -122.401910282252) | |
| 161963 | 161963 | 177571 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 85 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003363.5172 | 2094628.2576 | 37.73164082055779 | -122.430711717396 | (37.7316408205578, -122.430711717396) | |||
| 167220 | 167220 | 201333 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 85 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012567.329609999 | 2092761.5615400001 | 37.727032402119896 | -122.398761146908 | (37.7270324021199, -122.398761146908) | |||
| 47727 | 47727 | 140019 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 835 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005306.1677 | 2111978.3680000002 | 37.7793900431405 | -122.42522972311701 | (37.7793900431405, -122.425229723117) | |||
| 104785 | 104785 | 109134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 833 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773415 | 5981360.00156 | 2110051.11927 | 37.77271648064389 | -122.507925058041 | (37.7727164806439, -122.507925058041) |
| 42919 | 42919 | 193666 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 83 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012305.62256 | 2107084.52943 | 37.7663456133759 | -122.400671627101 | (37.7663456133759, -122.400671627101) | |||
| 187494 | 187494 | 193667 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 83 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012303.144619999 | 2107108.6420299998 | 37.766411682968396 | -122.40068189197599 | (37.7664116829684, -122.400681891976) | |||
| 109754 | 109754 | 94085 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 821 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2010 12:00:00 AM | 3x3 | Permit Number 53470 | 5990693.0 | 2099046.0 | 37.743044824488294 | -122.47483809769 | (37.7430448244883, -122.47483809769) | ||
| 176713 | 176713 | 201327 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 82 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012589.87975 | 2092790.8830400002 | 37.727114169367496 | -122.39868524772301 | (37.7271141693675, -122.398685247723) | |||
| 31858 | 31858 | 210113 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 816 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5991488.40902 | 2102519.55417 | 37.7526283666271 | -122.47234097878 | (37.7526283666271, -122.47234097878) | |||
| 165049 | 165049 | 210114 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 816 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5991465.4029 | 2102517.37168 | 37.75262104254921 | -122.4724203781 | (37.7526210425492, -122.4724203781) | |||
| 141322 | 141322 | 1975 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 81 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017802.667442501 | 2094895.5028312001 | 37.73318209752429 | -122.38081075812201 | (37.7331820975243, -122.380810758122) | ||
| 126529 | 126529 | 33417 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 80 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37527 | 5993258.22068719 | 2093571.67048868 | 37.7281619993725 | -122.46557071609502 | (37.7281619993725, -122.465570716095) | ||
| 28707 | 28707 | 177564 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 791 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001913.98711 | 2089225.11823 | 37.7167227891097 | -122.435336672548 | (37.7167227891097, -122.435336672548) | |||
| 41221 | 41221 | 62602 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 790 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22910 | 5984500.58062 | 2110524.7697400004 | 37.774201531153004 | -122.49709658414 | (37.774201531153, -122.49709658414) | |
| 65625 | 65625 | 78240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348306999 | (37.7255059765042, -122.43764348307) | ||
| 64253 | 64253 | 34245 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 778 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 8 | Permit Number 38055 | 6011531.92576 | 2104772.40188 | 37.7599538473986 | -122.403185056849 | (37.7599538473986, -122.403185056849) | |
| 127051 | 127051 | 39709 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 777 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41094 | 5996960.75086515 | 2094978.12726071 | 37.7322366517745 | -122.452872476937 | (37.7322366517745, -122.452872476937) | ||
| 164673 | 164673 | 210131 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 777 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996965.97886 | 2094988.851 | 37.7322663961807 | -122.45285517641899 | (37.7322663961807, -122.452855176419) | |||
| 61683 | 61683 | 96073 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767699 | 5985419.194 | 2110615.45577 | 37.7745043190564 | -122.493925666827 | (37.7745043190564, -122.493925666827) |
| 163351 | 163351 | 78279 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.43752492633101 | (37.7257404495571, -122.437524926331) | ||
| 44015 | 44015 | 210198 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999468.97173 | 2093758.3784900003 | 37.729030921431296 | -122.444113405523 | (37.7290309214313, -122.444113405523) | |||
| 67573 | 67573 | 210176 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000817.03746 | 2095186.4221400002 | 37.7330288117357 | -122.43955538059299 | (37.7330288117357, -122.439555380593) | ||||
| 175713 | 175713 | 210175 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000806.93054 | 2095185.9336700002 | 37.7330268952766 | -122.439590287785 | (37.7330268952766, -122.439590287785) | ||||
| 176704 | 176704 | 210177 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000839.931480001 | 2095188.1820099999 | 37.733034946901704 | -122.43947635624399 | (37.7330349469017, -122.439476356244) | |||
| 57116 | 57116 | 201295 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012646.29133 | 2092949.9404099998 | 37.7275540511672 | -122.39850138853998 | (37.7275540511672, -122.39850138854) | |||
| 161488 | 161488 | 78242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 767 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 12 | 6001367.70534 | 2092560.86013 | 37.725850945661 | -122.437463630336 | (37.725850945661, -122.437463630336) | ||
| 44023 | 44023 | 232064 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 764 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 6ft | 6010114.571769999 | 2104714.08807 | 37.759714473963705 | -122.408082907717 | (37.7597144739637, -122.408082907717) | |||
| 51706 | 51706 | 177541 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998622.731430001 | 2087153.99485 | 37.7108484939443 | -122.446563943873 | (37.7108484939443, -122.446563943873) | |||
| 59779 | 59779 | 177544 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998663.80946 | 2087170.3503700001 | 37.7108957487982 | -122.44642314511299 | (37.7108957487982, -122.446423145113) | |||
| 76610 | 76610 | 177543 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998648.38585 | 2087164.77044 | 37.7108795466262 | -122.446476051329 | (37.7108795466262, -122.446476051329) | |||
| 146503 | 146503 | 177542 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998634.17055 | 2087157.9364900002 | 37.710859970193 | -122.446524691177 | (37.710859970193, -122.446524691177) | |||
| 179208 | 179208 | 177545 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998675.35081 | 2087179.2071099998 | 37.71092072659079 | -122.446383892402 | (37.7109207265908, -122.446383892402) | |||
| 103239 | 103239 | 461 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/19/2015 10:10:00 AM | 3 | 8x100 | 5988827.12869 | 2110042.5268099997 | 37.7731300209347 | -122.48209512132799 | (37.7731300209347, -122.482095121328) | ||
| 131764 | 131764 | 460 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5988827.36485 | 2110053.67584 | 37.773160646819 | -122.482095121354 | (37.773160646819, -122.482095121354) | ||||
| 84417 | 84417 | 37376 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 91068 | 91068 | 37374 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 93477 | 93477 | 37378 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 95427 | 95427 | 37372 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 106497 | 106497 | 37368 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 109826 | 109826 | 37384 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 110425 | 110425 | 37367 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 112545 | 112545 | 37370 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 115975 | 115975 | 37380 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 129265 | 129265 | 37382 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 143392 | 143392 | 37369 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 187906 | 187906 | 119504 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 751 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986297.2178 | 2110799.61932 | 37.7750613132821 | -122.490902009459 | (37.7750613132821, -122.490902009459) | |||
| 24742 | 24742 | 54473 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.352419999 | 2095372.33986 | 37.73418801985999 | -122.39975324750799 | (37.73418801986, -122.399753247508) | ||
| 142105 | 142105 | 1974 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 75 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017781.0101898 | 2094915.5294804 | 37.7332358914551 | -122.380887025623 | (37.7332358914551, -122.380887025623) | ||
| 40079 | 40079 | 232057 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 748 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008510.29634 | 2104174.17335 | 37.7581420363439 | -122.41359313304301 | (37.7581420363439, -122.413593133043) | |||
| 38344 | 38344 | 33199 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | ||
| 165139 | 165139 | 201526 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 740 Earl St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6020358.69967 | 2093703.87805 | 37.7300508614476 | -122.371891339508 | (37.7300508614476, -122.371891339508) | ||||
| 55854 | 55854 | 177563 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 738 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002044.3357 | 2089508.8562099999 | 37.7175092723187 | -122.434906402712 | (37.7175092723187, -122.434906402712) | |||
| 163809 | 163809 | 201655 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 734 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6020157.476530001 | 2093804.76916 | 37.7303168341394 | -122.372593981633 | (37.7303168341394, -122.372593981633) | |||
| 136716 | 136716 | 201296 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 73 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012672.41087 | 2092931.31723 | 37.7275043708095 | -122.398409786303 | (37.7275043708095, -122.398409786303) | |||
| 157379 | 157379 | 210172 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997380.854669999 | 2098266.60912 | 37.7412900955557 | -122.45165721743099 | (37.7412900955557, -122.451657217431) | |||
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 58862 | 58862 | 37345 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39853 | 5998100.18965 | 2086460.63765 | 37.7089148310191 | -122.448320064445 | (37.7089148310191, -122.448320064445) | |
| 151292 | 151292 | 201289 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 72 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012662.53869 | 2092985.79759 | 37.7276534127642 | -122.39844773586901 | (37.7276534127642, -122.398447735869) | |||
| 57379 | 57379 | 201326 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 72 Bitting Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012622.32492 | 2092766.85402 | 37.7270499982339 | -122.39857139896999 | (37.7270499982339, -122.39857139897) |
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");