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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25432 | 25432 | 220094 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 436 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003910.2005900005 | 2096060.2503799999 | 37.735603706528394 | -122.42892377971 | (37.7356037065284, -122.42892377971) | |||
25732 | 25732 | 220090 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000882.83826 | 2105748.10477 | 37.7620324153945 | -122.44008496885401 | (37.7620324153945, -122.440084968854) | |||
30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
32463 | 32463 | 174965 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1645 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006090.3331 | 2092391.29935 | 37.725652733270294 | -122.42112577893101 | (37.7256527332703, -122.421125778931) | |||
34367 | 34367 | 220083 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4133 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002828.79114 | 2104135.9049299997 | 37.7577162927799 | -122.43323947601401 | (37.7577162927799, -122.433239476014) | |||
35471 | 35471 | 140101 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999584.517999999 | 2111094.1746 | 37.7766373769699 | -122.44495966716002 | (37.7766373769699, -122.44495966716) | |||
38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
41668 | 41668 | 203664 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999403.203369999 | 2093610.5277599997 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | |||
45041 | 45041 | 188518 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | |||
50333 | 50333 | 220053 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006880.915569999 | 2099461.25928 | 37.7451098211639 | -122.418893994368 | (37.7451098211639, -122.418893994368) | |||
54206 | 54206 | 220691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 455 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002941.274019999 | 2099459.3166400003 | 37.7448818664203 | -122.432516435499 | (37.7448818664203, -122.432516435499) | |||
60228 | 60228 | 245868 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.775131757595204 | -122.42608767011801 | (37.7751317575952, -122.426087670118) | |||
62851 | 62851 | 203648 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | |||
63850 | 63850 | 138348 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646001 | (37.786350268304, -122.43818965646) | |||
65658 | 65658 | 183506 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | |||
75192 | 75192 | 220070 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296795996 | -122.43079674288 | (37.762366296796, -122.43079674288) | |||
76144 | 76144 | 220025 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6002149.21455 | 2101175.68513 | 37.7495496617103 | -122.435377979316 | (37.7495496617103, -122.435377979316) | |||
76199 | 76199 | 220046 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 170 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997546.7288 | 2104141.22433 | 37.7574298380281 | -122.451507313917 | (37.7574298380281, -122.451507313917) | |||
130058 | 130058 | 220684 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004755.351530001 | 2110353.8827 | 37.7748984718146 | -122.427019494961 | (37.7748984718146, -122.427019494961) | |||
147911 | 147911 | 220060 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.751969847944295 | -122.42195066499599 | (37.7519698479443, -122.421950664996) | |||
149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
151048 | 151048 | 220044 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002160.56118 | 2096968.3315700002 | 37.7379978987733 | -122.43503787010201 | (37.7379978987733, -122.435037870102) | |||
155839 | 155839 | 220013 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005865.660759999 | 2102301.94093 | 37.7528524632741 | -122.42260639578998 | (37.7528524632741, -122.42260639579) | |||
156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
157166 | 157166 | 220088 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 18 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001975.9163 | 2107746.07495 | 37.767580520153 | -122.43644744680701 | (37.767580520153, -122.436447446807) | |||
159913 | 159913 | 138338 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | |||
160495 | 160495 | 124753 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2109 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999833.99614 | 2116225.74938 | 37.79074158819461 | -122.444465538654 | (37.7907415881946, -122.444465538654) | |||
169675 | 169675 | 203643 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.47245922253201 | (37.7417056300124, -122.472459222532) | |||
176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
176834 | 176834 | 220059 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.75197131922489 | -122.42173470182101 | (37.7519713192249, -122.421734701821) | |||
177028 | 177028 | 220692 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.986740001 | 2100702.91409 | 37.7483660981244 | -122.42835639293999 | (37.7483660981244, -122.42835639294) | |||
179698 | 179698 | 218406 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5994236.919980001 | 2100511.7669599997 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | |||
180724 | 180724 | 220669 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007464.462180001 | 2105680.20341 | 37.7622184653282 | -122.41731681192199 | (37.7622184653282, -122.417316811922) | |||
183618 | 183618 | 220682 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009643.101369999 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | |||
185361 | 185361 | 220004 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1142 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008637.13035 | 2101883.29537 | 37.751858924657796 | -122.412992509104 | (37.7518589246578, -122.412992509104) | |||
186671 | 186671 | 73754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.40968430266199 | (37.8025101678048, -122.409684302662) |
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");