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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68465 | 68465 | 108005 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | |||
| 73003 | 73003 | 117049 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | |||
| 73309 | 73309 | 110467 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | ||
| 74070 | 74070 | 110466 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6005573.1085 | 2111325.0754 | 37.777611337989605 | -122.42425978551701 | (37.7776113379896, -122.424259785517) | ||
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 74885 | 74885 | 97311 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.47618790715099 | (37.7431214880079, -122.476187907151) | ||
| 76198 | 76198 | 113276 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2129 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002796.8552 | 2118506.6849 | 37.7971730575287 | -122.434377355222 | (37.7971730575287, -122.434377355222) | |||
| 77147 | 77147 | 104353 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2594 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999783.3073 | 2113692.3242 | 37.7837825709749 | -122.444458768108 | (37.7837825709749, -122.444458768108) | |||
| 78346 | 78346 | 113409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 81079 | 81079 | 54103 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.792571182193605 | -122.43320427561301 | (37.7925711821936, -122.433204275613) | ||
| 92442 | 92442 | 37059 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 108810 | 108810 | 113054 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003823.0 | 2108493.0 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | ||||
| 110431 | 110431 | 113408 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003890.0 | 2099760.0 | 37.74576122776671 | -122.429257354108 | (37.7457612277667, -122.429257354108) | ||||
| 111616 | 111616 | 37061 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | |
| 116559 | 116559 | 113410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 129651 | 129651 | 111432 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | |||
| 130563 | 130563 | 31656 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | |
| 132458 | 132458 | 97936 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.41032100357701 | (37.8057498158932, -122.410321003577) | |||
| 134413 | 134413 | 120659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 778623 | 6015041.8167 | 2115476.8576 | 37.7895412902416 | -122.391794432707 | (37.7895412902416, -122.391794432707) | ||
| 135048 | 135048 | 55105 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 219 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11004 | 5998291.6539 | 2109868.1545 | 37.7731971698727 | -122.44934368775 | (37.7731971698727, -122.44934368775) | |
| 139908 | 139908 | 37062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 145969 | 145969 | 113486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998975.0 | 2116473.0 | 37.7913714231174 | -122.44745541416201 | (37.7913714231174, -122.447455414162) | ||||
| 148730 | 148730 | 67753 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | |
| 150219 | 150219 | 97934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | |||
| 150827 | 150827 | 59162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 16 | 3x3 | Permit Number 19443 | 6005553.1697 | 2111320.8777 | 37.7775986862615 | -122.424328461999 | (37.7775986862615, -122.424328461999) |
| 152489 | 152489 | 111433 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | |||
| 152607 | 152607 | 117030 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002496.7975 | 2114414.081 | 37.7859187837291 | -122.435122761266 | (37.7859187837291, -122.435122761266) | |||
| 153429 | 153429 | 113988 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.43599404678801 | (37.7856608347208, -122.435994046788) | |||
| 155188 | 155188 | 87083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1711 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53300 | 6000537.4917 | 2114630.4681 | 37.7864014751637 | -122.44191693732799 | (37.7864014751637, -122.441916937328) | |
| 155805 | 155805 | 108006 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005290.3504 | 2110988.0578 | 37.7766699998805 | -122.425213954913 | (37.7766699998805, -122.425213954913) | |||
| 162030 | 162030 | 115983 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862758996 | -122.40507012236701 | (37.796351862759, -122.405070122367) | |||
| 163651 | 163651 | 117047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002170.5041 | 2114314.4901 | 37.7856267989414 | -122.43624451502701 | (37.7856267989414, -122.436244515027) | |||
| 164557 | 164557 | 59351 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.44307315376899 | (37.7755210539143, -122.443073153769) | |
| 164701 | 164701 | 58783 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | |
| 164818 | 164818 | 87369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | |
| 165188 | 165188 | 62369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.773911796453596 | -122.44947832162799 | (37.7739117964536, -122.449478321628) | |
| 170111 | 170111 | 115985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011253.147999999 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | |||
| 171969 | 171969 | 56934 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | |
| 179301 | 179301 | 110471 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.77766542832121 | -122.42385987213899 | (37.7776654283212, -122.423859872139) | ||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 182606 | 182606 | 115984 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.796399137392896 | -122.405076175742 | (37.7963991373929, -122.405076175742) |
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");