Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41330 | 41330 | 57327 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.785592057564294 | -122.44539352748501 | (37.7855920575643, -122.445393527485) | ||
2878 | 2878 | 57526 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.42502261513701 | (37.7775297860553, -122.425022615137) | |
25086 | 25086 | 59963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 15 | Permit Number 19442 | 6005413.5665 | 2111133.9591 | 37.777077569392 | -122.424798095948 | (37.777077569392, -122.424798095948) | |
53659 | 53659 | 59958 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 515 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 17 | Permit Number 19435 | 6005418.82 | 2111104.349 | 37.7769965639956 | -122.42477781542601 | (37.7769965639956, -122.424777815426) | |
66083 | 66083 | 59960 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 492 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 21 | Permit Number 19438 | 6005457.1486 | 2111358.1318 | 37.777695554426295 | -122.424663282479 | (37.7776955544263, -122.424663282479) | |
134254 | 134254 | 59957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 539 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 12 | Permit Number 19434 | 6005396.005 | 2111241.6 | 37.7773721331465 | -122.424866506623 | (37.7773721331465, -122.424866506623) | |
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) |
134965 | 134965 | 63910 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1991 12:00:00 AM | 14 | Permit Number 30246 | 6009385.3216 | 2121038.8544 | 37.804497537044895 | -122.411758548847 | (37.8044975370449, -122.411758548847) | ||
2797 | 2797 | 142505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | |
3219 | 3219 | 142514 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | |
3249 | 3249 | 142515 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 21 | Width 0ft | Permit Number 774306 | 6010502.9388 | 2118931.0084 | 37.7987725428783 | -122.40774219721901 | (37.7987725428783, -122.407742197219) | |
54193 | 54193 | 59956 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | ||
170210 | 170210 | 57646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | |
35309 | 35309 | 64038 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | ||
25581 | 25581 | 64501 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | |
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) | |
156324 | 156324 | 77283 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1210 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | ||
31733 | 31733 | 33694 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.777091471020704 | -122.424910846803 | (37.7770914710207, -122.424910846803) | ||
36366 | 36366 | 33642 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005736999 | (37.776111096903, -122.42556005737) | |
75416 | 75416 | 33693 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.42485326118401 | (37.7771015944949, -122.424853261184) | ||
169263 | 169263 | 33692 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123001 | (37.7770838353758, -122.42497676123) | ||
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) | |
42034 | 42034 | 55481 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | ||
132537 | 132537 | 55484 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.43641927844601 | (37.7762536529278, -122.436419278446) | ||
152051 | 152051 | 55477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11429 | 6002598.3437 | 2110470.6592 | 37.7750969045142 | -122.43448938343799 | (37.7750969045142, -122.434489383438) | ||
153102 | 153102 | 55473 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.43741173817101 | (37.7760618062261, -122.437411738171) | ||
186817 | 186817 | 55476 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | ||
69466 | 69466 | 66825 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.77334802445179 | -122.450216391954 | (37.7733480244518, -122.450216391954) | |
45497 | 45497 | 72023 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1989 12:00:00 AM | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.40754355100599 | (37.7919886256319, -122.407543551006) | ||
67726 | 67726 | 57633 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 486 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1976 12:00:00 AM | 19 | Permit Number 16531 | 6005481.2851 | 2111360.2306 | 37.7777026803458 | -122.42457993532899 | (37.7777026803458, -122.424579935329) | ||
49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) | ||
181919 | 181919 | 53486 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 14 | Permit Number 6395 | 5996703.1102 | 2112969.116 | 37.7816206023811 | -122.455062757544 | (37.7816206023811, -122.455062757544) | ||
26569 | 26569 | 32778 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.775491837653796 | -122.43967909765101 | (37.7754918376538, -122.439679097651) | |
4497 | 4497 | 13125 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | ||
6065 | 6065 | 13190 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | ||
6232 | 6232 | 13105 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | ||
6459 | 6459 | 13183 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.43457818463301 | (37.7999239124366, -122.434578184633) | ||
6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
7620 | 7620 | 13281 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.44332922273199 | (37.7990349463185, -122.443329222732) | ||
7652 | 7652 | 13207 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2199 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001946.8642 | 2119395.357 | 37.799564834652706 | -122.43738219799299 | (37.7995648346527, -122.437382197993) | ||
8267 | 8267 | 13269 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2495 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000559.8762 | 2119201.7827 | 37.798954383190896 | -122.442167759467 | (37.7989543831909, -122.442167759467) | ||
1873 | 1873 | 20151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | |
27948 | 27948 | 58051 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.791740674082796 | -122.421003598405 | (37.7917406740828, -122.421003598405) | ||
6541 | 6541 | 33662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | ||
86975 | 86975 | 53539 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 322 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1969 12:00:00 AM | Permit Number 776401 | 5995280.52661988 | 2113383.63166464 | 37.78267703677329 | -122.460014224406 | (37.7826770367733, -122.460014224406) | |||
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) | |
71959 | 71959 | 62365 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 14 | 6x4 | Permit Number 22511 | 6002365.7866 | 2114401.6807 | 37.7858772955002 | -122.43557513482 | (37.7858772955002, -122.43557513482) | |
166552 | 166552 | 62362 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1905 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 13 | Permit Number 22507 | 6004330.152000001 | 2115433.2423 | 37.7888210787145 | -122.42885254308399 | (37.7888210787145, -122.428852543084) | ||
147652 | 147652 | 64012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923078999 | (37.7757444404433, -122.44883923079) | ||
23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
21249 | 21249 | 15334 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | ||
41574 | 41574 | 57511 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | ||
76775 | 76775 | 57510 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | ||
2799 | 2799 | 142504 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | ||
171478 | 171478 | 61148 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | ||
20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
151231 | 151231 | 54831 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.781366286141896 | -122.443343289517 | (37.7813662861419, -122.443343289517) | ||
37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
8913 | 8913 | 13286 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | ||
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) | |
7736 | 7736 | 20147 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1025 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3x3 | 6002893.7013 | 2111823.32 | 37.778827735903604 | -122.433564367127 | (37.7788277359036, -122.433564367127) | ||
162063 | 162063 | 53066 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | ||
162434 | 162434 | 67469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | |
35499 | 35499 | 66182 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.42868702120701 | (37.7879922787707, -122.428687021207) | ||
60145 | 60145 | 61078 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.44437783777398 | (37.7837992291467, -122.444377837774) | ||
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) | |
29471 | 29471 | 56977 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441002 | (37.8046566775876, -122.40963527441) | ||
75917 | 75917 | 68430 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | ||
9434 | 9434 | 18037 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1993 12:00:00 AM | 6 | 3X3 | 6000386.5591 | 2114760.4621 | 37.7867498032378 | -122.442448460651 | (37.7867498032378, -122.442448460651) | ||
133205 | 133205 | 62731 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | ||
156483 | 156483 | 32296 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | ||
165399 | 165399 | 32294 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | ||
167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
54324 | 54324 | 58879 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.785611411881106 | -122.44517715647801 | (37.7856114118811, -122.445177156478) | ||
152460 | 152460 | 62957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | ||
68178 | 68178 | 32290 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | ||
177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
2903 | 2903 | 13280 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.44322102307699 | (37.7990441048198, -122.443221023077) | ||
49029 | 49029 | 56933 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1915 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 14 | 3x3 | Permit Number 14177 | 6001940.9389 | 2115134.3349 | 37.787864837109 | -122.437097461747 | (37.787864837109, -122.437097461747) | |
61133 | 61133 | 56932 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1911 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14176 | 6001946.3485 | 2115087.5805 | 37.787736769008 | -122.43707539686001 | (37.787736769008, -122.43707539686) | |
64732 | 64732 | 56926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.774200340216396 | -122.439438484322 | (37.7742003402164, -122.439438484322) | ||
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) | |
180558 | 180558 | 66720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.44372871968399 | (37.778852049002, -122.443728719684) | ||
176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
63452 | 63452 | 54834 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | ||
24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
131817 | 131817 | 45603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.779665941263104 | -122.43171536011101 | (37.7796659412631, -122.431715360111) | ||
157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
29179 | 29179 | 63908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | ||
175202 | 175202 | 63909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.804275748547504 | -122.41170315133301 | (37.8042757485475, -122.411703151333) | ||
8030 | 8030 | 10637 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.43027732793101 | (37.7758893402664, -122.430277327931) | ||
8268 | 8268 | 10636 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | ||
8915 | 8915 | 10629 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.775925484701794 | -122.429965440473 | (37.7759254847018, -122.429965440473) | ||
171274 | 171274 | 59153 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.40941840765801 | (37.8047872831513, -122.409418407658) | ||
25536 | 25536 | 59622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | |
164315 | 164315 | 64505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | |
34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
47374 | 47374 | 70252 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1993 12:00:00 AM | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.43945159440399 | (37.7750685309709, -122.439451594404) | ||
49361 | 49361 | 38058 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | |
130494 | 130494 | 59752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.78409195734471 | -122.44085723976299 | (37.7840919573447, -122.440857239763) |
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");