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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13442 | 13442 | 47240 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1006X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013969.3769 | 2089681.5637 | 37.7186533627648 | -122.39369877082301 | (37.7186533627648, -122.393698770823) |
| 16011 | 16011 | 47239 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.718623377888896 | -122.393646260173 | (37.7186233778889, -122.393646260173) |
| 25981 | 25981 | 47237 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) |
| 99990 | 99990 | 47241 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543097995 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) |
| 122964 | 122964 | 47238 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) |
| 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) | ||
| 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) | ||
| 129421 | 129421 | 47061 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 114 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 3x3 | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | |
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 169210 | 169210 | 52724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | ||
| 127787 | 127787 | 58566 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | ||
| 101303 | 101303 | 59009 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1980 12:00:00 AM | 15 | 4x4 | Permit Number 18300 | 6005405.85335043 | 2104274.1193378996 | 37.758241653827 | -122.42433675552401 | (37.758241653827, -122.424336755524) | |
| 22336 | 22336 | 3627 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | ||
| 23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
| 112042 | 112042 | 6647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
| 120176 | 120176 | 6646 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
| 13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 126452 | 126452 | 2545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1590X Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.744986343975704 | -122.38683233058599 | (37.7449863439757, -122.386832330586) | ||
| 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) | |||
| 3892 | 3892 | 222929 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | |
| 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) | |||
| 83230 | 83230 | 95955 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675.0 | 2116143.7 | 37.791351915434 | -122.39311026796601 | (37.791351915434, -122.393110267966) | ||
| 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) | |||
| 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) | ||
| 13990 | 13990 | 16545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.38703865582701 | (37.7415453861211, -122.387038655827) | ||
| 22312 | 22312 | 3652 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.38264747761299 | (37.7437309716031, -122.382647477613) | ||
| 22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 66646 | 66646 | 3581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 117465 | 117465 | 51304 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767250 | 6001037.11613846 | 2102279.06351254 | 37.752516053262795 | -122.439302719451 | (37.7525160532628, -122.439302719451) | |
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 94554 | 94554 | 2524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449.0 | 2099041.0 | 37.7444899913278 | -122.38577963578699 | (37.7444899913278, -122.385779635787) | ||
| 144681 | 144681 | 21784 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2550X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2016 12:00:00 AM | 12 | 4X4 | 6008458.5658599995 | 2121488.77145 | 37.805680863133205 | -122.41499754514 | (37.8056808631332, -122.41499754514) | ||
| 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) | |
| 23428 | 23428 | 106029 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.790852311826704 | -122.39322941879801 | (37.7908523118267, -122.393229418798) | |
| 98613 | 98613 | 106036 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||
| 182276 | 182276 | 106027 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.819209999 | 2115987.9153400003 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | |
| 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) | |||
| 33365 | 33365 | 93109 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.354169999 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | |
| 35467 | 35467 | 93114 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.7110900003 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | |
| 123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
| 153716 | 153716 | 93113 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.4931799998 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | |
| 154271 | 154271 | 93112 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.38534341756599 | (37.7426681627043, -122.385343417566) | |
| 184090 | 184090 | 93110 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.548880001 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | |
| 23084 | 23084 | 16626 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | ||
| 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) | |||
| 125620 | 125620 | 4920 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:54:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 127870 | 127870 | 4917 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:50:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 143020 | 143020 | 4916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 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) | ||
| 15110 | 15110 | 7417 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.058999999 | 2111002.9309 | 37.7769959373466 | -122.40767730948099 | (37.7769959373466, -122.407677309481) | ||
| 112145 | 112145 | 6850 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 166502 | 166502 | 61685 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.730421490047604 | -122.39436277503201 | (37.7304214900476, -122.394362775032) | |
| 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) | ||
| 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) | ||
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 946 | 946 | 23565 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005634.29929 | 2120573.5209 | 37.8030087114389 | -122.424706189543 | (37.8030087114389, -122.424706189543) | |||
| 1160 | 1160 | 18860 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | |||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 1440 | 1440 | 222893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | |||
| 3418 | 3418 | 18865 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003863.26827 | 2115999.97726 | 37.7903507527417 | -122.43050834919501 | (37.7903507527417, -122.430508349195) | |||
| 4380 | 4380 | 106727 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000017.8025 | 2114366.8285 | 37.785647962066996 | -122.443695977864 | (37.785647962067, -122.443695977864) | |||
| 4762 | 4762 | 188472 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.41585412666099 | (37.7713614445082, -122.415854126661) | |||
| 4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
| 4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
| 4779 | 4779 | 188471 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.41550157982799 | (37.7711845613454, -122.415501579828) | |||
| 4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
| 4806 | 4806 | 188473 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.771378132318894 | -122.415898458759 | (37.7713781323189, -122.415898458759) | |||
| 4810 | 4810 | 188468 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | |||
| 4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
| 4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
| 6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
| 6403 | 6403 | 11181 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.42044724225599 | (37.8065129467732, -122.420447242256) | |||
| 7048 | 7048 | 18853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2222 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004009.33777 | 2116018.08762 | 37.7904087527096 | -122.430004251319 | (37.7904087527096, -122.430004251319) | |||
| 7397 | 7397 | 18866 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2241 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004050.55009 | 2115976.0428299997 | 37.7902956422834 | -122.429858659173 | (37.7902956422834, -122.429858659173) | |||
| 7418 | 7418 | 11180 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357004 | -122.420440716763 | (37.806461391357, -122.420440716763) | |||
| 7791 | 7791 | 18864 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003886.2489 | 2116004.41909 | 37.7903642506674 | -122.430429154879 | (37.7903642506674, -122.430429154879) | |||
| 7949 | 7949 | 14640 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | |||
| 9098 | 9098 | 2530 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
| 9135 | 9135 | 2542 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 9160 | 9160 | 16481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9221 | 9221 | 16483 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9262 | 9262 | 16480 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9277 | 9277 | 16482 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9322 | 9322 | 16485 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9397 | 9397 | 2544 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6016440.0 | 2099034.0 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | |||
| 9402 | 9402 | 16488 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) |
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");