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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25551 | 25551 | 138242 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999647.1063 | 2114070.9654 | 37.7848144491807 | -122.444957199215 | (37.7848144491807, -122.444957199215) | |||
53751 | 53751 | 138243 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999648.5931 | 2114056.0979 | 37.7847737117432 | -122.44495098624701 | (37.7847737117432, -122.444950986247) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
175276 | 175276 | 139007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.78481835543629 | -122.444802925313 | (37.7848183554363, -122.444802925313) | |||
134055 | 134055 | 139006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | |||
89436 | 89436 | 110184 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
95567 | 95567 | 110183 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
53354 | 53354 | 139055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.784564120210796 | -122.444654378813 | (37.7845641202108, -122.444654378813) | |||
175525 | 175525 | 139056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999748.2433 | 2113980.0087 | 37.7845704772917 | -122.44460075979201 | (37.7845704772917, -122.444600759792) | |||
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) | |||
27998 | 27998 | 103976 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000022.661 | 2113372.9775 | 37.7829193814773 | -122.44360774817 | (37.7829193814773, -122.44360774817) | |||
56567 | 56567 | 139360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000048.0331 | 2114373.2711 | 37.7856673759403 | -122.443591852007 | (37.7856673759403, -122.443591852007) | |||
174977 | 174977 | 225091 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | |||
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) | |
188391 | 188391 | 225051 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.752498802180796 | -122.439839555559 | (37.7524988021808, -122.439839555559) | |||
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) | ||
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) | |
71217 | 71217 | 125968 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001336.417830001 | 2115647.62359 | 37.7892398148051 | -122.43922579254101 | (37.7892398148051, -122.439225792541) | |||
154480 | 154480 | 225052 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000953.83658 | 2096674.2134099999 | 37.737121725291296 | -122.439189029173 | (37.7371217252913, -122.439189029173) | |||
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) | ||
37675 | 37675 | 225057 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | |||
65489 | 65489 | 225056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901044995 | -122.43874836315399 | (37.737188901045, -122.438748363154) | |||
178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
184149 | 184149 | 225054 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001139.36381 | 2096693.2959599998 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | |||
32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
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) | |||
71848 | 71848 | 125969 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | |||
109213 | 109213 | 18922 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2620 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002038.8 | 2115762.8 | 37.7895960030005 | -122.436803887406 | (37.7895960030005, -122.436803887406) | |||
116782 | 116782 | 4389 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | ||
42068 | 42068 | 205999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001682.52176 | 2095686.8275900001 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | |||
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) | ||
38071 | 38071 | 125966 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | |||
32238 | 32238 | 175841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | |||
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) | ||
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) | |||
134756 | 134756 | 225092 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002638.752309999 | 2108633.09345 | 37.770053697148796 | -122.434218205527 | (37.7700536971488, -122.434218205527) | |||
74103 | 74103 | 225093 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283004 | -122.43408300774901 | (37.770617436283, -122.434083007749) | |||
72741 | 72741 | 175840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | |||
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) | ||
5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
114992 | 114992 | 116858 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002788.0 | 2107242.0 | 37.7662425648461 | -122.43360252819201 | (37.7662425648461, -122.433602528192) | |||
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) | ||
19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
16981 | 16981 | 16634 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.43340627149901 | (37.7664480128774, -122.433406271499) | |||
16941 | 16941 | 16644 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002849.247169999 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | |||
18276 | 18276 | 16647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.6051900005 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | ||
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) | ||
59003 | 59003 | 225090 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002851.63466 | 2107200.7798599997 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | |||
88683 | 88683 | 16650 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | |||
35683 | 35683 | 225082 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002779.31526 | 2103257.0391599997 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) | |||
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) | |||
110377 | 110377 | 16641 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.949322799 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | |||
61818 | 61818 | 142100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002972.7027 | 2110318.8393 | 37.7747012881718 | -122.43318354410201 | (37.7747012881718, -122.433183544102) | |||
126122 | 126122 | 20125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
180608 | 180608 | 225049 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002919.63953 | 2100068.3028700002 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | |||
35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
135731 | 135731 | 115846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | |||
32206 | 32206 | 115845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003527.72894 | 2120738.7231400004 | 37.8033431135653 | -122.432007819421 | (37.8033431135653, -122.432007819421) | |||
46321 | 46321 | 115844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | |||
35568 | 35568 | 225084 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.43192775097401 | (37.7547027131682, -122.431927750974) | |||
42092 | 42092 | 115843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003556.384769999 | 2120742.54729 | 37.80335523820229 | -122.431908928161 | (37.8033552382023, -122.431908928161) | |||
174264 | 174264 | 115842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003573.215530001 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | |||
49414 | 49414 | 115847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003582.67693 | 2120834.7351599997 | 37.80360985246121 | -122.431824529496 | (37.8036098524612, -122.431824529496) | |||
184467 | 184467 | 140578 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.778435854356104 | -122.431812198827 | (37.7784358543561, -122.431812198827) | |||
168072 | 168072 | 115848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.43180918435499 | (37.8035189184231, -122.431809184355) | |||
161217 | 161217 | 140579 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.43180072975201 | (37.7783626547096, -122.431800729752) | |||
177272 | 177272 | 115849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003588.62501 | 2120788.7376599996 | 37.803483892518294 | -122.43180065966801 | (37.8034838925183, -122.431800659668) | |||
151213 | 151213 | 115850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003589.56269 | 2120774.48991 | 37.8034448250715 | -122.431796396884 | (37.8034448250715, -122.431796396884) | |||
25691 | 25691 | 140580 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.778294566327205 | -122.43178620552 | (37.7782945663272, -122.43178620552) | |||
37728 | 37728 | 225083 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003229.02977 | 2103031.88331 | 37.7547076090931 | -122.431776461616 | (37.7547076090931, -122.431776461616) | |||
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) | ||
33594 | 33594 | 244469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003415.8306 | 2109638.0930000003 | 37.7728572538387 | -122.43160206502701 | (37.7728572538387, -122.431602065027) | |||
71480 | 71480 | 125970 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2301 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6003734.22562 | 2115934.13704 | 37.7901626613254 | -122.430950126753 | (37.7901626613254, -122.430950126753) | |||
46091 | 46091 | 244452 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | |||
3024 | 3024 | 225099 | 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 | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
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) | |||
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) | |||
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) | |||
28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
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) | |||
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) | |||
6620 | 6620 | 18859 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1992 12:00:00 AM | 12 | 3X3 | 6004082.46062 | 2116030.31556 | 37.7904464684691 | -122.429752123658 | (37.7904464684691, -122.429752123658) | ||
25477 | 25477 | 225086 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.756311078698296 | -122.429732966312 | (37.7563110786983, -122.429732966312) | |||
60139 | 60139 | 246422 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.746018144524605 | -122.429473817668 | (37.7460181445246, -122.429473817668) | |||
23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
188742 | 188742 | 246420 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.42939827552401 | (37.7460188154337, -122.429398275524) | |||
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) | ||
182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
32636 | 32636 | 222888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004218.0 | 2109157.0 | 37.771581724556604 | -122.428792964354 | (37.7715817245566, -122.428792964354) | |||
174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
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) | ||
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) | ||
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) | |||
64492 | 64492 | 222913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004271.62218 | 2109232.3150299997 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | |||
184225 | 184225 | 222889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 81 Webster St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6004268.7476699995 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | |||
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) | |
137538 | 137538 | 222914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) |
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");