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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27292 | 27292 | 250990 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.57195 | 2112909.00953 | 37.7805965385427 | -122.50619104959299 | (37.7805965385427, -122.506191049593) | |||
30918 | 30918 | 117725 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 849 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5983504.07439 | 2113100.0545900003 | 37.7812140668155 | -122.500734098102 | (37.7812140668155, -122.500734098102) | |||
40578 | 40578 | 210099 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 700 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991230.12075 | 2092291.98484 | 37.72453111681111 | -122.47248860785601 | (37.7245311168111, -122.472488607856) | |||
53662 | 53662 | 210096 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Junipero Serra Blvd | 45 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991386.500659999 | 2094355.8588400001 | 37.73020705030461 | -122.47209839385201 | (37.7302070503046, -122.472098393852) | |||
56108 | 56108 | 183035 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 2522 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981504.4178 | 2097898.5163 | 37.7393573965741 | -122.506524088332 | (37.7393573965741, -122.506524088332) | |||
56979 | 56979 | 193543 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 610 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016026.74063 | 2103985.73325 | 37.7580438195766 | -122.38758464502399 | (37.7580438195766, -122.387584645024) | |||
57844 | 57844 | 72845 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 2625 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 10 | 5989234.0157 | 2097465.6374 | 37.7386209048407 | -122.479767197253 | (37.7386209048407, -122.479767197253) | ||
58602 | 58602 | 210092 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 261 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995627.09016 | 2091704.91878 | 37.72317269265079 | -122.457246512943 | (37.7231726926508, -122.457246512943) | |||
59532 | 59532 | 250982 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 145 Seal Rock Dr | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5981196.97714 | 2112934.78303 | 37.7806245632172 | -122.50870309708901 | (37.7806245632172, -122.508703097089) | |||
60700 | 60700 | 183354 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3544 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5982117.2654 | 2100157.6466 | 37.7455964086946 | -122.504572502943 | (37.7455964086946, -122.504572502943) | |||
61265 | 61265 | 184530 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 4045 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981394.5999 | 2102116.7749 | 37.7509330899515 | -122.50721664272801 | (37.7509330899515, -122.507216642728) | |||
71166 | 71166 | 232033 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003277.43124 | 2096153.4098099999 | 37.7358236645184 | -122.431118151596 | (37.7358236645184, -122.431118151596) | |||
71380 | 71380 | 141700 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 150 BEAUMONT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996841.3555 | 2111986.1699 | 37.778929621332004 | -122.454513467721 | (37.778929621332, -122.454513467721) | |||
73512 | 73512 | 122029 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 791 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990357.66226 | 2109998.66338 | 37.773098484036495 | -122.47679765911 | (37.7730984840365, -122.47679765911) | |||
75400 | 75400 | 210098 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 400 Junipero Serra Blvd | 18 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5991367.910130001 | 2094058.78209 | 37.72939027613779 | -122.47214101722099 | (37.7293902761378, -122.472141017221) | |||
128271 | 128271 | 119904 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003302.0 | 2096146.0 | 37.7358047110715 | -122.43103267909099 | (37.7358047110715, -122.431032679091) | ||||
133721 | 133721 | 119151 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 751 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5981332.09183 | 2110596.93925 | 37.774213497724396 | -122.50806211670799 | (37.7742134977244, -122.508062116708) | |||
137755 | 137755 | 183353 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3542 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982133.0347 | 2100158.2902 | 37.7455991034071 | -122.504518023708 | (37.7455991034071, -122.504518023708) | |||
150340 | 150340 | 250991 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.93947 | 2112926.15087 | 37.7806436252297 | -122.506191049582 | (37.7806436252297, -122.506191049582) | |||
153451 | 153451 | 139625 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 1761 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001622.1557 | 2112159.8649 | 37.779679575976 | -122.437987249049 | (37.779679575976, -122.437987249049) | |||
154502 | 154502 | 184532 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 4041 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981429.119 | 2102119.1438 | 37.7509416273735 | -122.507097450181 | (37.7509416273735, -122.507097450181) | |||
157211 | 157211 | 183355 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3546 Rivera St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982088.9451 | 2100155.7156 | 37.74558944081421 | -122.504670285508 | (37.7455894408142, -122.504670285508) | |||
159177 | 159177 | 232034 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 5 Clarendon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5998231.75186 | 2104660.34285 | 37.758894411852204 | -122.449175639859 | (37.7588944118522, -122.449175639859) | |||
159623 | 159623 | 210100 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 700 Junipero Serra Blvd | 125 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991216.87042 | 2091758.40738 | 37.7230652785221 | -122.472495529943 | (37.7230652785221, -122.472495529943) | |||
179294 | 179294 | 218220 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5993448.22771 | 2098043.70132 | 37.7404520434185 | -122.46523855682301 | (37.7404520434185, -122.465238556823) | |||
180522 | 180522 | 250985 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 169 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5981053.81587 | 2112927.8042099997 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | |||
182701 | 182701 | 210097 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991383.70914 | 2094347.6763 | 37.7301844215576 | -122.47210744821699 | (37.7301844215576, -122.472107448217) | |||
186695 | 186695 | 193542 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 610 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016043.65792 | 2103986.82395 | 37.7580477514291 | -122.387526213378 | (37.7580477514291, -122.387526213378) | |||
5374 | 5374 | 120897 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3760 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2016 12:00:00 AM | 3 | 2x5 | Permit Number 778876 | 6002560.418 | 2121574.39052 | 37.805582749215105 | -122.43541504397301 | (37.8055827492151, -122.435415043973) |
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");