Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
25032 | 25032 | 189928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.79149401858479 | -122.397829357532 | (37.7914940185848, -122.397829357532) | |||
25691 | 25691 | 140580 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.778294566327205 | -122.43178620552 | (37.7782945663272, -122.43178620552) | |||
28725 | 28725 | 125974 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007013.058230001 | 2121870.81717 | 37.806648529474295 | -122.42002707360399 | (37.8066485294743, -122.420027073604) | |||
28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
31280 | 31280 | 189919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013770.13743 | 2116011.13859 | 37.7909376251249 | -122.396231800058 | (37.7909376251249, -122.396231800058) | |||
35702 | 35702 | 189866 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | |||
38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
42030 | 42030 | 206000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997987.32263 | 2094070.28162 | 37.729802697139604 | -122.44925801953801 | (37.7298026971396, -122.449258019538) | ||||
43855 | 43855 | 206018 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | |||
43924 | 43924 | 225098 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6004313.032319999 | 2109116.83696 | 37.7714768248189 | -122.42846137891199 | (37.7714768248189, -122.428461378912) | |||
44243 | 44243 | 189896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.38492142508899 | (37.7426025436648, -122.384921425089) | |||
46321 | 46321 | 115844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | |||
47133 | 47133 | 138241 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.784847050450104 | -122.444961483404 | (37.7848470504501, -122.444961483404) | |||
54211 | 54211 | 188484 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016633.990259999 | 2098788.07165 | 37.743805736753394 | -122.38512235163 | (37.7438057367534, -122.38512235163) | |||
56567 | 56567 | 139360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000048.0331 | 2114373.2711 | 37.7856673759403 | -122.443591852007 | (37.7856673759403, -122.443591852007) | |||
57071 | 57071 | 205997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998801.07075 | 2096511.7970599998 | 37.736553033585295 | -122.446620405109 | (37.7365530335853, -122.446620405109) | |||
58573 | 58573 | 189943 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014663.902869999 | 2116268.03372 | 37.7916926905231 | -122.39315736781299 | (37.7916926905231, -122.393157367813) | |||
63520 | 63520 | 200192 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | |||
65825 | 65825 | 205992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993371.398019999 | 2093686.3141400001 | 37.728483309840996 | -122.46518778469299 | (37.728483309841, -122.465187784693) | |||
65891 | 65891 | 189889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.38428398832501 | (37.7425183122785, -122.384283988325) | |||
69557 | 69557 | 205989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.46305702188499 | (37.744370734026, -122.463057021885) | |||
74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
86488 | 86488 | 103341 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
104253 | 104253 | 111888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | ||||
109098 | 109098 | 97181 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
119094 | 119094 | 119743 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
119633 | 119633 | 103345 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 29899 | 6010491.0 | 2108479.0 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | ||
130575 | 130575 | 189868 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.38684957154899 | (37.7415077207098, -122.386849571549) | |||
136895 | 136895 | 225067 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009115.2795 | 2103823.2478099996 | 37.7572124269416 | -122.41147603989401 | (37.7572124269416, -122.411476039894) | |||
136904 | 136904 | 125982 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | |||
152156 | 152156 | 140023 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.42461301693301 | (37.7794631941198, -122.424613016933) | |||
155880 | 155880 | 189903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6016414.85135 | 2098379.02943 | 37.742670465863796 | -122.38585158400801 | (37.7426704658638, -122.385851584008) | |||
166023 | 166023 | 222906 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791001 | (37.7734445081828, -122.42695971791) | |||
167856 | 167856 | 189934 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.791446374309395 | -122.398104485334 | (37.7914463743094, -122.398104485334) | |||
168072 | 168072 | 115848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.43180918435499 | (37.8035189184231, -122.431809184355) | |||
169791 | 169791 | 125979 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.80574229793179 | -122.41523987893999 | (37.8057422979318, -122.41523987894) | |||
172191 | 172191 | 206010 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.47400476141199 | (37.7394635005399, -122.474004761412) | |||
173011 | 173011 | 189946 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 6014709.0415900005 | 2116225.6637 | 37.7915788597386 | -122.39299822110901 | (37.7915788597386, -122.392998221109) | |||
180722 | 180722 | 125998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | |||
181190 | 181190 | 189878 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.742556117060104 | -122.38564105721399 | (37.7425561170601, -122.385641057214) | |||
183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
185704 | 185704 | 188476 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6010896.57818 | 2106030.2080599996 | 37.763371997828706 | -122.405471012994 | (37.7633719978287, -122.405471012994) | |||
188870 | 188870 | 189960 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010412.08756 | 2108524.3089900003 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) |
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");