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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4762 | 4762 | 188472 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.41585412666099 | (37.7713614445082, -122.415854126661) | |||
4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
4779 | 4779 | 188471 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.41550157982799 | (37.7711845613454, -122.415501579828) | |||
4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
4806 | 4806 | 188473 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.771378132318894 | -122.415898458759 | (37.7713781323189, -122.415898458759) | |||
4810 | 4810 | 188468 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | |||
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) | |||
4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
23796 | 23796 | 189939 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013302.110780001 | 2116136.01551 | 37.7912544544909 | -122.397859927289 | (37.7912544544909, -122.397859927289) | |||
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) | |||
24544 | 24544 | 189940 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013316.29733 | 2116121.5529099996 | 37.791215533629 | -122.39780982696001 | (37.791215533629, -122.39780982696) | |||
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) | |||
30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
32837 | 32837 | 189922 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013429.98555 | 2116100.18474 | 37.791163192164 | -122.39741496705099 | (37.791163192164, -122.397414967051) | |||
36711 | 36711 | 189929 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013297.80377 | 2116238.25932 | 37.79153495213429 | -122.39788200474399 | (37.7915349521343, -122.397882004744) | |||
37108 | 37108 | 225085 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.42850855554701 | (37.7505398125629, -122.428508555547) | |||
41181 | 41181 | 189938 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013289.37156 | 2116149.2267400003 | 37.7912900199673 | -122.39790493209101 | (37.7912900199673, -122.397904932091) | |||
42255 | 42255 | 189935 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | |||
42568 | 42568 | 189927 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013321.30985 | 2116211.3881900003 | 37.7914624793694 | -122.39779878780001 | (37.7914624793694, -122.3977987878) | |||
47121 | 47121 | 189917 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6013829.87851 | 2116068.4816 | 37.791098399616104 | -122.39602911715299 | (37.7910983996161, -122.396029117153) | |||
52899 | 52899 | 189933 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.791519517964396 | -122.398191948892 | (37.7915195179644, -122.398191948892) | |||
64996 | 64996 | 189923 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013419.15414 | 2116110.6688599996 | 37.7911913760301 | -122.397453179235 | (37.7911913760301, -122.397453179235) | |||
73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
74030 | 74030 | 189936 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013261.48411 | 2116177.8977900003 | 37.7913671907995 | -122.398003434816 | (37.7913671907995, -122.398003434816) | |||
132027 | 132027 | 189931 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | |||
134675 | 134675 | 189932 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013255.6952599995 | 2116279.68267 | 37.791646345764796 | -122.398030607826 | (37.7916463457648, -122.398030607826) | |||
136532 | 136532 | 125983 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | |||
147048 | 147048 | 189921 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013437.412219999 | 2116091.23603 | 37.791139034597705 | -122.397388642991 | (37.7911390345977, -122.397388642991) | |||
148488 | 148488 | 189918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013810.73123 | 2116050.81938 | 37.7910488379738 | -122.396094128247 | (37.7910488379738, -122.396094128247) | |||
155986 | 155986 | 189924 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013405.38871 | 2116121.70148 | 37.7912209025705 | -122.39750158162799 | (37.7912209025705, -122.397501581628) | |||
163848 | 163848 | 189937 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013275.69539 | 2116164.65668 | 37.7913316253015 | -122.397953334494 | (37.7913316253015, -122.397953334494) | |||
167348 | 167348 | 225101 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.42246724636601 | (37.7721720124675, -122.422467246366) | |||
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) | |||
170578 | 170578 | 189925 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013397.06496 | 2116134.8231200003 | 37.7912564680486 | -122.397531302439 | (37.7912564680486, -122.397531302439) | |||
174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
178093 | 178093 | 189926 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013338.6063 | 2116192.95214 | 37.7914128215027 | -122.39773764826799 | (37.7914128215027, -122.397737648268) | |||
180285 | 180285 | 189941 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013331.4553 | 2116106.58194 | 37.7911752709767 | -122.39775632990299 | (37.7911752709767, -122.397756329903) | |||
180519 | 180519 | 225100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | |||
180715 | 180715 | 189930 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013282.15015 | 2116252.99602 | 37.7915745438725 | -122.39793720064199 | (37.7915745438725, -122.397937200642) |
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");