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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86391 | 86391 | 184203 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.75941282066329 | -122.500400782356 | (37.7594128206633, -122.500400782356) | |||
59935 | 59935 | 203290 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 11 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994415.40381 | 2090011.1413599998 | 37.7184523203103 | -122.46131232093201 | (37.7184523203103, -122.461312320932) | |||
55253 | 55253 | 203291 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 11 Jules Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994415.48252 | 2089998.39973 | 37.7184173393668 | -122.461311125716 | (37.7184173393668, -122.461311125716) | |||
45394 | 45394 | 203292 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 10 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994458.02189 | 2089982.3581700001 | 37.7183757412389 | -122.461162923744 | (37.7183757412389, -122.461162923744) | |||
179284 | 179284 | 221563 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.752703058000705 | -122.438378727412 | (37.7527030580007, -122.438378727412) | |||
179875 | 179875 | 221564 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001316.917769999 | 2102341.7359599997 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | |||
158034 | 158034 | 221565 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001328.916669999 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | |||
55535 | 55535 | 221566 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.8820400005 | 2102344.46852 | 37.7527130350975 | -122.43825001643299 | (37.7527130350975, -122.438250016433) | |||
184620 | 184620 | 221570 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.768688901296294 | -122.437411868978 | (37.7686889012963, -122.437411868978) | |||
41267 | 41267 | 221568 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | |||
51201 | 51201 | 221569 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | |||
155244 | 155244 | 221567 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | |||
29150 | 29150 | 221508 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004291.813569999 | 2095940.5809 | 37.73529671397821 | -122.427595874056 | (37.7352967139782, -122.427595874056) | ||||
46563 | 46563 | 221509 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004439.440880001 | 2096038.0117799998 | 37.735572586401894 | -122.42709240931102 | (37.7355725864019, -122.427092409311) | ||||
44105 | 44105 | 221562 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.28805 | 2102498.9287799997 | 37.753410020459995 | -122.421598049829 | (37.75341002046, -122.421598049829) | |||
71884 | 71884 | 221560 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898001 | (37.7534669142699, -122.42159904898) | |||
148793 | 148793 | 221561 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | |||
10086 | 10086 | 88538 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1306 York St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
155379 | 155379 | 221559 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1306 York St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010039.89073 | 2101557.1439900002 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | |||
136012 | 136012 | 187785 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1740 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.39891512883499 | (37.7599511143744, -122.398915128835) | |||
67739 | 67739 | 187784 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014258.31464 | 2106694.98019 | 37.765384711161104 | -122.393890307196 | (37.7653847111611, -122.393890307196) | ||||
76798 | 76798 | 187783 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014314.48936 | 2106550.7653 | 37.764991850418895 | -122.393685915597 | (37.7649918504189, -122.393685915597) | ||||
181350 | 181350 | 187782 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319857995 | -122.39363958970199 | (37.764680319858, -122.393639589702) | ||||
47711 | 47711 | 187781 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | ||||
116885 | 116885 | 96193 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.39039765239299 | (37.7395111076977, -122.390397652393) | |||
161335 | 161335 | 201715 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6015296.606380001 | 2088393.85947 | 37.715191240972 | -122.38902117888901 | (37.715191240972, -122.389021178889) | |||
33280 | 33280 | 201714 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.715111861390795 | -122.388945312084 | (37.7151118613908, -122.388945312084) | |||
39265 | 39265 | 201713 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015343.41284 | 2088314.94317 | 37.7149771465452 | -122.38885388790001 | (37.7149771465452, -122.3888538879) | |||
179218 | 179218 | 201712 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015351.33364 | 2088303.0821 | 37.7149450173645 | -122.388825682463 | (37.7149450173645, -122.388825682463) | |||
30241 | 30241 | 201711 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015357.64919 | 2088292.5533900002 | 37.714916457608204 | -122.388803118478 | (37.7149164576082, -122.388803118478) | |||
59268 | 59268 | 187787 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1650 Galvez Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6015518.873319999 | 2097965.1979799997 | 37.7414845469671 | -122.388920758811 | (37.7414845469671, -122.388920758811) | ||||
54543 | 54543 | 187786 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1650 Galvez Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6015560.61147 | 2097934.79581 | 37.7414033822515 | -122.388774319486 | (37.7414033822515, -122.388774319486) |
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");