Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14258 | 14258 | 100759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 362 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014440.04423 | 2112282.11717 | 37.780735840838396 | -122.39365282322201 | (37.7807358408384, -122.393652823222) | |||
28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
31564 | 31564 | 242341 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1867 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004609.18081 | 2097837.81117 | 37.7405240251544 | -122.426633675907 | (37.7405240251544, -122.426633675907) | |||
33462 | 33462 | 68846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 731 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | 9 | Permit Number 32807 | 5982263.55129 | 2110779.79011 | 37.774770393997706 | -122.50485363813101 | (37.7747703939977, -122.504853638131) | ||
36218 | 36218 | 31084 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1397 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34820 | 6006995.97256 | 2107440.57968 | 37.7670256771058 | -122.419062011995 | (37.7670256771058, -122.419062011995) | |
39438 | 39438 | 180429 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 220 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000152.41454 | 2091672.2540900002 | 37.723341869512204 | -122.441601052259 | (37.7233418695122, -122.441601052259) | |||
39912 | 39912 | 68348 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 518 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32167 | 5990339.7966 | 2111825.86021 | 37.7781144278241 | -122.476992997759 | (37.7781144278241, -122.476992997759) | |
54781 | 54781 | 6305 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.781580315205396 | -122.434887466275 | (37.7815803152054, -122.434887466275) | ||
62144 | 62144 | 180456 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008358.46394 | 2092021.93043 | 37.7247661267393 | -122.41325889728998 | (37.7247661267393, -122.41325889729) | |||
64622 | 64622 | 198302 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011892.6623 | 2093405.69149 | 37.7287634360827 | -122.40113871700301 | (37.7287634360827, -122.401138717003) | |||
67459 | 67459 | 219423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992070.57915 | 2106257.11168 | 37.7629243953779 | -122.470599950627 | (37.7629243953779, -122.470599950627) | |||
76791 | 76791 | 180463 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008211.686319999 | 2092495.1796099998 | 37.7260573265766 | -122.41379975137698 | (37.7260573265766, -122.413799751377) | |||
82751 | 82751 | 34551 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | 9 | 3x2 | Permit Number 778622 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) |
113312 | 113312 | 26041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5996239.04821 | 2088090.4012099998 | 37.7132832040965 | -122.454870071763 | (37.7132832040965, -122.454870071763) | ||
129794 | 129794 | 123883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992072.431890001 | 2114857.09467 | 37.7865377268901 | -122.471220147048 | (37.7865377268901, -122.471220147048) | |||
130049 | 130049 | 218781 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1436 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5991498.75753 | 2105657.77331 | 37.7612456893572 | -122.472533966988 | (37.7612456893572, -122.472533966988) | |||
130307 | 130307 | 36947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 121 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | 6x9 | Permit Number 39582 | 5994567.08556 | 2114703.52353 | 37.78626004419979 | -122.46257818064801 | (37.7862600441998, -122.462578180648) | |
133964 | 133964 | 114471 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2351 Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009306.05236 | 2121599.3882299997 | 37.806032175519 | -122.41207250624599 | (37.806032175519, -122.412072506246) | |||
148742 | 148742 | 242886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 435 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007448.19697 | 2107143.49662 | 37.766235412247894 | -122.417476777052 | (37.7662354122479, -122.417476777052) | |||
149884 | 149884 | 68246 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3475 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32046 | 6001228.52061 | 2120448.06456 | 37.8024144268505 | -122.43994344164301 | (37.8024144268505, -122.439943441643) | |
150623 | 150623 | 180454 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008374.23169 | 2091967.3383 | 37.7246171135761 | -122.413200531303 | (37.7246171135761, -122.413200531303) | |||
151102 | 151102 | 68380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | 3x8 | Permit Number 32204 | 6002292.26866 | 2094136.6804799999 | 37.7302303121653 | -122.43438009877701 | (37.7302303121653, -122.434380098777) |
152635 | 152635 | 136916 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6000038.63255 | 2121244.89177 | 37.804534494021794 | -122.444118317601 | (37.8045344940218, -122.444118317601) | |||
153986 | 153986 | 68245 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3471 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32045 | 6001229.5729 | 2120436.05695 | 37.802381517044104 | -122.439938938746 | (37.8023815170441, -122.439938938746) | |
159051 | 159051 | 180448 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008430.60445 | 2091787.20061 | 37.7241256583517 | -122.4129929264 | (37.7241256583517, -122.4129929264) | |||
159394 | 159394 | 33106 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2953 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37345 | 5999975.52574 | 2118733.08238 | 37.7976341371664 | -122.444156101749 | (37.7976341371664, -122.444156101749) | |
159638 | 159638 | 219424 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1351 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992069.53986 | 2106182.25369 | 37.76271879506721 | -122.470598092623 | (37.7627187950672, -122.470598092623) | |||
168577 | 168577 | 180460 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008247.39503 | 2092379.68479 | 37.7257422077099 | -122.41366814277 | (37.7257422077099, -122.41366814277) | |||
168908 | 168908 | 242881 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007152.90115 | 2107695.77387 | 37.767735216134604 | -122.41853731696301 | (37.7677352161346, -122.418537316963) | |||
170868 | 170868 | 62135 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 9 | Permit Number 31835 | 6001148.79085 | 2092353.9589200001 | 37.7252703936925 | -122.43820558541901 | (37.7252703936925, -122.438205585419) | |
174546 | 174546 | 219447 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999412.642419999 | 2094330.1651599999 | 37.730597700505 | -122.44434921406601 | (37.730597700505, -122.444349214066) | |||
177030 | 177030 | 124216 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.45575789701401 | (37.7796587851836, -122.455757897014) | |||
177790 | 177790 | 36989 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39610 | 5993273.5401 | 2114815.16246 | 37.7864919948194 | -122.46706159406999 | (37.7864919948194, -122.46706159407) | |
182275 | 182275 | 136954 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011359.28517 | 2121128.07702 | 37.8048530581732 | -122.404933719313 | (37.8048530581732, -122.404933719313) | |||
187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
187872 | 187872 | 136933 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999921.83043 | 2119840.52401 | 37.8006718131986 | -122.44442153123998 | (37.8006718131986, -122.44442153124) |
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");