Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4658 | 4658 | 176983 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | 5996974.67191 | 2087476.2225099998 | 37.711638981816 | -122.452283225586 | (37.711638981816, -122.452283225586) | |||
4683 | 4683 | 176984 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2923 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 3ft | 5996996.89662 | 2087496.1826099998 | 37.7116950608382 | -122.452207850721 | (37.7116950608382, -122.452207850721) | |||
8136 | 8136 | 2477 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.790123955413705 | -122.43124522668998 | (37.7901239554137, -122.43124522669) | |||
11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
11690 | 11690 | 1262 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | |||
12496 | 12496 | 24276 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 350X Winding Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.710003801206796 | -122.438925891137 | (37.7100038012068, -122.438925891137) | |||
17570 | 17570 | 1213 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3411 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5993897.04108 | 2087339.7447 | 37.711087454604204 | -122.46291036762199 | (37.7110874546042, -122.462910367622) | |||
18415 | 18415 | 13417 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 400 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 5 | 5999553.15658 | 2097034.9165400001 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | |||
21000 | 21000 | 29586 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 3X3 | 5991342.7865 | 2093687.81781 | 37.7283702470744 | -122.47220084100901 | (37.7283702470744, -122.472200841009) | |||
21489 | 21489 | 29601 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.090009999 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | ||
21749 | 21749 | 29627 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 12 | 3X3 | 5991152.87782 | 2090760.03066 | 37.7203202787275 | -122.472643981031 | (37.7203202787275, -122.472643981031) | ||
23148 | 23148 | 973 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | |||
24818 | 24818 | 191371 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 66 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.39963665401699 | (37.7547181653131, -122.399636654017) | ||||
27702 | 27702 | 191370 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 63 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012517.15762 | 2102887.31193 | 37.75483277672829 | -122.399645237162 | (37.7548327767283, -122.399645237162) | ||||
30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
38640 | 38640 | 191369 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | ||||
38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
79154 | 79154 | 976 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 6001942.44101 | 2093088.0021099998 | 37.7273310167784 | -122.43551450655701 | (37.7273310167784, -122.435514506557) | |||
79594 | 79594 | 12917 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
84781 | 84781 | 101254 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3700X Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005840.6 | 2100555.6 | 37.74805599841039 | -122.422568977073 | (37.7480559984104, -122.422568977073) | |||||
94398 | 94398 | 116654 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
95215 | 95215 | 116655 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
95391 | 95391 | 113478 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6006917.0 | 2098966.0 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | ||||
95944 | 95944 | 116681 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
98542 | 98542 | 12918 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
102052 | 102052 | 23670 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 317 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
105136 | 105136 | 18878 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6003659.521319999 | 2115878.15996 | 37.7900047293604 | -122.43120460047501 | (37.7900047293604, -122.431204600475) | |||
112441 | 112441 | 24808 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.49562310699899 | (37.7794670623637, -122.495623106999) | ||
117712 | 117712 | 26830 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3590X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 8 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
139249 | 139249 | 16565 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.716870613942795 | -122.443365227339 | (37.7168706139428, -122.443365227339) | |||
140815 | 140815 | 16566 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.716806377922104 | -122.44343023048201 | (37.7168063779221, -122.443430230482) | |||
142319 | 142319 | 24738 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5983089.132019999 | 2112566.68135 | 37.7797252106941 | -122.502130088809 | (37.7797252106941, -122.502130088809) | ||
143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) |
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");