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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
13899 | 13899 | 16527 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016370.17243 | 2098292.39049 | 37.7424301004582 | -122.386000034169 | (37.7424301004582, -122.386000034169) | |||
13990 | 13990 | 16545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.38703865582701 | (37.7415453861211, -122.387038655827) | ||
14034 | 14034 | 78331 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014103.033559999 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | |
14293 | 14293 | 17415 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.73659758599771 | -122.395366549732 | (37.7365975859977, -122.395366549732) | |||
15529 | 15529 | 78325 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014082.074630001 | 2094268.0058099998 | 37.731253074258596 | -122.393630047885 | (37.7312530742586, -122.393630047885) | |
16099 | 16099 | 16541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | |||
16103 | 16103 | 17387 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6014551.02447 | 2095461.0111900002 | 37.7345548713079 | -122.39209219010901 | (37.7345548713079, -122.392092190109) | |||
19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
79625 | 79625 | 14913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | |||
81285 | 81285 | 16511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016438.273030001 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | |||
82455 | 82455 | 14908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
83106 | 83106 | 16498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016898.459480001 | 2098256.16023 | 37.7423598423185 | -122.38417083560499 | (37.7423598423185, -122.384170835605) | |||
87292 | 87292 | 16507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016604.68474 | 2098314.9336900003 | 37.7425049753024 | -122.385190723599 | (37.7425049753024, -122.385190723599) | |||
88469 | 88469 | 96756 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | |||
89283 | 89283 | 16514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016343.322430001 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | |||
92651 | 92651 | 6652 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
93430 | 93430 | 14909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | |||
94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
94704 | 94704 | 94894 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
97633 | 97633 | 16512 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772611999 | (37.7426746595649, -122.38584772612) | |||
98540 | 98540 | 16491 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016683.0708800005 | 2098298.50072 | 37.7424641896573 | -122.384918540359 | (37.7424641896573, -122.384918540359) | |||
102458 | 102458 | 22886 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
103848 | 103848 | 14914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.742305197314295 | -122.383103612647 | (37.7423051973143, -122.383103612647) | |||
104168 | 104168 | 94893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
107427 | 107427 | 6650 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
109213 | 109213 | 18922 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2620 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002038.8 | 2115762.8 | 37.7895960030005 | -122.436803887406 | (37.7895960030005, -122.436803887406) | |||
110305 | 110305 | 6648 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
112145 | 112145 | 6850 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | ||
112741 | 112741 | 16513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.742663293572505 | -122.38588614932699 | (37.7426632935725, -122.385886149327) | |||
113999 | 113999 | 14911 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | |||
114992 | 114992 | 116858 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002788.0 | 2107242.0 | 37.7662425648461 | -122.43360252819201 | (37.7662425648461, -122.433602528192) | |||
116782 | 116782 | 4389 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | ||
119053 | 119053 | 6649 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
119228 | 119228 | 94892 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
119784 | 119784 | 16497 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | |||
120157 | 120157 | 17414 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.39520830982599 | (37.7365002389252, -122.395208309826) | |||
120176 | 120176 | 6646 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
122698 | 122698 | 16510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
123471 | 123471 | 6651 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
124746 | 124746 | 14912 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017247.980359999 | 2098210.14599 | 37.742252815079496 | -122.38295908456999 | (37.7422528150795, -122.38295908457) | |||
138765 | 138765 | 16490 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | |||
140383 | 140383 | 16554 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
142096 | 142096 | 10409 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5999436.0 | 2108778.0 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | |||
145790 | 145790 | 14915 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.742321829008496 | -122.383156775767 | (37.7423218290085, -122.383156775767) |
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");