Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
| 8586 | 8586 | 97596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 783 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001525.9433 | 2111041.0042 | 37.7766019950898 | -122.438239913038 | (37.7766019950898, -122.438239913038) | ||||
| 10268 | 10268 | 49966 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2003 12:00:00 AM | Permit Number 46718 | 6000426.47543442 | 2105220.01428839 | 37.7605564179186 | -122.44162544737301 | (37.7605564179186, -122.441625447373) | |||
| 13619 | 13619 | 22307 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014686.8832 | 2094799.1002 | 37.7327449405845 | -122.391576215676 | (37.7327449405845, -122.391576215676) | ||||
| 14900 | 14900 | 42231 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42486 | 6010159.8373 | 2112236.08642 | 37.780370682809 | -122.408456946549 | (37.780370682809, -122.408456946549) | |
| 15465 | 15465 | 22290 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4850 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014853.4802 | 2095344.2309 | 37.7342510046252 | -122.391038331468 | (37.7342510046252, -122.391038331468) | ||||
| 16246 | 16246 | 85552 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 320 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008325.98929 | 2108714.16712 | 37.7705974578492 | -122.414551808542 | (37.7705974578492, -122.414551808542) | |||
| 16867 | 16867 | 84834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010439.60599 | 2111868.75172 | 37.7793777314294 | -122.40746318667 | (37.7793777314294, -122.40746318667) | ||
| 17980 | 17980 | 51193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 18181 | 18181 | 7048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001113.3036400005 | 2110008.37363 | 37.7737431739315 | -122.43959330500601 | (37.7737431739315, -122.439593305006) | ||||
| 19693 | 19693 | 45729 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 20214 | 20214 | 16047 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6000544.66834 | 2094663.6950599998 | 37.731578019092396 | -122.440459552683 | (37.7315780190924, -122.440459552683) | ||||
| 20619 | 20619 | 42911 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42822 | 6008853.88469765 | 2103932.85927525 | 37.7574987299949 | -122.412387795343 | (37.7574987299949, -122.412387795343) | ||
| 20869 | 20869 | 41252 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 155 Minna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41945 | 6012533.02981985 | 2114448.22388081 | 37.7865773148555 | -122.40040234125 | (37.7865773148555, -122.40040234125) | |||
| 21235 | 21235 | 63156 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.46937656879999 | (37.7605085633711, -122.4693765688) | ||
| 22939 | 22939 | 106926 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1630 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | 1 | Permit Number 772472 | 6006674.89128 | 2116548.04872 | 37.7920144933451 | -122.420819236116 | (37.7920144933451, -122.420819236116) | ||
| 23007 | 23007 | 22285 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6014905.6735 | 2095512.4095 | 37.7347156849635 | -122.390869630779 | (37.7347156849635, -122.390869630779) | ||||
| 23183 | 23183 | 5156 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 270 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/1990 12:00:00 AM | 2 | 6001844.2525 | 2109252.3731 | 37.7717089596497 | -122.43701070699899 | (37.7717089596497, -122.437010706999) | |||
| 23634 | 23634 | 38826 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 35 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 7 | Permit Number 40661 | 5993919.30733 | 2115313.05171 | 37.7878963157335 | -122.46486358906 | (37.7878963157335, -122.46486358906) | |
| 24231 | 24231 | 41521 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1001 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 7 | Permit Number 42063 | 6014203.50387 | 2106173.31085 | 37.763949275370706 | -122.394043363717 | (37.7639492753707, -122.394043363717) | ||
| 25605 | 25605 | 41164 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 6 | Permit Number 41886 | 6012808.90052 | 2114914.6323 | 37.787873343513 | -122.399480646824 | (37.787873343513, -122.399480646824) | ||
| 25636 | 25636 | 67280 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 705 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 7 | Permit Number 30756 | 6005348.882780001 | 2092459.4150200002 | 37.7257979378164 | -122.42369375707399 | (37.7257979378164, -122.423693757074) | |
| 26289 | 26289 | 66938 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2001 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1992 12:00:00 AM | 11 | Permit Number 30264 | 5999304.6432 | 2111145.9532 | 37.776763570609496 | -122.44593155725599 | (37.7767635706095, -122.445931557256) | ||
| 26674 | 26674 | 30678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1035 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34601 | 6007763.45978 | 2109624.69043 | 37.77306592059371 | -122.41656211886499 | (37.7730659205937, -122.416562118865) | |
| 28545 | 28545 | 38090 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2613 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 4 | Permit Number 40262 | 5999952.6506 | 2114003.5175 | 37.784646688105205 | -122.443895271597 | (37.7846466881052, -122.443895271597) | |
| 29323 | 29323 | 73436 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 376 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014381.64402 | 2112223.83347 | 37.7805725617252 | -122.39385077838499 | (37.7805725617252, -122.393850778385) | ||
| 30261 | 30261 | 239066 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005897.29527 | 2109110.01262 | 37.7715476104631 | -122.42298083840001 | (37.7715476104631, -122.4229808384) | ||||
| 30328 | 30328 | 66823 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1945 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 12 | Permit Number 30119 | 5998494.0785 | 2110339.7621 | 37.7745036601214 | -122.448677450991 | (37.7745036601214, -122.448677450991) | |
| 30372 | 30372 | 32311 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 156 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 9 | Permit Number 36884 | 6013680.41155 | 2106339.05645 | 37.764375289609 | -122.39586421206002 | (37.764375289609, -122.39586421206) | ||
| 31365 | 31365 | 54752 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2711 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1972 12:00:00 AM | 4 | Permit Number 10600 | 6001093.70548 | 2116875.25307 | 37.792596751990004 | -122.44015361411002 | (37.79259675199, -122.44015361411) | ||
| 31960 | 31960 | 68737 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 12 | Permit Number 32656 | 6008735.2093 | 2120769.9280000003 | 37.8037226410898 | -122.413989292504 | (37.8037226410898, -122.413989292504) | ||
| 32246 | 32246 | 187491 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006526.88476 | 2086669.8859599999 | 37.7099675513223 | -122.419210983794 | (37.7099675513223, -122.419210983794) | ||||
| 32258 | 32258 | 84831 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 3 | Permit No. 49236 | 5992481.519090001 | 2110715.0101099997 | 37.775188347838395 | -122.469503188975 | (37.7751883478384, -122.469503188975) | ||
| 32500 | 32500 | 67873 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 57 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1993 12:00:00 AM | 1 | Permit Number 31560 | 5996810.8975 | 2114210.6164 | 37.78503561646139 | -122.45477959222099 | (37.7850356164614, -122.454779592221) | ||
| 33719 | 33719 | 38536 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40515 | 6015198.3793 | 2096282.9865 | 37.7368477693481 | -122.389911447438 | (37.7368477693481, -122.389911447438) | ||
| 33931 | 33931 | 38487 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 663 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 11 | Permit Number 40484 | 6008553.25241 | 2118118.58868 | 37.7964325026095 | -122.414431248111 | (37.7964325026095, -122.414431248111) | |
| 34485 | 34485 | 196775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013724.81339 | 2108580.1885900004 | 37.7705314116112 | -122.395867690649 | (37.7705314116112, -122.395867690649) | ||||
| 34923 | 34923 | 196938 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1675 Howard St | 1 | : 4 | Tree 1 | Private 1 | 7 | 6007452.5571800005 | 2108703.80636 | 37.7705199011999 | -122.417572293134 | (37.7705199011999, -122.417572293134) | ||||
| 35410 | 35410 | 31403 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4244 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 34994 | 6002175.10963 | 2104146.03155 | 37.757706993800504 | -122.43550089685 | (37.7577069938005, -122.43550089685) | |
| 35697 | 35697 | 179258 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989486.24295 | 2090206.2141599997 | 37.7187030225094 | -122.478364452564 | (37.7187030225094, -122.478364452564) | ||||
| 35737 | 35737 | 40109 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 181 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1999 12:00:00 AM | 8 | Permit Number 41329 | 6012428.69161 | 2114004.12071 | 37.785352092364604 | -122.400732117288 | (37.7853520923646, -122.400732117288) | ||
| 36577 | 36577 | 47078 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 150 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | Permit Number 45065 | 5996844.0629 | 2111961.8035 | 37.778862872875706 | -122.454502341108 | (37.7788628728757, -122.454502341108) | |
| 36659 | 36659 | 38773 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 88 Guy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 8 | Permit Number 40637 | 6014157.54526 | 2114261.49133 | 37.7861550475601 | -122.39476879105699 | (37.7861550475601, -122.394768791057) | ||
| 36688 | 36688 | 72131 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 975 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2014 12:00:00 AM | 1 | Permit Number 772897 | 6012808.0555 | 2103001.2980400003 | 37.75516196906929 | -122.398647223515 | (37.7551619690693, -122.398647223515) | |
| 37057 | 37057 | 84835 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010454.595980001 | 2111882.01804 | 37.7794149966465 | -122.40741226527399 | (37.7794149966465, -122.407412265274) | ||
| 37261 | 37261 | 74866 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 7 | 6015612.0948 | 2112518.9573 | 37.7814512083448 | -122.389614645118 | (37.7814512083448, -122.389614645118) | ||
| 38201 | 38201 | 43525 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1664 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | 5 | Permit Number 43200 | 5999846.7791 | 2110578.6022 | 37.775236710967 | -122.444015378674 | (37.775236710967, -122.444015378674) | ||
| 38320 | 38320 | 247961 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 14 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6010370.704 | 2098913.358 | 37.743801288699395 | -122.40678825178001 | (37.7438012886994, -122.40678825178) | ||||
| 39426 | 39426 | 33289 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1250 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37450 | 6008792.2608 | 2116678.011 | 37.79249045392179 | -122.413502289805 | (37.7924904539218, -122.413502289805) | |
| 39545 | 39545 | 52519 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 52 Navajo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 3 | Permit Number 48620 | 5999464.555919999 | 2090507.1181599998 | 37.7201034593997 | -122.443895170628 | (37.7201034593997, -122.443895170628) | |
| 39762 | 39762 | 76392 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015910.963140001 | 2112668.39256 | 37.7818780913398 | -122.3885911303 | (37.7818780913398, -122.3885911303) | ||
| 40209 | 40209 | 80574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2002 12:00:00 AM | 3 | 5988121.26409 | 2111709.35839 | 37.777665594619 | -122.484659059603 | (37.777665594619, -122.484659059603) | ||
| 40264 | 40264 | 31824 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | 4 | Permit Number 45448 | 6009316.55308 | 2110688.06938 | 37.77607293244729 | -122.411264885376 | (37.7760729324473, -122.411264885376) | ||
| 40937 | 40937 | 31342 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 240 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34954 | 6006186.23354 | 2111270.37249 | 37.7774957381658 | -122.422134888438 | (37.7774957381658, -122.422134888438) | |
| 40945 | 40945 | 196597 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1251 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6014153.4442300005 | 2104763.78989 | 37.76007625593729 | -122.39411782218599 | (37.7600762559373, -122.394117822186) | ||||
| 42141 | 42141 | 46227 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 55 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 6 | Permit Number 44531 | 6012551.18992 | 2115185.10084 | 37.7886016190163 | -122.400391288634 | (37.7886016190163, -122.400391288634) | ||
| 42349 | 42349 | 47925 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1793 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | 7 | Permit Number 45661 | 6000638.2577 | 2111331.2873 | 37.777348511449105 | -122.441331500835 | (37.7773485114491, -122.441331500835) | |
| 42544 | 42544 | 41165 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 6 | Permit Number 41886 | 6012835.78991 | 2114885.77965 | 37.787795619607394 | -122.39938558756701 | (37.7877956196074, -122.399385587567) | ||
| 43261 | 43261 | 73404 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1817 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 11 | 6005442.665019999 | 2092673.3852400002 | 37.726390746633896 | -122.423384762607 | (37.7263907466339, -122.423384762607) | ||
| 43478 | 43478 | 51181 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 43737 | 43737 | 38772 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 88 Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 8 | Permit Number 40637 | 6014164.6407699995 | 2114290.42577 | 37.786234889376004 | -122.394746269337 | (37.786234889376, -122.394746269337) | ||
| 44718 | 44718 | 31343 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 240 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34954 | 6006171.37375 | 2111269.23628 | 37.777491780263794 | -122.422186212726 | (37.7774917802638, -122.422186212726) | |
| 45299 | 45299 | 38771 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 88 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 7 | Permit Number 40637 | 6014168.3381199995 | 2114298.50018 | 37.7862572654152 | -122.39473404303699 | (37.7862572654152, -122.394734043037) | ||
| 45754 | 45754 | 46235 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 55 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 9 | Permit Number 44531 | 6012580.75695 | 2115152.90153 | 37.788514856022296 | -122.400286728063 | (37.7885148560223, -122.400286728063) | ||
| 46365 | 46365 | 84832 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 3 | Permit No. 49236 | 5992462.33951 | 2110714.34502 | 37.775185413225 | -122.46956948643101 | (37.775185413225, -122.469569486431) | ||
| 46829 | 46829 | 32672 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 52 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37096 | 6011553.1933699995 | 2109908.84309 | 37.7740585418955 | -122.403472874078 | (37.7740585418955, -122.403472874078) | |
| 46951 | 46951 | 65985 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 659 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1990 12:00:00 AM | 8 | Permit Number 29014 | 6010750.4184 | 2116208.9676 | 37.7913123281025 | -122.40669390128599 | (37.7913123281025, -122.406693901286) | |
| 47301 | 47301 | 196777 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6013719.28205 | 2108540.3195 | 37.7704216322684 | -122.39588402954901 | (37.7704216322684, -122.395884029549) | ||||
| 47304 | 47304 | 40937 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 525 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | 20 | Permit Number 41798 | 6013400.10228 | 2111194.56324 | 37.777691824563796 | -122.397174227516 | (37.7776918245638, -122.397174227516) | ||
| 47532 | 47532 | 213788 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 409 Edna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998741.333869999 | 2094177.6114700001 | 37.73014049957229 | -122.44665904717199 | (37.7301404995723, -122.446659047172) | ||||
| 47909 | 47909 | 31837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1162 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35293 | 6009869.4904 | 2110535.9885 | 37.77568634927629 | -122.409341384883 | (37.7756863492763, -122.409341384883) | |
| 47987 | 47987 | 68761 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 50 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/1997 12:00:00 AM | Permit Number 32684 | 6003960.97119147 | 2105124.66245865 | 37.7604953479062 | -122.42939444048099 | (37.7604953479062, -122.429394440481) | ||
| 48008 | 48008 | 32432 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 22 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | 7 | Permit Number 36959 | 6007622.50376 | 2099741.8653700002 | 37.745922032184794 | -122.416349576665 | (37.7459220321848, -122.416349576665) | ||
| 48374 | 48374 | 46228 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 55 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | Permit Number 44531 | 6012528.68122922 | 2115201.03212894 | 37.788644107377294 | -122.40047028530898 | (37.7886441073773, -122.400470285309) | |||
| 49223 | 49223 | 67218 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 67 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | Permit Number 30674 | 6004275.36148655 | 2108843.45765699 | 37.770724059917605 | -122.428572194222 | (37.7707240599176, -122.428572194222) | ||
| 49274 | 49274 | 66968 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2944 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1992 12:00:00 AM | 6 | Permit Number 30308 | 5996959.7461 | 2111582.866 | 37.7778290438915 | -122.45407477375299 | (37.7778290438915, -122.454074773753) | ||
| 49909 | 49909 | 31895 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 11 | Permit Number 47709 | 6008447.6164 | 2108708.53583 | 37.770588827951 | -122.41413069917299 | (37.770588827951, -122.414130699173) | |
| 50535 | 50535 | 42232 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42486 | 6010147.47945 | 2112226.4024900002 | 37.7803434009533 | -122.408499015011 | (37.7803434009533, -122.408499015011) | |
| 50735 | 50735 | 85042 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3130 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | 4 | Permit Number 49389 | 5999184.1651099995 | 2116655.69602 | 37.7918850087356 | -122.446744861386 | (37.7918850087356, -122.446744861386) | ||
| 51220 | 51220 | 38673 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 9 | Permit Number 40591 | 5999617.1558 | 2110820.1364 | 37.7758868007627 | -122.444827060795 | (37.7758868007627, -122.444827060795) | |
| 51390 | 51390 | 30772 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34651 | 6015119.06429 | 2112403.324 | 37.7811063552192 | -122.39131222069099 | (37.7811063552192, -122.391312220691) | |
| 51789 | 51789 | 52348 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 69 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2005 12:00:00 AM | 3 | Permit Number 48490 | 6013679.9014 | 2114409.67507 | 37.7865353573557 | -122.39643171485001 | (37.7865353573557, -122.39643171485) | ||
| 52008 | 52008 | 46236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 55 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 9 | Permit Number 44531 | 6012569.894280001 | 2115163.6548599997 | 37.78854377641579 | -122.400325067045 | (37.7885437764158, -122.400325067045) | ||
| 53012 | 53012 | 72269 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 550 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6003171.66265 | 2090288.8451 | 37.719714892907 | -122.431065391947 | (37.719714892907, -122.431065391947) | ||
| 53599 | 53599 | 39870 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3626 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41421 | 6006079.92775485 | 2101440.50496023 | 37.750499244033705 | -122.421804236007 | (37.7504992440337, -122.421804236007) | ||
| 54501 | 54501 | 71438 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 671 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | 6003019.09073 | 2089456.91868 | 37.717421959831 | -122.43153341803401 | (37.717421959831, -122.431533418034) | ||
| 55411 | 55411 | 51933 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 329 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48161 | 6009122.9755 | 2121466.1666 | 37.805656108704206 | -122.41269665162201 | (37.8056561087042, -122.412696651622) | ||
| 55715 | 55715 | 102680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 56602 | 56602 | 43984 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 547 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | 7 | Permit Number 57029 | 6002992.49585 | 2090428.7998400002 | 37.7200890234651 | -122.431694694364 | (37.7200890234651, -122.431694694364) | ||
| 56940 | 56940 | 33960 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 12 | Permit Number 37913 | 6008630.6596 | 2120754.8577 | 37.803675389390605 | -122.414350026627 | (37.8036753893906, -122.414350026627) | ||
| 57819 | 57819 | 38091 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2621 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40263 | 5999871.7643 | 2113997.1422 | 37.7846245690042 | -122.444174651925 | (37.7846245690042, -122.444174651925) | |
| 58051 | 58051 | 51188 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 0 | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | ||
| 58575 | 58575 | 38164 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 215 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 7 | Permit Number 41402 | 6010124.1026800005 | 2094106.4490599998 | 37.7305887468511 | -122.40730215048299 | (37.7305887468511, -122.407302150483) | |
| 58704 | 58704 | 34495 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38218 | 6008672.47995951 | 2097726.39703626 | 37.7404469880804 | -122.4125764416 | (37.7404469880804, -122.4125764416) | ||
| 59425 | 59425 | 33959 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 10 | Permit Number 37913 | 6008606.6414 | 2120752.0321 | 37.8036662817713 | -122.41443294306801 | (37.8036662817713, -122.414432943068) |
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");