Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
4895 | 4895 | 69228 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 537 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 12 | 7x7 | Permit Number 33281 | 6005209.5873 | 2111278.8914 | 37.7774639950364 | -122.425514041455 | (37.7774639950364, -122.425514041455) |
13611 | 13611 | 27142 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011388.172669999 | 2095338.5375299999 | 37.7340424699754 | -122.40301867507401 | (37.7340424699754, -122.403018675074) | |||
14097 | 14097 | 27140 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776002 | (37.7340894298873, -122.40294377776) | |||
16487 | 16487 | 32962 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 952 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 6x12 | Permit Number 37276 | 6015219.88415 | 2104168.1362900003 | 37.7584999350397 | -122.39038786691299 | (37.7584999350397, -122.390387866913) |
17784 | 17784 | 18386 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | ||
20704 | 20704 | 26501 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008910.69527 | 2102429.93481 | 37.7533752266066 | -122.41208510844801 | (37.7533752266066, -122.412085108448) | |||
21333 | 21333 | 28065 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2576 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2001 12:00:00 AM | 12 | 3X3 | 6009719.0461099995 | 2102350.04498 | 37.753201188885605 | -122.409284012572 | (37.7532011888856, -122.409284012572) | ||
23435 | 23435 | 226459 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3242 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007896.86765 | 2105631.29342 | 37.762108488128796 | -122.41581781745899 | (37.7621084881288, -122.415817817459) | |||
28716 | 28716 | 226385 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | |||
57800 | 57800 | 190715 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 350 Texas St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | |||
60833 | 60833 | 226797 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003894.50507 | 2104240.41525 | 37.7580636523416 | -122.429561252457 | (37.7580636523416, -122.429561252457) | |||
64595 | 64595 | 229736 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1446 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009548.10461 | 2100752.4115 | 37.748804863855604 | -122.409762403312 | (37.7488048638556, -122.409762403312) | |||
66402 | 66402 | 229837 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006672.14762 | 2104765.95957 | 37.759663556138 | -122.41999225186301 | (37.759663556138, -122.419992251863) | |||
69857 | 69857 | 226395 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | |||
70237 | 70237 | 32980 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.0613700002 | 37.7593873374867 | -122.39515493295201 | (37.7593873374867, -122.395154932952) | |
76883 | 76883 | 226323 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | |||
78165 | 78165 | 34059 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | 12 | 6x7 | Permit Number 37961 | 6009447.37701969 | 2106694.23265708 | 37.7651141201322 | -122.410530241296 | (37.7651141201322, -122.410530241296) | |
79747 | 79747 | 37675 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 12 | 3x3 | Permit Number 40071 | 6008076.0 | 2104474.0 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) |
120446 | 120446 | 229783 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 975 San Bruno Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6011090.02369 | 2103815.82999 | 37.7573026253193 | -122.404646049572 | (37.7573026253193, -122.404646049572) | |||
125800 | 125800 | 37663 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3236 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 12 | 6x6 | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.41579877386101 | (37.7621224556474, -122.415798773861) |
137114 | 137114 | 226401 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.74524623751729 | -122.414263403134 | (37.7452462375173, -122.414263403134) | |||
137527 | 137527 | 229876 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 231 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004828.77791 | 2100152.4422299997 | 37.746891885367 | -122.42603912601001 | (37.746891885367, -122.42603912601) | |||
137999 | 137999 | 226461 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2080 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008035.4164 | 2106222.9796700003 | 37.7637409096456 | -122.415380518518 | (37.7637409096456, -122.415380518518) | |||
153299 | 153299 | 229859 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 800 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010147.5039099995 | 2104457.87286 | 37.7590128085149 | -122.407950942988 | (37.7590128085149, -122.407950942988) | |||
157701 | 157701 | 35349 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1162 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 12 | Permit Number 38812 | 6012188.571690001 | 2103037.2823900003 | 37.7552262409021 | -122.400792120955 | (37.7552262409021, -122.400792120955) | |
165158 | 165158 | 226371 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 626 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002431.857369999 | 2098894.2222599997 | 37.743301348371794 | -122.43423751036 | (37.7433013483718, -122.43423751036) | |||
179360 | 179360 | 226405 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628924996 | -122.415012541103 | (37.746498628925, -122.415012541103) | |||
185078 | 185078 | 226762 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 62 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005544.98011 | 2099653.8434200003 | 37.745563298918704 | -122.42352711990101 | (37.7455632989187, -122.423527119901) | |||
186891 | 186891 | 226458 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008112.40239 | 2104471.67491 | 37.7589365568012 | -122.41499028288 | (37.7589365568012, -122.41499028288) |
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");