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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84215 | 84215 | 64260 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25062 | 6009914.751597701 | 2100087.93471467 | 37.747000896924796 | -122.40844766940799 | (37.7470008969248, -122.408447669408) | ||
| 84246 | 84246 | 84682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961002 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | ||
| 84489 | 84489 | 52669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 346@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | Permit Number 48750 | 6004271.44295602 | 2099877.18374076 | 37.7461045741604 | -122.427946728117 | (37.7461045741604, -122.427946728117) | |||
| 84501 | 84501 | 35777 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3528 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1998 12:00:00 AM | Permit Number 39032 | 6006085.57014843 | 2104950.10312581 | 37.7601361059974 | -122.422034016017 | (37.7601361059974, -122.422034016017) | ||
| 84514 | 84514 | 95936 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 706 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767632 | 5987288.3 | 2111108.8 | 37.7759680859814 | -122.487496400821 | (37.7759680859814, -122.487496400821) | |
| 84629 | 84629 | 63385 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 219 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23966 | 6006529.47672641 | 2095826.96456486 | 37.7351110645595 | -122.419851373342 | (37.7351110645595, -122.419851373342) | ||
| 84633 | 84633 | 64125 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 623 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24896 | 6002552.88374737 | 2098852.79748639 | 37.743194474099795 | -122.43381607276599 | (37.7431944740998, -122.433816072766) | ||
| 84683 | 84683 | 108690 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 61 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005327.5 | 2105108.8 | 37.760529065911896 | -122.424667111807 | (37.7605290659119, -122.424667111807) | ||||
| 84897 | 84897 | 95669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 84930 | 84930 | 82925 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 733 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52380 | 6012148.34936451 | 2104990.04920575 | 37.7605858648735 | -122.401068426273 | (37.7605858648735, -122.401068426273) | ||
| 85116 | 85116 | 52350 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.74329208444921 | -122.46696519775 | (37.7432920844492, -122.46696519775) | |||
| 85552 | 85552 | 64143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 461 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24917 | 6002822.78297859 | 2098575.51836339 | 37.742448442032796 | -122.432863028806 | (37.7424484420328, -122.432863028806) | ||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 86058 | 86058 | 32838 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.750358149840395 | -122.43408346062701 | (37.7503581498404, -122.434083460627) | ||
| 86106 | 86106 | 66453 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | ||
| 86122 | 86122 | 46996 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 86130 | 86130 | 95714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 649 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767469 | 6004402.3 | 2092291.6 | 37.725283675745395 | -122.426954078943 | (37.7252836757454, -122.426954078943) | |
| 86269 | 86269 | 47258 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944.0 | 2106611.0 | 37.763772878653995 | -122.477980844758 | (37.763772878654, -122.477980844758) | ||
| 86326 | 86326 | 114443 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 LOOMIS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010781.0 | 2097775.0 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | ||||
| 86401 | 86401 | 35080 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 86452 | 86452 | 56109 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1985 12:00:00 AM | Permit Number 22207 | 6006832.665298599 | 2102651.38828329 | 37.7538664735729 | -122.419287095 | (37.7538664735729, -122.419287095) | ||
| 86456 | 86456 | 46994 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 86497 | 86497 | 95668 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 86572 | 86572 | 61992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | ||
| 86598 | 86598 | 52436 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1808 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | ||
| 86662 | 86662 | 35073 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 87037 | 87037 | 45790 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | |||
| 87063 | 87063 | 100358 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | ||||
| 87110 | 87110 | 46247 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | ||
| 87135 | 87135 | 103919 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 87209 | 87209 | 35084 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 87446 | 87446 | 92277 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52726 | 5992357.0 | 2098417.0 | 37.741414037816604 | -122.46903872163601 | (37.7414140378166, -122.469038721636) | ||
| 87482 | 87482 | 88794 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1240 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.765421253667796 | -122.461828244278 | (37.7654212536678, -122.461828244278) | |||
| 87513 | 87513 | 63381 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23961 | 6006861.89612331 | 2095799.20465588 | 37.7350535636056 | -122.41870010933201 | (37.7350535636056, -122.418700109332) | ||
| 87545 | 87545 | 64142 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 387 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24915 | 6003450.8356786 | 2098610.10956553 | 37.7425790233006 | -122.430693879032 | (37.7425790233006, -122.430693879032) | ||
| 87743 | 87743 | 88741 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299.0 | 2109043.0 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | ||
| 87850 | 87850 | 49865 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.733409356185796 | -122.430016351279 | (37.7334093561858, -122.430016351279) | ||
| 87898 | 87898 | 47557 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 206 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45420 | 6004100.72419306 | 2102141.4355601002 | 37.752312022935904 | -122.428698432782 | (37.7523120229359, -122.428698432782) | |||
| 87907 | 87907 | 47688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.752453700851795 | -122.429649915481 | (37.7524537008518, -122.429649915481) | |||
| 88115 | 88115 | 58747 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.720571340719104 | -122.45724965074699 | (37.7205713407191, -122.457249650747) | ||
| 88310 | 88310 | 33723 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | |||
| 88358 | 88358 | 36987 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39609 | 5993070.986847 | 2113501.00043119 | 37.7828719719487 | -122.46766676288799 | (37.7828719719487, -122.467666762888) | ||
| 88475 | 88475 | 33202 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51141 | 5994405.76875734 | 2099294.92155065 | 37.743942754277 | -122.462018491778 | (37.743942754277, -122.462018491778) | ||
| 88518 | 88518 | 63599 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1987 12:00:00 AM | 8x6 | Permit Number 24233 | 6004551.34106685 | 2109096.89343089 | 37.771435547373294 | -122.427635635138 | (37.7714355473733, -122.427635635138) | |
| 88610 | 88610 | 41815 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 30 Barcelona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | ||
| 88887 | 88887 | 52809 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 88901 | 88901 | 52808 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 88946 | 88946 | 46246 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | |||
| 89433 | 89433 | 33009 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37303 | 6005672.83784214 | 2102003.77697796 | 37.752022893601996 | -122.42325202087099 | (37.752022893602, -122.423252020871) | ||
| 89523 | 89523 | 68462 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 295 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32324 | 5991504.44002823 | 2113463.17784531 | 37.782677546779205 | -122.47308354896799 | (37.7826775467792, -122.473083548968) | ||
| 89940 | 89940 | 92240 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1470 32nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.49067468059499 | (37.7597856659048, -122.490674680595) | |||
| 89977 | 89977 | 50759 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 286 Willard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2004 12:00:00 AM | 3x3 | Permit Number 47298 | 5996260.1 | 2110808.5 | 37.7756626959421 | -122.456439068917 | (37.7756626959421, -122.456439068917) | ||
| 90003 | 90003 | 50890 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47400 | 5991328.18651744 | 2100148.47255099 | 37.7461087183508 | -122.472722183475 | (37.7461087183508, -122.472722183475) | ||
| 90064 | 90064 | 66339 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | ||
| 90179 | 90179 | 46325 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3649 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 56854 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | |||
| 90403 | 90403 | 95670 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 91030 | 91030 | 42946 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42841 | 6007766.22670563 | 2106145.49280526 | 37.7635130152875 | -122.41630607676201 | (37.7635130152875, -122.416306076762) | ||
| 91080 | 91080 | 64683 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | Permit Number 25622 | 6007786.51024737 | 2105766.07733259 | 37.7624723689104 | -122.416209048783 | (37.7624723689104, -122.416209048783) | ||
| 91081 | 91081 | 52641 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 171@ LAKEVIEW Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | Permit Number 48723 | 5997085.87939987 | 2088850.31270085 | 37.715418286429895 | -122.451997937847 | (37.7154182864299, -122.451997937847) | |||
| 91101 | 91101 | 115160 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | |||
| 91147 | 91147 | 88310 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 91442 | 91442 | 88308 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 91474 | 91474 | 46992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 91524 | 91524 | 62118 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 473 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1985 12:00:00 AM | Permit Number 22220 | 6006824.76119309 | 2101034.29989716 | 37.749425872837 | -122.419199729312 | (37.749425872837, -122.419199729312) | ||
| 91542 | 91542 | 47689 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.752453700851795 | -122.429649915481 | (37.7524537008518, -122.429649915481) | |||
| 91637 | 91637 | 64414 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1988 12:00:00 AM | Permit Number 25261 | 6003697.20020727 | 2098175.28884646 | 37.741399060208 | -122.42981101521299 | (37.741399060208, -122.429811015213) | ||
| 91661 | 91661 | 82191 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1995 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49854 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | ||
| 91844 | 91844 | 102356 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012524.1 | 2106651.0 | 37.765167421152206 | -122.399885503722 | (37.7651674211522, -122.399885503722) | |||||
| 91917 | 91917 | 88205 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51210 | 5998774.0 | 2109909.0 | 37.7733369001006 | -122.447678136621 | (37.7733369001006, -122.447678136621) | |||
| 92182 | 92182 | 64027 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 700 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24784 | 6007920.33784852 | 2095628.68558962 | 37.7346448914343 | -122.41502862166 | (37.7346448914343, -122.41502862166) | ||
| 92351 | 92351 | 47754 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 719 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | Permit Number 45534 | 6003126.79155658 | 2109592.75856581 | 37.77271638950771 | -122.43259864508998 | (37.7727163895077, -122.43259864509) | ||
| 92767 | 92767 | 84679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 150 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49720 | 5996250.33825299 | 2090885.9667731998 | 37.7209598197785 | -122.45503293044901 | (37.7209598197785, -122.455032930449) | ||
| 92923 | 92923 | 48688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Palm Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | |||
| 93004 | 93004 | 42947 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 370 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42842 | 6007791.87448942 | 2105665.73605783 | 37.7621971566206 | -122.41618338894699 | (37.7621971566206, -122.416183388947) | ||
| 93152 | 93152 | 88727 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 66 Pontiac St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | |||
| 93453 | 93453 | 46988 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 93505 | 93505 | 114442 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 LOOMIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010781.0 | 2097775.0 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | ||||
| 93552 | 93552 | 64117 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 606 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24888 | 6002640.14988451 | 2098909.68283406 | 37.743355619614704 | -122.43351839421699 | (37.7433556196147, -122.433518394217) | ||
| 93696 | 93696 | 63317 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 408 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23884 | 6009379.46071943 | 2100205.52672578 | 37.7472937869951 | -122.41030696757099 | (37.7472937869951, -122.410306967571) | ||
| 93764 | 93764 | 33048 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.752099147776704 | -122.423020719371 | (37.7520991477767, -122.423020719371) | ||
| 93777 | 93777 | 32839 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.750358149840395 | -122.43408346062701 | (37.7503581498404, -122.434083460627) | ||
| 93781 | 93781 | 37489 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39958 | 5990687.69704484 | 2106519.91830078 | 37.763565929909895 | -122.47540200080401 | (37.7635659299099, -122.475402000804) | ||
| 93814 | 93814 | 35075 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 94119 | 94119 | 52437 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1808 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | ||
| 94305 | 94305 | 50867 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.794611798503205 | -122.44050314696199 | (37.7946117985032, -122.440503146962) | |||
| 94453 | 94453 | 31507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 4.5x6 | Permit Number 35067 | 5998199.5847285995 | 2112645.80731224 | 37.780818618472 | -122.44986238382401 | (37.780818618472, -122.449862383824) | |
| 94484 | 94484 | 83962 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 626 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767447 | 5992636.32789452 | 2105971.3213845002 | 37.7621723886495 | -122.46862244318999 | (37.7621723886495, -122.46862244319) | |
| 94687 | 94687 | 35076 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 94878 | 94878 | 46904 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44960 | 5994548.84037989 | 2106162.48962063 | 37.762807581301296 | -122.46202170341101 | (37.7628075813013, -122.462021703411) | ||
| 94962 | 94962 | 51679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2005 12:00:00 AM | Permit Number 47959 | 5997000.93217055 | 2089281.06298021 | 37.716596160573104 | -122.45232261590401 | (37.7165961605731, -122.452322615904) | ||
| 94991 | 94991 | 64808 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 53 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25810 | 6002470.46019505 | 2099868.65232966 | 37.745979096274 | -122.434173677497 | (37.745979096274, -122.434173677497) | ||
| 95062 | 95062 | 63367 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 511 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/1987 12:00:00 AM | Permit Number 23943 | 6007615.98725252 | 2095736.23144951 | 37.7349230812673 | -122.4160884814 | (37.7349230812673, -122.4160884814) | ||
| 95121 | 95121 | 59667 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32205 | 5998489.35496183 | 2105990.50764874 | 37.762561442192705 | -122.448380521343 | (37.7625614421927, -122.448380521343) | ||
| 95141 | 95141 | 94172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553.0 | 2102835.0 | 37.754691137470495 | -122.399517610991 | (37.7546911374705, -122.399517610991) | ||
| 95240 | 95240 | 83184 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51667 | 6004633.65578728 | 2109108.35984762 | 37.7714716870977 | -122.427351721243 | (37.7714716870977, -122.427351721243) | ||
| 95357 | 95357 | 63384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23964 | 6006724.73531603 | 2095810.6587823 | 37.7350772906705 | -122.41917513645399 | (37.7350772906705, -122.419175136454) | ||
| 95483 | 95483 | 63383 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 260 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23963 | 6006655.03075921 | 2095764.2987202 | 37.7349460704184 | -122.419412842724 | (37.7349460704184, -122.419412842724) | ||
| 95564 | 95564 | 31348 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.776635212167896 | -122.42638959956999 | (37.7766352121679, -122.42638959957) | ||
| 95622 | 95622 | 38422 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | ||
| 95656 | 95656 | 60994 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4126 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25142 | 6003063.49787732 | 2100688.38010697 | 37.7482635177611 | -122.432181564789 | (37.7482635177611, -122.432181564789) |
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");