Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 7135 | 7135 | 65883 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3100X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2013 12:00:00 AM | 3 | Permit Number 770126 | 6002440.42815 | 2118878.8821400004 | 37.798174776289294 | -122.435637321312 | (37.7981747762893, -122.435637321312) | ||
| 8392 | 8392 | 23566 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2005 12:00:00 AM | 6 | 6005632.06356 | 2120580.6858200002 | 37.8030282582004 | -122.424714436346 | (37.8030282582004, -122.424714436346) | |||
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 30875 | 30875 | 64436 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2445 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1988 12:00:00 AM | 12 | Permit Number 25292 | 6006658.75135 | 2119650.10198 | 37.8005310432266 | -122.421095439396 | (37.8005310432266, -122.421095439396) | ||
| 31183 | 31183 | 61726 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.2493599998 | 37.7304922999628 | -122.39434750633998 | (37.7304922999628, -122.39434750634) | |
| 39687 | 39687 | 80561 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 15 | 6013651.87309 | 2096197.8113799999 | 37.736528009043795 | -122.395252475224 | (37.7365280090438, -122.395252475224) | ||
| 39980 | 39980 | 30908 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1511 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34730 | 5999634.2212 | 2114153.2322 | 37.7850395970423 | -122.44500769339199 | (37.7850395970423, -122.445007693392) | ||
| 40687 | 40687 | 57316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | ||
| 42030 | 42030 | 206000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997987.32263 | 2094070.28162 | 37.729802697139604 | -122.44925801953801 | (37.7298026971396, -122.449258019538) | ||||
| 53040 | 53040 | 56853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.880580001 | 2091960.10063 | 37.724365284516395 | -122.427429718013 | (37.7243652845164, -122.427429718013) | ||
| 54603 | 54603 | 119737 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | ||||
| 58705 | 58705 | 46514 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 525or larger Golden Gate Ave In A 24 Box | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44680 | 6007056.20383649 | 2112568.41573989 | 37.7811088818185 | -122.41921746578801 | (37.7811088818185, -122.419217465788) | |||
| 66191 | 66191 | 48531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 72094 | 72094 | 51302 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 12 | Permit Number 47670 | 6008052.8861 | 2112760.32075 | 37.781691886721795 | -122.415783025366 | (37.7816918867218, -122.415783025366) | |
| 77510 | 77510 | 60693 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2762 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20336 | 6009623.17116786 | 2103391.2059206003 | 37.7560546117591 | -122.40968905174101 | (37.7560546117591, -122.409689051741) | ||
| 78262 | 78262 | 62275 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 141 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22411 | 6004215.98521889 | 2109270.59348358 | 37.771893510559 | -122.428808033039 | (37.771893510559, -122.428808033039) | ||
| 78776 | 78776 | 85052 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 80147 | 80147 | 44334 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 57 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2001 12:00:00 AM | Permit Number 43719 | 6004283.91720992 | 2108781.91004669 | 37.770555549309 | -122.42853821202299 | (37.770555549309, -122.428538212023) | ||
| 81111 | 81111 | 49041 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46216 | 6004132.32350443 | 2101573.22879489 | 37.750753648355605 | -122.428548658976 | (37.7507536483556, -122.428548658976) | ||
| 81764 | 81764 | 63117 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23624 | 6006928.92708318 | 2099162.96302102 | 37.7442934699851 | -122.418706828381 | (37.7442934699851, -122.418706828381) | ||
| 81810 | 81810 | 50386 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 81866 | 81866 | 61684 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | ||
| 82379 | 82379 | 65221 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.722149084859296 | -122.43447802603701 | (37.7221490848593, -122.434478026037) | ||
| 82535 | 82535 | 63222 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.41839259476801 | (37.7440872763149, -122.418392594768) | ||
| 84256 | 84256 | 63130 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 26 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23644 | 6007187.15982152 | 2099399.82780325 | 37.7449583833589 | -122.417830699083 | (37.7449583833589, -122.417830699083) | ||
| 84282 | 84282 | 105450 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | |||||
| 84450 | 84450 | 51842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 48069 | 6007044.58832094 | 2099374.8552715 | 37.7448817898933 | -122.41832191623199 | (37.7448817898933, -122.418321916232) | ||
| 85449 | 85449 | 41699 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.737098580964606 | -122.438954184383 | (37.7370985809646, -122.438954184383) | ||
| 86972 | 86972 | 58315 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.744076720184495 | -122.41884863660299 | (37.7440767201845, -122.418848636603) | ||
| 88159 | 88159 | 65411 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.77096427235279 | -122.42862063626801 | (37.7709642723528, -122.428620636268) | |||
| 88250 | 88250 | 48533 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 89326 | 89326 | 62271 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22405 | 6004283.36290773 | 2109163.56782991 | 37.771603457424604 | -122.428567338549 | (37.7716034574246, -122.428567338549) | ||
| 89790 | 89790 | 60257 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 911 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | Permit Number 19811 | 6009422.17813465 | 2103864.55146626 | 37.757343046708 | -122.410417577389 | (37.757343046708, -122.410417577389) | ||
| 90392 | 90392 | 67184 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30631 | 5998760.11857013 | 2106856.81248154 | 37.7649555743728 | -122.447506412542 | (37.7649555743728, -122.447506412542) | ||
| 91351 | 91351 | 63739 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1988 12:00:00 AM | Permit Number 24410 | 6003393.73641512 | 2109629.91106527 | 37.7728335359212 | -122.43167790707399 | (37.7728335359212, -122.431677907074) | ||
| 91986 | 91986 | 67186 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 281 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30634 | 5996869.12207945 | 2106987.0610707 | 37.765204956904604 | -122.454056265196 | (37.7652049569046, -122.454056265196) | ||
| 92531 | 92531 | 105449 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | |||||
| 93830 | 93830 | 63116 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.41897885676701 | (37.7435658517454, -122.418978856767) | ||
| 99294 | 99294 | 52077 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2959 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2005 12:00:00 AM | Permit Number 48273 | 6009147.75263717 | 2102727.30105861 | 37.7542050255745 | -122.41128631630698 | (37.7542050255745, -122.411286316307) | ||
| 99462 | 99462 | 60684 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2969 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20325 | 6009095.19054271 | 2102724.34950865 | 37.7541939732112 | -122.411467881257 | (37.7541939732112, -122.411467881257) | ||
| 100880 | 100880 | 50384 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 101649 | 101649 | 62273 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.42876647673701 | (37.7716874486567, -122.428766476737) | ||
| 101713 | 101713 | 58721 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1981 12:00:00 AM | Permit Number 19065 | 6002629.53182761 | 2108749.25499909 | 37.770372124834296 | -122.434258404788 | (37.7703721248343, -122.434258404788) | |||
| 102431 | 102431 | 62270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 102 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22404 | 6004290.78316217 | 2109110.18870614 | 37.7714573112605 | -122.42853786594999 | (37.7714573112605, -122.42853786595) | ||
| 103487 | 103487 | 50383 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 104167 | 104167 | 50385 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 104509 | 104509 | 60288 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2932 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19852 | 6009284.44431761 | 2102786.94037008 | 37.754376447104995 | -122.410817812439 | (37.754376447105, -122.410817812439) | ||
| 105012 | 105012 | 62272 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 113 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22406 | 6004233.40404883 | 2109145.28748516 | 37.7715504366717 | -122.428738845772 | (37.7715504366717, -122.428738845772) | ||
| 105799 | 105799 | 51546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.806678119982706 | -122.419815746942 | (37.8066781199827, -122.419815746942) | |||
| 105923 | 105923 | 59722 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2905 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/14/1984 12:00:00 AM | Permit Number 19154 | 6008831.83417105 | 2103879.56302809 | 37.757351153159 | -122.41246028798 | (37.757351153159, -122.41246028798) | ||
| 105938 | 105938 | 51301 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.41559966360799 | (37.7816708281319, -122.415599663608) | ||
| 106049 | 106049 | 59362 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.736772117155496 | -122.43808313790001 | (37.7367721171555, -122.4380831379) | |||
| 106473 | 106473 | 60259 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28050 | 6009367.15001104 | 2103917.51160129 | 37.757485378294895 | -122.41061162692301 | (37.7574853782949, -122.410611626923) | ||
| 107534 | 107534 | 63118 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23625 | 6006935.01451866 | 2099174.11524824 | 37.7443244342333 | -122.418686569992 | (37.7443244342333, -122.418686569992) | ||
| 109880 | 109880 | 50388 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 110320 | 110320 | 60260 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19815 | 6009158.9675903 | 2103949.64001782 | 37.757561921733 | -122.41133387759399 | (37.757561921733, -122.411333877594) | ||
| 110724 | 110724 | 101044 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 112036 | 112036 | 101042 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 112235 | 112235 | 60690 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2773 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20333 | 6009572.74299755 | 2103336.33183864 | 37.7559011138434 | -122.409859576548 | (37.7559011138434, -122.409859576548) | ||
| 115300 | 115300 | 85051 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 117344 | 117344 | 57469 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.46831233823299 | (37.7263014049972, -122.468312338233) | ||
| 117686 | 117686 | 47317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | |||
| 120131 | 120131 | 60694 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2770 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20337 | 6009580.52702931 | 2103388.84293588 | 37.7560457337564 | -122.409836363248 | (37.7560457337564, -122.409836363248) | ||
| 120218 | 120218 | 51670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.44769041413299 | (37.765863591183, -122.447690414133) | ||||
| 120646 | 120646 | 63121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23632 | 6007120.53987433 | 2099276.08223849 | 37.7446148564174 | -122.418052288309 | (37.7446148564174, -122.418052288309) | ||
| 120916 | 120916 | 101045 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 121368 | 121368 | 101043 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 121827 | 121827 | 60691 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2767 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20334 | 6009604.72609902 | 2103338.10407704 | 37.7559077723841 | -122.409749093146 | (37.7559077723841, -122.409749093146) | ||
| 122387 | 122387 | 65950 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | ||
| 123961 | 123961 | 57556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23627 | 6007019.50965831 | 2099220.3784742 | 37.7444562195491 | -122.418397682663 | (37.7444562195491, -122.418397682663) | ||
| 124706 | 124706 | 63223 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | ||
| 125283 | 125283 | 35826 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.718805244392904 | -122.433947949751 | (37.7188052443929, -122.433947949751) | ||
| 126974 | 126974 | 49779 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 241@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46565 | 6012711.25696991 | 2087289.78103258 | 37.7120160109599 | -122.39787992529499 | (37.7120160109599, -122.397879925295) | ||
| 127474 | 127474 | 63232 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | ||
| 127575 | 127575 | 47316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | ||
| 128506 | 128506 | 60264 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19820 | 6009362.55423892 | 2103960.83669592 | 37.7576040815568 | -122.410630580485 | (37.7576040815568, -122.410630580485) | ||
| 131650 | 131650 | 32421 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.2312599998 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | ||
| 137523 | 137523 | 65609 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.0268700002 | 37.7295104552453 | -122.42472001303801 | (37.7295104552453, -122.424720013038) | |
| 138411 | 138411 | 63122 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.41840295087499 | (37.7447579331798, -122.418402950875) | ||
| 138752 | 138752 | 48532 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 140440 | 140440 | 34010 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.43328338001899 | (37.7670985064042, -122.433283380019) | |||
| 140595 | 140595 | 61796 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 60 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21819 | 6002883.06164476 | 2108748.24537279 | 37.7703837393735 | -122.43338137366399 | (37.7703837393735, -122.433381373664) | ||
| 140677 | 140677 | 56842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 910 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | 3 | Permit Number 30536 | 5998759.08975741 | 2106864.1829233 | 37.76497575295679 | -122.447510501506 | (37.7649757529568, -122.447510501506) | |
| 142139 | 142139 | 33711 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | |||
| 142476 | 142476 | 68375 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.76299319850379 | -122.45048498278999 | (37.7629931985038, -122.45048498279) | ||
| 143125 | 143125 | 201373 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018334.732369999 | 2095383.1099099999 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | ||||
| 143717 | 143717 | 63120 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 46 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23631 | 6007008.06371762 | 2099307.94192573 | 37.7446960047915 | -122.418443468102 | (37.7446960047915, -122.418443468102) | ||
| 144535 | 144535 | 63125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | ||
| 145409 | 145409 | 60263 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19819 | 6009497.44754454 | 2103916.17692673 | 37.757489017835496 | -122.410160909746 | (37.7574890178355, -122.410160909746) | ||
| 145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
| 150575 | 150575 | 56925 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | ||
| 151813 | 151813 | 51298 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | |
| 154115 | 154115 | 32473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.910540001 | 2106227.11632 | 37.763312407875205 | -122.442259981907 | (37.7633124078752, -122.442259981907) | |
| 154265 | 154265 | 119738 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013480.63892 | 2116044.41356 | 37.7910128776808 | -122.397235794198 | (37.7910128776808, -122.397235794198) | ||||
| 155166 | 155166 | 40183 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 298X Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 11 | Permit Number 41371 | 6013446.24914 | 2105734.66956 | 37.7627027466551 | -122.39663174926001 | (37.7627027466551, -122.39663174926) | ||
| 157632 | 157632 | 119739 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) | ||||
| 158717 | 158717 | 61724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.39430169937599 | (37.7307052783181, -122.394301699376) | |
| 159567 | 159567 | 51299 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.781683418708404 | -122.415851598691 | (37.7816834187084, -122.415851598691) | |
| 164903 | 164903 | 201371 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Hare St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6018297.03999 | 2095334.9344400002 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) |
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");