Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
78383 | 78383 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5996066.0 | 2095432.0 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | |||
78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
79771 | 79771 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 595X San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006124.4715599995 | 2100100.1430599997 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | |||||
80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | |||||
85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
102846 | 102846 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
103243 | 103243 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
105103 | 105103 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
105444 | 105444 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
107871 | 107871 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
118749 | 118749 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
138465 | 138465 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 Fairfax Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||||
154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) |
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");