Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3708 | 3708 | 241324 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | Width 3ft | 6007395.8118199995 | 2106861.7423400003 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | ||
15236 | 15236 | 61555 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1175- 1175 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49777 | 6012252.19835 | 2102963.4918400003 | 37.7550271768774 | -122.40056689654101 | (37.7550271768774, -122.400566896541) | |
32204 | 32204 | 241310 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007485.43036 | 2106430.0255 | 37.764278482093204 | -122.417297428844 | (37.7642784820932, -122.417297428844) | |||
33736 | 33736 | 65937 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.44598557278401 | (37.7958202522453, -122.445985572784) | ||
51103 | 51103 | 196994 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.39472477462401 | (37.7473596740254, -122.394724774624) | |||
58092 | 58092 | 196987 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | |||
59685 | 59685 | 49557 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 7 | Permit Number 46446 | 5999409.77309 | 2093045.0994900002 | 37.7270690458815 | -122.444266822659 | (37.7270690458815, -122.444266822659) | ||
59733 | 59733 | 78256 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | ||
66253 | 66253 | 241332 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 263 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007398.28361 | 2108137.64954 | 37.768962314089606 | -122.41771989078501 | (37.7689623140896, -122.417719890785) | |||
73801 | 73801 | 241296 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1350 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007156.61283 | 2107616.82741 | 37.767518656696794 | -122.41851887996 | (37.7675186566968, -122.41851887996) | |||
74291 | 74291 | 241309 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007486.87936 | 2106417.71309 | 37.7642447566068 | -122.41729154457799 | (37.7642447566068, -122.417291544578) | |||
74848 | 74848 | 179278 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | |||
75172 | 75172 | 196997 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 11 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.747335557807496 | -122.395144856947 | (37.7473355578075, -122.395144856947) | |||
75960 | 75960 | 36966 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.520930001 | 2112981.13075 | 37.781516271518505 | -122.463326949801 | (37.7815162715185, -122.463326949801) | |
80461 | 80461 | 91672 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.41706129314801 | (37.7614631059869, -122.417061293148) | ||
82384 | 82384 | 91599 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007449.0 | 2105508.0 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | ||
92412 | 92412 | 91663 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 859 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007573.699386 | 2104662.928197 | 37.75943140801971 | -122.41686692513399 | (37.7594314080197, -122.416866925134) | ||
96342 | 96342 | 67314 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | |
101922 | 101922 | 241307 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 629 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007511.70266 | 2105973.00163 | 37.763025078965704 | -122.417174173153 | (37.7630250789657, -122.417174173153) | |||
113030 | 113030 | 91608 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | |||
113695 | 113695 | 91586 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.767493554100206 | -122.417782265097 | (37.7674935541002, -122.417782265097) | |||
120681 | 120681 | 91673 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.41706129314801 | (37.7614631059869, -122.417061293148) | ||
128202 | 128202 | 91646 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1271 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | ||
131396 | 131396 | 241318 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 280 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007336.81249 | 2108065.49507 | 37.7687607355409 | -122.417927400355 | (37.7687607355409, -122.417927400355) | |||
131604 | 131604 | 136183 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | |||
151502 | 151502 | 241302 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007545.5728 | 2105350.70249 | 37.7613182952255 | -122.41701293280501 | (37.7613182952255, -122.417012932805) | |||
153311 | 153311 | 119966 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5987215.946719999 | 2112352.1893599997 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | |||
161219 | 161219 | 241342 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2122 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009546.723809999 | 2104789.44467 | 37.7598895755605 | -122.410052140597 | (37.7598895755605, -122.410052140597) | |||
162522 | 162522 | 30565 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | ||
162667 | 162667 | 65010 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | ||
163897 | 163897 | 241320 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007347.086630001 | 2107747.30956 | 37.767887651234105 | -122.417869305024 | (37.7678876512341, -122.417869305024) | |||
171371 | 171371 | 31983 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.724640001 | 2113855.38064 | 37.7839533587811 | -122.46118939688499 | (37.7839533587811, -122.461189396885) |
173145 | 173145 | 196992 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.747370139416205 | -122.394524516312 | (37.7473701394162, -122.394524516312) | |||
173220 | 173220 | 241336 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | |||
180332 | 180332 | 241380 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4050 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008348.5979 | 2096262.4488099997 | 37.7364091240834 | -122.413592786804 | (37.7364091240834, -122.413592786804) | |||
181475 | 181475 | 241308 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.764198964923295 | -122.417285889641 | (37.7641989649233, -122.417285889641) | |||
185013 | 185013 | 241316 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007332.32989 | 2108125.54734 | 37.768925372644205 | -122.41794716295 | (37.7689253726442, -122.41794716295) | |||
186450 | 186450 | 196986 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | |||
186926 | 186926 | 241319 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007346.30903 | 2107764.0705 | 37.7679336290724 | -122.417873182915 | (37.7679336290724, -122.417873182915) | |||
187168 | 187168 | 196993 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013912.096059999 | 2100139.0238799998 | 37.7473642236913 | -122.39462867398501 | (37.7473642236913, -122.394628673985) |
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");