Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
37928 | 37928 | 245555 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 939 Valencia St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6006339.61299 | 2104100.8799799997 | 37.7578186617191 | -122.421095101275 | (37.7578186617191, -122.421095101275) | |||
38856 | 38856 | 245670 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 7 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6005859.67566 | 2099629.8615 | 37.745515207653604 | -122.422437245889 | (37.7455152076536, -122.422437245889) | |||
40909 | 40909 | 175907 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6012827.98154 | 2086955.6822799998 | 37.7111051415626 | -122.39745307312401 | (37.7111051415626, -122.397453073124) | |||
40958 | 40958 | 245580 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1481 Noe St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003338.08753 | 2099620.14855 | 37.745345967858206 | -122.43115580621901 | (37.7453459678582, -122.431155806219) | |||
48480 | 48480 | 245660 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2758 Harrison St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6008913.58885 | 2102381.9168599998 | 37.753243542460105 | -122.41207170856501 | (37.7532435424601, -122.412071708565) | |||
48923 | 48923 | 245554 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 939 Valencia St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6006339.99922 | 2104098.0841099997 | 37.757811006682296 | -122.421093567011 | (37.7578110066823, -122.421093567011) | |||
50860 | 50860 | 245727 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 20 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002249.128 | 2105868.24313 | 37.7624399737353 | -122.43536810295299 | (37.7624399737353, -122.435368102953) | |||
52034 | 52034 | 182133 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1434 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5988383.962 | 2105543.0196 | 37.760749825160204 | -122.48329818067499 | (37.7607498251602, -122.483298180675) | |||
57369 | 57369 | 245657 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3028 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009300.2906599995 | 2101614.27208 | 37.7511574507759 | -122.410680202833 | (37.7511574507759, -122.410680202833) | |||
61589 | 61589 | 189295 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6012074.255340001 | 2105313.32081 | 37.7614693633429 | -122.401347403775 | (37.7614693633429, -122.401347403775) | |||
66418 | 66418 | 245557 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 939 Valencia St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6006339.4561 | 2104107.6647200002 | 37.7578372821949 | -122.421096125609 | (37.7578372821949, -122.421096125609) | |||
66830 | 66830 | 245661 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2758 Harrison St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6008913.41852 | 2102400.6628799997 | 37.753295005261705 | -122.412073622309 | (37.7532950052617, -122.412073622309) | |||
68499 | 68499 | 175876 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998776.13579 | 2086731.33993 | 37.709696740283604 | -122.446003364979 | (37.7096967402836, -122.446003364979) | ||||
72451 | 72451 | 245556 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 939 Valencia St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 6006339.41374 | 2104105.6014900003 | 37.7578316146567 | -122.421096125611 | (37.7578316146567, -122.421096125611) | |||
76084 | 76084 | 245577 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 29 | 6002723.765319999 | 2099062.4015200003 | 37.743779693292204 | -122.43324018380301 | (37.7437796932922, -122.433240183803) | ||||
97394 | 97394 | 58598 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||
117658 | 117658 | 245543 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 569 Peralta Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6009858.44464 | 2098854.68351 | 37.7436115056701 | -122.408555393522 | (37.7436115056701, -122.408555393522) | |||
129253 | 129253 | 111768 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||||
132646 | 132646 | 245569 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 661 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 5ft | 6002237.36498 | 2100017.36446 | 37.7463741924229 | -122.434990322071 | (37.7463741924229, -122.434990322071) | |||
133336 | 133336 | 245547 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2104 Folsom St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008076.4108 | 2106131.7088200003 | 37.763492605016204 | -122.415232269774 | (37.7634926050162, -122.415232269774) | |||
135146 | 135146 | 175875 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998788.01102 | 2086736.62559 | 37.709711931626394 | -122.445962702139 | (37.7097119316264, -122.445962702139) | ||||
147844 | 147844 | 245644 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3389 22nd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 3ft | 6005789.06956 | 2103129.90059 | 37.7551215274464 | -122.42293010315001 | (37.7551215274464, -122.42293010315) | |||
150975 | 150975 | 245724 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002238.95199 | 2105860.0462 | 37.7624168890453 | -122.435402711587 | (37.7624168890453, -122.435402711587) | |||
154239 | 154239 | 245579 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 10ft | 6002722.739709999 | 2099078.10781 | 37.743822760922 | -122.43324485216101 | (37.743822760922, -122.433244852161) | |||
162817 | 162817 | 245711 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 707 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6002439.56956 | 2104058.13279 | 37.7574806614195 | -122.43458000188801 | (37.7574806614195, -122.434580001888) | |||
164773 | 164773 | 245505 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1529 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6005301.27188 | 2099453.26683 | 37.744998802543705 | -122.424355562768 | (37.7449988025437, -122.424355562768) | |||
169393 | 169393 | 245726 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 19 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002246.8756800005 | 2105865.17588 | 37.762431423900296 | -122.435375673468 | (37.7624314239003, -122.435375673468) | |||
169416 | 169416 | 183302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4500 Irving St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5981770.8567 | 2106269.7 | 37.7623579967214 | -122.506223442565 | (37.7623579967214, -122.506223442565) | |||
172985 | 172985 | 245575 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | 6002723.45066 | 2099047.1713 | 37.7437378568072 | -122.43324018378901 | (37.7437378568072, -122.433240183789) | ||||
173823 | 173823 | 245656 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3028 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009308.84232 | 2101614.09746 | 37.7511574507702 | -122.410650617835 | (37.7511574507702, -122.410650617835) | |||
174400 | 174400 | 245728 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 21 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002221.89305 | 2105851.67983 | 37.7623929481978 | -122.43546111354799 | (37.7623929481978, -122.435461113548) | |||
175275 | 175275 | 182213 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2730 Lawton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5985735.4613 | 2104364.4813 | 37.75735939305871 | -122.492371241702 | (37.7573593930587, -122.492371241702) | |||
175945 | 175945 | 246749 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 178 Ripley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6009160.6356 | 2099093.6334599997 | 37.74422850445271 | -122.41098512967301 | (37.7442285044527, -122.410985129673) | |||
181351 | 181351 | 245725 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 18 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002243.08627 | 2105863.38602 | 37.7624262941732 | -122.43538865158001 | (37.7624262941732, -122.43538865158) | |||
181548 | 181548 | 245671 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 7 28th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6005840.27881 | 2099627.45735 | 37.745507512170704 | -122.422504146459 | (37.7455075121707, -122.422504146459) | |||
186209 | 186209 | 245576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002722.8359199995 | 2099050.09706 | 37.7437458553887 | -122.433242518424 | (37.7437458553887, -122.433242518424) | ||||
187674 | 187674 | 245578 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6002722.030809999 | 2099065.57444 | 37.7437883069939 | -122.433246407993 | (37.7437883069939, -122.433246407993) | ||||
187929 | 187929 | 245723 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002221.88018 | 2105851.05746 | 37.762391238590205 | -122.435461113537 | (37.7623912385902, -122.435461113537) |
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");